Search results

No I have not. I will try that. THanks

How would I go about this?

I have a form that users use to input data for our Work Orders. They also use an excel spreadsheet to do quotes. I would like to be able to open the quote from the Work Order form in Access so I don't have to keep opening excel just to print off the quote. Can this be done? Thanks

I have a report that I want to show on part of a form so the user can see the report in the lower panel of my form. Can this be done?

Thanks guys. I used the int() and it worked.

I need to have a text box show a number that is rounded down. Here is the code I have. This code rounds UP I need it to round DOWN. Private Sub cmdCalculate_Click() txtTotalPacks = Round((txtSheetsRan * [# Up]) / [# in Pack]) This ((2750*2)/1000) = 5.5 needs to be this ((2750*2)/1000) = 5 I...

I found this article. Think it might work? ACC2000: How to Update and Append Records in One Update Query

I read this somewhere and I think it is pretty good advice. TABLES are for storing information. If you want to do something with the information then use a query. I think you need to look into queries. Run your forms off of queries also.

I have 2 tables that contain the exact same columns. Basically titles and singers of CD's I have I want to make one table out of them. Is there a way to do this?

You should try to find a way to limit your data to one table. You could make a lookup field in one table that pulls data from the other table. That way when you change it it is changing the original table. First_Table name_ID (Primary key) F_name L_name Second_Table address_ID (Primary Key)...

Thats what I was afraid of.:( :( Thanks

How does normalizing affect current queries and forms? I need to normalize a database here at work, the original creator made one BIG table. My concern is how will that normalization affect the current queries and forms I have created based on the current table? I tried the Wizard but that...

Sela Ward - The Day After Tomorrow

I have a database my company uses to print work orders. I would like to make a tracking report we can use to keep track of where the orders are in the plant. I would like to make a form that we select the work order and click what area it has moved to in the plant and then print the report...

James Farentino - The Final Countdown (1980)

I have a form that all information on it is based on one table. I need to use a number from another table to do some calculations to populate a text box on this form. Example: FORM BEING USED TABLEONE field_#Up field_# inPack TABLETWO field_Sheets_per_min I need on my form a text box to...

I found another way to do it, got it from: http://www.databasedev.co.uk/disable_mousewheel.html Download the example here. http://www.databasedev.co.uk/downloads.html Works great!

I would think that you would need to change the code on your report. Since your report is already coded you need to change it to accept a value from your combobox. So say something Like If combobox.name = null THen print all else if combobox.name = name1 then print name1 Not quite the code you...

Here is the sample database I got it to work on.

I figured it out. I have attached my working version for those who need to see how I did it. Might not be perfect but it does the job.