Search results

I know this post is very old, but since I just had the same problem in Access 2007 and this post is highly ranked by Google, here is a possible solution: I had a query underlying the form which used the tbl.* to query all the fields in the table and then tbl.field which was sorted ascending. I...

I've figured it out. The problem was not the code, but, naturally, the calculated text boxes. It took a long time to get the query right, but now it's working fine. Moral for future readers: If it needs to be calculated, it should be done with a query.

Oops. Sorry about that.

I have a large number of calculated text boxes in an Access 2007 report that I want to apply conditional formatting to for more than 3 conditions. I have been trying to use a Collection to allow me to loop through the text boxes and apply the formatting. I have the following code attached to...

That did the trick! Thanks for pointing out that I was using a reserved word too. I appreciate the help!

The [name] fields are the names of a sponsoring organization and a benefiting organization (for charitable events). I have an organizations table and an events table. I have two queries, one for sponsoring org's infor related to an event, and one for the benefiting org. A final query collects...

Oh. Sorry. The '+' concatenation got the null field control to shrink. This is a concatenated field I want to shrink if two source fields are equal (might be a new string).

Thanks! The '+' concatenation took care of one of the controls (I've got two I was working on). Now I'm trying to use VBA to set the Visible property in the Print event of the Detail section: If [PendingRequestsHostQuery.Name] = [PendingRequestsBenQuery.Name] Then Text21.Visible =...

I don't have just one ControlSource, though. The text box is a concatenation of two query fields with some text. Is there a way to make the whole thing shrink if a third query field is null (VBA?)? Thanks

Hello, I've got a concatenated field (we'll call it [Report]) in a report that I want to shrink, allowing lower fields to move up, if a given field in my report record source (we'll call this [Source]) is null. How can I do this? Thanks

Use the forms wizard to create a Customer form. Then, create a Visits form and set its default view to datasheet. While viewing the Customer form in design view, use the controls wizard to make a subform using your Visits form. You shouldn't need SQL.

Another thing to consider when using calculations in Access reports is that Access does not store calculated values for future use. So, you can't perform a calculation using a calculated value, you have to insert the whole calculation. When I moved from Excel to Access, that gave me a lot of...

I've made several posts about this in the last few weeks and am getting closer to the solution, but the deadline for my project was last Friday and this still needs to be done. I have the following fields in a table named EventSchedule (compiled from normalized tables via append queries)...

Actually, I do have another question. How do I get it to count to zero? Currently my query only shows records with matching criteria that count one or higher, but I need it to show records with zero matching criteria as well.

Nevermind. I think I got it. Thanks a million!

Okay, thanks. How do I get it to count events by date instead of total records?

I have a list of events for a number of vehicles. I want to display a week's schedule with one row for every vehicle, with the days serving as column headers. Currently, the report created a row for every event recorded for a vehicle. The IIF expression was supposed to create one row that would...

Every time I run the following query: SELECT SchedRepQuery_1.LicensePlate, SchedRepQuery_1.VehicleName, IIf((Count([SchedRepQuery_1.Event1]<>"-")=1),[SchedRepQuery_1.Event1],(IIf(Count([SchedRepQuery_1.Event1]<>"-")>1,"CONFLICT","IDLE"))) AS Expr1 FROM SchedRepQuery AS SchedRepQuery_1; I get...

Thanks, I'll give it a shot.

I have a series of events that have a start date and an end date. How do I write an append query to append an event to a table as an individual event for every day in the given range?