Search results

Oops I had a type-o. Customer names appear like this "* ABC Company" or some are like this " * DEF Company" and even some are like this "*Company".

I have a linked customer address table in my DB. In this table I have thousands of customer names that start with an *. I * was used in the past to distinguish between ship to and regular addresses. The * is no longer used and is causing problems with searches. What a surprise, I know. I'm...

I'm running an update query and I get this error - Function Sequence Error. (#0) I have an excel spreadsheet that I imported into a table. I am trying to update the part table with date from the spreadsheet. The part id is unique and thats how the tables are joined. I only need to update 5...

Look at this post - I have done exactly what you are asking about. You need to create a query first - http://www.access-programmers.co.uk/forums/showthread.php?t=128958&highlight=print+current+record

That is exactly what I am looking for. It works perfectly, Thanks!

My database is for creating labels for finished goods. If the admin needs to add a part to the database they need to enter the necessary info in a form. However I would like a query to run on the form load and if the results of the query is nothing but a blank datasheet I would like a msgbox...

I have a query and a form setup. My query pulls sales data. On my form I have 3 checkboxes - 1 to exclude a certain company, 1 to group by sales rep, and 1 to group by customer. Is it possible to drive a query based on those checkboxes. For example if the exclude box and group by customer...

thanks Paul you were right there was a line all the way at the bottom of the page that I didn't notice.

I can't seem to change the size (width) of my report. I'm in design mode and I can't change the width. Right now the width is bigger than I need. I try to change the width in the report properties but it goes right back to what it is now. I click on the edge of the report and try to move the...

I tried that and still nothing. I also tried between forms!SalesPartCust.Text21 and <= Forms!SalesPartCust.Text25. and I still get no results.

My query needs to pull data within a range of part numbers. Here is what I have in the query - On my form Text21: 10360041 Text25: 10360064 Field: Part_ID Table: SalesByPartCust Criteria: Between [Text21] and [Text25] When I run the query no data is returned. I did some other querying and...

In my query I have a field that contains an id. The id consists of 8 characters. I need all part to find all parts where the last character in the string is an "F". This is how I have the query setup right now. Field: Finished Good:Right([Part]![User_8],1) Criteria: "F" When I run the...

I'm trying to exclude several customers from a query. Here is what I have for the query - Field:CustomerID Table: SalesSumLine Criteria: Not ="4016002" Or "4433001" Or "4481001" Or "4709001" Or "5100019" When I run the query only the first customer ID is not in the result set. The rest of...

I am creating a report and I need data about parts that have not been used in the past 12 months. I'm not sure how to get just numbers from the past 12 months. How do I get the current date minus 1 year?

I have a new user who is trying to connect wirelessly. I set up the ODBC connection on his laptop but when he tries to run a report that uses queries looking at linked tables he gets ODBC call failed. Is it because he is trying it wirelessly. I'm just the data guy so I don't know too much...

I have a report that is generated after a macro runs. The macro runs several queries (select, make table and an append). I would like to have just the report open. Right now the 2 select queries open and then the report opens.

Thanks Bob - I was forgetting the *

I need to create a query and find records where the customer id starts with 4016. I know this is fairly simple but I can't remember how to do this.

I've had a request to modify the query. If a checkbox is checked then another box will open where the user can input some additional criteria. For example one checkbox is Model Number. If the user checks the box a text box opens and then the user enters a Model Number. Can I have the query...

Ok - i have it set up as a listbox instead of a subform. but I can't figure out how to double click on a line item and then have another form open.