Search results

Hello, googled this for a while, but no luck. All threads which deal any kind of 'Access changes my sql syntax' topic end abruptly without a resolution. I have a form called UpdateFTE with a listbox whose rowsource is: select distinct ucase(LastName & " " & FirstName), LastName, FirstName from...

I will try out the global variable method right now. Thank you!

You may be absolutely right- I could probably make it faster. I just assumed it was being slow because there is a whole sql update action going on at each iteration of the loop. But I guess the speed issue isn't my main concern (at least right now). I was just trying to get that 'break out'...

Do you mean that breaking out of the code requires looking at Transactions? I didn't realize that... I thought it was just a simple 'ok, now end this process at whatever point it is at' kind of thing. As in, whatever was updated can stay, and the procedure just won't get to the rest. If you...

haha ok this is as short as I can make it: -checks Employee table for current pay rate for the employee -checks if rate is not null, if it is, sets to 0 -checks for value of the field WorkTimeType (regular time or overtime) -If Reg, multiplies the HoursWorked (the field that the user fills...

I posted a short follow up when I realized I forgot to anwer the question: cross check takes about 4-5 minutes, which is not so long really, but it is long to sit there and stare at something that you're just itching to stop.

Oh, forgot to answer your question: The Cross Check procedure take about 4-5 minutes to run because it's a long recordset. I don't want the user sitting there that long if they just want to break out and start the data entry over. Thanks.

Errrr..... Guilty! I like to write long. I guess I do it because of my own experience of browsing threads for help. I like when people give detailed explanations of how they set their procedures up- that way anyone reading the thread can use that as inspiration to use in their own applications...

Hello, I am in access 2003. I have a form on which the user enters numbers into one field and clicks a button called CrossCheck which calculates and auto-populates numbers into other fields based on the values which she has entered and then she verifies that those numbers are what she expects...

No problem. Between the two of you, you've gotten me much farther along on this problem than I've been in days. Thanks again!

Hello Bob, thank you so much! Just tried it and the findfirst method did the trick. You have no idea what a relief it is to finally have a working solution to this problem. Right before finding your response, I was going to post back here with a tweak of the code posted by vbaInet, using the...

Hello, I tried getting rid of the subform name and did the following: Set rs = Me.RecordsetClone With rs .Filter "invoicenum = " & Me.InvoicetoSearch.Value If Not .NoMatch Then Me.Bookmark = .Bookmark End If End With End Sub I have gotten rid of the first compile...

Hi Beetle, I am going to save that as my last resort simply because I have an upload/download limit on my work computer. But I am definitely a big fan of looking at the thing directly. Thanks! By the way- your signature quote is hilarious!

I think your code made me take a few steps back away from the abyss of despair- thank you! Though the tears have not dried off quite yet... I did the following: -pasted your code into the on click event of the button -changed 'subformcontrol' to the name of the subform on which the...

Hello, I am VERY frustrated and annoyed over having spent a ridiculous amount of time on something that should be very simple. I have a form of vendors, with a subform of invoices, which also has a subform with invoice details. All the fields are locked- I only want the user to use this form for...

Wow! What an embarassingly silly mistake on my part. I am beet red! Thank you so much for catching that!!

Hello, uploaded is a copy of my db with dummy data and only the relevant forms and tables. Thank you!

My grandchild is still throwing a tantrum and won't take off the invisibility cloak :( Thanks for the resource link. I went through it and checked that none of those problematic conditions apply to me. I don't have any filters set and my recordsets are legit- I have plenty of records to show...

I have Allow Additions set to Yes, but Data Entry set to No. Does that make a difference? Thanks!

Hello, I am in access 2003. I have a form that I have been using for a while: main form: vendors child: invoices grandchild: invoice details It's been up and functional for weeks. All of a sudden, I open the database to find that when I open the form in form view, it is compeletely blank- only...