Search results for query: *

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

930driver - I have a similar issue with normalizing a database tables. I was wondering if I could send you my relationships and tables info. Thanks, Survane.

I have the line : Dim cat As ADOX.Catalog Dim rst As ADODB.Recordset Dim usr As ADOX.User In order of the ADOX to work, I had to add the "Microsoft ADO Ext. 2.5 for DDL and Security" reference to the database. Is there alternative code that can be used instead of ADOX? When I add...

When I attempt to open one of my databases with ADO code in it I get the following error messsage after the database exits quickly: "Cannot find the file ____________________ or one of its components. Make sure the path and filename are correct and that all the required libraries are...

I recently added the ADOX DDL and Security reference to 3 databases now when I attempt to open them, they exit immediately. I try to break the code but to no avail. Has anyone experienced this? Thanks.

I tried that too and it didn't work. Thanks.