Recent content by ThatDougGuy

The Combo box is there to spot the end-use form entering new SMnumbers. If you are updating the program look for a older frm that has a txtbox for in put. elsa you will have to make a new frm with all the field take are in the table that is used to creat the list in the combobox and the new...

For some reason I can not use the lineDim db As Database It wont take it when i compille

with the code above, can you get the table name and the fields names from textbox,s on a form ? so it can be used with diffrent tables

Thanks That helped alot when i use the Dim db as Database It will not take it ( "not user Difined" ) and on the set rst1 = bd.openrecordset("txtTable") i wanted to bring that in from a form can i do that ?

I need to open one table read the records in a loop, but in the middle if the loop i will need to write the data to another table after i work with it. I'm not sure what to do. 'Open txtTable For Input As 1 DoCmd.OpenTable txtTable, , acReadOnly Recordset.MoveFirst Do Until EOF(1)...

I have the name of a table. I need to find the date field in it and get the format for it. any ideas on how to find the field name and the format?? I'LL also need to find the name of the key field DOUG [This message has been edited by ThatDougGuy (edited 05-11-2001).]...

What im trying to do is.....leave soom hair on my head HA HA I have a screen with a button , when clicked ineed a screen with entry flied i have that but i wanted to bring one field from the first screen to the second .

Wow the programs sounds like it would be a great time saver I would love to have a copy. I can't wait to see how this is done ThatDougGuy@aol.com [This message has been edited by ThatDougGuy (edited 02-26-2001).]

Hi All The trouble is if i click on a button the controll stay on the button. i was hope to get it to return to the field that had focus before the button was clicked. ( the button stays indented ) any help would be great

Hi All Im new at VBA and boy am i stuck. What i need to do is write code for the arrow keys(up, down, left, right). the keys will be a command button and will need to work just like the keys on the keyboard(I need to remake the wheel here). I made a basic keyborad on the screen with cmd...