Search results

Yah. I know now :) The biggest one I need to stop doing is the spaces between words in field names.

Hi June7, had a look at the db you kindly sent back for me to check. The 2 tabs and this part of the db are a part of a much larger database that I'm working on. It involves entering a lot of data, looking for and updating data, etc. Thus the reason for a bunch of different tables/queries. The...

Hi June7, thanks for your suggestions. I will have a look at the file and learn from it. Like I said, I'm fairly new to creating a large db, although I've dabbled with Access in the past. I wish I found out about the naming conventions before I started. Some of the field names are now coming...

Hi June7, vba_php helped me with a starting point. Being a newb to VBA coding, I like to use the KISS principle, which his example is for me. I was thinking initially of somehow using the 'AfterUpdate', but it is still all new to me. Lots of reading up ahead for me :) A

Have a good one :) I'll be busy myself for a while writing code :)

Thank you, Adam. I appreciate your help. I wasn't sure how to populate all the fields with a click of a button. I'm still so new to all this ..... A

I'll have to rename the 2 queries - '..Stats' and '...Completed'. I think I'm getting myself so mixed up I'm chasing my own tail :) And, yes, I only see the completed files. So that part is good. When I press the 'Results' button, a report pops up with all the completed containers. What I...

Hi Adam and June, Sorry, I didn't leave better notes, it was late at night ....... The whole stats page is based on -qryMDEMexamsStats- Right now, when I enter the start date and the end date on the 'STATS' tab, a report pops up, based on the date range, showing how many total containers were...

[SOLVED]Collecting statisctics in db with VBA Hi all, I have another question about the db I'm working on. This time, it's about collecting and displaying statistics. I would like to collect several stats (off of a query page?) and have them displayed on a form. And it's all based on two...

According to Wiki, he took a part in a bank robbery and a subsequent police chase on Sunshine coast. The only way to get out of that area are 2 different ferry rides, about 100 or so mile apart. So him being caught was inevitable. Only got 2 years less a day, plus probation. Hmmmm Again, that's...

I've sent it after I went to the link above, re: Joey Cramer. He lives on Sunshine coast, which is about a 45 minute ferry ride from Vancouver. I don't know much about him, although I've heard of the movie Flight of the Navigator.

Hi Doc_Man, Thanks for your note. Happy New Year to you and yours. I'm only scratching the surface with Access, but it's something that I love to play with. I'm learning tons of new things and coming up with ideas for db's.

Hi Colin and Adam, thank you so much for helping me out. I really appreciate it. It works like a charm and exactly how I envisioned it. Respect to you both :) Andrew PS: Adam, I've replied to your other message separately. A

Hi guys, I had to delete the previous message with the attachment, because I had to remove some more stuff from the db. This one is OK to go out to the world. I removed some sensitive data. Thanks for all your help. Andrew

Thank you, Colin and Adam, for your suggestions. I tried all the different ways that you've suggested, but still not working (all on one line, and as I had it in the OP). The txtContainerN and txtContainerNUmber fields are both text fields. I noticed that when I added the 3rd comma in the DoCom...

Thank you, Adam, for your reply. The reason I need it the way I have is to see the report of all the containers and then from there I can pick which worksheet to print with which container. I've looked through AW forums in the past and I find them very helpful. I got a lot of good/different...

Awesome. Thank you. When I posted first time, a message flashed but I didn't see what it said. Now I know.

[SOLVED]Single and double quotes Hi all, I've searched high and low all over the Net, but am getting stumped .... And I think the culprit is/are the quotation marks. I've downloaded and modified a code I found on the net and it works to a point .... I use Access 2016. I have a db, where I...

Thank you. Happy New Year to you as well :)

Thank you, Sir. Happy New Year to you as well. All the best for the upcoming year :)