Recent content by djphatic

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 :)