Search results

http://www.access-programmers.co.uk/forums/showthread.php?t=256295 This thread solves the issues.

http://www.access-programmers.co.uk/forums/showthread.php?t=256295 This thread solves the issues.

Hi, Thank you both for your help. I tried the Do...Loop but still no look. I found a very simple solution to my problem. Was making things way too complicated, just needed to step back from it for a while. Instead of unchecking the box as soon as the date expires I have created a report...

I have the following code where on the load of the form which contains over 100 records I want the checkboxes to be set to false if CSCS/Insurance/passport has expired. The reason for this is even though we may enter another expiry date for the furture I want the system to flag up if we haven't...

Never mind. managed to sort it. This seemed to work... Me.FormNo.Requery If [FormNo] > 0 Then Me.PPE_Issued.RowSource = "SELECT ID, Item_Name, PPEIssueID FROM QryPPEIssuedDropDown " & _ "WHERE PPEIssueID = FormNo.Value " & _ "ORDER BY...

tried adding the additional piece of coding but still not returning anything. Any other ideas?

I am trying to set up a cascading drop down box. The default value for the first drop box is 0 which means that no form has been selected. If no form has been selected I want all items of PPE to be listed from the PPE table. If any form number above 0 have been issued this relates to only...

Thank you so much. This really clearly things up and gave me another perspective to resolve my issued. In the end I used the table you produced with the numbers and just linked these numbers to the "amount issued" field in a query which produced the required number of rows. This query then...

I have read up on temporary tables but cannot seem to get an understanding on how to produce the results I want. I have tried docmd. to add new records, I have tried Do Until Loops and tried to research subreport as suggested by another user but am not getting anywhere. Any change you can...

Is there some coding to do this? I have tried several different types of coding but nothing seems to be working. Really struggling to get a resolution to this.

You can set a password to the back end using the encrypt with password feature on access. This will require uses to input a password before being able to view and tables in the backend. To ensure the front end works after applying the password you will need to relink and update locations for...

Hi, I have attached the stripped down database. The tables are usually attached to a back end but for this purpose I have copoed over the required tables. The information has been taken out and 2 records for examples have been entered. There is only one report on the database, this is the...

I have been told my problem may be able to be resolved using a query.... I have a form where we fill in information for supply of PPE to employees. Each item must be signed for on a printed report. I am encountering problems trying to create enough rows for my report detail for each...

Had a few views but no responses. Amy reason why? Is what I am trying to achieve possible? Thanks

I have a form where we fill in information for supply of PPE to employees. Each item must be signed for on a printed report. I am encountering problems trying to create enough rows in my report detail for each signature of the number of items supplied. For example, on the form I will...

Sorry if I'm being dull. Any chance you can explain using my data... The Query gives the results below: (Item name is linked to a PPE table containing Item ID, Item Name, Cost etc..) IssueID DateProvided Item_Name AmountIssued 0001 01/11/2013 Gloves (Orange) 10 0001...

Ok no problem I will give this a go today and let you know how I get on. Thank you :)

Thank you for the suggestion. Unfortunately I don't think this will help in this situation. The Print Name, Signature & Date are all unbound fields not allocated to any tables or queries. They will have no real significance in the database. This report will only be relevant for paper use so...

I have a form where we fill in information for supply of equipment to employees. Each item must be signed for on a printed report. I am encountering problems trying to create enough rows in my report detail for each signature of the items supplied. For example, on the form I will select...