Thanks for all your input. i solved my own problem before i even looked to see if anyone answered. I did a LOOKUP( ) function. It worked great. :) thanks for your help!
marie
Hello,
I have two colums of data. A customer number and a customer name.
I have a spead sheet that I am working with that has a colum for entering the customer name and i have created a drop down list that is populated by a list of names i have hidden below the form. also hidden below next...
Yeah i Got the locking of the sheet part down but i want them to enter a date instead of text. The issue is that they are entering TBA and i want them to set a DEADLINE! :) thus i want a date format in the delivery date and also i don't want them leaving it blank. :) Does that make more sense...
Another quick additional question...How can I get it to skip the 1st row which has the title..???
Would it then be like
If Target.Column = 23 AND Target.Row = 2? but then how do i continue down for the rest of the rows? or do i just do an If Target.Row = 1 skip the rest kind of deal. And run...
THANKS! I changed the col. ref and it works for the 1st cell....But that only works for one iteration. The first time i go the cell and enter in incorrect data and hit enter it gives me the error. The 2nd time i enter incorrect data and hit enter it stays there and no error message appears...
Ok. I want the user to go along entering data across the cells.... then when they get to the DATE colmn. i want it mandatory for them to enter a date and not go to the next cell or any cell for that matter. ( i know if i had it my way this file would be in access, but i have to work with it in...
Hello,
I was wondering how i can make a user input a date into a cell. I need excel to not let them continue until they do enter a date in. How can I go about doing this? does this question makes sense?...or do i need to explain more..
thanks in advance,
marie
I think what she orignally wants to know is how to do this....go to http://www.universityphoto.com and go to view party pics. Pick any picture and you can't download it to use. I had a friend in charge of uploading them. I'm not sure what they use but It works for novices for sure.
:)
hope...
If you are using number instead....change the number field length to DOUBLE. This will stop access from rounding it off. In fact i have my access properties set to default all my numerical fields to double just for that reason.
hope this helps.
:)
m
if you don't really need security from people who know how get around it....Just add a simple pop up box on your main menu or whatever form you want password protected.
add this for the Private sub on the ONLOAD proceedure of the form you wish to protect. Elvis is the password i used here...
Hello All,
I know this question has been brought up before but searching through previous threads has brought me no solution.
I have a Date of Birth field that i want the user to input as dd/mm/yyyy. But when i set the mask to 99/99/9999 The first two digits of the year get lost when the...
Well i've ditched the filter idea and went for a query that querys the information from the changes in the combo box for MRnumber. I hope this works.
I still don't have this working smoothly.
thanks for all your help though!
marie
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.