Need search help

[Don Webb]

Been trying to use Allen Browne's search to help build a form to check sport field use. I wanted to be able to type a date and have it show me what fields are available. To be honest, I am not only new to access, I am a really slow learner. My table has the following fields. Calendar, Field and User. Thats all. Any help would be truly appreciated.

[June7]

Show the link to the Allen Browne info.

Show the SQL statement for the query you attempted.

[Don Webb]

http://allenbrowne.com/ser-62.html

[lebmelo]

Try attaching your db that you have built at this point. I have used the Allen Browne search function in 3 different databases and had a bunch of success. That said like you I'm not a guru and I have to see to assist rather than read any possible issues.

[Don Webb]

I tried copying the form and the code into my database and replacing the search fields with my field, didn't work real well. What am I missing?

[June7]

We don't have enough information to advise. Can you provide project for analysis?

Otherwise, you need to debug. Link at bottom of my first post is a good tutorial on debugging techniques.

[Don Webb]

Attached file. Want to be able to create a form where we can type in a dates and see what fields are in use. Thanks for everyone's help.

Don

[June7]

You did not provide form and code, just a table.

Another example can be found at: http://www.datapigtechnologies.com/AccessMain.htm
Look at 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in the section Access Forms: Tips and Techniques.
The 'query method' Allen refers to is utilized.

There is no need to save the Day in table. This can be retrieved with function: Format(datefieldname,"dddd")

Why is the date field named Name? Name is a reserved word, should not be used as field name.

The query you want is basic and Access Help has guidelines on building queries.

We will analyze your effort but not going to build for you.

[Don Webb]

Thanks to all for the ideas and info. I was able to get things up and running. Will say I have a lot of studying to do if I going to be doing much of this.

Thanks again for the help!!!

Don

[June7]

Search Access Help for topic 'Introduction to Programming in Access'. This offers a fairly good primer on programming options in Access.