Recent content by sp00k

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...

Yeah, thats pretty much what my boss wants. He wants to know what came in, just in case there is any issues with the original shipment in later times. But he wants to know how much of *a certain item* he has at any given time. As well, he wants the employee who gets the items ready for the...

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...

Actually that does work. Just missing any Colour that I've added before (alternate line colour and lines) though this will have to do. Maybe save it as a pdf, then into a jpeg, and paste all of the pages into photoshop? i will try this!

Yeah thats what I did. Still can't get past 22.75 inches, and there is not page customization that allows me to choose a very long page(40inches lets say). It's weird that you can do custom print pages in word but not access:(

I don't think i did, how do I do this? The plotter is set to my default... but i did not nominate it as the printer source for report!

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...

thanks! working perfectly...at least for now :D

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...

Thanks, i will give that a go(I like the color picker example!) I haven't used VB coding too much though. Is there anyway to use the expression builder? or should this be pretty straight forward?

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?

RTFM... Microsoft must have missed putting a manual in my access packaging. I had my date formatted YY so i thought YYYY, I wouldn't work, didn't explain that in the help files.

Heh, I just found it. DateAdd("M",12, tblVehiclesDatabase.AnnualInspectionCertificateExpiry) As AnnInnDueDate Seems to work, I tried "Y", 1 but that only changed the day for some reason..?

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!