Search results

I have a query and in it are three check boxes $25, $10 and $5. Is it possible to build a calculation into the query that if check box $25 is yes then $25.00-if check box $10 is yes than $10.00-if check box $5 is yes then $5.00. If this is possable could you please tell me how I could do it...

did you try a union query from the data in the tables?

I have a form that runs off a query, there is a text box 'cosr per copy 1' that auto populates a cost once a copy type is selected from a combo box. in my query I also have 'cpc 1' field that links to the job table and it is set "CPC 1:cost per copy 1" when the form is open it will capture the...

thanks Pat

thanks, one more question how do i bind them?

save text box data to table????? I have a form that is controlled by a query, on the form is a text box that is auto populated by a combo box, how can I save the value in that text box to a table field??? Query: job summary query1 Form: job form combo box: combo17 text box: cost per copy 1 I...

Is it possible to have a combo box save 2 different fields into a table? If so how is it done? Thanks for any help

you say you only have one report. what do you mean by all reports? do you mean you only want to print one record from that report?

I have a form used to edit "jobs" in a database. I want to use combo boxes for some of the fields to change the information. I CAN'T GET IT TO CHANDE IN THE TABLE. Any Ideas? all help appriciated

I get this error message when I try to export any report from this program to Excel. Any suggestions??

Pat I do have it in beforeupdate on the form.. Thanks again for all your help you truly are a master at this program. Thanks

once again help is needed Can I use this code in the before update for two different fields on the form? If so how would I write that? Help is greatly appriciated.

Thanks

Access is capable to handle it, and run it. however, it would probably run faster and smoother if some of the database was converted to sql and ran on a sql server.

I am working on an old database that was not well thought out. My question is I have a table cammed "recievers" id contains an id, account # and location #. I also have a table called "Purchase orders" Among other thigs it also contains. id, account # and location #. However, in the ID there...

Pat thank you, thank you, thank you you are a lifesaver. One more question if you don't mind. I used this code on multiple forms for the name entry. but I cannot get it to work on a date field??? could this be because it is linked to a query and not a table? any help appriciated. thanks again!!

Pat I tried your code maybe I am putting it in the wrong area can you help me please. Preventing the form close is a little more work. 1.Create a form level variable named Dim gPendingError As Boolean I put this under the option explicit statement...

I use now() to get exact times that an employee worked on a task. I need date() to pull the production report for each employee for a specific period of time. thanks for the help!!

If I have a field in my table that is "NOW()" is there anyway I can change it in a query to be "DATE()"

Sorry Pat I didn't try your code or saw it when I wrote my reply. My reply was to Newman.