Search results

Hi All! I am stuck and I posted something about this before, but then I went back and reread it and it didn't make much sense........so here goes. in a nutshell, can you use a recordset, created in a module, as criteria for a query? I have one query that brings up a list of dates, and then I...

Hi! I have a recordset based on a query that is getting a 'too few parameters ' error. I think it is because I have a form referenced in the query that I need to set the value of? Is this right? I checked the KB article, but didn't quite understand it.. Thank you! jennifer

I've been trying to work this one out myself, and I just figured out that you have to .movelast before you recordcount to find out how many records you have! I really need some help, though - because I have to nest my loops and I just can't figure it out. 1) click event on a form button - got...

Hi! I am packaging and deploying my DB, and my boss wants to start thinking about how people (we're sending it out all over the country) can backup their runtime versions of the DB so that they can restore from it if they screw up their DB. Is this possible? Thank you! Jennifer

Hi! I havea button to print out a report... Reports!rptSalesMix.OrderBy = "[PLUNumber] ASC" DoCmd.OpenReport stDocName, acNormal and when you click it it opens the report in design view before printing it. How can I stop it frlom doing this? Thank you! Jennifer

Hi! I have a button on a form that runs through some queries before closing the form. Weird thing is, you have to click the button..hard? to make the queries run? SOmetimes if you click quickly it just closes the form, and then if you go back and click hard it runs the queries and then closes...

I have a calculation on my report that sometimes ends up dividing by 0 - and when it does, it comes up with a #Num! error. I tried to Nz it, but it didn't work, any suggestions? =([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount] is my control source. Thank you! Jennifer

Hi! I have a query, and I want to eliminate a record that has an ID of "I077" AND a lastcost of 0. I thought that if you put the criteria on the same line, it would produce and AND result, but it gets rid of ALL records that have an ID of "I077" and then eliminates all records that have a...

Hi all! I'm getting ready to distribute version 1.0 of my application and it has been packaged and deployed ........but I just realized that I don't know how to UPGRADE my users versions when I'm ready with fixes and enhancements! How will I get the new versions to them AND let them keep all of...

It's very big, and complex and runs on dozens of queries and eight subforms. Each individual component runs fine on its own, but when run together they freeze. I've done everything I can think of in the way of simplifying the queries.......any ideas? Thank you! Jennifer

Hi! I have an ID field that is user determined, and is a number. When the field is sorted, the numbers come up like this 100 110 1150 1160 120 1300 1310 140 etc. How can I get them to display in true numerical order? Thank you! Jennifer

Hi All, I have a form in continuous forms mode where a user enters information. Currently the new blank record line shows up at the bottom of the form, is there a way for is to show at the top of the continuous forms? Thanks! Jennifer:confused:

Hi Everybody! I have a query that averages some costs, but if the item hasn't come in, the result in query.lastcost will be 0. if it's 0, I need to get the result from another query for that item. How do I do this? ( I have the other query built already) Do I need to give more information...

hi all, I need to find the InvoiceDate from tblInvoice that was most recently entered using frmInventory.InventoryDate as the criterea. For some reason I can't make my DMax work. I have a query that finds the DMax date in the tblInvoice, but how do I get the InventoryDate field in as the...

Hi All! I have a complex question - I'll do my best to make it clear. I have a table of invoices, stored by date. The invoices contain item numbers, and item costs. I need a query to look at tblInventory for the last date an Inventory was entered - then go to tblInvoice and find all Invoices...

I know there has to be an easy answer to this question, but it's driving me crazy! How do I keep my forms from maximizing when they are opened?? Jennifer (thank you!)

Hi all. I have a number of forms where the user enters data where the number/name entered must be unique to the vendor/etc. So when the user enters a number that has already been used and there is a key violation, they get a system message that is rather cryptic explaining the situation. I want...

Hi. I'm sorry I've been posting and deleting but I'm trying to figure out just what my problem is before I ask for help.... I want to run a query on the close of a form, and take a calculated field from that query and display the number in a text box on a linked form. So, on 'save' I have...

I have a subtotal that needs to be within 1 of my Total. Right now I have an If statement with subtotal = total but how do I change this to allow for an error of 1? Thank you! Jennifer

Morning all, I have a function that validates some info, and returns a true or false depending on whther the info was good. If true, the form saves, if false it doesn't. This is the call to the function - which works but is ugly as hell and never seems to get to the "Call" part. Is that line...