Search results

Ok I figured that part out...but it gives me the following pop up: "You can't go to the specified record"

You have to put a recordset infront on the movenext method. There is a problem with .MoveNext.....I think you have to put something infront of it.

Sorry if I came off unfriendly. It's just the frustration talking. It's a long story to explain why I need this done, but I do. I'll give your code a shot. Thanks.

Can anyone tell me if this is possible and how to do it? Thanks.

That's essentially what it does already. My combo boxes are all unbound. What I need is when the user clicks 'Add Record', instead of adding the record one at a time, it would add lets say 30 of the same record. Any clue how to modify my existing code? IE. Where to add a while loop?

Please, if you know how to help, please do so. I wouldn't be asking if it wasn't for a useful purpose.

I want to create a button that adds as many records to a table as you want. So I would have - a text field where the user would input the number of records - the code of the button having a for loop or while statement to add that many records as the user typed in This is my code of a button...

Is it possible to modify data values in a cross tab query? I tried and it won't let me delete or type anything. Thanks.

Thank you! I appreciate the help.

I am trying to link Primary Key (autonumber) to a double field in another table as a FK. I get this error. Relationship must be on the same number of fields with the same data types What is the problem? There is no problem with the data itself...it should work. But is it a problem with the...

If this can be done, can someone please tell me how? My form name is called test. Combo0 is a list of Oil_Names from the Oil table I want the text box called testbox to display the Oil ID, after I choose the Oil Name from Combo0. Do I create a query for the record source of the test form...

Post my database?

Is this possible? I want to have a combo box with a listing of names from a table. Once you choose a name, a textbox in the same form (not subform) populates with the corresponding ID. Thanks.

Thank you guys! Wow...compacting makes a big difference. Went from 435 mb to 19 mb. Sorry for the stupid question. I didn't even know this utility existed. Thanks again!

Sorry...no I haven't. I don't know anything about compacting databases.

I see. But I still don't understand where the almost 400 mb came from. I didn't add any graphics or sounds. I just added a couple forms and drop down menus.

Just to check...I made a copy of the database and deleted all the tables, forms, queries in it....and it's still 435 mb. How can this be?

I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?

Because I'll then need to hardcode the column names. I don't want to have to do that because they will be changed.

Actually if I have a table like this: WORKER Name Age Instead of my report looking like this: Age.............Name 1................Bob 2................John 3................Dave I want it to look like this: ..............................Age .................1.............2...............3...