Recent content by PMrider

How about Now() which will show the date and time together

in the ON CLICK event procedure of your combobox add DoCmd.ApplyFilter, "[yourfieldname] = Forms![yourFormname]![Comboboxname]"

go to TOOLS/OPTIONS then go to the GENERAL tab and uncheck all of the NAME AUTOCORRECT. This will speed up your forms opening up.

I have a working calender to where you just double click the date field you want to insert the date. Email me if anyone wants it. Its 2 moduals and 1 form akolln@srt.com Alan

Does anyone have a model on the use of ItemsSelected for list boxes. It will be greatly appreciated. akolln@srt.com thanks.. Alan

Base your report on a SQL statement and in the recordID or primary key field criteria insert =Forms![FormName]![RecordID] the report should only show the record you have open on your form

ok, Here is my problem. I want to be able to calculate the number of days between deliveries on my subform. The fields are: InvoiceID, Winter/Summer, DateOfDelivery, GallonsDelivered, PriceperGallon, RateStatus, Driver, Remarks. The final result i'm trying to achieve is to have a text box...

I'm very new to VB and i'm not sure how to do the recordsetclone or the FindNext. I'm wanting to use an unbound textbox to display the next record's DateOfDelivery on the current record. since my underlying query has my records sorting decending so I can show the most current delivery first...

I tried to lookup PrevRecVal in my help screens and could not find it anywhere. I have Access 2000. Is it somewhere else?

This is what I came up with and it doesn't work. I'm not really understanding how do I do a lookup on the next or previous records to put in the current record so I can use the DateDiff =DLookUp("[DateOfDelivery]","F_Delivery Subform","[DateOfDelivery] = Forms!F_Delivery Subform") Pleae...

I'm building a database for deliveries. I want to be able to calculate the number of days between deliveries using just the [DateOfDelivery] field. Each delivery is a separate record on the form.