Search results for query: *

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.

I have tried doing this calculation specifying the fields in the table and also tried the using textbox values. The calculation is just incorrect. Here's an example: there are only 4 decimal places in the two fields I am subtracting. The numbers are 38002.6167 minus 38002.617. There are no...

I may need a combo box, but I'm not sure. I need to link the 'box' to a query that counts the number of instances based on the value of the form that is open (the query behind the list/combo specifies the value of the field on the form) It only shows the count of the first record and never...

I created a form with a subform linked to it. It works fine. I copied it and changed ALL the queries behind both the new form and the new subform. The new subform refuses to link with the new form (I triple checked the queries). NONE of the command buttons work (like go to next record, first...

In the code behind a form, I have a query that pulls records from a table based on the values of two fields in that form. When I use a duplicate copy of that query (called something else) as a recordset object, Access tells me I have 'too few parameters, expecting 2', but there are two...

Also - there is NO way anyone could be in the file when the program is running. The output does not write over an existing file - here is where it is being created.