Search results

  1. M

    Requery Listbox not playing ball!

    Hi All, i have a drawing database that is constantly evolving... and i have an odd issue. https://www.dropbox.com/s/grp4jhaa78ls9t2/Database%20Overview.jpg?dl=0 When the database opens 2 forms are opened... (I attached an image on the link) 1 Form is the search and add new drawings sections...
  2. M

    Linking PopOut Form to Main 'Parent Form'

    Hi, I've been searching through the forums for the last few hours but I have not seen a workable answer for this... So Basically the title says it all. I've got a form in which I create a roster list on... and to save space I would like to create a pop up form to add notes to a particular day...
  3. M

    I limited Number of records in continuous form, but now can't add records

    I think John got it in one there! :)
  4. M

    Main form - popup refresh

    Me![qry_date subform].Requery Forms!frm_home![qry_date subform].Requery I've used this code a few times with success to update querys etc
  5. M

    Selecting Row On Sub Form(Cont Form) to select record on Main Form

    Thank You for that link, As the form is a 2nd subform i used the following Me.Parent.Parent!ControlName which for me would mean Me.Drawings_qry.Drawings![Drawing Number] and applied it to a ondoubleclick. But then it says method or datamember not found, do i not need to tell it to change to the...
  6. M

    Selecting Row On Sub Form(Cont Form) to select record on Main Form

    Good Morning guys and Gals, Would someone be able to help me with my problem? How do I go about selecting a record on a subform to then show the record on the main form? I've had a look through the forums, but i've not seen anything that would help me (that i know of!) I've attached a jpeg to...
  7. M

    MkDir With Multiple SubDirs

    I've litterally this second just sorted it, I've had to use: MkDir "\\Gimli\dofiles\CO Drawings\ABC\Drawings Issued\LW\" & [Drawing Number].Text & "\" & "Current Issue" Thankyou for your reply, i'm sure this won't be my last question!
  8. M

    MkDir With Multiple SubDirs

    Hello, Thankyou for your response, I did try the following MkDir "\\Gimli\dofiles\CO Drawings\ABC\Drawings Issued\LW\" & [Drawing Number].Text\"Awaiting Checking" But nothing happened, it just added the original folder with no awaiting checking folder Cheers
  9. M

    MkDir With Multiple SubDirs

    Good Afternoon, What is the code to make multiple sub Directories? I currently have the following, which works no probs Private Sub Command70_Click() [Drawing Number].SetFocus If Len(Dir("\\Gimli\dofiles\CO Drawings\ABC\Drawings Issued\LW\" & [Drawing Number].Text, vbDirectory)) = 0 Then...
  10. M

    Dublicating Parent and Relating Forms

    Good Afternoon, I've solved the problem now, so thankyou for your time!
  11. M

    Dublicating Parent and Relating Forms

    Good Morning, Here is the code i've used for my button: Private Sub btnDuplicate___Click() Dim dbs As DAO.Database, Rst As DAO.Recordset Dim F As Form ' Return Database variable pointing to current database. Set dbs = CurrentDb Set Rst = Me.RecordsetClone On Error GoTo Err_btnDuplicate_Click '...
  12. M

    Dublicating Parent and Relating Forms

    Good Afternoon, I'm currently undertaking a database and I've finally got to point of needed assitance! I basically need to dublicate a Record on a form (Which I can do) but the bit i can't do is to dublicate a child form that links to this form. Here is my database layout I have...
Back
Top Bottom