Search results

I am trying to update just 1 field on a form. I has a temp table and I just want to display the history based off what serial number is selected. Iwas trying to put this code in the control source for that field. =DLookup("[temptablekitmove]", "[Parthistory]", "[Serial Number] = [part1c]")

I have a form that I use to edit some information on a part. So I have a combo box that the user selects the part they want to edit. Once they have the correct part there are 3 yes/no boxes that would be updated, a Date field and a comment field. Once modified I want to run the query to update...

I have a form with a combobox that is linked to a box number I want to select a box value and then have that record displayed. I cant get the gotorecord on the after update working on that combobox it that the rightway to go about this?

I have been doing a ton of searching on this issue and looks like its something I should be able to do but cant. I have a table linked to a form say 10 fields. Simple enough, the table has a primary key and its an autonumberd field. I'm trying to prevent incomplete records so on the close button...

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

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...

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...

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...

is there simple way (without changing the table structor to check to make sure a number only has been entered in a field? If a user enters 0 - 9 its ok but if they enter a 2' it will fault? thanks jon

I have code behind a cmdbutton simple me.txt1 = "1" which when the button is clicked the txt1 box should get a 1. I get this error Run Time error -2147352567 This Recordset is not updatable. I have checked the form properties and it is set to allow edits. What else could it be? jon

I have a form that has a bitmap picture on it and I have some hidden buttons that point to different parts of the picture. If the user points to a section info for that part is displayed. All that works fine until the user decides to change his screen resolution and or even worse changes their...

Is it just me? I open a report using a macro in normal mode. How the heck do you close that report? jon

I have a people table in my database and there is a yes/no check box that is used to confirm weather or not the person has completed paperwork required for a certian time. So the table could have thousands of people and I would like to reset this Yes/No field to No on the click of a command...

To start off my problem started with a Select Case that got to big and started causing a complier error "Procedure Too Large" So after doing some research I figured that I needed to break the Cases down into inidivial procedures. So I figured it would be easier to create seperate Functions for...

I'm having some trouble with a before update event. I'm trying to prevent incomplete records so on the before update event I have this code. So I can catch the null in the step, I get the error msg, I can get the undo so step88 has no data but I cant move the focus to the field that needs data...