Recent content by Survane

This code is running behind my splash form. I want to see if the time is between 1 and 2 PM.

Is this correct? If Time > #1:00:00 PM# And Time >= #2:00:00 PM# Then If CurrentUserInGroup("usrgrp1") = False Then MsgBox "This is usrgrp2's time" DoCmd.Quit Exit Sub End If End If

Skip, Say this is my table CID PmtID PmtAmt BalanceOwed 1 20 25 500 1 22 50 500-25-50 = 425 1 43 100 425-100 = 325 See what I mean?? --------------------- survane@hotmail.com

Guys, I have a query in which I track payments but I wanted to know how I could decrease the customer's total when a payment in made either in full or in installments. If I do a calculation then the current payment is subtracted from the balance but not previously made payments. Please help...

I am trying to append all the records in a continuous form to a table but I am having a lot of trouble do so. The query is not getting the criteria from the form. Has anyone done this successfully? --------------------- survane@hotmail.com

I am trying to append all the records in a continuous form to a table but I am having a lot of trouble do so. The query is not getting the criteria from the form. Has anyone done this successfully? Thanks so much --------------------- survane@hotmail.com

vbSun, When I tried to call it, the "OpenFile" command didn't work. It kept saying that Form1 was not defined. Thanks! --------------------- survane@hotmail.com

Guys, Is it possible to add an option to an option group that binds it after the wizard is complete? I need to add one more choice but it is not "bound" to the group. Thanks. --------------------- survane@hotmail.com

I tried this, but the year always defaults to the current year. If I select 1/1/02, it displays 1/1/03. Has anyone else encountered this problem?? --------------------- survane@hotmail.com

Steve, Could you send the mdb to me as well please? Thanks, Survane@hotmail.com --------------------- survane@hotmail.com

DM1, Did you find a viable solution to this problem? Thanks. --------------------- survane@hotmail.com

I've tried both methods but somewhat to no avail. When I used the SELECT statment, I got the recordsource. I couldn't push the value to cbo box. The dlookups didn't work either. Is there a way to do this in ADO also what if I need to leave the last field blank because the PK is based on the 1st...

I have a table that lists 400 different cars by manufacturers, makes and models. Each car has a unique ID (autonumber). I am linking this to another table but I only want to store the vehicle ID. I don't want to add three new fields for the manufacturers, makes and models. My user has to enter...

Thanks Bandit WK. I will try this a post feedback.

I have a form where I enter callers information. I may have duplicate callers but that's ok. What I want to do is if a caller is a duplicate caller, then after the phone number is entered, it will check that table and automatically enter that caller's information in the table. I have each...