I have a combo box with hospital names in it. I am wanting to select a hospital from the combo box and have the the address text box automatically fill in...

Hello, I was hoping someone could assist with the following expression in access that combines the Left function and Len function: I have column called ID,...

I have this union query in access which produces a Run Time 3035 System Resource Exceeded error. If I remove one of the queries from the Union it works, but...

I would like to create a query where the user can input 2 or more parameters (part numbers), separated by comma and/or space and return information about...

Fred, we now can see the code -- don't know how we didn't run into it earlier. The SQL code looks understandable for the original simple query with no drop...

Hi Guys, Are you able to change the colour of a field dependant on the fields current value in datasheet view. When the output from a query is opened, I...

I am trying to incorporate a pop up calender from Allen Browne. Downloaded the file (for Access 2000 and later) from the address below and unzipped it. ...

Hello: I'm attempting to produce a report in Access. The report will have page breaks when the header info changes. The problem is that the pages will break...

I would like to select records that are valid based on todays date. In this case the records startdate and enddate need to be between todays date. My table...

I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending...

I am looking for a way to query for the following: *T* The problem is the T is surrounded by an * which is a wild card. It pulls all the records with a T...

In an Access query, I'd like to have an expression that takes the current day of the week (Sun through Sat) and returns the date for Saturday (in "Short Date"...

Hi Guys, I can't see a table in QBE even when I have the scroll bar as far left as I possibly can. I have joineed another table to the query and I can see...

Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1...

I have a query that executes a Table-Valued Function in SQL server. If I execute it withing Query Analyzer in SQL server, it completes in 40 seconds. If I...

Im trying to build a form with multiple check boxes that each apply a filter to the records displayed. I need for the user to be able to select any...

I'd like to run a SQL statement which will return a single number, and assign this number to a variable. Here's the SQL statement: "SELECT COUNT(ReceiptID)...

I am trying to decipher the “status� of records in my table based on two date fields and the name of the agent assigned to each record. The fields are as...

Hi, This is a continuation of a post a few days ago. Apologies about the time lag, but the question is from a contract I am working on only 1 day per week,...

I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...