Search results

  1. D

    RunSQL - Syntax Error

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

    RunSQL - Syntax Error

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

    RunSQL - Syntax Error

    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 & "," &...
  4. D

    RunSQL - Syntax Error

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

    Configure 3 Tables

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

    Restricting Access to Tables

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

    Looping Through Form

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

    Looping Through Form

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

    Any advice?

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

    Any advice?

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

    Any advice?

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

    Refreshing Subform - Requery not working

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

    Searching a table

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

    Searching a table

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

    Preventing two users from Accessing the same Record

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

    Creating Form without Access on machin

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

    No Oject Error

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

    No Oject Error

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

    No Oject Error

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

    No Oject Error

    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
Back
Top Bottom