Search results

Main form = frmmain Sub form = frmmainsub I have two fields on the main form [Email] & [User] that are populated using the on open event for the main form. User is based on a table and is populated by the GetUser function The subform is based on qryleaveview which uses field [Email] to...

I've looked through a few but I am looking for a way to do it exactly how I've described to make it of use Any help please?

I want to add an audit trail to my existing database. Basically when certain button are clicked I want the On Click event to add an entry into tblAudit. tblAudit contains [Request Number], [Action], [Date] [Time] [User] I want the request number to be taken from the form field of the same...

I am currently using a staff holiday database to collect holiday requests from 7 working locations. Due to very poor network speeds early on I created a table to be stored locally for each of the 7 locations to aid with speed issues, each has the primary key field [RequestNumber] which is an...

I have a frmTM which most staff use to complete Health and Safety checks, however some staff have the responsibility to oversee otherr checks on frmLTM I have a field called USER on frmTM - I want to add an iif type statement to a button so that if the contents of [USER] = "mccors" or "baylim"...

Thanks Wayne You're solution worked straight off

I have currently got a frmTM which has three subforms that contain a series of check that a manager still needs to carry out. When all checks are completed obviously the subforms are blank. I have also got three fields on the main form called [totalppe] [totalpwd] & [totalpb] - these show the...

Thank you so much for solving this one, I don't think I would have noticed that space for a long time! Interestingly I got the DCount to work immediately by removing the space and then I added a Between line into the crieria of qryppe again, and it is now working perfectly with criteria rather...

I tried running the query with no parameters and that makes no difference

I've attached the sample Dbase I am using to try and test this feature before using it anywhere else. You need to open mainform and enter the dates as From 01/10/2008 and To 31/12/2008. The qryppe takes dates from these. Maybe you can find what I am missing here, the command 6 button should...

Added your suggestion but still does the same The text box value is just typed in at the moment as the I am still building and testing it

Yes, it is showing the contents of the text box correctly Any thoughts?

The text box [Staffname] is an unbound text box, could this cause a problem as the value has not been saved or stored?

Private Sub Command6_Click() If DCount("[StaffName]", "qryppe", "[StaffName]=' " & Forms("MainForm").Staffname & "'") > 0 Then Exit Sub DoCmd.OpenForm "frmppe", acNormal End Sub I used your code but have come to a problem, no matter which name is typed into the text box on the form the frmppe...

I have got the following DCount code set up in a command button that is supposed to only allow the frmppe to open if the [Staffname] on MainForm is not present in qryppe. The code runs fine but no matter whether a name entered on the form is in the query or not the frmppe still opens...

That sounds like good advice I will probably add a message box to the effect of why its diabled (sort of) I shall give this a try

I have a Health & Safety check database. At the moment a manager enters and presented with frmmain, which contains subform frmsubmain which is a list of that managers staff based on a one to many relationship between field [TMID] in tbltm and tblstaff. I have also got a query running in the...

Thanks for your advice It would seem easy enough to set up a query to run in the background. Assuming I did this method and had a query running it would basically have an entry for a member of staff or there would be no entry at all, how would the DLookup need to be formatted to take into...

This might be tricky or easy to do I'm not sure, so here goes! I am setting a database which monitors checks carried out on staff once per quarter when managers ensure staff vehicles and equipment are checked properly. Currently I have a table of manager tblTM and one of staff tblstaff, the...

Thanks all for your assistance with this one. I have taken Missinglinq advice and adding the BeforeUpdate event into the code has solved the issue Thanks again