Search results

I need to figure out how to do it progammically, because this file with be imported into the database daily... Gurn

I am having a problem when transfering an excel file to my database... For some reason when I transfer the file the bottom few records end up on the top of the list when it get into a table... 90% of the time it's the bottom 5 that end up on top... Here is the code I am using currently...

Wayne, That's my fault, I just didn't type it in properly, but it is correct on the report... It's not given me an error, but when I run it "#Error" is the only thing that comes up... Like I said before I'm not sure if I am using the DSum function in the proper place... I couldn't figure out how...

Thanks for the reply but it's still not working, is there another function I can use other than this =DSum ("[TotalWeight]", "qryschedIngredients", "[F_IngCode = " & [F_IngCode]) FYI: I have this in a txt box on a report and I am trying to use the DSum as the query is running and generating the...

I am trying to get a running sum of weight for different product numbers using the DSum function in a text box control source... Here is the function =DSum([txtTotalWeight],"rptSchedIngredients","[F_IngCode] = " & [F_IngCode]), but when I run it the result is #ERROR#... Any Ideas??? Thanks, Gurn

Yup that was the right direction Thanks!!!!! gurn

I need some help importing a DDF file into a table... The file looks something like this: | 3000 0000 5005B 177.033 5025 5.089 5026 4.000 5028 3.040 5035B 330.739 5044 338.538 5046B 160.001...

Thanks the Hyperlink works great!!!!

Is there a way to import a file as a whole into a database? I can not find anything but importing the data from a file... Help Please!!!! gurn

Thanks, that works great!!!!!!!!!!!!

I looked there and I still can not find anything, I may be looking in the wrong place... Here is the code to put it into the DB by hard coding, DoCmd.TransferText acImportDelim, , "tblIngredients", "C:\Formula\3241.txt", True MsgBox "File Transfered" I would like to open a input box and...

I am trying to search for text files in a folder and import a particular file to a database... I can do it by hard coding it but I need the user to type the file name and and import that file... Can someone help...