Search results

Not deleting...closing the original recordset so that it is no longer visible in the open form. >Quote #500 is open on the form. >User clicks the "Duplicate Quote" button >New quote #501 (duplicate of #500) is created and is displaying in the form. >Now I have both quotes open on the form...

The code that I have above does leave me on the new record, but it also allows the user to click the record selector on the form to go back to the original record. I would like the original record to clear out of the form. Or maybe I should just clear out the "Customer" field in the new...

Here is a link that describes how to set it up: Set up user login form. Hope that helps.

For the first message box, place this at the top of your code block: If MsgBox("Do you want to copy the file names?", vbYesNo, "Copy Files?") = vbNo then Exit Sub Do you want a separate message box for each file name or one message box that would include all file names?

User clicks a button on a form and it creates a copy of the record with a new quote number. This code works perfectly, but I want to close the original record and keep the new record on the form. How? 'This will copy the current quote into a new quote number Dim intNewNum As Integer On Error...

Yes - I have the large components split out into separate tables and parts of those components split into other tables and labor split out as well. It is a mammoth task so I am constantly looking for ways to improve it. Thanks for your input.

Thanks - I appreciate the help. The reason I started to question my approach is that I see many posts of someone asking for help who has a lot of fields in a table and the first response is almost always something along the lines of "Your table has too many fields and so I suspect it is...

I have a table for quotes tblQuote. It has QuoteNum Descript CustID SalesID MaxPartLength MaxPartHeight MaxPartWidth MaxPartWeight PlantCity PlantState PlantCountry and a slew of other aspects of the quote. It originally had 110 fields. I pulled out 50 of them and placed them in other tables...

Thanks Doc - but I only have the BE open (not the FE). I guess I should just "save early save often". You'd think I would have learned that by now.... :D

I'm having this same problem. I am opening the BE of the split database and if I stay on it too long, I lose my network connection to it and get this error when I try to save. I believe that there is a setting that will automatically disconnect network mapped drives if you have been idle for...

I had to put my glasses on to read this post.

I can't do without my calculator watch.

In the properties of the combo box, set the Default Value: ="Please Make a Selection" Once the user clicks on the dropdown and selects something, the "Please Make a Selection" will no longer show.

Thanks, liddlem, for this little gem! I didn't realize that I needed it until I saw your post. Your are correct - eventually some data will get changed and my boss will want to know who updated it and when. :cool:

Someone in the US won the $758 million lottery last night. Wasn't me. But I'm curious...what would you do if you won that much money? I think I'd call in sick to work for the next couple of days. And plan a nice extended vacation to tour Europe. :D

"Cissy Strut" is an excellent example of funk. I love that song.

Music is as subjective as humor is. I often find that I am on the minority side of what I find musically interesting (or what I think is funny). I agree that Queen's "Another One Bites The Dust" is a simple song, but it was crafted brilliantly with a minimalist feel. As was "We Will Rock...

I see this stated often when talking about table design. But it is never explained WHY this is a bad idea. Can someone elaborate on what kind of a problem this introduces? For example: If I have a table tblSalesOrder and the primary key is SalesOrderNumber which is an Auntonumber, what kinds...

More information - and probably what is really at the heart of the issue: I created a new database and tried the Split - password protect BE - open FE and everything worked without having to use the shift button. I was able to open the database, delete the tables and relink to BE tables. This...

Seems that the Shift option had nothing to do with it. After I enabled the Shift option - it still did not allow me to open the FE - even after recreating all of the steps above with the Shift option enabled and pressing shift while opening FE. What did allow me to open it is if I did this...