Recent content by arage

Grouping & Parameters Hope someone can correct me on what I’m doing wrong, I’ve tried 2 versions of the below query which always end in ODBC failures. Any help is appreciated. SELECT DistributorInput.DistributorNumber, DistributorInput.InputFileName, Count(DistributorInput.InputFileName) AS...

Importing text files Can someone point me to an adequate tutorial on importing text (CSV) files into access 97 via code? I haven’t found one yet that I am comfortable with.

Set import dialog box Is it possible through code to set the LOOK IN, FILE NAME, and FILES OF TYPE options in the import dialog box through code??

But how do i specify the eof record in the delete query???...i tried placing chr(13) as criteria for all fields but that changes nothing...to help you visualize what i do when i manually make this change....imagine the txt file open...i do ctl+end & then backspace key one time...this is what i...

Modify text file I have never really used dao or recordsets in any of my coding experience but think I am about too. I’ve got my form to the point where I can determine whether a file exists in particular directory and I need to modify this file by opening it (thru code) going to the bottom of...

Hi crosmill...yeah something like that i want to be able to go into a directory & determine how many (and type) of shipping files i have for each distributor. The only way i can do this is by the naming convention the file is sent to me with.

I’d like to set up a form with several buttons, earch with a distributor name on it & a number too. The number is a count of the shipping files each distributor has, waiting to be processed. These files sit at various places on our network directory, is there some way for me to tell access to...

Dlookup I’m fine tuning a report & am using the dlookup function in the detail sections onFormat event. I typed this code: intCollCod = DLookup("Code", "Collections", Title = Me.Title) but this isn’t executing correctly, intCollCod keeps returning the value of the first collection in the...

List box entries written to email How might I click on several list box entries & have them be written to the body of an email?

you’re right I’m using this code to refer to a node in order to fill it. Bear with me I’m an array newbie but I defined my array something like this array(1 to 9, 1 to 2) So this is a 9 row array with 2 columns right? But based on your solution above, it seems a little different from what I’m...

its type long integer

I was wondering could I use an array as the CASE in a CASE STATEMENT like below? Select case array(I,J) Case (1,1) Case (1,2) End select

# sign added to end of value When I type: tempSAP = 60614907704 I get this instead: tempSAP = 60614907704# Could someone explain please?

Missing menu I cannot find nor enable a custom menu that I have no recollection of ever having deleted or disabled in my system. This is scary. Any suggestions?

Printer icon face id value Can someone please tell me what the faceID value is for the PRINT icon is? I can’t find it!