Hi there,
Not sure if this is what you're after, but in the properties of the text box in the Validation Text Box you could type your message to your user, like this
Validation Rule : Is not Null
Validation Text : Please Enter A Value
This would then throw up a warning box with your personal message. Hope this helps.
Mark
6360MGrist
Last Activity: May 1 '08, 04:05 PM
Joined: Mar 20 '08
Location:
-
Hi Stewart,
Thanks for that, it must have taken you ages! As I said before, I decided on a simpler solution, but will deffinately look at what you have posted as it might be a better way of doing this.
Many Thanks for your help.
MarkLeave a comment:
-
Thanks for your help Stewart,
I decided on a much simpler solution, using temporary tables, append and delete queries to move the data to my main table. A dynamic range in access would have been nice, but I guess going round the houses is better than not going at all.. :)
Many Thanks for your help in this matter.
MarkLeave a comment:
-
Thanks for that,
I need the data from columns A to P, but as the number of rows in the spreadsheet will vary, I need the range to expand/decrease to include all the rows, but not the rows that dont have any data in i.e. if only 3 rows of data is input, the range would be A1:P4. I know you can create a dynamic range in excel using OFFSET($A$1,0,0 ,COUNTA($A:$A), COUNTA($1:$1)) but is there a way of using this range in access?
...Leave a comment:
-
Import Excel to Access
Hi,
I'm trying to import an excel file into a access table. The problem im having is that rows that have no data are being added to the table. As the amount of rows will change depending on the file, I dont want to just set a range of x amount of rows. Is there a way around this problem?
this is the code I use at the moment.
ImportName = Text1.Value
DoCmd.TransferS preadsheet transfertype:=a cImport,...
No activity results to display
Leave a comment: