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

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?

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

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

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

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

hi guys i have a main form called Passengers coming from tblPassengers table and then it has a subform to select the destinations for each passenger. My subform (continuous) consist of entering up to 3 destinations for each passenger so i created a combo box with this row source: SELECT...

hi guys i have a main form with a subform. i have created an add command button to add rows in the subform. (it could only add when the record count is less than 3). here is my code If Me.SubFormName.Form.RecordsetClone.RecordCount >= 3 then Msgbox " You can only add three" cancel=true...

hi guys i am working in customizing my current switchboard and i was wondering if there is any way to hide a button according to a user.. i currently have a tblusers with the username, switchboardid and itemnumber i want as a default, but i would also like to have a certain itemnumber to be...

hi guys, as of now i have a network access 2003 database as a front end and the sql server 2000 as the backend. I have done some research and i read some forums that the best way to have a fe access db is to actually have a copy for each user locally? is that correct???, then what happens to the...

hi guys i have a list box which has 4 columns that come from a query. when a user double clicks a selected item, i want the frmUPdate to open with the selected item; it gives me no error it just always goes to the 1st contract . have no idea what else to try... here is the code: Private...

hi guys, i was wondering if you can help me, i have a text box and a combo box that needs to changed every time the user clicks on a contract in my contract combo box... but i keep getting this error and it goes to the end of the code and it says the value you entered isn't valid for this...

hi guys, i am a working on a form in which is bound to a table in my access database. I have a text box (which its source is the Facility ID, then a combo box that has all the contract id that the facility can have, and then a contract status combo box in which it changes according to the...

hi guys. i was hoping you guys could help me, i have a combo box "cbocontract" which gets populated according to a selection from another combobox(cboAll). now i have another combo box(cboStatus) which according to what the user selects in cbocontract list box it should display active or...

hi guys , i need help with my espressions in this view..... my espressionskeep giving me an error message... can anyone help? SELECT dbo.[query 2 b ].Expr1, dbo.[query 2 b ].Expr1 AS Customer_No, MAX(dbo.[query 2 b ].Invoice_Date) AS MaxofInvoice_Date...

hi all, i have two 2003 access databases with linked tables to my sql server 2000. For one access database i used the upsize wizard to send my tables to a new database in sql server and for the other database i went to file, get external data, linked talbe, odbc database and created a new odbc...

:confused: I'm running an Access 2000 Database on Windows 2000. The Access Database links to SQL Server 2000 tables. The error occurs when the users login with their windows login (my sql server is mixed authentication) and open the database to open the tables or forms. The connection will...

hi guys, i was wondering if you can help me, i have a form in access the code is kind of big but i am only having a problem when adding a new record so here is that part . the problem is that when someone enters an account code that needs to be added then it refreshes the form, and the fields...