Search results for query: *

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

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?!?!?!?

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

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

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.

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

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

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.

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?

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

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