Recent content by Cowboy

Thanks for some more explanation. So am I getting this properly, that if I made form with checkboxes for each time slot, I would only save the information for a checkbox that is selected? If a user selects 13 of the 29 checkboxes, how do I store which check boxes have been selected in a table...

Thanks for the responses. I guess the only reason I would need the 30 (or 31 I guess since I'd be using a date field) fields is because it needs to be dumped into an excel sheet with all, some, or none of the fields holding a single boolean value. I think your post confused me doc_man. Some...

I am trying to create a scheduling program to help out one of my coworkers and I'm having some trouble designing the db. I have figured an employee table to assign a pkEmployeeID to keep track of who is putting in availability. I have broken out tables for the dates(tblYear, tblMonth, tblDay...

No problem. Glad I could help out!

It definitely is a great feeling. I still feel like I don't know a lot of what I'm doing, but I noticed a post I felt I could help with...and it took me 10 minutes to figure it and then voila...good feeling!

I had to say it somewhere, because this is the first time I actually offered advice on these forums, and as I am still learning A LOT of this, I felt I needed to express my joy in the fact that I came up with an answer to help someone with an SQL query!! YAY!:D (I didn't create the answer, I...

Re: querying two fields in two tables using a conditional statement? Here is an SQL statement that should work - just tweak the table names/fields to match yours: SELECT DISTINCT tblEmployeeCerts.EmployeeID FROM tblEmployeeCerts LEFT JOIN tblKeyCerts ON tblEmployeeCerts.fkCertID =...

Hi rjhartman. I think your post might be better suited for a thread in the Queries section of the forums. *Note: I'm still learning, so this might not work* I would try running the following query: "SELECT EMPLOYEE_CERTS.EmloyeeID WHERE EMPLOYEE_CERTS.CertID <> KEY_CERTIFICATES.CertID"...

Thanks for getting back to me so quickly. So "8" & Chr(34) & " Par" should be the way it looks then? Thanks again, I'll go try it out!

I realize this is an outdated post...from 5 years ago! I was searching through the boards to find an how to put a single double quote in a string (such as "8" Par"). Would doubling up the quote work? ex: "8"" Par" I've been searching around the 'net and can't seem to find a clear answer! Thanks.

Which is why I hate it! I too agree it is a fantastic game, the whole storyline and "open" design. I just wish the damn developers were more like Blizzard in the way that Blizzard waits forever to put out a "polished" game rather than rush the way Bethesda Softworks did and then put out a...

Hi Jon (and everyone else), I realize, being quite a newbie here, that I don't know much about how things have "always been" or "always looked", but I have some questions/suggestions I think might be worth a look. First, the Google Ads on the Products, Services, and Learning tabs seem a bit...

Thank you! I will try that. I didn't know I could sum inside a query. Learning new things everyday. (Which is good!) :D UPDATED SECTION OF CODE: ' Define SQL statement to look for all the rows with added stock for a specific ' color since the last stock take strSQL = "SELECT...

Shoot. How would I total up all the values for a quantity? I posted my code here: http://www.access-programmers.co.uk/forums/showthread.php?t=198447 Maybe that can help you see what I'm looking to do. Thanks.

I'm wondering if someone could look at this code and let me know if I'm doing something wrong? Thanks in advance if you take a look! Public Function fnGetAddTransactions(vLastStockTakeID, vLocInvID) ' This function will take in the last stock take ID: varLastStockTakeID ' which was...