Search results

  1. S

    DMax Question

    The following code is working ok. The thing is I have been asked to change the DB slightly, my question is Within the table tblVisits can the DMax check 4 other fields in the table eg CustRef1, CustRef2, 3 and 4?? So I am basically getting the DMax command to check 5 Fields instead of the...
  2. S

    Photo Storage

    Hi All I am trying to incorporate adding a photo to our Work Permit Database. When a Contractor is added we take a photo and give him a Badge. Exploring the site I have come up with a program called Dorgem which seems to do what I need, but I cannot get Access to save the photo...
  3. S

    Web cam capture onto a form

    Fanatastic, I have sent you a 'Message'
  4. S

    Web cam capture onto a form

    Hi Dennis Thanks for replying I have taken your code and tried to modify as follows Private Sub Command4_Click() On Error GoTo Err_Command4_Click Shell ("C:\Program Files\Dorgem\Dorgem.exe /m/") [FilePath] = "E:\Database Folder\Work Permit\2011 Edition\Back...
  5. S

    Web cam capture onto a form

    Hi Guys This is exactly what I am looking for. Did you ever get it sorted, Whenever a contractor is entered I need to take a photo and save the photo in a folder with the Contractors Unique ID. I can take the photo but cannot automate the save location. Can you help? Regards Gareth
  6. S

    Make Text Box Invisible

    Hi All I am trying to get a report to make either one of two text boxes invisible depending on the users input. So if txt15 is blank then visible = FALSE this should then reveal txt18 which should then have data in. I have looked through the forum and found something similar to the...
  7. S

    DMax

    Galaxiom I tried everything but that, as I thought as I was already on the form why would I have to tell it where to find the textbox again. Buy hey ho, it works So thanks again
  8. S

    DMax

    Hi People I am trying to nail some DMax code, and could do with some help I have an unbound text box called DateOfPrev, I am trying to get the code to lookup the last date that a particular client visited our site =Dmax("DateOfVisit","tblVisits","CustRef = txtCustRef") The above code...
  9. S

    DateADD

    If I put the function =wdateadd([Forms]![Frm_ContractHeader]![Daterequired],-49) as the ControlSource the correct date appears. But if i bound it to the relevant field in the table it comes up blank?
  10. S

    DateADD

    Hi Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then Me!PlannedStartDate = wdateadd([Forms]![Frm_ContractHeader]![Daterequired], -49) End If End Sub The textbox (PlannedStartdate] does contain the correct date, but still can't get this date into the table
  11. S

    Not to include Weekends

    Sorry sorted it. DOH!
  12. S

    Not to include Weekends

    Hi jzwp22 Yes, that does indeed work, many thanks. I have tried to make it go back but alas got dates from 1783. So my question what do I amend to make the Function count backwards?? Gareth
  13. S

    DateADD

    Forgot about weekends and holidays!!!! Looking through this forum adding this little parameter isn't going to be easy. Any suggestions GW
  14. S

    Date Calculation

    Hi Bob I have a similar issue but I just need text2 to feed of Text1 eg If Text 1 is 12/07/2011 Text 2 should 33 days before, but need to omit weekends and holidays. I've searched through the forum and tried various suggestions but none have worked so far, (probably my lack of vba...
  15. S

    DateADD

    Thanks for responding, I believe I may have to query it at a later date, so if the date is in a table then I have that option. You make a good point though. Thanks again
  16. S

    Not to include Weekends

    I know this topic has been extensivley written about but I could do with some guidance. I have a form with about 10 textboxes on. The first textbox gets it's date from the Release Date, less 30 days. The other textboxes get there dates from similar offsets off other textboxes cascading down...
  17. S

    DateADD

    Hi everyone. A subform has a TextBox called 'PlannedStartDate' bound to table tblCSP The main form (frm_ContractHeader) has a DateRequired Field. On the subform, if I puts it's default value as =DateAdd("d",-33,[Forms]![frm_Contractheader]![DateRequired]) then the textbox is blank. If I...
  18. S

    Lockdown a Continous Form

    John Big Booty, when I sit back and think about your reply, it's so easy! I should've been able to sort that myself. Dave, you reply however, I used elsewhere in other form, which improved the form no end. Guy, many many thanks, don't know what I'd do without you and this Website Gareth
  19. S

    Append Query

    Thanks for the response Will try it later. Gareth
  20. S

    Lockdown a Continous Form

    Thanks Both I shall try and sort it later on today. Many Thanks, once again Gareth
Back
Top Bottom