Search results for query: *

hi, i have a field name ID (autonumber) and date, how do I reset the autonumber to 1 when new year start. Examples: ID Date 1 01/01/07 2 07/15/07 3 12/24/07 4 12/31/07 1 01/01/08 2 02/05/08 3...

I have a tiny problem related to this one. The Date is the unique key and can not be duplicated (dteDate = me.txtCollectedDate).So how can I avoid the duplicate if user enter the Date which already has the record in the table and would like to pop-up a message saying "Duplicate Record. Please...

Oh Yeah, I got that one Missinglinq...Thanks TN (USA). I'm using Windows XP, Access 2003, Crystal Reports 11 and SQL Server

Thank you very much to everyone that has helped me. Once, thanks alots. Especially, The Missinglinq...These codes worked like charms. These are exactly what I'm trying to do. TN (USA). I'm using Windows XP, Access 2003, Crystal Reports 11 and SQL Server

Hello All, I would like to calculate Week Number (each year has 52 weeks) and period during that week. First Day of the week is Sunday and last day is Saturday. Example: If I enter these days below: Date: 01/01/2008 01/03/2008 01/15/2008 03/28/2008 07/01/2008 07/22/2008 09/27/2008 12/21/2008...

HI No1biscuit, I have the same problem but couldn't can it solve. So may I have a sample of this post. I'm very appriciated. Thanks for a millions. TN (USA). I'm using Windows XP, Access 2003, Crystal Reports 11 and SQL Server

It said "ODBC--call failed". But if in table I had: CustomerID VOH_ID OptID 1 5 2 Then it would add CustomeID = 1 , VOH_ID = 1, then 2, 3, 4 when adding VOH_ID =5, getting an error with "ODBC -call failed" because there is alreay had...

Please help... with this one, I'm very appriciated. table named: "tblCustomer", Primary key: CustomerID and VOH_ID. If there r new records then I can use this button for adding new. However, if there are some records in this table such as: CustomerID VOH_ID OptID 1...

hello, i have a problem using access 2003 and SQLServer. using DOBC. If i'm using the mdb by myself then it's working fine. However, this is a shared mdb by network, so more than 2 people can open the database at the same time. All other forms are working except 1 form after i hit a button then...

Thanks lespaul and PHV for your repond. I haven't noticed the ".close" before the Next statement. Once, PHV - thanks, I'm very appreciated. That's helping alots. TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server

Thanks dhookom, I posted in the wrong forum. Thanks for reminding me. TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server

Thanks Remou, I got it figured out. It worked. Once thanks alots TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server

I took out the Set VioID =1 then it's only adding record number 1 and after the loop i got an error "3420 - Object invalid or no longer set" TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server

Thanks for your reply lespaul. However, how I'm gona Insert your code into my sample code below, please help I try with the code below but it's not working Private Sub cmdAddingViolation_Click() Dim rst As Recordset Dim wsp As Workspace Dim VioID As Integer Set wsp =...

I have a form linked with a subform such as: main form: (table A with ID: primary key) ID :1545 CustomerID (auto-number) 500 and some other fields subform (table B, primary key: CustomerID and ViolationNO)(CustomerID in both tables A & B linked) ViolationsNO Score...

hi i have a main form linked with subform, in the subform I would like to show all 27 records, how can I do it? please help? Example: Main form: CustomerID (auto-number) : 12545 Subform: (link with customer ID) (continuous form) Violations Score CustomerID 1 5...

hi i have a main form linked with subform, in the subform I would like to show all 27 records, how can I do it? please help? Example: Main form: CustomerID (auto-number) : 12545 Subform: (link with customer ID) (continuous form) Violations Score CustomerID 1 5...

Thanks for your response - synapsevampire I tried with your recommended with the codes above and I got an error pop up in ({@Display}) such as "String length is less than 0 or not an integer" Below is my code for ({@RXDesc}) : trim(if isnull ({table.Code}) or ({table.Code}) = "" then ""...

I created a report with formulas: In group header: (@Reset): whileprintingrecords; StringVar RXDesc := ""; Group footer: (@Display): whileprintingrecords; StringVar RXDesc; left(RXDesc, len(RXDesc)-2); And In detail: (@Accum): whileprintingrecords; if not isnull ({@RXDesc}) and...

Thanks synapsevampire and lbass, it worked. I'm very appreciated. TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server