Search results

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.

I made a form with several combo boxes on it and I need to print a report from this form. I did this in a hodge-pod way and I almost have it working but have hit a wall on how to fix my problem. Right now everything is on the report except for the Item Number. I am sure now that I have done...

Wow! so simple. :o Thanks.

one form in my database? I would like to put a password on one form; all other forms are open to see. Can this be done?

Hello I have a database that opens in maximized form. I also have another form that opens when a button is clicked. What I want is for the second form to open small and not maximized like the main form. Can this be done? Thanks

Hello, I need some advice. I am currently trying to rework and enhance a database where I work. It was set up for printing work orders only. I have enhanced it to keep a database of Customers and will soon get a tracking form up and working. My question is; should I put all this effort into...

Thanks for your replies that is some useful information I will use. BUT....I noticed that you are pulling the data from the table, I read somewhere that one should never populate a form straight from a table but use a query to get the data and then populate the form. Thats what I was trying to...

Hello I hope someone can help me on this one. This is something I am not getting an understanding on and need some help. I made a form that holds all information for our customers. I want to make the Company Name box into a combo box so when I change the Company Name in the combo box it...

Well I tried the analyzer and it has not finished. I will let it run tonight when I leave and hope it gets done by the morning. I will see what happens then. Thanks

Hello I have a question. I work for a company that had someone set up an Access database that generates work orders. That person created a single LARGE table. 107 fields in the table. over 3000 records created so far. Should I bother to try and normalize it? Can it be Normalized? Is it a...

I would like my form to open and automatically go to the end of the records, so I don't have to navigate to the end before I start entering data. I have seen a form do this but can't find out how. Thanks