Search results

dcx, Thanks for posting that picture, I see now how to set up the append query will work on it and come back and tell you how it works out. I need that picture!

The append query would work for fields A......but the update query is not what I can use because I do not want to update the values in fields B and C, I want to add the records so a person can view all the changes that have taken place. In field A say the value is 1, There could be several...

I need code or help getting started with code that will compare two tables looking for any changes in fields, the two tables have the same fields, one table is called hist and another is called changes, consider my two tables have 3 fields name A, B and C. While A is like the Id of the records...

Thanks WayneRyan:D

AncientOne, first thanks for your help. I have found this line of code which is working well for me DoCmd.TransferText acImportDelim, "file import specification", "tablename", "filename.csv" found that due to WayneRyan post thanks WayneRyan. his post help me to do a better search. to find how...

AncientOne, They are csv files and I will have over a 100 to import

Is there a way to import several files at one time instead of importing files one at a time. Like could you set the names of the files to be imported in a macros or modules click a button and then it would import 10 files while you do something else? if so whats the best way to do it?

Thanks WayneRyan and dcx693, WayneRyan, putting code in...Private Sub Combo62_GotFocus() Select * From tbljobs Where DES = '" & Me.YourCombo.Column(0) & "' And " & _ "TYPE = '" & Me.YourCombo.Column(1) & "'" It does not like the Star....at the star it gives a compile error expected...

How do I make a combo box that has two fields for the key to select a record on the form? the first field is A and the second field is B I can alway get the right A selected but if there is a second or third B to go with that A I can not get the record to come up by select the choice in the...

Tiro, I just tested your code and it works great.... your code does also gives the option to print all reports you do have to make sure you have a combo box and two buttons and then name them right but it covers every things cfp wants

cfp, no dont wipe out your form but if I understand how Tiro code is working you do not need a table with the report names.... Tiro has code for a print button, preview button and the combobox and the form....take all of Tiro code and place in the form and rename your buttons and combo box...

I would think that cfp means added the name to the table, was it a refresh problem by not showing? after adding to table did you reopen form and then the dropdown?

Thanks Pat, When I saw that you were here was hoping to get answer from you thanks!

this is the print button code: Private Sub Command0_Click() On Error GoTo Err_Command0_Click Dim stDocName As String stDocName = Comboxname.Value DoCmd.OpenReport stDocName, acNormal Exit_Command0_Click: Exit Sub Err_Command0_Click: MsgBox Err.Description Resume...

Thanks for the function and the heads up on the sometime error!

When a new record is started, I have a sub form load in a list of default records per the user request. Those would be the C values and then the user fills in the D values example field names............ C.......................D values..........Start proj................01/01/01...

Jay, Thanks a bunch that did exactly what I was wanting it to do! I did change your lines to below and it works great! Me![DES].DefaultValue = "'" & Forms![frmjobs]![DES] & "'" Me![TYPE].DefaultValue = "'" & Forms![frmjobs]![TYPE] & "'"

Here's another question on popup forms. In my main form I have a subform that has two fields date and notes.....It is link to the main form by two fields Des and Type On the form I have a button that makes this sub form to popup.....When I add data inside the popup form it adds the data but...

Thanks Autoeng ! thats is what I needed to know

I am using a Continuous Forms and need to use that type.