Recent content by TadyB

Thanks! They can have more than 1 guest per visit. I've set up the 3 tables you suggested, but it's actually 4. I can't have the one table to hold all people...guest and members. I have my member table and created a guest table. Then I created a visit table and the 4th that holds the visitid and...

Hey everyone. I have a form I'm having trouble developing. It's for a swim club. When a member enters, they need to check in. I've developed a simple form called Visits that keeps track of this. It is linked to the Member table where all member info is stored. The Visit table just stores the...

I'm getting an "object variable or with block variable not set" error and I don't know why. There is no code involved. All I'm trying to do is change the background picture of a subform. I go to the subform properties, then his the ellipses for the Picture, select my file and then I get the...

Ok, thanks...I will try that...can't wait to learn! Stacey

OMG...that was so cool! I've never looked in my SQL before...so much to learn...it works perfectly...thanks sooooooo much!!! Stacey

Hey. I have an invoice report with a query that prompts the user for a date range based on the InvDate. Is there an easy way to get that date range printed on the report? I don't have my invoice items listed individually, just the total for items purchased for that date range. I would like to...

Duh, never mind. Thanks anyway, Stacey

Hey everyone! This might be a simple solution, but I can't think of it. I'm creating an inventory report but I don't want the items to be printed, just the total. It's for snack bar items and they just want a Snack Bar total, not every coke and chips they bought that month. Any ideas? Thanks...

Hey Richard! How have you been??? This problem comes from the swim database when you go into the ItemFrm and try to select from the Reorder dropdown. Any ideas? Thanks, Stacey

Hey...thanks for the reply! I'm searching to find if CNUM was defined somewhere else in the coding that I might have deleted...going back to the original. The line with CNUM in it is: sngReorderPt = cnum(strReorderPt)/100 I searched for CNUM in this forum and it seems to be used to return a...

Hey everyone! I'm learning VBA and run into a problem. Someone gave me an Access database to use to learn from and it has CNUM in it and I'm getting an error when it calles on it. It says "Sub or function not defined"...CNUM is highlighted when I go to debug. I check everything else and it seems...

Thank you...but that's not quite what I'm looking for. I'm trying to have a better/easier/quicker way to select items without the use of a dropdown list. I don't want the user to have to scroll through a bunch of items to find the one needed and do this repeatedly until the order is complete. I...

Hi everyone! I know this has been answered before, but I can't find it! I don't know VBA, so please be gentle!! I have an Orders form/table (my main form)...a category subform...an item subform...and the order details subform. I would like the category and item subforms to be data sheet. Each...

Thanks y'all! I'm working on it...I appreaciate everything you've done!! What would I do without you???? Stacey

Sweet...thanks Lightning