Search results

think I fix that problem seems to be working good Now my partner has pointed out something strange. When you scan through the forms the Autonumbered ID's are not in order Example: Recordset #4(the last of the list) is actaully Incoming ID #2 Is there a way to Syncornize the Recordset and the...

it seems that the Date Range works if you put dates in that are larger then I want (from the biginning to the end), then it lists everything the way I think it shoud be. but if I do a search for a single day, let's say 06/03/08 to 06/03/08 then all fields are blank and i get no error message.

I think I may have found my problem ID#1 [Incoming Style]=Drop-Off ID#2 [Incoming Style]=Pick-Up But ID#3[Incoming Style]=Drop-Off again So i am going to try to build a report and group Incoming styles. If you are wondering i am trying to build a shipping and receiving database.

i am using a form with a subform linked by ID ...does that help? It is picking up all items in ID#1 and ID#2 but that is all though I put in dates that are past ID#2

Now it is only picking up 2 out 6 ID's

Correct, set it to 2

i Read about the date reserve while going though some of the other forms here and have changed all Date fields to MyDate I think that this what you were asking or the SQL: SELECT [Dateform].[DateFormID], [Dateform].[DateFormReportName] FROM Dateform;

Sorry the '_' under strWhere is not in [Event Procedure], must be a cut and paste mistake.

Sorry so long in getting back but here is what I have done: Made new Date Range Form 1- ComboBox which which gets the Name of the Report from a Tables List (Name of ComboBox is cboReportName) 2- Date Entry Boxes BeginDate and EndDate Set to short date format 1- Botton Command labled 'PreVeiw'...

Sorry RG I don't understand what you are asking( i have been rebuilding computers for years,just recently got in to the database building,self taught) but hope this helps. It is the guide line I used to build it. 1. A) Build your form with 2 unbound text boxes set to enter short date only...

By a Report Date Range form with [BeginDate] and [EndDate]

I have been trying to build a database for my business for the last 4 months off and on. I am down to doing up the reports and am stuck again. I have set up DATE FORM and added a text box to the report. When I click on the Report it brings up the Date Form, but when i click OK it still lists all...