Search results

I need to create code for a save button so that the form is saved and then cleared but only have the data saved if text box "Q24" is populated with either "Yes", "No" or "Don't Know", and if "Q24" is NOT populated when clicking the save button the form is just cleared without saving the data...

I have a form with a tab control and on one of the tabs I am trying to put in a simple line of code to tell a label to be visible or not visible depending on a drop down, however i cannot get it to work in the tab control but if i put the code on a drop down on the main form it will work fine...

I have a table that holds scores, they are either scored a 1, 2, or 3. I am trying to convert all of those to a percentage by dividing them by 3. I created the following query but i get an error unless I change the tables properties for those fields from a fixed number to "Text", but that...

I am trying to query a table by date but the datatype for the date is set to text, unfortunetly i am unable to change it to "date/time" is there anyway for me to create a query that will query by date without changing this? any help is appreciated!! thanks Paul

I have a table that holds an employee hire date. What i need to do is create a query that will show all employees between a certain range of dates whether it be in the past or future date, that have been with the company for 90 days. Though i only want to show those of them that are 90 days...

I am simply trying to get a field in a table to hold a 16 digit credit card number, i have tried and i keep getting the error "The value you entered isnt valid for this field" "for example, you may have entered text in a numeric field or a number that is larger than the filedsize setting...

I have a query that queries between 2 dates, what i would like to happen is have a calendar popup instead of having to manually enter the dates in. I have been trying to do this for weeks and have been unsuccessful. any help is GREATLY appreciated!!!! Paul

I need to create a query that will only show entries that do NOT have the phone number field in the following format (xxx)xxx-xxxx is it possible to query and bring up only entries that are NOT formated this way? Thanks in advance!

I have a form that contains a field that holds a SKU # for a product a customer returns, if they are returning more than one product i have a button that opens another form to enter up to 8 more sku#s in, problem i am running into is i cant figure out how to get both forms to save to the same...

I have a form that has a field to enter a sku# for a product a customer has returned, i failed to account for if a customer returns more than one product. I didnt want to create 10 different fields to enter sku #'s so i created a subform with the additional sku# fields, my questions is, I...

Is it possible to have a field in a form poplulated when something is entered in a field from another form?

I have two questions. 1. I need to query a field in a table and only show records that contain numbers....Is this possible? if so how would i go about it? 2. I need to query an EMAIL field, but i want to cleanup email accounts that are not formatted properly, no @ symbol or .com, .net etc...