Search results for query: *

DHookom, I have a question on how to go about something. On my "End Of Day" function, all works fine but I want to change it up a little bit. Right now it's totaling up the total amount brought in for haircuts (IncomeType=6) that day and inserting it into the tblLedger table. I want to separate...

I did it exactly like you said and it works perfectly... Thanks for showing me how to do that, it's simple stuff, but it's the simple things that make it simple

That works perfectly. Thank you! Here's the code I used on the AfterUpdate Event on my cboCustomerName combo box... Private Sub cboCustomerName_AfterUpdate() Dim CustomerID As Integer CustomerID = Me.cboCustomerName.Column(0) Me.optCoupon.Enabled = (DLookup("CouponFlyer", "tblCustomers"...

DHookom, I have a small issue I'd like a bit of help on if you can. On the same unbound form where user selects type of haircut, payment method, and customer name; I also have a option box to check if the customer has a coupon before they click the cmdSubmit button. A customer can only use one...

When I was stepping through my code, my locals window was showing my salesDate value surrounded by # signs so I assumed I didn't have to put them in my code, but I assumed wrong. I modified the code to be like yours and it works with no problems, thank you very much. Dannie.

DHookom, I am using the code you wrote and it works fine, but I was thinking of a possible issue that might arise. Let's say a user runs the "End OF Day" totals and then cuts another haircut. If they forget to run it again to update the last haircut and then does it the next day then I need to...

Thank you DHookom for your help. I've never used the DCount function before but I got it to work and I really appreciate it. I had to modify the code a little but because the "CurrentDb.Execute strSQL, dbFailOnError" would give me an error, "Too few parameters, expected 1". I changed it to the...

I have been building a database for my barber shop. On my unbound "frmHaircuts" I have some option buttons for the user to select which kind of haircut the customer just received. I have corresponding text boxes with DLookups as the control source displaying the price for the selected haircut...

I got it to work, thanks so much!!

Previous totals won't change but if the need arises, I can make an Update Query to handle that. The haircut table just stores what we've done for each customer. At first it started out as only a barber shop, but now a lady works there doing styles, perms, and coloring for females as well and...

Sure, and thank you for helping. Here's the SQL statement: SELECT tblHaircuts.HaircutDate, Sum(tblHaircuts.TotalPrice) AS SumOfTotalPrice FROM tblHaircuts WHERE (((tblHaircuts.EmployeeID)=1)) GROUP BY tblHaircuts.HaircutDate; This brings back totals for each day for each employee. The way I...

Hello, I am building a database for a barber shop. Not too complicated and it's coming along well. I have an unbound form that has option buttons for user to select types of haircuts, prices, and payment methods. After all fields are populated, user clicks cmdSubmit button. This runs an Insert...

I am making a frmCustomers form. It is bound to the tblCustomers. On the form I want to put an image box (do i use image boxes, bound/unbound object frames, or Active X controls?). I want the image to only display the image, not store it in the database. I've used the File Dialog Picker before...

Thank you so much missinglinq, i appreciate the help. I got it to work ...

I have a problem I can't figure out. I have a couple unbound combo boxes (cboEmployeeName and cboCustomerName) on an unbound form along with other controls as well. There are numerous controls on the form for user to select and once all are selected, I have a submit button that will run a SQL...

I tried both ways just to learn, but the SQLDate Function was the only way I could get it to work. I also coded number signs around my variable in the sql statement and that worked as well but I like the function so I don't have to write the statement every time...Thanks for all the help MajP...

I am having a problem with running a SQL statement. I've dimmed all my variables and it does exactly what I want it to do but I am having a problem with the date variable. It enters it into the table but it's 12/30/1899...I know I have to use # signs but I don't know where to put them in my VBA...

I did like you said and it worked out great...thank you very much!

Hello MajP, you helped me a couple years ago with a database I was building for a restaurant...Yes, I am using radio buttons, and I have them all laid out and properly named. I just need direction on how to go about writing a procedure to check all radio buttons' value and make sure that only...

I do have a question on another issue and I was hoping you'd point me in the right direction. On this unbound form I have 8 unbound check boxes that user will select when entering the haircut info into the table. User can only select one of the 8 check boxes because each check box is for each...