Search results

  1. T

    Passing data between forms OpenArgs?

    This was the original code that i had in the Beforeupdate event, are you saying that this way would still work ? If Nz(cboxOption, "") = "" Then MsgBox "You have to select an option !", vbExclamation + vbOKOnly, "Missing" Cancel = True ESCMessage Else On...
  2. T

    Passing data between forms OpenArgs?

    Just playing round with the validation code - should something like this work on the tabbed forms ? Private Sub Form_BeforeUpdate(Cancel As Integer) If Nz(cboxOption, "") = "" Then Cancel = True Else End If End Sub
  3. T

    Passing data between forms OpenArgs?

    Code changes to the below. If Me.NewRecord Then If Not IsNull(Me.OpenArgs) Then strOpenArgs = Split(Me.OpenArgs, ";") Me.TbJobId = strOpenArgs(0) End If End If Not sure i understand what you mean by the above, can you explain in more detail how to do this.
  4. T

    Passing data between forms OpenArgs?

    That sounds like the bit i am struggling on, so would i start with If NewRecord Then If Not IsNull(Me.OpenArgs) Then strOpenArgs = Split(Me.OpenArgs, ";") Me.TbJobId = strOpenArgs(0) '.. If there were more arguments ' Me.txtAnotherTextBox = strOpenArgs(1) Else...
  5. T

    Passing data between forms OpenArgs?

    the issue is not so much in adding a record, if you delete all the data in the tblmeasures table, and then go on to FrmInspection, it creates a new record - i think this is due to the primary key, and the job number being stored. How do i deal with these false records ?
  6. T

    Passing data between forms OpenArgs?

    updated - removed the code form the combo boxes
  7. T

    Passing data between forms OpenArgs?

    Latest version - OpenArgs working, but creating blank record, just storing the Job number - am i doing something wrong or do i need to build in to delete the blank records ?
  8. T

    Passing data between forms OpenArgs?

    Ok, i have managed to get the OpenArgs data to pass to the 2nd form using the code posted by Badly Bob in another post. I still have a issue that it creates a new record with just the job number stored in the table.
  9. T

    Passing data between forms OpenArgs?

    Imported into New DB and now only 1.5mb
  10. T

    Passing data between forms OpenArgs?

    how can i do this if it is not actually a subform, but a separate form..?
  11. T

    Passing data between forms OpenArgs?

    that's what i dont understand, i have 3 tables with 3 records , and 3 forms, and i cant make it any smaller. With the Ref to OpenArgs, i think i have done it right, but i think the issue is more around that i have the code on the on enter field, I have tried on before update, but one of my...
  12. T

    Passing data between forms OpenArgs?

    Hi all, i need some help, Firstly - i tried to zip a copy of my database so i can upload, but the smallest i can get this is 12mb, so unfortunately i am unable to upload. I have 2 forms - FrmMain and Frminspection. My main form (FrmMain) assigns a job number to the request, and then when...
  13. T

    Audit Trail - Tabbed Control

    I have set up a new form with a Tab Control, that contains 5 tabs. On most of my forms in my database use the below code to track changes to fields that are Tagged ? If I Tag the Tab Control, I get error 2427 - You entered a expression that has no value. or error 438 - Object does not support...
  14. T

    How to call function name and pass into other function

    Managed to get it working, in the end. Thanks.
  15. T

    How to call function name and pass into other function

    after thinking about it, i dont think that would work as i am going to run this on about 20 reports,
  16. T

    How to call function name and pass into other function

    I am playing with some new code below to log the time that it takes to run a query. So i have added a new function called Startlog and EndLog. I want these to use the function name as i log this in my table, is there a easy way to pass the Function name to StartLog and EndLog so i dont have...
  17. T

    Import tables function

    I wish I knew why it takes so long. I have some data in amazon AWS / sqlserver that I use to look up against, and my main data is kept in a back end with aws. I have 15 reports that export every morning, some days to export all 15 reports takes approx 6 minutes, other days same reports can...
  18. T

    Import tables function

    I have the code below to import tables from my Master database to my Dummy database. The problem i have is the the Master database table is a link to a SQL table, and i want it to convert to a local table (Taking too long to pull data from SQL Server), and not just copy the link. Is there are...
  19. T

    Dlookup Multiple Criteria

    Just found the issue - someone had unticked the Live Field... Thanks all.
  20. T

    Dlookup Multiple Criteria

    Still Struggling with another Dlookup for multiple criteria. My current code which works is WhoCharge = Nz(DLookup("Processor", "TblQCPreRetailSuppliers", "Supp_Code='" & Nz(tbSup_Code.Value, "") & "'"), "") and i want to add another criteria to check if the supplier is live, so tried this...
Top Bottom