Search results

I have made my Search Form that will search through my tables, some how I have a syntax error for the following: year, Section and ID, these fields are not text I use numeric values so I think the search is not working for that reason, I am not sure how can I fix it though do I have do add val()...

Thanks guys Got it fixed.

Thanks pbaldy, I did some search and I found the way to do it, I just simply added this line it is a bit slow but it seems to be working: =DLookUp("[Total]","AcademicAudioCount")

I have created my query based on a table in order to find how many data are in the list, then I have added a textbox in one of the form and I added this line in the control source: SELECT AcademicAudioCount.Total FROM AcademicAudioCount; This is what I get: #Name? But its not working, any...

mm I assume it should go to 2000, the number will be increased always by one I just need to add ACA to Identify it.

I really forgot how to do this, how can I change the format of my ID, I have set it up as autonumber and I need to view as For Example ACA001 ACA002 etc The way I have it now is just simple plain numbers 1,2,3,4,5..etc Thanks.

I have my form and Subform I have used the Datasheet to view them, on my Subform I have my Combo Box (EX. Year with the values 2000, 2001 etc) When I view the form it shows that its a textbox till I click on it then it drops down the value list, I need to show the arrow on the right side in...

Hi, not sure if this on the right section if not feel free to move it. Basically I do have a form that contains a subform, I need to have a button or sth similar that will search the subform of a record, if the file is needed I can uploaded. How can Do that, I have tried to use a compo that...