Search results

Vassago, I think (and that takes a lot of effort - and is often wrong but . . .) Dynamic Crosstab reports are normally ordered by using the "Column Headings" in the query properties. However, this will cause all columns to be present in your report (not dynamic). If you sort by your...

No problem Susan ;)

Your ReportFooter4_Print also has an incorrect field reference. Your "Tot" should be "Tol" Brad.

Your Header and Detail events are incorrectly named. eg: Your Detail section "Detail" is referenced in code as "Detail1" This is the same for your PageHeaders etc. Brad.

That would have to be one of your most cryptic demo's Ilk. ;)

Sorry Dave, You are correct, there is an error in my second line. Should read: If MsgBox("Please complete ALL of the details. Do you want to close without saving?", vbYesNo, "Confirmation") = vbYes Then Note addition of "(" to syntax. Thus overall code should read: If IsNull(Me.TxtCopy)...

I'd like to enrol in "Pat's Access Course" please ;)

You need to close under two circumstances 1 - if the user wants to close even if not complete 2 - if the details are complete If IsNull(Me.TxtCopy) Or IsNull(Me.TxtCost_Code) Then If MsgBox"Please complete ALL of the details. Do you want to close without saving?", vbYesNo...

Microwave Jenny??? Perhaps I could put some big flash gates on my "small white box" apartment. Might just stay where I am though, cos at the moment I live only 1 hour from Bonnie Doon - Ah the serenity. :D Brad

Sounds alright to me though. How much does a small white box, louvred on all sides, one metre above a grass surface at Brisbane Airport go for these days?

Beer at lunch . . . Now there's an idea :)

If field1 is the correct name, then you should try: stWhere = "[field1] = " & lstThis.value DoCmd.OpenReport rptName, acViewPreview, , stWhere Brad.

If you are "really" new at this, then I would encourage you to get an understanding of your required process one step at a time. I am by no means an expert, but see that you could find things a little overwhelming if you tackle your desired result straight off the bat. Check out the following...

You can rename files using a method similar to that listed here. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48841&highlight=rename+file+brad If you struggle converting the code to your purposes, repost and I will rework it for you. Brad.

Jan, Sorry to mislead you in the previous posts. The main problem is not due to a label being used instead of a command button. The actual (or Main) problem with not allowing the second search, is due to writing to the query with the method you are using. If you check out the re-work of your...

Perhaps the following may help. I have rehashed your example with my code. This is not to say that it is exactly correct, but . . . Note: I have removed the IsNull testing and made the subform visible. It is possible to test for Nulls, and hide the subform if you really wish. I would...

Jan, Are you using the code I posted, or your own code? Please repost your code (or .mdb) and I will try to assist. In regards to the focus error, I would suggest that this is occuring due to your subform being hidden (not visible). Brad.

Use the wizard to create your Combo Box. As long as your form has a record source, you will be given the option to: "Find a record on my form based on the value I selected in my combo box" - (or something like that :) ) Follow through the wizard and "hey presto" HTH

Try importing from the .csv file directly. Just a thought ? ? Brad.

As many customers do! ;)