Search results

I have two tbls, one called Inventory and the other is called description. Inventory stores all the users input data, the fields are: ID, Part Number, Description, Date, Technician, Notes, Organization, Qty Add, Qty Subtract and Requirement. Description is a tbl where I store the fields: ID...

Is it possible to validate a combo box with this field type? I have all other validations working but they are text boxes...I have searched here and the web but unable to find the answer? I want to make sure the field is not left empty, other cbo boxes work but are of a short text field type...

I have setup a form that has links to images stored in a folder and the path to those images listed in a table and it works good, however my question is the data I am linking images to is a text field in the tbl called part number. When i enter another record into the tbl that has the same part...

On occassion I have copied a previously completed database as a template to keep from re-creating forms, tables etc. However, when I receive error messages like canceling a hyperlink button, I will receive an error message where the caption refers to the previous database name. How can I change...

Im attempting to validate an amount field to control the currency that is entered. The data type is currency and the code appears to work fine, however I would like to setfocus to the amount field if the currency entered is 0 or above 200,000. Everything I have tried gives me back the error...

Can someone please help me with this syntax issue? I am using the following code to check usernames and passwords on a form, and am getting the following error: Application-Defined or Object-Defined error My Table Name is tblUsers and the field names are UserName and Password The form name...

Hello, I have two combo boxes which I am trying to declare variables for. These combo boxes have assigned data in them which I pull from a query. The first cbo lists events and the 2nd lists dates of the events. What I would like to do is select the event from the first cbo and have the 2nd...

Im using a form to enter date and time data into four separate fields. I have sequential validation working ok, but now I need to modify the validation to not accept any time entries that are beyond 2 hours apart in the last three fields. Fields: Ticket (Time Printed) *Time In (Time TIC) *Time...

I have a form used to enter dates and time tables for events. Within this form i would like to add a subform and display the last record entered whenever I choose to add a new record. What is the best way using code to put this together? I have seen a few examples here, but Im not quite getting...

Hello, I am new to VBA and would like to ask for some help on coding in my database. I am attempting to enter four time entries; Time Printed, Time TIC, Time Processed, and Time PUFC into a table. What I am having a problem with is when the user enters data into these fields, I need for...