Search results

When I double click the report and open it manually, the report comes up fine...except it comes up for ALL 9500 records. When I use the button on the form (which used to work fine) to print the report for ONLY the CURRENT record, I get a blank. Here is the code for my button Private Sub...

I want a warning message to pop up if the data entered into the field isn't a certain number of characters. What's the best way?:rolleyes:

I have a number of dealers: each of these dealers has multiple locations. Right now they are each set up in the same table with each location as a separate dealer. ex. dealer1 - locationA dealer1 - locationB dealer1 - locationC They have a number of different fields...one with the long name...

unfortunately that isn't the case here. All the records are showing the same dealer and all the different dealers are in tblDEALERS as DEALERBUY is looking up from that table. this is frustrating as until I get this figured out my report won't work. I changed one little thing and BOOM! ARGH!

As you can see with the attached photos, if I just query the serial numbers and dealers everything comes up exactly as it should... If I add the second table...I get the individual serial numbers but all the same dealers.:banghead: I know I'm overlooking something small but can't figure it out.

I built the combo box and a query with the field. also, the entire report is based on a query. sorry if this is frustrating to you. sometimes I need things spelled out for me. see photos

is there a way to "Trim" combining the two fields?

another note...If I just add the city field or state field to the report...it works fine but if I =Trim for the city/state...it comes up with the numbers. ????

CRAP! yes I do. now in easy to understand terms...how do I fix it so it comes up. I have a look up field for the dealer name and it is coming up fine.

When I run the report query, the city & state come up as the words but when I run the report print preview, it comes up as the numbers...why?:banghead:

Those don't describe my problem. Hmmm...the VBA seems fine still. I checked all the other check boxes in the form and all work fine except that one. What to check next???

One check box is causing a crash all of sudden. Everything WAS working fine and then...BOOM...CRASH!! I've tried copies and I've tried a compact/repair. Help?

I'm feeling like a giant idiot that I can't get this to work.

here's what i have now.

Still not working. I have it as a label in my report and I have it set up under report properties "On Open" I have the label associated with the control "State/Prov"

:banghead:I'm trying to get a box to only show if the state of Montana is there. here is what I have.

Hmmm...I must have something wrong because it didn't work... Private Sub btnSHIP_Click() On Error GoTo Err_btnSHIP_Click Dim stLinkCriteria As String If Me.Dirty Then Me.Dirty = False stLinkCriteria = "[Serial Number] = " & Chr(34) & Me![Serial number] & Chr(34)...

I'm trying to get my VB written to ONLY open a report if the DriverID is "SELECT CLASSIC CARRIERS". This is what I have... Private Sub btnSHIP_Click() On Error GoTo Err_btnSHIP_Click Dim stLinkCriteria As String Dim DriverName As String DriverName = Me.DRVID If...

lovely. ugh. I've been trying to make this database "Normal" for MONTHS! Still a work in progress.... Thanks for all your help/feedback Bryan! :)

They both run from different queries. The two unit report (generated from a query) is pulling two different records from the same table. My understanding is that I need two tables so it can pull the information for Unit #1 from the original table and Unit #2 from the duplicate table.... not...