Recent content by Punice

You nailed it, sir. As soon as I saw the work 'type', I realized what I should have done and did it. I had the 'number' configured to 'single, 2 decimal places. I attached the setup that works. Puzzling though, is why did the previous two years db work correctly using the old setup. Thanks...

I have a form (frmState_Mileage), where a truck driver enters the odometer readings (M_Odom) for each leg of a trip. The form assigns a unique number (M_SerNo) to each leg's record, when a driver starts a new trip or continues on the same trip All records are saved in tblState_Mileage...

I did something like what you suggested in a query to restrict the sort, in descending chronological order, by "Pickup Date', to isolate the broker names to those who were used to haul the material entered in the loads form. I entered this: "[Forms]![frmLOADS]![Material]" in the criteria field...

Thanks to all for responding to my post. The two example databases are stored in my pc. They will save me from having to think or scour the 'net in the future.

I did use a form that held the broker names in a combo-box, starting in 2011. Now, that list contains 460 broker names that I can select from. It is a PIA to scroll down through all of them and associate the material with the brokers that I used to haul the material previously, to select which...

I understand what you wrote. Here is what I was hoping to achieve, if what I asked was possible. I'm a trucking company person entering data in a new form that will include all of the information pertaining to a load, such as: the name of the broker I will use, eventually, pickup location...

Is it possible to incorporate VBA in a report to send record's picked field's data that is displayed to a form. If so, please show me an example(s)

Using Access 2007 (I know). I have a form with a text box, where I can enter various commodity names. I want to pick a command control that contains code the sorts through a query for all records that match the name entered into the text box and open a report that displays them. I have already...

[/CODE]

Shokly, Your code was instrumental in helping me find the solution to what I wanted, as presented in my initial post and simplfied, down the line. Thanks you. Instead of using 'after update' to run the code, I found that the on-load was better. For the code to run as desired, I edited the...

I solve my problem by understanding shokly's code and modifying it. I'll post that code, later, today.

In the form's VBA under the combobox, I use this strLT_TN = DMax("[T_TN]", "qryTrip_Sheets") to get the last record's T_TN value. And, in the value list, the highest value integer, let's say, is less than that. All I want to do is add value list items from that integer to the strLT_TN...

Ok shokly, I'll give that a try, tomorrow after I return from a visit to my doctor. Thank you.

The Row Source is a value list (integers). Last year, it with a list between 1 & 99. I grew beyond 99. Those had to be manually entered. Because the list last year exceeded 250 with the additional burden of requiring the user to scroll through a long list to access a number to select to open...