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

    Determine if user is linking to or directly opening data table

    I have several Access 2007/2010 databases operating (front end stored locally on user's PC, back end data files stored on network). My question is this: Is there a way to determine if the user is linking to the data files by opening the front end (properly) or if he/she is going on the network...
  2. xwordmark

    Access 2007 Image Control on Continuous Form

    I didn't think I needed the code - I only tried it because when I load the form there are no pictures. I was aware of the thread you posted, but it still doesn't explain why there are no pictures being displayed when I open my form! Any other suggestions?!?!?!?
  3. xwordmark

    Access 2007 Image Control on Continuous Form

    I have an impage control ([Image70]) bound to a field (PhotoFilePath) which is a valid file path to a picture. However, the control is blank when I load the form. I read somewhere (I can't remember where) that I needed to put the following code in the 'Form_Current()' event of the form...
  4. xwordmark

    Long date

    Based on what you've shown, the control on the report is not returning a date, it is returning a string, and the date is a part of that string. So you need to format the date before putting it in the string. How about: ="Payment :" & "" & CStr(Format([required date],"mmmm d, yyyy"))
  5. xwordmark

    How Can I Change My Access Report to Look at a Different Table?

    At the top of the 'Properties' window is a combo box. From this combo box select "Report". You can then update the "Record Source" property.
  6. xwordmark

    Force upper case in text box?

    In the "After Update" event add the following: = UCase([YourTextBoxName])
  7. xwordmark

    Need help with importing files

    PROXI, Sorry I couldn't finish with you yesterday. Anyway, change the following section and you should be good to go. For Each objF1 In objFiles If Right(objF1.Name, 3) = "txt" Then strfile = objF1 DoCmd.TransferText acImportFixed, "TxtImportSpec", strTableName, strfile...
  8. xwordmark

    Need help with importing files

    Actually, I think its bombing at the 'Kill strfile' because the Name statement not only gives the file a new name, it moves it so that it doesn't exist in its original location. Since strfile has moved, the Kill function can't find strfile, and there is no need for the Kill function anyway.
  9. xwordmark

    Need help with importing files

    Well, I'm not certain because I've never worked with a file that had a dot in the filename other than right before the extension, but that might be what's giving you the problem. Can you rename the file and change that dot to an underscore (or whatever works for you) and try it again?
  10. xwordmark

    Need help with importing files

    It appears you have referenced (twice) the variable strFolderPath before you set its value. You need to move the following line of code up two lines: strFolderPath = "C:\Documents and Settings\parkes23\My Documents\Daily Recon\" Also, as you have the backslash at the end of the variable...
  11. xwordmark

    Combo box not working as desired

    Try this: rs.FindFirst "[EID] = '" & Str(Nz(Me![cboCellNumSearch], 0)) & "'" I hope this helps!

Part and Inventory Search

Back
Top