Search results

Which book is better, I’m not quite a beginner, but I’m no mean an expert (still have trouble with some challenging relationships and normalization) I was wondering what book would you recommend. So far I’ve been looking at two. Beginning Database Design Solutions (Wrox Programmer to...

I have a field that I want to color if the checkbox is selected. I have [MntConfA]="Yes" (format the text green), [MntConfA]="No"(format the text orange) so far, which worked with a drop down list. but is not working with a check box. Any ideas? i've tried using true/false but to no avail...

Basically I have to create a database to keep track of bulk orders that we receive. I have a tracking form to know when it came in, and what was in the certain shipment bulk order(finished this part) Now the hard part. I should have another form that combines all the same items from the...

Basically I have a report that stretches 16 inches wide and about 24 inches down(almost two full pages on tabloid setting). I need to be able to print this onto a plotter. Access does not allow anything over 22 inches, so I need a new approach. I have tried acrobat, but it seems that it saves...

Basically I have it so, two dates can be entered on the form, the earliest date shows up on the last four digits of the project number(the later date does not) I ran into a problem when rcDateSiteAwarded is null right now I have: =IIf([rcQuoteSubmitted]<[rcDateSiteAwarded], .... so on...

So basically I have a report about vehicles. I have the name of the vehicle and the color of the vehicle. But I want the vehicle name background be the same color as the color field. I can't seem to get the color logic down. Any help?

Hello, I have a field where it says date a certificate was purchased, but I would like another field that displays the same date, but only a year from when it was purchased. AnnualInspectionCertificateExpiry is the name. I've tried adding 0/0/1 but it doesn't seem to work. Thanks!

Populating an access database from another access database, Is this possible in access? If so how can you do it? My one database has dates of equipment received(no internet there) So i bring it back and my other database has a section for when the equipment was received. I would rather have a...

Hey, I am creating a inventory database and I want to keep in normalized, but in this situation I'm not sure if I can. Basically a shipment comes in and from that shipment all the serial numbers, part numbers, part description, and Manufacturer number has to be recorded. The problem is most...

I have a table with multiple serial numbers(serial numbers, part numbers, part desc, a second serial number) which exceeds the amount of fields. I know there is an easy way to fix this, but i can't think of it at the time. My table looks a little something like this. SerialNumberA38...

Pretty new to vba, I need to make a control grab the first date entered from two text boxes. I have tried doing this in expression builder, but it was getting pretty complicated(not sure if you can do variables in expression builder) If anyone can help me out that would be great

So basically I have a bunch of text boxes, two of the text boxes gathers dates, and the others gather other info and puts it into a smart key containing keys from the date boxes and other boxes. The problem is I only want the date from the first date that was inputted. If anyone knows how to do...

Topic says it all. I have a drop down menu that connected to a table. When you change it, it should update the control beside it(from another table) with the current date. I've tried a few different things in the expression builder and nothing seems to work(not even updating it with a certain...

Hello, I have a union query that is grabbing last name(from the employee table) and also grabbing card number and expiry date(from cardholder table) It seems to work, but only when I have one UNION ALL. Anymore and I get this error "The Microsoft Office Access database engine could not find...