Search results

I have an unbound combo box on a form. I assign a query programatically to the combo box row source The pull down of the combobox shows the query has behaved correctly but the combobox is blank. The combo box query has 5 columns The bound column is column 4 All columns in the query are...

I've obviously changed something in the background as I'm getting the following error "The value you entered isn't valid for this field" (80020009). This is the code Private Sub Form_Current() ' The assignments below keeps the unbound combo boxes cmbFamily and cmbNameGeneric in line with...

[Solved] Combobox as record selector is blank doesn't update with navigation controls I have a form with a subform (dataset). I have followed this advice https://...

I am an Access newbie. I have had some success in using the query wizard to construct simple queries and have done sufficient reading to be able to use a UNION query to provide one answer to my problem. I'm now just checking if there is an alternative answer which would allow me to consolidate...

I have two tables that are simple lists of Company name and Company Address. Because these are large companies, multiple names can use the same address (e.g. a holding company with many 'Trading as' names). tblCoName has fields of ID and Long-Name with ID being an autonumber allocated by...

Hello all. I work in the field of Pharmaceutical regulatory affairs. I'm new to Access but have identified it as the best way to solve a problem in my current contract role (To avoid creating a massive spredsheet). I have a lot of experience of writing small pieces of software but only for...