Search results for query: *

That wont work I need the data that is in the field befor the Update to change the checkbox back

Private Sub CoreID_AfterUpdate() Dim StrNoCheck As String Dim db As DAO.Database Set db = CurrentDb If [ServiceType] = &quot;Core&quot; And [CustomerIn] <> &quot;&quot; Then StrNoCheck = &quot;UPDATE Worksheet SET CoreOwed = 0 WHERE RefrenceNumber = &quot; & Me.[CoreID].Column(0) & &quot;;&quot...

I have written the code to update a check box in a db based on the input of a certain field on a form. This works ok the problem I have is if the field is changed back the check box does not change based on the data that was in the field before the change. It seams that the data is changed...

How would I make a field on a form required without setting the required proprities at the table level

I keep getting syntax error in FROM clause This is what I have done Private Sub PoNumber_AfterUpdate() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String strSQL = &quot;Select Closed From PoNumber&quot; & &quot;WHERE PriKey=&quot; & Me.[PoNumber.PoID] & &quot;;&quot; Set db =...

Thanks for the help Sticking it gives me a good start Kevin

I have a combo box that needs to update a true/false check box in a different table based on the user selection of the combo box. When the user selects something I need to up date the check box in the record that corresponds with the selection How would I go about this? Thanks Kevin

I have a form that changes data in fields when a combo box data changes the combo box is using the primary key as its data source Question: How do I stop certain fields from getting updated when I change the data in the combo box

How would I go about updating a field in a record other than the record that I am displaying on my form

I need to have a field in a report that prints out its data with a &quot; * &quot; on either side Something like this in the fields record source =&quot;*&quot; & [Field in select query] & &quot;*&quot; but this doesn't work any suggestions ? I cant use text labels on either side because I...

First I would like to thank every one for all the help this has been one of the best Access forums I have found you have saved me days of research and taught me a lot not to mention the fact that I would have less hare. any how here is my next dilemma I have a orders form with a subform linked...

I Figured out what I was doing wrong the first combo box was bound to the wrong field Thanks for all the help

I also tryed it this way SELECT worksheet.[PO#], worksheet.OurPartNumber, worksheet.Description, worksheet.CustomerID FROM worksheet WHERE (((worksheet.CustomerID)=[Forms]![Orders]![BillTo]));

I get no choices in my other combobox You got it all correct except that the BillTo is also a combobox

Didn't seem to do anything do I leave my rowsource in the combobox the same?

I have a combobox with the row source creating a select query I need the querys criteria to be set by what is in another field on this form (BillTo) I tried something like this SELECT worksheet.[PO#], worksheet.OurPartNumber, worksheet.Description, worksheet.CustomerID FROM worksheet WHERE...

The Me.UpdateField1= Me.[cmbControlName].Column(1)worked fine Thanks I tried the DLookup but it would only put the first option from my combobox to the field I wanted updated

I have a form and I need to have 2 or 3 fields that are updated with data when I put data in another field (combo box) on that form e.g Part number (combo box) updates part price and and description I know how to do this normally but the problem is that the table I get this data from is not the...

I need a command button that copies and appends a record to the next consecutive record which already exist except for 1 field which is the primary key. I have tried the Command button with the wizard but it wont work because of the primary key field Thanks Kevin

I have a database with 10 linked tables in it these tables are linked to 4 different databases I need to refresh the link at start up because the drive letter can change from time to time. Is there a way to specify the path for the linked tables with a field in another table in a different...