Search results

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

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

Fanatastic, I have sent you a 'Message'

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

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

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

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

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

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?

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

Sorry sorted it. DOH!

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

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

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

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

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

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

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

Thanks for the response Will try it later. Gareth

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