Search results for query: *

Thanks I will look through my tabs and double check my queries. :)

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 tried all of these tips and tricks but so far no go with my user. She has Outlook 2003 but is using IE6, she can't upgrade due to compatibility issues with the payroll software she is using. However she had no issues until a PC replacement last week. I am not sure what has shifted, another IT...

Thanks, that is a good thought.

That was the conclusion I was starting to come to myself, I was just hoping for that magic bullet that would do it at this stage thanks for the help! ~Kendra

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...

In contemplating this I came up with this to start solving my problem...also may need this statement by worksheet. A nudge in the right direction would be appreciated. Thanks! If Dir("C:\Group1.xls") <> " " Then If IsNull("C:\Group1.xls") Then 'need to add a do nothing statement, or...

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...

Thanks so much you guys are lifesavers. I am not getting compile errors with that code now I am getting an error with this: Private Sub cmdImport_Click() which wasn't throwing an error before. I can't wait until this becomes a bit more natural to me!

Thanks that is exactly the problem I am having with the mismatch. However each of the workbooks 1-10 discuss different terms for each graduating group of nursing students so group 2 will have different spreadsheets than group4. For example here is sample code including two groups: If...

I looked at the website given by abaldwin, and thought this bit of code would be helpful as I was trying to see if the file existed before I tried loading it into the database: If fso.FileExists("C:\GROUP1") Then I got the same "identifier under cursor is not recognized" and it is next to the...

If Dir("C:\GROUP1") <> "" Then I added this code and was give the: "Identifier under cursor is not recognized" and the cursor is set right after the > Thanks though.

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...

Thanks that helps so much!

This is the first of 10 Groups I need to cycle through, so if the file doesn't exist then I can just put End If? Or End Sub and start Group 2 as a new Sub? Ideally at the end it will say "import complete" if it downloaded at least 1 group and "nothing to import" to notify the user that there...

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"...

Before I connect this code to the switchboard I would like to run it to be sure that it works. When I click on the module screen the run button is grayed out, when I double click the module itself it just opens the code window. The code will not start therefore, I can't step through and see...

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...