Search results

hi guys i have a code to prevent the standard error message for duplicates in my data entry form but for some reason is not triggering. i keep having the Standard Microsoft Access Error message, when trying to enter a duplicate key value. this code has worked in my other forms with no...

hi Keith so this is what i did and it seems to have worked, i schedule dto do this once every month. this DTS is very basic just copies a table(it has duplicates) from another database and then put the data into my table with different column names. In my table i inserted a pk autonumber...

is there any way to skip the ones that have duplicate values int the PK?

thank you Keith, but that is the first thing i tried, in the source tab in DTS wizard where i have the select statememt i put Select Distinct ..... but i stilll keep gettting the error the task reported failure on execution the statement has been terminated cannot insert duplicate key row...

Hi guys , I am trying to do a dts in which copies a table with duplicates, and then puts the data but it cannot have any duplicates. What is the best way to do this? I remember long time ago I saw a trick of how to do this by coping the table and then inserting a pk into the table, not sure of...

thank you, but none of the transaction logs matches that location i gave you, this files seems to be updated every night too . i was reading an article regarading the sql.log , it said to go to control pannel, under odbc connections then go to tracing tab, stop it and then change its location...

hi guys i was wondering if you can help me... i find a folder named 1 under my local\adminstrator\temp in my c drive in sql server, when i open this folder i have a sql.log file, this file is almost 3GB, i need to move it to another drive but it won't let me, can someone tell me how can i do that?

i did an same error.... i also rechecked the indexes in the two tables and everything is fine... :confused:

hi guys i was wondering if you can help me this is my code: i have a main form with this code, this form contains a subform linked by the All_PricingID Set rst = CurrentDb.OpenRecordset("tblAll_Pricing") 'main table ' adding data to the table rst.AddNew ' Main table rst!All_PricingID =...

studentID is coming from the DMax("StudentID", "tblStudents") + 1 .............. yes the subform has an autonumberID called SubDepartmentID , this form comes from the tblSubDeparments. the foreignkey is FKStudentID. There is a one to many relationship between tbl Students and tblSubdeparments...

Thank you Pat! so i would put this in my main form? Private Sub cmbDepartment_AfterUpdate() Dim intQty As Integer Dim i As Integer If MsgBox("Are you sure you want to add a new tuition plans for this student?", vbYesNo) = vbYes Then Me.txtStudentID = DMax("StudentID", "tblStudents") + 1 'get...

hi i have a main form called "frmMain" that i use for users to add new studentsNumbers txtStudentsNumbers.bound to tblStudents also this form has a combo box called cmbDepartments coming from tblDepartments. Then a subform which right now it has a combobox called cmbSubDepartments (coming from...

thanks i did not know that... i got it!!!! i had the code in the price change event.. so it was adding every time i would add a number... now i changed it to the save event and it works perfectly... yayy!!! thank you so much for helping me.

yes you are right there is a one to many relationship from tblPricing and tblhistory.. from PricingID . I need to somehow select the pricingid in the form and insert those fields for that pricing id fk in tblhistory. labbolt thank you so much for your code, it works wonderfully... then only...

hi guys i have a form that comes from a query with a parent and child table. Main table pk is pricingid and then the foreign key in tblHistory is pricingid. I am trying to do an append table but i keep getting an error message Pricing ID is the pk autonumber in tblPricing (parent table)...

no because the subcontract combo is what defines how many rows is going to be.

hi guys i was wondering if you can help me please, in my main form i have a text box which the user enter an item number , and a combo box with the main contracts., then a continuous subform which has a combo box with the subcontracts that belong to that main contracts, in the subform i also...

hi guys i have form with a listbox . The listbox is coming from a query that gets all passengers(column 1 in listbox) and destinations(column 3) . so you have repeting rows of passengers since they could have up to three destinations. Then the user has to select a row in the list box , click...

dont' worry , i finally figure it out, i just had to add the requery to the after insert event... woohoooo!!!!!!!!! finally :)

no , the user enters a value in the txtPassenger text box in the main form. then they go to the subform and select a Destination in the combo box. Since it is a continuous subform with one combo box, then when you select one then the combo box appears again and again to enter many Destinations...