Search results for query: *

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 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 " * " on either side Something like this in the fields record source ="*" & [Field in select query] & "*" 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 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...

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

I need to specify the path for linked tables in a database with a field in another table in a different database so that when the DB is moved to a diffrent drive the path can be changed for all my linked tables by changing the path in that field I am not a verry good VB programmer so if this...