Search results

I recently ran across an interesting problem. One of my users works off a computer with no printer installed. When trying to preview a report she got a 2202 error. Apparently you need a printer installed to preview a report. I had her install a "dummy"printer just to keep Access happy. Does...

There have been a lot of posts similar to this, but none that I can find that address the issue exactly. What I want to do is force my main report to display my subreport exactly as I have made it when there is no data in the subreport. Although there are no records, there are still headers...

It doesn't retain the link. I don't really care that much. It's just slighly more convenient for sizing and moving the label and control together. I'm aware that you can just select them both by dragging or using the shift key, which is why I say its slightly more convenient. I know that you...

Does anyone know how to move a label to a separate section in the report from it's parent field, while maintaining the link between them?

I think that would be more cumbersome than just storing the dirty values in variables and repopulating. Thanks for trying. I'm guessing that it's just one of those little Access glitches. No biggie.

I think the question is, what am I missing? :p The code is a little more complicated than that. I'm sure this will all seem overcomplicated, but it has to do with preventing the form from closing only when suspicious data has been entered, but still allowing the user to close the form after a...

I realize that. I'm pretty familiar with the event sequence. Without getting into a long story about the logic behind the form, trust me when I say that the BeforeUpdate event of the fields covers the all the possible errors I'm looking for. I agree that it's generally better to link data...

The data validation is actually done in each field's BeforeUpdate Event. What I am trying to do in the form's Unload Event is to prevent the form from closing if the user enters invalid data in the last field and tries to immediately close the form. No data validation is done in the form's...

I've set up a form to check for certain data errors, and prevent the user from leaving fhe form if one is encountered. It works fine except that when I cancel the FormUnload event, the database automatically undoes all of the user's (dirty) changes to the record. I've circumvented this by...

I'm using Office XP, so Access 10 or 2002. Normally I'd agree with you, but using the Optional statement with a default value doesn't work whereas setting the argument to variant does. Can't argue with results.

Problem solved Thanks for the help, everyone. Turns out it had to do with the variable type of the arguments. When set to Variant, as in Rich's post, it allows null values, but when set to String, as in my post, it won't. I'd rather not use Variants, but if it works, it works! :D Thanks...

Thanks Rich. I actually tried that. It didn't work. I also tried setting a default value, which didn't work either (see below). Any other ideas? Tried: Function FullAddress (strCity As String, strProv As String, strPC As String) As String Function FullAddress (Optional strCity As String...

I have created a function that takes the City, Province, and Postal Code fields and creates one address based on the entries. Works OK, except I get "#Error" returned in my forms or queries if there is a null value in any one of the arguments. I've accounted for nulls in my code, and it works...

Not so far. I'm betting it has to do with record-level locking, but I haven't played with it in a while.

Update to Problem I've been plaing with this a little more with no success, but I've discovered something that may help. When I make changes to the subform, both the subform and main form become dirty. If I manually save the record within the subform (SHIFT+ENTER), it is no longer dirty, but...

Wayne, Thanks. That worked. I kind of figured I'd end up doing it that way. I was trying to keep the number of tables in the database to a minimum, but I guess there's no way around it. Thanks again! :D

Jerry, Thanks for the idea. Normally, that's what I would do. I wasn't very clear in my post, but as far as I know I can't use a query to select the data. What I am doing is looking at a table and picking out records that have no entries in another table that is on the many side of the...

Wayne, Good idea! But it didn't work :( . I'm glad to know about that function though. Thanks.

I am trying to select records from a table and export only the selected records to Excel. There may be a better way to do this, but the only way I could figure out was to create a recordset from the original table, create a new table of just the selected records, export the new table as an...

I suspect you're right. Thanks! :D