Search results

Thank you! I knew it was common - I just couldn't seem to make it work. Thanks for the answer. Jennifer

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...

That sounds like it's going to work! For some reason I just couldn't get the logic straight in my head. Thank you so much - I'll let you know how it turns out. Jennifer I've been worrying FOREVER about this query and you did it. It works and it took 10 minutes and I am forever grateful.

question? hi! I solved this same problem by insertin -1 and +1 into the query critera. It worked - though it seems a little simplistic........maybe it wasn't the right way to do it. Jennifer

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...

It doesn't work All I want is for the form to be small on open instead of full screen! Seems like this must be easy..... It's not a pop-up or modal (i don't want it to stay on top, or close before going to another form) HELP! I think I got it - I changed the border to dialog and it seems...

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!)

Thank you for clearing that up a little, David...I was having some trouble understanding. After I got the data types right - it worked perfectly. THANK YOU Jen [This message has been edited by JCross (edited 05-16-2002).]

Thanks for the responses. I'll check out the link - and the reason I can't trap it is because I tried the error handling method and I can't figure out what event is triggering the message! Went through everything I could think of.... [This message has been edited by JCross (edited 05-13-2002).]

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...

Thank you, RIch. I've used DLookup - I just didn't know I could use it for a query. Works perfectly! Jennifer

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...

Thank you! I knew that I had some unnecessary lines in there, I just couldn't figure out what they were! Jennifer

This is the call to the function: Call PrepSaveValid("frmPrepItem") The funtion itself looks like this (and is stored in a General module. Public Function PrepSaveValid(formname As String) As Boolean 'validation for all prep items on save Dim f As Form Set f =...

Travis, Works perfectly. Thank you. Jennifer

Thank you, Jack.........but what if I want it anywhere in that range? The subtotal can be anywhere from = to 1 over or under, including fractions. Is there a way to do that? jennifer [This message has been edited by JCross (edited 04-12-2002).]

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

I used this to see if a date entered in a text box was also listed in a listbox of 'valid dates'...i don't know if it will help you, but it works. Jennifer If IsNull(DLookup("InventoryDate", "tblinventory", "InventoryDate = #" & Me.BeginDate & "#")) Then MsgBox "Please choose a...

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...

Sorry this wound up in two threads, but I found someone else with the same problem after I posted. OK - It's a bit convoluted, but I added an invisible control to the Details, RunningSum OverGroup...and then made a visible control in the Footer referencing the invisible control. Not pretty...