Recent content by hitpoint

Pretty much. This operation should be a failsafe during editing. The user inserts the reference number, and if the record exists, it can be edited in its old form, and if it's new, it can be populated as much as possible with existing information elsewhere, and then have some more info added to...

So the bugger is still being weird. I tried a bunch of uninformed variations, like adding an "End If" and deleting the "Else", etc, but nothing seems to want to make the code work. With this version below, I still get the "This action was cancelled by an associated object." Private Sub...

Oof. Shamefully, I spoke too soon. The code doesn't want to work. It hilights the "rs2.FindFirst "LPNUM =" & Me!LOADPLANNUM" line as the error line and gives me, "The action was cancelled by an associated object." Here's the full block of code, just for kicks: Private Sub...

Thank you all, so so much. Everything works beautifully. And George, yes, I desperately need to clean up my code. This was my first take on an Access DB, and some of my original forms are still infantile.

So, I'm trying to figure this one out. If a record exists, I want it to recall the existing record and have it populate the field. If it doesn't, I want it to automatically write those fields to the new table. Private Sub LP__BeforeUpdate(Cancel As Integer) Dim db As Database, tb As Recordset...

I'll definitely be looking into that. This database'll end up having a large number of records. If I could only figure out these problems. So, back to the original code you gave me, it produces an error when it can't call upon a file number to get extra fields for. Is there any way to null this...

I do hope you're making obscene amounts of money doing what you do. I can imagine your databases are far more complex than the crap I have wasting away in my application. Then again, the only languages I've really gotten into have been HTML and mIRC. Yeah, my code is very dirty by fault of this...

You, sir, are fabulous. It works, and I assume that adding more lines to that code, each with every field I want to auto-populate, should work. Also, assuming I want to preserve the space in between names such as "LP Table" instead of bridging it as "LPTable," what is the character for spaces...

New database uploaded because I renamed a few fields to get rid of the "#" sign, because I think it might have been interfering with operators. I inputted your code under the On Enter function of LPNUM on Create Master. It's complaining of a bug that I can't figure out.

On the "Master" form, the user inputs LP#, and it automatically draws from the "LP Table" table multiple fields such as VSL, BKG#, etc and not only reflects them in the "Master" form, but saves the values again to the "Master Table."

Many thanks for any assistance you can offer. I'm looking to have some of the information in the form/table "Load Plan" automatically populate in the form "Create Master" based on the primary key in "Load Plan".

So I've been at this for about four weeks straight, 9-5, trying to overhaul a DOS based application to the Microsoft Access environment. Google has been my friend thus far, but I'm going to have to compromise my male-ness and roll down the window to ask for directions. Here's my issue: I'm...