Search results

I have a query field that currently has an expression that "adds" three text strings together to define a new one. The expression right now is "Division: [Class]+" "+[Male/Female]+" "+[Style]+" "+[In/Out Of State]". Is there any way i can put code in so that is [In/Out Of State] is blank (...

I got it!!!! Thank you soooo much! All i did was change the name of the form to "Me" and bam! it worked!!! Thank you sooo much!

i'm sorry but i still can't get it to work and access 2002 bible is really helping... this is the line I am getting an error on If [Imput Archer's Data (Multiple Lines)].txtLine.Value = [Imput Archer's Data (Multiple Lines)].txtLine.OldValue Then The error message says "Microsoft Access...

heh....makes sense....thanks again

ok well nothing i have tried works (sorry, still learning) the table's field is set to Indexed: Yes (duplicates ok) Name of field in table is "Line" name of textbox on form is "Line" table that feeds form is "Archer's Data" the form to which this code module is attached is "Yo" thanks again...

error message I keep on getting an error message on the If Me.txtLine.value = Me.TxtLine.OldValue Then line of the code. Of course i changed the "me" and "txtLines"

wow, thank you so much.

Is there anyway to limit the number of duplicates in a table? For example, I have a column that is named "Line". I want to be able to limit a specific entry in this column to only 28 times. So that the same information (let's say "Saturday 9:30") can only be entered 28 times in that column...