Search results

More Errors... Hello again, I get an error user-defined type not defined for: Dim dbs As Database

Attempting to get this working... I'm back Wayne... With regards to the code snippet below: Code: ----------------------------------- sql = "Insert into MyChildTable (F1, F2, F3) " & _ "Values ('" & Me.txtBox1 & "', '" & Me.txtBox2 & "', '" & _ Me.txtBox3 & "')"...

Anyone with experience...? Anybody willing to steer me in the right direction on this...?

Thanks Thanks Wayne! I'll give this concept a try tomorrow...

Hello, For some time now I've been creating small DB solutions to accomplish various tasks such as Scheduling, Track Training, Overtime tracking, Vacation Tracking etc, etc... All of these work fine and some have been implemented for a couple of years now. All of the various DBs have been...

Thanks for the reply Wayne! If I understand you correctly, I can Insert subtable field data directly from values on a parent form textbox(parent table) as well as Current TimeStamp values instead of setting txtbox values from parent form to subform that way I currently have it...? If so, can...

Hello, How can I add a new record in a Subform that is generated from a button on the Parent form...? Then set textboxes on the Subform to values from code...? Previously, I was able to accomplish this when all the textboxes where on the same form based on the same table; however, I have...

Thanks! Thanks Jon! Had to rework it a little, but it worked fine!

Hello, I'm moving a field in a Table A w/ data to another Table B and would like to know if a Update Query can accomplish this...? The field in question is not a primary or foreign key but I don't want loose the data currently stored in table A I have copy/pasted the field into Table B; now I...

Anyone...?

I've attempted several different concepts to no avail... I would like to filter MainForm by address fields criteria available on a subform located within a 'Tab' container. I was invisioning a "Search Button" on the Main Form that opens a SearchForm based on the address fields: StreetNumber...