Recent content by Kriis

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.