Recent content by hinesbrad

Ok - I think I have the basic idea. The problem is I haven't been able to find the code that does the recordcounting. Would I need to use ADO or DAO to do this with some SQL? Could you recommend an introductory tutorial on how to use these? (Maybe "Select COUNT() from table stops where...

Hi everyone. I've come across a challenge on a sub of subform situation that I've had some challenges with. I have a form designed to accept input related to picker efficiency and you have all helped me tremendously - thank you. My next question is on the forms exit event. Since we're using a...

Yes - this is true. So we've identified the problem. What ideas do you have on a workaround?

Greetings. I find myself in a bit of an odd situation where I need to keep track of the rate of items being worked on. I have a tabular form that contains three fields for a time entry: (HH, MM, and SS) presented so a user can easily enter a time value.:confused: HH : MM : SS and another...

Hi team, I don't think I am doing a very good job at explaining my problem or outlining what I am trying to achieve. I'll try and do a better job on that the second go-around. Some of this information might not be value added. If it's not, please allow me to momentarily bow my head in shame...

As Requested.

Would it be possible for me to email a copy of the relationships I have set up to verify my integrity in question?

Would it be possible for you to send me a copy of the relationships table of the database under discussion? Maybe a screenprint of the relationships window of the database in question would make things a bit clearer.... Hines Dot Brad at gmail dot com

Thanks for responding! I have the tables set in a many to many relationship because it would seem that I'd break data integrity rules if I didn't. One customer has many deliveries. Each customer (store) has a customer number associated with them. So, if I want to say, pull a query that lists...

Hi all, I'm encountering some special issues on an Access 2007 VBA application I am writing, and having some issues and challenges correctly creating the tables to relate my data. I believe at the end of this I should have four tables total, but we'll see. In a nutshell: I work for a warehouse...