Search results for query: *

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...

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...

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 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...

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...

Hello. Is it possible to change the background color of a button. I do not see the option in the properties box...just fore color?

Hi everyone. Is it possible to add a new field in a table in a more user-friendly way then having to go into the design view of the table? Could a form do this? Thanks, Stacey

Hey again! I know this has been asked before, but I don't understand the answers that well...I'm very new! I doing a program to write up food orders. As of now, I just have an unbound text box next to the item that shows its price. The price amount is set in the default value in that text box...

Hi again! I know I'm new to this message board and I hope I'm not aggrevating everyone with posting so much. It's just such a great source to find out things I haven't been able to find in my Access Bible or the Access help. :) Anywho... I have about 40 different food items for sale in this...

I have a subform that I need to perform a calculation in. One of the objects to be calcualted is a field, and the other is a text box. I set up a third text box to perform the calculation in its control source. It looks like this: Control Source: =[SmSoda]*[SmSodaPrice] SmSoda is a field and...

I'm running a cash register type program. On my form, I have a text box to calculate the change for an order: amount tendered minus the total which is done in the Control Source in the text box properties. When less money is given than the total, the change field shows the negative in...

I am running a cash register type program. After the order is totaled, I would like to have a button that brings up a pop up box to enter the amount tendered. AmountTendered is a field in this order table. Any ideas on how to do this? I've tried having the button open a new popup form that just...

I'm new to Access and trying to find my way, but I can't seem to wrap my brain around how to do this. I would like to write a program that is basically a cash register. The screen would have pictured buttons of the food items with a quantity box next to it and when you hit the button the...