Search results

I had a split database that I wanted to do some structural work on so I made a copy for testing and converted the tables to local tables (Right click -> convert to local table) to help me keep from breaking anything too permanently. The changes ended up taking longer then I expected them to and...

I have a bit of code that uses controls on a form to batch add records to the tables. Before the code executes, it needs to do a check to make sure that all of the needed data has been supplied. I've set something up that works, but I wonder if there might be a more preferable way to do it or if...

I was working in my database going back and forth between form view and design view to test the row source in a listbox when the property sheet changed on me. The text in the right column is all bold and there is no longer any border around the values. It appears to have affected the property...

I have a parent table (tblLabels) and a child table (tblRevision) where the revision history for the parent table is kept. The parent table is populated via an excel import and may have several records imported at once. Instead of having the user manually enter a new record note in the child...

I have a module that I am using to verify that file paths in my table point to valid jpg files. The table has grown quite a bit since I first created the module and it has gotten to the point where it's taking too long for the module to execute. I'm in the process of trying to change the...

I am using an on-click event on my form to call up a report for the current record. It has been a while since I've used the form to call the report, but I always remember it working correctly. Today when I try to call up the report, it opens but no record is being pulled up so the report...

I have button on my form that uses a selected record in a listbox (non multi-select) to run code that updates a table. The code itself works great so long as there is a record selected in the listbox. If no record is selected an error is thrown. I'd prefer the end user not to ever see that...

I'm using the following code to clear selected records from a listbox after a button is pressed: For i = 0 To lstProducts.ListCount - 1 lstProducts.Selected(i) = False Next The code works great except that it leaves the listbox scrolled all the way to the bottom...

My table: tblHeatTreatment - HeatTreatmentID - PK - HeatTreatmentDesc - Text - HeatTreatmentDetails - Memo My form has a listbox (lstHeatTreatments - Multi-Select disabled) that displays Heat Treatment descriptions and an unbound textbox (txtHTDetails) that I would like to have display the...

I have a specification database that collects size information of a given product. Sizes can be entered as an integer into min / max fields, or they can be classified as "Varies" with a yes/no checkbox. On my form, I'd like to disable the min / max fields when the Varies check box is clicked...

I have an close button on a form that is supposed to Refresh the subform of a different form and then close the form with the close button. frmOperations - no refresh / requery subfrmPlants - Needs to be refreshed / requeried frmPlants - Needs to be closed Currently the button effectively...

I have two forms: frmOpeartions frmManagers frmOperations allows the user to assign a manager to an operation by selecting the manager record from a combobox. Occasionally the user may need to setup a new Manager record if one hasn't been setup already. In this case there is a "New" "button"...

I have a combo box based off of a query of a table that I'm trying to tell to requery the list it provides each time it's opened. The user may need to add new records to the table sporatically (through a pop up form I've created) so I need for them to be able to have live data each time they...

I'm using the following code to allow the user to pick a record from a continuous form and edit it in a new window. For some reason my where condition isn't working properly as the edit form always opens to the first record instead of the record associated with the "Edit" button that was...

I use access 2010. I have a form that allows the user to assign products to operations. Each operation can produce multiple products and each product can be produced at multiple operations. I manage this many-to-many relationship through the use of a third table that stores primary keys for...

Hi forum, I'm using access 2010. I want to put some code behind a button that will allow the user to add selected products in a listbox to which ever operation is selected in a combobox by creating records for each product / operation combination in a third table: tblProducts tblOperations...

Access 2010 windows 7 The database I'm working on stores product records. To help the user narrow down which product they want to use, the navigation form has a listbox that looks to several combox values to filter the records it displays. As the user selects values for additional comboxes...

When I attempt to compile the database I'm working on I get an error message that says: Me.LabelList is then highlighted from my vba code: Private Sub LabelList_DblClick(Cancel As Integer) DoCmd.OpenForm "frmLabels", acNormal, , "[LabelID] = " & Me.LabelList End Sub I've verified...

Access 2010 Objective?: I'm attempting to change the file location of the back end portion of my split database. What I've done so far: I've used the linked table manager to update the back end location of all tables in the front end portion of the database. Symptoms: When making a...

I am attempting to normalize an existing database. I've created the table structures necessary and now I'm designing a query that will update the new field in my primary table: "LabelBaseProduct" with the primary key from my new table: "tblBaseProduct" where the old field from my primary table...