Recent content by k5kowboy

This particular time, I do need the calculation results stored because at the end of the year, I have to figure out total storage days for each company I am involved with. Legalities are such a pain sometimes

Brad ~ Thanks for the help. Everything I have learned has been through trial and error. I didn't even realize there were normalisms for naming. You have been a great help and I have the problem fixed now - and I worked a way to prevent an "accidental" clicking of the checkbox. Now, I have...

When I run each query individually under the Objects Query page, each one of them functions as they should - I.E., the Append Query updates the appropriate columns in the Inventory Table with the records that I have selected with a "YES" in the appropriate field and the Delete Query deletes that...

Brad ~ I e-mailed the code to your e-mail address listed here. Thanks for your help. This is my first TRUE big project for someone and am really wanting to get it right the first time. Thanks Ross k5kowboy@classicnet.net

WOW....I can't believe I overlooked the simple things like that. Was looking WAY too deep into it I guess. Thanks for the help.

"On Click"

Works great for displaying the results of the query. However, I need the information in a form so I can be able to add more information to it. Can I run a command that will copy the information from the query results and paste it in equivalent fields on a form? If so, how?

OK..here is my dilema. I have a check box on my form that I am working with. I have written the code for it to perform the required function..the only problem is that it only does it the 3rd time I check the box. Here is what I need it to do...when I check the box to indicate a "yes", I need...

I am trying to get the results of a query to show up in a form instead of in the results window. The query is run from a different form than the one I need the information pasted in. I have figured out the code to get the proper form to open up and also run the query, but I am unable to get...

I need to calculate the total number of days that I have something in inventory. I can't find any help with this, so maybe I can get some insight here. If I place an item in inventory on Jun 30th and remove it from inventory on July 4th, how can I get access to calculate that as a total of 5...

Hmmm The DoCmd.OpenQuery line does not appear to work for "special" queries (Delete, Append, etc). However, if I put the name of a "normal" query in it's place, it works just fine. Is there a special command line for "special" queries?

Here is what I put in place and it doesn't seem to work correctly. Private Sub Repo_d_Click() DoCmd.OpenQuery "UpdateInventoryFromGenInfo" DoCmd.OpenQuery "DeleteFromMainAfterInventoryUpdate" DoCmd.OpenForm "Inventory" End Sub If I put spaces between the words in quotations...

I have an issue that I can't seem to figure out. I have a form with a check box (indicating "yes") that I need to perform the following functions when it is checked. 1. Move selected data from "table 1" to "table 2" (I have accomplished this with an Append Query) 2. Delete that record from...