Search results

Basically we have numerous pieces of equipment that use a specific motor or belt or bearing... but that part is also used in other pieces of equipment not just that one piece of equipment. I have linked what I have so far. The columns labeled with the ID are the actual pieces of equipment...

I have a table called tblEquipMaster. This table has one column and it holds all the equipment IDs for our equipment. Some of these pieces of equipment use some of the same parts... so I thought I would create one table for each item like one table for motors, one for belts, one for bearings...

I am wanting to use a master table to add a piece of equipment to and when I add that piece of equipment in the master table I want it to populate in multiple other tables as well. Is that possible?

Is is possible to have a form command button add data into several columns in a table through vba?

That worked... I didnt even think about using the value element of that field... thx.

Yes it is on a form, so there are multiple rows with the same field info, and I am only wanting to update on record on the form otherwise I would use the default value for =Date()

I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?

I just realized that in the table I needed to have a column for each separate number I was entering in the form. duh!

I have a text box linked back to a table and I am needing to be able to make multiple entries at one time for this text box but when I enter the first number and hit tab all the other text boxes that are linked to this one in the table show the same number....

ok... so on access 2007 when I choose to open an event procedure from a form open vba in general only the module I selected or even procedure I selected opens in vba. Not all of the modules, event procedures and so forth... So what I meant was how can I get that to work like that in Access 2010

oh.... duh I should have known that..... :banghead:

Is there a way to make a text box populate a predefined number based off what time of day the form is opened?

I can provide you an example contacts db that I built if you would like?

Just upgraded to Access 2010 and now when I open a vba window... all of them open not just the one I need. Is there a way to stop that from happening?

Thanks for the quick responses guys.

What steps do I need to take in order to convert a 2007 database into a 2010 database

OK..... but if I create databases with Access 2010 I wont be able to use Access 2007 to open them will I?

Will Access 2010 open Access 2007 databases and allow me to function within them normally? I am being told that Access 2010 will not work with 2007 databases.

I am needing help with some queries. I currently have a PM form that duplicates the daily records so I was wondering if someone could look at these two queries and tell me if anything in them might cause duplication. The first is for a daily pm list: INSERT INTO [PM History] ( [PM#], [Last...

Got it. Private Sub cmdCompleted_Click() On Error GoTo Err_cmdCompleted_Click DoCmd.SetWarnings False DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True Exit_cmdCompleted_Click: Exit Sub Err_cmdCompleted_Click: MsgBox...