Search results for query: *

I have created a form with several tabs. Each tab (home info, hire info, certifications, business info, and so on) relates to the main form (faculty). Upon completing my form I all of my relationships are working great and I can edit any of the current records. However, my problem comes from the...

I am working on a large import app, from excel 2003 to access 2003, and I have gotten it to import several workbooks and worksheets within the workbooks, it is however also importing the fields with nothing in them. I know that is how it is set up and not sure how to say if the fields are empty...

I am working on a large import app, from excel 2003 to access 2003, and I have gotten it to import several workbooks and worksheets within the workbooks, it is however also importing the fields with nothing in them. I know that is how it is set up and not sure how to say if the fields are empty...

I would like the program to look for a specific file on the C: and if there to append it. I have tested the appending portion of the code and all is well there. However when writing the if-then portion of code I am getting errors when trying to step through, this is the troublesome bit of code...

I am trying to run an "IF-THEN-ELSE" statement, that will either pick up the workbook or if it doesn't exist move on to the next workbook, here is the start I have but I am not sure what the ELSE command I need. If "C:\GROUP1" = True Then DoCmd.TransferSpreadsheet acImport, , "Students"...

I have seen several posts on this issue and taken the tips to heart, so thanks for that. However, I am renewing my VBA knowledge as I haven't used it in over 5 years so I am not sure why the following code isn't working: Option Compare Database 'The button on the switchboard will gather the...