Hi Trevor, I am working on a VBA user form which is saved on shared drive,multiple people will be using the user form to log data I am having issues here as when multiple users use the form it gives an debug error and dose not work properly can u help what needs to be done
@Slapfunk79
3 жыл бұрын
Hi Trevor, this is great but I am having some trouble. I get the msgbox saying that the data has been successfully exported to the access database but the new information is not there when I open it.
@williampepe6104
6 жыл бұрын
when i change the database and adjust everything to my needs i get a 3625 error, i was wondering if you could help me with this?
@rosebud8760
8 жыл бұрын
Trevor, really enjoying your videos. Question on this one: why set the ADO reference in Access. My setup with sending data to Access works well with only Excel set with the ADO reference. Is there a potential performance benefit when talking back and forth over a network? Thanks! Keep the videos coming!
@irdovsi
6 жыл бұрын
Dear Mr. Trevor, Thank you very much for such of excellent postings . I tried to export excel data to access db, but error 3265 occurred. Do you have any idea of solving this problem.
@williampepe6104
6 жыл бұрын
i was wondering if you ever found a solution to this as im having the same issue
@BrhimMT
7 жыл бұрын
I have been looking at this and it has been very helpful and has saved me a ton of work. However I have one questions. If you wanted to have the macro button on a different worksheet from the data you want to export how would you do that?
@SomethingIngenious
7 жыл бұрын
Thank you for this, its been very helpful but I'm having trouble adapting it to my spreadsheet. It says it works but isnt being applied to my database, my "chart" that in excel im using starts at B3 if that makes a difference, unsure what I should change. Thanks again!
@thshm2938
8 жыл бұрын
Dear Mr. Trevor .....you have no idea how much your tutorial helped me in developing my own program...but, i have a question my excel has 46 columns and 400 rows.I have made some adjustments on the code you provided.Especially on adding the data " For i=1 to 46" but after i located my access data base when i send the data to ii i get the error -2147217843 (Autenticatio failed.) in procdure Export_data .What should i do??? please help.
Пікірлер: 15