Search results

I guess what I am trying to do is populate the database. I don't care how it is done. If I do it in a query, where do I put the expression? :confused: Sorry for the ignorance! :D Christine

Colin: that would be pretty much it. Rob: the answer you posted makes sense, however, where do I run this from to make it work? How is it specified that the result must go in the "after" field? Thanks so much! :D Christine

Hello All! I am having a problem, basically because of my lack of knowledge of Access (which I one day hope to rectify! :D ), dealing with using an if statement to fill in a field. Here is the senario: I have two tables. One table, titled MainCategory has the name of the category, the Category...

John, Alright, so I did as you suggested, and I was all excited when I typed in the ftp site and it all came up...all of the files and folders located there. However, when I selected the file and clicked on the Import button, it failed. I got a message saying the "ftp location" is not a valid...

Alright, I am running into some problems trying to do this: While trying to set up the transferText in a macro, and I can't figure out what to put into the Specification name and File name fields. Obviously, the name of the file should go in the filename field, but since I am getting it from an...

Thanks John! I will try it out. Cross your fingers!! :D

Hello All! I hope someone can help me out with my problem here: I would like to import a file into Access that is located on an FTP server. I want to be able to do this quite often, so manually importing it every time it is neccessary is not really an option. So, I realize that some VB is...