Search results

Hello, I have an append query that kicks misc. data into a 500byte string which is required by many of our customers. We have a customer however, who is requesting modifications. What I need is a field in the append query what will count each line and enter the corresponding line number in...

I GOT IT ALL! THANK YOU ALL SO MUCH FOR YOUR HELP!!! *hugs*

I appreciate everyone help with this - I will be SUCH a hero if I can make this work. Kryst51 - thanks for the idea - I am open to anything but still just above the novice level so let me make sure I understand. Are you basically saying to make an extra box with an if then statement? I...

Okay, I put the code below into the format section of the detail on the report(label) as per this link: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=31935&d=1272576420 It's giving me a macro error. Do I need to list the Textbox or the Field name? I tried it both...

Okay - Text2 contains the field "Item".... in the "on click" I put the code below but nothing is happening when the report(labels) open: Private Sub Text2_Click() Select Case Me.Text2 Case "EAGX" Me.TextBoxName.BackColor = 3937500 '(gray) Case "GATX" Me.TextBoxName.BackColor...

Okay - stupid novice question...where do I put that code? Tried a couple of places but nothing happens.

Thanks all! Will get to work!

THANKS!!! Where can I get the color codes?

We have 1/2 of the systems here running 07 and half on 03 so it's probably best to set up in 03 correct? Can you give me a sample code? I'm still just a little above novice level. :)

I am trying to create a label report with the attached form. I have it all designed and seems to be working great. What I need is the car number (shown here in grey) field to changed based upon the content. For example this "car id" is TILX and needs to be gray. If it contains GATX the...

Well, I have and I haven't. They have changed the policy annually. I wish they'd settle on something. I thought they had visited this one previously but I couldn't find that post. THANKS for finding it!!

Thanks! I'll try....how would I convert that into an if then statement to use in a text box?

Happy New Year All!! Our vacation policy changed with the new year and I am pulling my hair out trying to figure out how to have the database automate the vacation available for our employees. Let me see if I can explain this properly. Previously, vacation was figured based on your annual...

Thanks for your help but I'm still a little confused. I need to type all that in the text box? Also, sometimes the number may be 1234.56 and sometimes the total bay be 12345.67 but at all times I need it to display as ten characters with leading zeros. Does that make sense? Basically I need...

Hello, I have a column in a report that I am adding up to total an invoice as normal such as 1234.56. I also need to kick that total out in a 500byte line on the bottom of the report so I have a text field (62) that says =[text54] and this works fine however, I need that field to always have...

I have no idea how to do that....

Database Attached... Sorry for the delay....I have been off for a month with surgery and trying to work on this as well so I've been somewhat in and out. I have tried shrinking th database to 1 record in each table but it is still 910kb and it won't post it so let me try to better explain. I...

Thanks but it is still only clearring the 1st box. My form has 38 rows and currently 4 check boxes (print box) selected. Is it because it is a field in the table? UGH!

That worked but it only cleared the 1st check box and not all the boxes on the form. Each row in the form has a print check box at the end so you cn select the lines to print...is there a way to make it clear all the checkboxes? Thanks!

Estimate/Supplement Approval Number..... The form contains the fields estimateapproval and supplementapproval from the table. On the form I have 2 unbound text boxes: 1) Estimate Approval Number 2) Supplement Approval Number In the bound textboxes from the table I put...