Did you have a chance to take a look the form in the database? This is how the end product should work. You might get the idea from looking at the FORM1 in the database. <br>
The user should have the acceess to GUI only and all the tables won't be seen as they are now. <br>
<br>
you enter the...
Yep, it works... But I'm so much far from the result that is needed... <br>
I hate to be somebody's pain in a neck.<br>
<br>
statement "between and " worked fine<br>
<br>
but how do i make the db search for particular thing<br>
<br>
i just have no clue where and how to enter that part of the...
Here is the query SQL statement<br>
<br>
SELECT [Main Table].*, Availability.*, [Point of Contact].*, [Bounding Coordinates].*<br>
FROM [Bounding Coordinates] INNER JOIN ([Point of Contact] INNER JOIN (Availability INNER JOIN [Main Table] ON Availability.ID = [Main Table].Availability) ON [Point...
THANKS :o)<br>
<br>
I'm afraid I'm too unexperienced in MS Access -- SQL statements is something over my head now. Gees, it's killing me. Where do I start? :o)<br>
<br>
<br>
Let me try, and I know I'll be back in few minutes :)<br>
<br>
THANK YOU VEEEERRRRRRRRYYYYYYYY MUCH!
Well, <br>
I kinda know how to do the query search. It's easy, just adding a criteria.<br>
<br>
I have lots of records in the table though. The thing I wanted to do, but can't solve the problem yet, is that I would like to create the FORM that searches for specific record and gives me the output...
i have a MS Acess database (tables with data)<br>
i have a not working form that i wuold like to MAKE :) work and search for entries (records) within the database.<br>
<br>
search should be based on :<br>
document type (agenda, minutes, etc.)<br>
date of publication<br>
document unique...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.