Need help with coding (excel + access 2007)?

Answer I would offer that it would be easier to simply create a new worksheet, such as "Extract", and copy the required information to that sheet. Then, pull that sheet into Access.The following event ha... Read More »

Top Q&A For: Need help with coding (excel + access 2007)

Access Denied When Saving From the Excel 2007 Format to Excel 2003?

Converting a file from Excel 2007 to Excel 2003 allows users with older spreadsheet software to view the content of the file. However, if the folder in which the Excel file is contained is set to "... Read More »

How do I add records in MS Access Is my coding right?

Submit the form to a Javascript function to make sure that the name and password have been filled in - return true if they have, false if not. Set local variables to the POST variables n1 and pwd ... Read More »

How to disable cells in excel through VBA coding?

I am going to assume that when you say "disable/enable" that you are referring to the Locking of cells, which can be done manually through the Formatting option. But to do that, you will also need... Read More »

How to set list box in Access properly by coding?

Has something been selected in the list-box ??At what point are you trying to use the list-box selection??If you are trying to use the list-box before anything has been selected, then it will have ... Read More »