Search results

Unless it is tax related. -dK

Got to thinking. Check the form properties to see if the name of your custom menu bar is in the ToolBar property. If it is not in the drop-down, then you might have to import into 2010. Like I said, I don't know for sure but you are using a product barely out of the chute. -dK

I am not sure what you mean when you say that you used a query to auto-populate the other controls. What you can do is in the AfterUpdate property of the combo box control is assign the values to the other controls. E.g., Me.txtControl1 = Me.cboComboBox.Column(1) Me.txtControl2 =...

Why not append Table 1 to Table 2 then? If not, go into Table 1's design mode, add the field and save. Then run your append query. To answer your question though, no. You could use a data definition query for the mod and then an append query. I've never tried it but you may be able to...

If it is just a one-off then you can use a make table query to do this. Then you can be selective about the mixing and matching of fields in the QBE to be used in the new table. I am not sure of the whole using combo box stuff or why you would want to do that. Now if the scenario is that you...

No, that is fine. The deal is, you can set it as an SQL statement. I am not sure off the top of my head of the loading order since you use a query. You may be able to get away with using ... Forms!frmFormName!txtControlNamewithID In the critieria of the query under the ID column (this...

You betcha. Glad I could contribute (effectively). Good luck! -dK

Bob is not only clever in presenting the most elegant solution - he is the most astute in observation as well. :D Good luck, David. -dK

Greetings! and welcome to the forums! Can? It will probably be the only tool you need. :) Since they are forcing this tool on you, are they providing training as well? Might be something to bring up. Anyhow, regardless of your situation - here are some tuotorials to get you started...

What I think you would want to do is put in a Where statement on your SQL. On the Load property of the form, you can specify the control source of the listbox. So it would something like ... Dim sSQL as String sSQL = "(... your SQL Code ...) Where [PersonID] = " & Me.txtPersonID...

Like this? -dK

Okay ... suppose you have a country control on the form. Suppose for data integrity purposes it was a combo box control (and control will work, just using this as an example). Also, suppose the combo box stored the country primary key (autonumber) in the first column so the rowsource of the...

Much cleaner than adding in the empty records. I have to applaud since I rep spreading is in short supply on this end. <Applauds> -dK

Not append back ... but update, err, back? -dK

Haha .. yeah. I hadn't looked at creating a 'dummy' table and doing a union query to fill in the gaps, so to speak - and then using that as the output for the binary dump. I wasn't sure if all the index's started out at the same number - or if those were used to link all of the tables...

Here is something, although it is not a query. This method actually creates those records in the tables in question. In a module, you can create a new function using the following code: Public Sub FillIndexGaps() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim sSQL As...

It seems you are just entering a field name. Without brackets it will auto-input quotes - but for what you want, this probably isn't correct. 1. Back up your table. 2. Create a new query. 3. Select Update query. 4. Drop the zip code field into a column. 5. In the update row in this column...

This link will provide a solution. Although it also duplicates records in a subform, you can choose to use or ignore this portion of the code presented. But posted this link just in case. HTH, -dK

Is all good. I understand your question about the ordering - I remember running into the same issues. I actually cleared the links, assigned the source, then assigned the linkage. The perplexing bit is that it works fine with your other one and it fails on clearing the links not assigning...

If you have a form with no code in it other than your command button and associated query code does it work? If not, could you post the code behind the button? -dK