Recent content by JoanieB

Does anybody actually READ what questions these things are asking?

I have code that runs thru a record set and for each record, sets the dept as a query criteria and then runs a union query based on the current dept. I am wondering if there's a way to have one of the queries run thru with multiple criteria (ie: where it says dept = TP, I would like to change...

OK. Know how when you're running a program or something on your PC and you have a program up that is not running anything, it's just open while something else is running? And you can click and drag the windows around and they blank out "erase" what would show behind them? {Again, this...

I only opened it as dynaset when trying to figure this out before. As to the problem: I know now that it's the main query (call it Qry1) fueling the form. Originally I had a 'grouped' query in Qry1, but only as a qualifier - no data was being used in the query's output other than 1 table -...

PS: It only happens on SOME of the records being updated...

I have a query fueling a form. The properties show that the query is Dynamic. In the code behind the form, I set a recordset and do some work. After scrolling thru the recordset, I then update fields on the form. When I try to set me!txtfield.value = variable determined in code, I get a...

Thank you thornmastr - that code put me right on track. I haven't tried the open notes suggestion yet, but thank you both!

CAN ANYONE ANSWER THIS QUESTION? I need to know about Access's compatibility with various email systems. We have Lotus Notes and were wondering how (if) we could incorporate emailing procedures into a program. {I don't believe Access 97 can use anything other than Windows based email?} If...

I have tried using both a select query (not a grouped or action query) as well as a table to show which records I want deleted from another table. In the original selectquery, I individually selected each field (not*). Whenever I try to run the delete query it tells me I have to select which...

That's the On Current event behind the form, right? I think that's it! Thank you.

Thank you both!!! End result: SUCCESS.

That was great! But I have a question: can I only do this within the code behind the form? The users will be jumping around alot and using the find button on the toolbox to locate certain records. If I can only requery within the code (next, previous buttons, etc), we may run into probs.

I figured out WHAT but not WHY. Basically, I had a private sub defined behind the form that was calculating an outstanding balance based on two of the form's txtbx values. I removed the sub, made it a module function instead, and now all is well. The form is fine and the module works. I would...

I am working with Access 97 and there is no round function. There is some crazy fraction of the number here, because when I manually set variables in my code to the numbers I want to subtract, it gives me a result of -2.99...E-04 {this tells me something about the fact that it's a fractional...

Sorry - the number it gives me is -2.9999...E-04.