Recent content by paultri

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

Thanks Brian that worked great!!!!!

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 only have read rights to the data, so the only way for me to change the data is to actually import the table and then convert it that way, but i would have to do that every time because the table is constantly updated. Its pulling this table from a foxpro database.

I can just copy the table, however it is over 600 megs and it takes some time and plenty of system resources, it is added to every day so i would have to copy it everyday that i would want to run the query. Thank you! I will look into the cdate!! Thanks paul

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

Rich, do you possibly have the URL where i could download that, i am having problems finding it. If you do that would be great, if not i will continue searching anyhow. Thanks Again Mile-O-Phile , I have a calendar to use, what i cant figure out is how to bring it up from the query, How...

Thanks! that gave me exactly the results i was looking for!

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!

That is a fantastic idea dcx693!! I will try doing that! thanks ALOT!!! Paultri

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