Search results

I think it would be called a "Bound" check box as it is a "Yes/no" field in the table with a default setting set to "0"?

I'm using Access 2010 on Wind 7. I have a Db with 2 tables. the form duplicates each field in the Tbl. Its a "Data Entry" recording of hard copies of many peoples records. Sometimes they make mistakes. So I have to enter as reported, and fix mistakes at a later time. So I have a "Yes/No"...

I'm using Access 2010 on Wind 7. I have a Db with 2 tables. the form duplicates each field in the Tbl. Its a "Data Entry" recording of hard copies of many peoples records. Sometimes they make mistakes. So I have to enter as reported, and fix mistakes at a later time. So I have a "Yes/No"...

I maybe should have added that each field in the forms is directly related to each field in the table. Hence I assume they are all "Bound" controls.

I must be missing something, or I don't explain things complete. I put your code in the Record Source field in Properties. And open the form the Query has run showing 22 records. However I don't want the Query to run until I push the button? Wha have I got wrong?

I have a form for data entry into my main table. Some records are correct, but some I need to come back to later and correct. So I have a button on the form to run the Query which works fine. But it opens in a new "Data Sheet View". Can I make it open in the original form so I can edit the...

ah ha lights came on, thanks, I thought I needed to use the same form as I did to initially populate the table. But using a separate form for setting the query parameters looks cool. Thanks

I would think that if the query selects the dates for the report then those dates must be available somehow to populate a text box, or at least only have to enter the dates once?

I must be missing something. Too old to do this stuff maybe. It fills the text box nicely with the date. But I have to enter "Start Date" and "End Date" 2 times. ???

SELECT tblLogBook.Log_Book_Nbr, tblLogBook.Date, tblLogBook.Driver_ID, tblLogBook.OffDuty, tblLogBook.SleeperBirth, tblLogBook.Driving, tblLogBook.[OnDutyNot Driving], tblLogBook.Unit_No, tblLogBook.Miles FROM tblLogBook WHERE (((tblLogBook.Date) Between [Enter Start Date "MM/DD/YY"] And [End...

SELECT tblLogBook.Log_Book_Nbr, tblLogBook.Date, tblLogBook.Driver_ID, tblLogBook.OffDuty, tblLogBook.SleeperBirth, tblLogBook.Driving, tblLogBook.[OnDutyNot Driving], tblLogBook.Unit_No, tblLogBook.Miles FROM tblLogBook WHERE (((tblLogBook.Date) Between [Enter Start Date "MM/DD/YY"] And [End...

I don't know how to do that

Thanks for your suggestion. However. My report is querying the last days records. So the parameters move ahead every day by one day. So I don't want to enter the dates 2 times. But would like the report to automatically report the date parameters in the header. So your suggestion make me...

I've got to build a daily report which will put in the header the start date and end date of the data summarized. I have the query boxes asking me to input the dates Start and End. And that will change every day. And the report tells me how many days but not the "Dates". Start and End...

Thanks for your interest in my project. This report needs to be run daily at the START of every day, hense there is no data for today yet. between date()-8 and date()-1 However that just returns the last 2 days data. ??? I don't have time in the picture. I'm trying to make it so that when...

Where do I put this code?

I want to pull a report, including only the last 7 days not including today. How best should I do that? What query syntax will pull those record out?

I have 3 calculations on a form that are there to only validate 4 categories of numbers. I don't whant anybody to be able to enter anything in those boxes. They are not data fields. So how do I avoid access to them?

Customer_ID is a key field

Hmm - my Customer_ID has to relate to 4 tables. I didn't think this was a "calculation". It's not in a calculation field but a text type. When one of several hundred contacts phones my dispatcher he identifies himself. We have the "OrderDetail" form open. And need to quickly identify the...