Search results for query: *

I eventually got it figured out. I had to create one condition in the query the report used and one condition in the control source of the field. AlexCuse - OnLoad wasn't an event option for the report. It's there for a form, but not a report....at least on this one. Thanks for your help...

I'm trying to clean up an Access program designed by someone else and I'm having some difficulty (regarding syntax) creating a condition for a field on a report. I have the following case statement created and I wanted to be able to apply this logic to the field. It had been a nested IIf, but...

Grrrrr...."The Query Designer does not support the CASE SQL construct.

I don't know if I'm posting this in the correct forum, so I apologize if it should be elsewhere. I'm in the midst of converting one of our Access DB's to use an SQL backend. I already have the tables converted but I was also pondering converting some of my more heavily used queries to SQL...

TTT

NOTE: I've recently tried using 03 Pro with "Visual Studio Tools for the MS Office System" and it does the same thing. I have Office XP Developer and used the packaging wizard to create my runtime package. I haven't had any problems deploying this on any of our machines until we got two brand...

I'm stuck on issues with two different DB's at work, but I've split them into two posts so no one gets a headache trying to read one huge post. The other will be in the Access: Reports Section For this one, I'm trying to create a Data Access Page. I've created it based upon a query which...

I'm stuck on issues with two different DB's at work, but I've split them into two posts so no one gets a headache trying to read one huge post. The other will be in the Access: Forms Section For this one, an employee has created a report from a single query. The Report involves Customers and...

Sorry, I'm running Office XP Developer on XP Pro OS.

Has anyone ever received this message when clicking on the Tools Menu? It only happens the first time you access it after you open a DB. ---------------- Microsoft Access can't display the Add-ins submenu &123 Error Handler Wizard because a setting you entered in the Windows Registry is missing...

Thanks, you ROCK! The "" didn't work, but the " " did!

I'm a novice Accesser so bare with me. It was brought to my attention (where I work) that a certain report, which is based off a query did not have the stock numbers sorted correctly. Our Stock Number field is formatted as Text and sorted in ascending order in the query. The problem is caused...

Background Info: Our Internet Sales Dept is currently managing sales from 4 independent websites. Three of these websites use MS ACCESS DBs to store their order information. The fourth site uses a text file. Periodically throughout the day, the data from each site is manually imported into...