Recent content by John Nelson

I'm trying to figure out the best way to print out a report that's generated from a query where the user inputs specific criteria. What I'm wondering is how to give the user the option to input multiple criteria to print out multiple instances of the same report, but based on the multiple...

Do you guys happen to know if it would work to run the compact/repair (in access '03) command using the DoMenuItem method? What is the most recent menu version? I used acMenuVer70 and I'm not sure if that's right, because it doesn't seem to see that command. Thanks.

Oh okay, I didn't even think about that. Thanks for the help!

Ghudson, first of all... thanks for the reply. I appreciate your patience. I see now that there are a lot of similar posts around - obviously my search wasn't thorough enough. That aside, I've been playing with your code and it seems to work up until the Shell command goes looking for...

Ideally I wanted to allow the user to do the same thing as Tools>Database Utilities>Back Up Database. But it looks like what you've provided will do just fine. Thanks a lot for the help!

I'm trying to make a button to allow a user to back up the database. Though, when I click the button it gives me an error that says: "Command or action 'Backup' isn't available now." The code is nothing fancy. I'm just not sure what I'm doing wrong. Private Sub cmdBackup_Click()...

Hey Wayne, thanks for the reply. I actually have a child/master set up. It's a field called CustomerCodeID that ties in the customer's configuration and pulls from the query (the form is based off of) the information specific to each customer. I'm not sure that's the problem, because the form...

I have relatively simple subform that allows the user to check an order's configuration of part numbers and their quantities. I set an INSERT INTO statement on the part number combo box to the "NotInList" event and everything seems to be working correctly except that when the focus leaves the...

I'm not sure what you mean. Resetting it to what? It's set to the table I want it to pull from. Is there a reason I'd switch it?

I have a form that I have linked (master/child) to a combo box on my main form. I have a requery command for the subform set to the "After Update" event on the combo box. When the combo box is updated originally, the subform updates. However, if the combo box is updated after having a value...

It's definitely possible. Do you already have your master/child fields selected? If not, you need to set that (on the subform's properties) to a field that relates the two tables. It looks like PromoName is the only common field, but I like to use ID fields (and then just hide them in the...

Hey thanks a lot. I'm going to give that a try. In case you guys are still watchin' this thread... What's the best data type to use for numbers with decimals? I used variant just because I didn't want to have to deal with what could happen if I use the wrong one. Thanks! John

I'm having trouble with the INSERT INTO statement. I can't figure out why I'm getting a syntax error. Any ideas? strSQL = "INSERT INTO tblTransactions ( PartID, ProjectID, TransDate, Qty, TotalPrice ) " strSQL = strSQL & "SELECT" & intPartID & ", " & intProjID & ", " & datDate & ", " strSQL...

To continue Liv's thought... If you did disable the menu through the startup option you can get around that by holding the "shift" key when you open your database. That will bypass any startup settings that you've changed.

That did it. Thanks a lot lagbolt!