Search results

Am I talking rubbish? Is this not doable? Is there a better way of acomplishing this? i wonder... :rolleyes:

Check out this example in Access 2000 format.

One question: is the Date Field called Date? if it is you may want to change it. Date is a reserved word and it will cause you problems. Change it to AttendDate or something.

That is correct i just tested it and it works. Something else on the Query is probably being filtered already. If you put NO in the Criteria it will only give you unchecked records. If you put YES in the Criteria it will only give you checked records. If you put nothing in the Criteria it...

Here is a screen shot.

Within the query under the Attend (Yes/No) field in the Criteria section enter Yes This should filter out the No records.

Hello everyone, Using Acess 2007 This is what I have: I have one Query with the following: Main.ID, Main.First Name, Main.Last Name, Main.Assigned Date I created a Daily Report using this Query to tell me when I need to meet again with these people. I have a Report that has the following...

Thanks! :)

The trusted locations are already in place and waitting! :) Thanks for all your efforts and time spent in this very unique and helpful place. René

Access 2007 and Front-End Update Utility... Hello Bob, I tried using your handy utility on an Access 2007 db, but I wa not able to get anywhere from the get go. it checks that the db has an extension of .mdb. I'm not very familiar with vb but I tried tinkering with the code so It would...

I know this is an old link, but I thought I would just make a quick comment pertaining to the import of data. Could they not link .csv files as their tables? This way the person with the Full Access app can just export the data to csv files and have the remote users (with no Office apps)...

I just quickly tried it in Access 2007 and i was able to get the full (Monday January 28, 2008) date with out the Format command. i just added a text box (with =Now() to test the date) and in Property/Format selected "long date" and it worked fine. Just so you know.

Hello Adam, I'm afraid not. Villarillo Gardens? Where is that? I live in Central California. Now you got me wondering where Villarillo Gardens is at. René

Glad you figured it out! I knew you could. It makes more sence when we work it out on our own that if someone gives us the answer. This forums are a gold mine of information, but the more we learn to work it the more valuable the information is. So see this forum as a learning exerience. A...

Hello Ramirez, Read on this links to understand how to do the Auto population of data: http://www.access-programmers.co.uk/forums/showthread.php?t=139288&highlight=Auto+populate http://www.access-programmers.co.uk/forums/showthread.php?t=125349&highlight=Auto+populate have fun! René

Hello Fugifox, Do you mind sending me a copy of the calendar? Would love to see it. Thanks!

Hello Zigzag, I think you are a very generous person, nothing wrong with that!, but I think doing it for him will not teach johnson34 how to do things within Access. I think that assisting him with the issues as HE creates the solution would prove to be a better option in the long run. what...

Hello brsawvel, If what you need is to sort a list box, read the whole thread, but focus on the following posts: http://www.access-programmers.co.uk/forums/showpost.php?p=499667&postcount=2 (Look at the MouseDown Event code)...

Dr. Data, Thank you for your post on this topic. I followed your instructions and it worked flawlessly. Thank you! This was a sore subject until I found your sample DBs. The requestor required exaclty what you demo'ed in your db samples. thanks again! René

Sorting and Grouping... Look in the Sorting and Grouping on your toolbar. Check under keep together. Option. René