Search results

Sorry that's just a typing error. In my query the quotes were there. I simply added "Like" to each criteria and that fixed the problem. I don't understand it but it's working now so I'm happy.

I finally figured out the problem but I don't understand why this happened all of a sudden. In the Criteria field of my query, I did not use Like. For example, for my status I used "open" or "ReadyForExcept" or ReadyforApprove instead of Like "open" or Like "ReadyForExcept" or Like...

Thanks. That will work.

I have a query to filter the results of my data based on a combo box located on a form. The form Combo Box is called cbo_Status. The code I have in the Criteria section of the query is [Forms]![frm_Main]![cbo_Status] Or Like [Forms]![frm_Main]![cbo_Status] & "*" When I run the query, with a...

By split do you mean that the data is in one file and the front end in another file? If so the answer is no. The data, forms and reports are all in the same database file. I am not sure what this means. However, I looked at the Event Procedure for the the On Click event. I removed the code...

I created a new database in Access 2007. The main form serves as a menu to open other forms and reports. After creating the whole thing, I wanted a button to close the database. So, at the bottom of the main form I added a Quit App button. To add this button I clicked on the button tool and...

Brianwarnock - I have been a way for a while but I finally got this to work. Thank you so much. I about pulled out the few hairs I have left trying to figure out how to do this. Thanks again, Jim

No I have not changed anything. It just all of a sudden started giving the error message. Any suggestions? Thanks, Jim

Thanks pbaldy. That worked. Jim

I am really frustrated at Aceess 2007, especially the Reports. I created a new form but it won't let me move the data fields and field headings around like I want. If I drag one the other come with it. If I try to drag the heading from the page header to the group header it won't let me. If...

I have a simple Append Query that all of a sudden gives me the error message I have not changed the design of this query in months and it has worked fine. Any suggestions on how to fix it? Thanks, Jim

Brianwarnock - I tried your latest suggestion. When I run the query I get a pop-up box to enter a Parameter Value for "datetime". If I click OK and do not enter any Parameter Value, the results of the query returns all data and ignores the date range even though I have a startdate and enddate...

When I look at the SQL view I already see a lot of code (see below). Plus I am not very familiar with manually coding SQL. SELECT tbl_Data.ID, tbl_Data.TagNumber, tbl_Data.DateOfTicket, tbl_Data.Offense, tbl_Data.EmployeeName, tbl_Data.EmployeeBadgeNo, tbl_Data.EmployeeType...

"Where Clause"? Do you mean the Criteria section of the query?

I have a table with a field name "Date". I have a form with two fields "StartDate" and "StopDate". I have a query to display the results. In the Criteria field I want it to use the StartDate and StopDate as the range. However if no date is entered into the StartDate and StopDate, I want it...

Can you give me some details about how to do this? Thanks, Jim

I have a form frm_DataEntry. On this form I have a combo box cbo_Status. I also have other text and date fields on the form. 5 of these fields I only want visible when cbo_Status is set to "Ticket Returned". My 5 conditionally visible fields are named EmployeeName, EmployeeBadgeNo...

That works! I really appreciate the help. Jim

Thanks for the help. Bob I used your suggestion as it looked the easiest. As a follow-up however, when I now run the query any fields that are blank show "#Error". Before they were just blank which is what I want. Any way to eliminate this error?

I have a query that is uses a linked table to an SQL database. Threre is a Date/Time field which is formatted like this: 10/7/2008 2:43:25 PM. In my query I am only interested in the date. The reason is that I run the report using the due date and approved date to show me the records where...