Search results

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

That may work. The only other thing I can think of is the name of the sub doesn't match. In all of my trials of doing the same sort of thing, I never got the error you are seeing. I don't have access to some archived stuff where I had done exactly the same setup. Like I mentioned, I modified...

I am not sure about 2010. I know you can import custom bars in 2007 and utilize those without any issues - I use these as right-click pop-up menus. -dK

I believe it is a reference issue ... You are trying to do something from Sub MH2 and apply it to Sub MH3, however, you are not supplying the path from MH2 to MH3 (the Parent). I've done the same as you before but different implementation (from a module function) so I am swagging here, but...

I disagree. I think the OP is suggesting that the user opens the job form and assigns customer to the job. As PNGBill stated, what many are used to is to go to the customer's form and add a new job from this form (while seeing all previous jobs in a subform). I have applied the technique...

Think about it like this ... different human languages all say the same thing except with minor nuances, so I'd probably take a standard DBA/Coder template because everything you do in Access is being done in other languages. So is someone who holds themselves out as an .ASP programmer better...

And here I was thinking it was my ex-mother-in-law. :D