Search results

Thanks for the reply. I'm not sure I'm following your syntax in your example. Is the Dlookup part of the actual Append query or something done after the fact? Also, I chose not to do as the original post indicated because I will only have 1 header record with the detail records that go with...

I'm importing orders into a temporary table. There are two types of records that will be imported. 1) Header records (IH), 2) Detail records (ID). As soon as the records are into the temporary table, I am appending the Header records to the header table, and the detail records to the detail...

Got it. I'm officially lame. Thanks again. Have a great weekend. I'm out of here.

Just kidding. I found that easy enough. I have this code and now I'm getting the following error: "Run-time error '424': Object Required" Public Function CSNImp() Dim dlgOpen As FileDialog Set dlgOpen = Application.FileDialog(msoFileDialogOpen) dlgOpen.InitialFileName = "Y:\Access...

Got it. I'll make sure all users have at least 11.0 library in their references. Sorry to bug again. YOu are just such a wealth of knowledge.... Can I default the open to a particular directory?

All I have available is 12.0. Will that work?

Within my references, I have "Microsoft Access 11.0 Object Library" checked. Is this correct?

Wow! I'm turning out to be a real dweeb here. I'm not sure how I do that. I am using access 2003, but my DB is in Access 2000 file format

Hmmmm. I'm now getting "Compile error: User-defined type not defined" It highlights this section of code: dlgOpen As FileDialog

Awesome! Thanks. So, both pieces of code I need to use, right? Put each one into its own module? Or into the same module? Is one function calling the results of the second? Thanks again

Looks like this is the syntax: Dim dlgSaveAs As FileDialog Set dlgSaveAs = Application.FileDialog( _ FileDialogType:=msoFileDialogSaveAs) dlgSaveAs.Show So, if I want to put the file as the variable in the TransferText command, what part of the above code do I use as that variable...

You mentioned that you prefer the API...hopefully not because its easier... Can you tell me about the built in Dialog? This really should be pretty simple I thought.

Wow, so I need to put ALL of this code into the module? ' This code was originally written by Ken Getz. ' It is not to be altered or distributed, 'except as part of an application. ' You are free to use it in any application, ' provided the copyright notice is left unchanged. ' ' Code...

Oops. my bad. I had named the module same as function. I have now named module "Test" and function "Testing" I'm now getting the error: "Compile Error: Sub or Function not defined" When the error pops up the portion of code that is highlighted is "ahtAddFilterItem"

So if I can get the examples to work, I'm usually pretty good about massaging them to get what I need. I have this exact code in a new Module (not on form or in report). As I try to run it, I'm getting "Compile error: Expected variable or procedure, not module." Public Function Testing()...

I'm obviously new enough to code & syntax that I can't exactly tell what I'm doing here. I put in the sample code into my VB editor and I get the message "Compile Error: Sub or Function not defined". when I click "ok" the part for ahtAddFilterItem becomes highlighted. Not quite sure what to...

I think this helps me out. One question. What if I'm doing this from the user switchboard? I'm not actually doing this from a form. Can I still just code this within a Public function on my module and call that function from the button on the switchboard? Shouldn't be a problem, right? I'm...

Dialog box. I'm looking into CommonDialog now. First time using it. Any help?

Sorry, I think I made it a little unclear. This is a process I'll be doing repeatedly each day. On any given day I will have X amount of files to be imported. I need some way to select the file for importing. Then I'll move on to the next file, etc, etc.

I have a series of files that I need to import on a regular basis. All files will be stored in the same folder and will be .TXT (Pipe delimited files). I am using Docmd.transferText acImportDelim function. I have created and correctly input the import specifications, indicated the table name...