Search results

Thank you eagle eye, how did I not see this :) It Worked!!!!! Thank you all

Thanks for this, I have put this code in the access form that loads up, it did come back with no errors but the file remains. What could I be doing wrong?

Hello I have some code that I kindly found online that creates a batch file which closes the current file, deletes the current file and downloads another one from a location and reopens. All works great, however it leaves the batch file on the place were you run this code, my case the desktop...

Thanks for this, I will make these changes within Database and hopefully this will correct these errors. Thank you

Hello, I have a form that you populate, once done, the user clicks on the send report button, It sends it as a PDF. Once the outlook email box comes up with your attachment and you send it, you have no issues. If however you click on the send report button and the outlook email box comes up...

Just an update, I managed to get the append query to work in the end :) Another one solved!

I have compacted the database but still gives me the same response I have also done a front and back end approach again no look. The database when compacted comes to 134MBs. I have no experience of creating a temp table? Thank you for your time isladogs.

Due to the amount of data when I use the append query to update the table it says the database is over 2GBs and not enough memory. I wish to setup a form were you select the an excel spreadsheet and it uploads into an existing table.

Hello the dream team :) I have a database that has over 600k records and will not append but I can export the data into a spreadsheet put in new records from a report that is ran into this spreadsheet and upload it back into the table for analysis using the wizard. I have got the code to...

Yes had them multiple times but put some vb code in to address this. Thank you!!!

Thank you so much, this site and the people is amazing, thank you for everyone who took the time to assist me in this :) No I must return the favor to someone else.

Amazing thank you so much :)

Hi my name is Mark and have a good understanding of Access and learn new things all the time and feel quite confident in creating databases. I hope you can help me. I have a table called tblUploaddata and one field is called Week set as text, it has data like Week 1 P1W1 and Week 10 P10W4...