Search results

Rich, These combo boxes are bound to tables. Could this be my problem? PDX, I used that code and I still get the syntax error. durdle ________ toyota corolla history

Hi Again, I hate to keep on this but I can't see any issues with the data being appended. Below is the data: INSERT INTO tblmain (Trainer, Date, Week, A1_1, Comments1, A2_1, Comments2, A3_1, Comments3) Values (1, 6/1/04,3, 1, Test1, 5, Test2, 4, Test3) Note: I have the combo boxes linked to...

Hey pdx_man, Thanks for the reply, but I am getting the same error message. The code I used is DoCmd.RunSQL "INSERT INTO tblmain (Trainer, Date, Week, A1_1, Comments1, A2_1, Comments2, A3_1, Comments3) Values (" & Forms!frmmain2!cbotrainer & ", " & Forms!frmmain2!Date & "," &...

I want to apologize for my ignorance because I am new to this type of statement. But when I use: Private Sub cmdsubmit_Click() DoCmd.RunSQL "INSERT INTO tblmain (Trainer, Date, Week, A1_1, Comments1, A2_1, Comments2, A3_1, Comments3) Values (forms!frmmain2!cbotrainer, forms!frmmain2!date...

Good day, I am just looking for some guidance on the following problem. I feel if I explain it more so then attached my database, I will learn easier. Here goes: I have three tables: tblSourceTable(This is a Linked table from another Database) tblEmployeeMain tblUpdateTo Basically I want to...

Good day, I am looking for a way to restrict end users to access tables/queries/modules. The users have Access 97 installed on their machines. I am not sure how to split the database, I believe you need the developers verision of Access?. If I created an MDE file, this would not limit the...

True enough dcx693, I didn't think of that. Thanks ________ buy silver surfer vaporizer

Good day Everyone, I was seeking some advice with regards to data on my attached form. Essentially my form is build on a query which can return multiple records on the form. By each record you will see an Update, Delete or Cancel button. I am tring to build the SQL and/or queries for these...

Thanks for your help Wayne, working now. ________ digital vaporizer

Too few parameters error Good day, I am getting an "Too few parameters error:Expected 1" on the indicated line below: strsql1 = "Select Count([empid]) as CountofEmpID from tblvacation where tblvacation.curtour=" & Me.curtour strsql2 = "Select count(empid) as CountofTourEmps from tblEmployee...

Good day Everyone, I am looking for some help with my vacation database attached. I have spent alot of time tring to reach my resoultion using queries but that seems like it is not working. I just need to be given some direction in how I should go about this. I am creating a vaction...

Good day, I have attached my db to simplify my explanation. When you open the db and in the Search field type "Tester", and then Click the Command button to the right on the next form. This will open the frmemployee form and on this form it has the "frmvachrsbooked subform" subform. There...

Hey Dan-Cat, That function worked like a Big Mac Combo, supersized. :) Thanks ________ ford xc falcon

Good day, I am here trying to figure out some vba. I have a date textbox on my form and when the user enters a particualr date I want to search through a table"tblStatdate"(this has only one field in it with 7 values) and if the date entered is in the table i want it to go inside the if...

Hey, I have a question regarding mutiple users accessing the same table, in particular the same record. I was wondering is there a way to prevent this from happening, a way to "lock" a record if it is currently used. This database has 20 user ID's in it, so if one user is updating the record...

Goo day, Just wondering how do you create a small data entry form and put that onto a NT 4.0 workstation where Access is not installed. Thanks Chris ________ suzuki gn series history

Mile I have the following code behind the button: On Error GoTo Err_cmdFrom_Click Me.txtto = Nz(Me.txtto, Date) Call ShowCalendar(Me.txtto) Exit_cmdFrom_Click: Exit Sub Err_cmdFrom_Click: MsgBox Err.Description, vbExclamation, "Error #" & Err.Number Resume...

I just registared the calander control, so now when I click on the button it opens up the calander great, but when I select a day it do not return it to the textbox? This is weird. ________ chrysler dr platform history

Hey FoFa, When you say control do you mean the actual form? durdle ________ mexico city hotel

Hey, On my form I have command button, when this is clicked a calander pop's up. It works fine on my machine but when I tried it on my friends system the following error message appeared: "There is no object in this control." Any idea's on this one. Thanks durdle ________ extreme q vaporizer