Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. khosseini

    Input on Tabbed Forms question

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

    Input on Tabbed Forms question

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

    Outlook 2003 Missing header

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

    Importing Null Values

    Thanks, that is a good thought.
  5. khosseini

    Importing Null Values

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

    Importing Null Values

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

    Importing Null Values

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

    Importing Null Values

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

    If then else, not sure what the else should be

    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!
  10. khosseini

    If then else, not sure what the else should be

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

    Looking for File to Append

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

    Looking for File to Append

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

    Looking for File to Append

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

    If then else, not sure what the else should be

    Thanks that helps so much!
  15. khosseini

    If then else, not sure what the else should be

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

    If then else, not sure what the else should be

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

    Appending several excel sheets to several tables

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

    Appending several excel sheets to several tables

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

Part and Inventory Search

Back
Top