Search results

Hi vicgirl. All you have to do is to create a new table by importing the specific excel sheet you are interested in. Make sure you let access create the primary key for you. After this you create a query that looks like this: SELECT * FROM YourTable WHERE YourTable.ID>0 And YourTable.ID<36...

Damn! It still doesn´t work. I´ve been moving the code around and triend all things I can think of, but no success. Thanks anyway Len.

The little workaround I proposed earlier works in my head but not in VBA... What I want to do is to move the content of one textbox to another, but the problem is I´m new to procedural programming. The problem would be solved in the blink of an eye in Java... My code looks like this: Private...

Oh, your gonna be like that now, huh? :)

Heh! Your suggestion is exactly what I´m trying to pull off at the moment, Len. My idea is to let the "imported text boxes" be "visible = false" and then copy their contents to another set of textboxes that has their control source set to the table I want them to be saved in. It ain´t pretty...

Thanks for the reply, Len! I tried your suggestion, but it doesn´t work to my satisfaction. The reason for this is that the control source currently is set to the iported tables field that I want to fetch. If I change the control source to the place I want to save the data the program doesn´t...

Hi, all! I´m self learned and a bit of a novice so bear with me... When a user wants to enter a new post, the first thing they have to do is fill in a message box promting them for an id-number. When they fill this in, my program is supposed to take that id and fetch a couple of items from...