Search results

I have a command button that will open a particular PDF file. Is there a way to have it open a file for that current record without having to browse? I am thinking I would name the file the same as the reference #, and then possibly ask to open the file name that equals me.referenceno Is this...

Thanks for the response. I get the same error either way. Gary

This is my string to calculate the next increment # based on request date and users initials. However, I get the #NAME? error when I run the form? =DCount("[INCR]","tblPURD","[reqdate]=" & Format(me.txtreqdate,"\#mm\/dd\/yyyy\#") & " AND [initials] = '" & me.txtinitials & "'")+1 Any help...

Hi, I can get this to work in a totals query but not on a form. I have this for the control source: =DCount("[initials]","pickupreqdatafrm","[reqdate]=me.reqdate AND initials =me.initials")+1 Do I have the format wrong? I'm looking to return the count value and then concatenate the 3 parts...

This is similar to another response I've had but maybe I just don't understand what's happening in the line: CInt(Nz(DMax("Right(Yourkey,3)", "YourTable", "Left(YourKey, 3) = 'XYZ'"),0)) I'd appreciate anyone breaking this down for me (like what is Nz?) and maybe that will help me with my...

I want my db to generate our reference # automatically based on input from other fields. The number is the date record entered, the users initials, and an incremental number. Ex. 120505GMM02 My form is based on a query and I have the query generating the first two components from the date...

Ken, Thanks. I had created the field in the table but had not entered it as the control source. Duh!! Another thing, though. It works fine, except, if I make an error and delete the value from the date field, the ckbox remains checked. Can it be set to return to False if the value in the...

I have set three yes/no check boxes so I can use them in a query to see if results are in another field. One example: After Update Event: If me.pickupdate.value is not null me.pickupdateckbox.value = true end if This works except it gives the true value to all the checkboxes on every record...

Scott, Thanks a lot. But, also, is there a way to start the increment again and follow it for each user. Say, when GMM put in his third for the day it would give an 03 rather than, say, a 10 for the 1oth total order for the day? Thanks.

The title probably doesn't give an idea of what I need, so here goes. We currently have reference #'s for our bills that include the date requested in mmddyy format, the first 3 letters of the customer, the initials of the order taker and finally a sequential number to show the sumber of bills...

I was trying to go the query route but with little success. Basically, I want to return a result from my routing guide table that would ask for the origin state, the consignee state, and the service level. The only output I need is the carrier name to be populated into the carrier field...

I agree, very cool. But why would 1 star be excellent and 5 be terrible. I guess I'm just used to seeing it in the reverse. Gary

My suggestion is why have separate tables? Have your table contain the three fields (name, phone, & email). You could then set the Indexed? property to Yes (no duplicates) to whichever fields you choose. Name, however, does have the opportunity to be duplicated. Just an idea from another novice.

Here is what I am trying to do. I have a table with routes that tell me which carrier to use. This is based on from what state to what state it is traveling as well as the service lever (next day, standard, etc.) How would I code for the value in the carrier field to populate based on the...

Thanks. This along with my original code works perfectly. In your debt, Gary

I have the following code on the On Current event of form PickUpReqDataFrm: Private Sub Form_Current() If Me.RescheduleCkBox = True Then Me.RESCHEDULEDDATE.Enabled = True End If If Me.RescheduleCkBox = False Then Me.RESCHEDULEDDATE.Enabled = False End If End Sub This works fine...

Thanks Shane, I'll give it a try. Gary

I don't think so This is the translation literally - Of the words are changed enough, leave me also, finally, to actions sees! Would probably be worded differently in English conversation. What threw me off was that the word eleven given in your translation was not in the quote. The german...

my simple solution What I have done for this problem is to create a file named BOLTemplate.xls in a certain location. It has the report format on the first sheet with cells linked to a hiddend sheet. This hidden sheet is created when the user runs the transferspreadsheet macro to export the...

I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table. I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose...