Search results

One of my co-workers is opening a database that several of us have access to. When he opens it, a copy of the database is immediately made in the folder. EG: User double-clicks MyDatabase.accdb -- immediately, a copy is created in the same folder called MyDatabase1.accdb (without the user...

I have a form and just wondering if there is any difference between setting the Record Source to "SELECT TblOven.* FROM TblOven;" versus a query that selects all fields from TblOven? Is it essentially the same thing? If not, which is the preferred method?

I have over a dozen tables that together represent a final quote. TblSys TblOven TblWasher TblMisc etc... They are all linked by PK QuoteNum. I want to duplicate any given quote so that with a new quote, most of the work is done with just a few changes that are needed. So I need to create...

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

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

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

:banghead: I must be doing something wrong...but I've followed several different tutorials and still can't get this to work. My steps (in Access 2016): 1. Split database into BE/FE. BE is now on a network shared drive . FE is local drive. 2. Opened each one (individually) just to make sure...

I am creating a database and have about a dozen tables, have a dozen forms, and another half dozen queries. I realized that I will need to split this database into FE/BE, but at what point in the process should I do it? Now or after I have finished creating all of the...

Greetings - I have previous experience with Access 2000 - but I haven't touched it in over 10 years - so I'm back to learning again. It's nice to get back to it, just wish I could get to some of the old Access files again for reference. As for my username: I used to be the constable in a...