Search results

I'm working off a form that had a combo box that lets me select a selection from data entered in another table. In the main table I have a Yes/No field. When I select from that combo box how can I change the Yes/no field for that selection? In the after update of the combo but don't know how to...

I'm trying to d a Dcount on 6 fields on a form. My problem is that The same value can be entered twice but not 3 times. Some times the 6 fields will always be different and sometimes some of them maybe the same but never no more than 2 can be entered. Trying to prevent users from entering bad...

Does anyone know if it is possible to create QR codes within access using a command button? I can be done in excel so guessing maybe??? Excel looks sloppy and using access might be easier to track and update. jon

no that was creating a sn post

It is being done in 2 tables but I need to build the kit as a form because the parts can and do change until we get a matched set if you will.

I'm actually getting an error. If I drop the last to OR's it works. So I'm building a kit that contains 15 parts all different. As a user selects the parts from a main table to put into a kit I want to verify there all different. Part1a, Part2a, etc etc are the different parts and can be...

If (Me.[Part1b]) = (Me.[Part2b]) Or (Me.Part3b) Or (Me.Part4b) Or (Me.Part5b) Or (Me.Part6b) Or (Me.Part7b) Or (Me.Part8b) Or (Me.Part9b) Or (Me.Part10b) Or (Me.Part11b) Or (Me.Part12b) Or (Me.Part13b) Or (Me.Part14) Or (Me.Part15) Then Is there a better way to write it? jon

I have a combo box pulling a partID from another table. Say part ID 50 how do I get the other fields to update on my form? Field1 = Field1 and field 2 = field 2 etc etc

To start with there are only 13 different parts that I need to track. They all have a unique serial number so that is how I will track them. The other problem is that all 13 parts make up a full kit and even tho a part is in say kit 5 today does not mean it will be in kit 5 forever. as pm's...

access2016

I need to convert it, error I need a newer access to open?

Sorta. I need the format to be 0000-0000 and I cant get 0000-0001 to add 1 no matter what I do.

I got it I think [SerialNumber] = "NM-" & [SerialNumber]

How do I add the NM- to the begging?

I think I'm getting close So I have my table for the serial number NM-00001 and NM-00002 I have this code on my form SNupdate = DMax("[SN]", "Tble-SN") Me.[Serial Number] = (Me.[SNupdate] + 1) This kind of works but I can't use the NM- infront of the number and if I have...

I'm trying to track a small set of part numbers, 13 different parts. 10 of the 13 parts have serial numbers and I have my table to not allow duplicates. Works fine for the 10 parts. So for the 3 parts that don't have a serial number I want to make a serial number. Something like NM-0001 and for...

Agree, I was trying different things But I don't know how to query based off the 3 different check boxes? Since the data in the table field is called Location and the user selects checkbox 1 then I want to return all records that are Phase 1 but how do I determine Checkbox 1 and or 2 and or 3...

Ok, I will search on using Check Boxes instead. Thank you

I'm trying to build a table based off a form that has 1 combo box and 3 radio buttons. I'm trying to use this is a way for users to simplify their searches. So the combo box I think I have but I don't know how to code the radio buttons. What I have is Phase 1, Phase 2, Phase 3 and if the user...

is this possible to do with a command buttom. I have a table that holds a few different bmps seperated by a tool number. So the table would look like tool / image1 / image2 / image3 etc etc. So when the user opens a form I have a command button that opens a new from that has a query to it to...