Search results

Hello again everybody, I am looking for guidance here on an issue that has been plaguing me for the past few years. Question: How do I duplicate a set of records, then select the newly duplicated records, then update a field on only the newly duplicated records? Context: I have a form called...

Hi everybody, Can anybody suggest how to reference a table column name that has a space in VBA? I'm working on a function to duplicate a selected record and copy the desired data into the new record. All fields work except the fields with spaces in their name. For example, the Certificate...

I've been struggling for over 1 year to resolve this bug being experienced on 2 of my 7 data input forms for one of my databases at work. If you enter data into any text or combo box on the form, the record locks and a pencil appears in the corner. If you try to leave the form using the close...

Hi everybody, I built and manage a compliance database for my company. Instead of actually attaching PDFs to the records, to keep size down -- I've added a hyperlink text box to hold a hyperlink to the file. I have a command button (cmdFileDialog) which brings a file selector up and lets the...

Hi everybody, I created and manage an access database at work, and recently we've upgraded to Windows 10 / Office 365. I have 1 hurdle I am struggling to resolve and was hoping for guidance if anybody has time and would be so kind: The database in question here is a split database. I have a...

Hi everybody, I have a report I've created which pulls in query data from two separate queries: The report is called: rptMonthlyReport It is bound to the source: qryMonthlyReport This report allows us to select an employee from a dropdown (cboEmployee) and view all active project records for...

Hi everybody, I've created fairly complex database at work here in the US to manage and track a large amount of projects, reports, and data. Initially this was only used at our corporate office, but a need has arisen for users to access this database remotely from Europe. In total, only 15...

Hi everybody, I have a form for users to enter project data into a table. On this form, I also have a subform displaying a list of the users projects. When a user selects a project record from the subform, I'd like the main form to navigate to this record so the user can update their project...

I have a database I've been designing to track projects. I'm having trouble setting up a DoCmd to open a form to specific records where field values contain alphanumerics. I'll try to keep this simple. I think this is a datatype mismatch issue. Any ideas how to setup a DoCmd to open a form to...

Hello everybody, I was wondering if anybody has or knows of an example database which uses a lookup column to automatically populate a table field. For example, if a database has 2 tables: 1.tblCountry Field: CountryID (Primary Key) (1 to many relationship with CountryID in tblCity) Field...

I'm creating a database to track products, European directives where compliance is required, and standards used to demonstrate compliance. I've hit a wall where, because of the structure of my tables, I need to create a record in 2 tables simultaneously from one form. Long story short, i have 3...