Search results

actually, it only finds the first entry in the table, and only the first entry...

Pat, You are a genius. Thanks for the help. Steve

I fixed that. Now it only finds the record that has the ID # 1 and only 1. Any other number I search for is not found.... any ideas?

I have a report that prints out the results of an archery tournament with several divisions. Is there anyway to number these results? i.e. 1 Archer1 2 Archer2 3 Archer3 Basically, I need an autonumber field or something similar to be in the Detail section of the report. Thanks, Steve

Here's the code... Private Sub Command53_Click() Dim strArcherRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search...

I realized that yesterday....i think i'll be better off doing it a different way but thank you for your response.

First, I have to explain what this DB is being used for. It is used by an archery tournament administrator to enter archer information (i.e name, address,etc. and scores.) When a new archer is inputted, it creates a unique ID using the DMax() function. Now, what i need to be able to do is...

welp, i've finally figured it all out. It took a while, but i finally understand the DMax() function. By using that on the in put form, and setting the default value on the table for the new ID to "1", I am now able to create the ID #'s like i need without using the AutoNumber. To reset the...

the reason i am using autonumber was to assign each archer a unique ID #. By using autonumber and setting it as primary key, i was able to search for the archer by using the ID #. Having the ID # equal the record number, this made it exponentially easier. Now, I want to be able to hit one...

while i was at it...i was looking over your other post about creating a new autonumber field. using Public Function AddTableField() Call CreateAutoNumberField("YourTableNameHere", "YourFieldNameHere") End Function as the code. How would I go about deleting the old field using code? Thanks...

Ok, well i'm trying to get the "delete all entries" part working first. For some reason, i can't get this to work and i can't figure it out. Any help is greatly appreciated. Private Sub Command4_Click() Dim Msg, Style, Title, Response, MyString Msg = "Do you want to reset the program?" '...

i looked but must have skipped over that one....thanks. I'll look it over

is there an easy way to delete all records on the main table and re-setting the autonumber back to 1? right now i have to manually delete all the records, delete the autonumber field, create new field with the same name as the old one and then set it up to autonumber (btw...the autonumber is...

That works but everytime I close the database, the information in the form is reset. Is there anyway i can have it saved and still work the same way?

Hey, it's me again. I found something else that i just can't figure out how to do. When my database opens, I want a form to pop up (i dunno if it should be unbound or not) and ask me for some information. Specifically, i want it to ask "Tournament Name?" and I will enter the tournament name...

I got it! Thanks so much guys!!:D :D

YES!! i got the Iif function to work. Division: IIf(IsNull([In/Out Of State]),[Class]+" "+[Male/Female]+" "+[Style],[Class]+" "+[Male/Female]+" "+[Style]+" "+[In/Out Of State]). Now, is it possible to do multiple IIf functions for one field in a query?

;;Delete;;

and can you elaborate on the IIF function? an example would help alot....like some code....please, i'm still trying to figure this stuff out

ok, i understand what your saying but I left out one important piece of info....i'm a newbie! :rolleyes: so one thing....how do you make a global module? do i just go into the module menu and hit new and start from there?