Search results

Any suggestions?

Hi I am having some trouble coming up with a solution so that a combobox only lists staff members at a particularly who have the relevant qualifications associated with a service. Perhaps I have the table design wrong (please see the relationship image) to do this kind of thing: Here's what I...

Turns out I had set the wrong field in the Append To part of the query, doh! Out of curiosity, do you turn Warnings off before running the Append query in your system and then turn back on, or leave on always? If you turn the warnings off, how do you deal with notifying the user that a record...

The indexes in the table should prevent any duplicate records being created. However, the append query appears to have broken the Autonumber in the table. I believe this is a bug relating to http://support.microsoft.com/?id=884185

A couple of questions regarding your solution. Resetting the values back to 0 (or False in my case) when the form is opened, is this done using an Update Query or VBA? Also, I presume the way the data is added to the order detail detail is done using an Append Query?

Yes that makes sense I just need to add a new field into the Equipment table to do this. A solution I was thinking of was using a multi-select listbox and those entries selected on the listbox would be used in a similar fashion. I will give this a go, if I get stuck I'll post back for an example.

Hi all I am looking for a more elegant and easier/quicker form to create for inputting data into a many to many table. Here's how my tables are setup: tblPractice: PracticeID (PK-Autonumber) PracticeName ... tblEquipment: EquipmentID (PK-Autonumber) EquipmentName ... tblPracticeEquipment...

Hello I want to use an Iif statement in my query so that If a contractor has a certain value (True/False) then different records are filtered out. I have standardtypes c, h, i and b. I always want to omit "b" (<>b) but depending on the true/false value I want to show/hide "i" I have tried the...

Hi I currently have a main form (frmStandResults) and 2 subforms within tab controls. There are 2 combo boxes (Contractors and Groups) in the main form header that when updated (AfterUpdate) they requery 2 subforms that are on different tabs using the below code...

I have taken a look at your example, which works well but I am looking for something different in how the form functions. I have added my forms to the example you provided. Please see frmInitialInputContractor where the user selects the contractor and then standard types via combo box, although...

Hi Thanks for you response, I will take a look at your example shortly. I am sure it will be of great help to me. I have thought about my situation again, in regards to your comments of the problems with creating a temporary table. I have created an unmatched query where the user can input the...

After more searching I managed to find a solution which I found here http://www.mvps.org/access/forms/frm0043.htm Replacing "*" with Null sorts everything out.

Hi again I have an issue with my combo boxes sorting incorrectly. Here is one combo box: StandardGroupID is an AutoNumber with records 1-40. When I click on the combo box the records are ordering as if the numbers have been converted to text i.e. instead of sorting them as *, 1, 2, 3, 4, 5...

Bumping post - can anyone help me out?

FANTASTIC! Thanks for your help! Easy when you know how :)

Here was my attempt I get the error: The specified field tblContractors.ContractorName could refer to more than one table listed in the FROM clause of your SQL statement. I also tried this but I get the same error:

Hi I have been searching around these forums and found some great examples of things you can do with combo boxes and filters. I am trying to join 2 examples I have found but with no success. At present I have 2 different types of combo box, the first: This lists the contractors found in the...

Thanks for your response. I looked at it abit closer and I realised what was going on with the module. I didn't notice it at first. I have been able to change the code to my own requirements though, thanks for sharing.

I have been playing around again and I do not understand why the gotfocus event is being used as the same results are achieved by setting the rowsource as: Select Distinct PLCD from qry_input where PLCD is Not Null I cannot see that the combo boxes are refreshing themselves if one combo box is...

Hi there I have been taking a look at your example today as I am looking to do something similar with combo boxes etc. As this is the first time I have ever used modules in Access I have a question relating to the drop_down_list module you use to find the records entered in the table...