Search results

Hi, Apologies for not replying sooner. I ended up rebuilding the necessary parts again and it all works now. Thanks all for your input.

Have deleted the colons and still get the same problem. My naming conventions have improved as I have go on with this database. (Honest!)

Will delete them and see what happens.

The text boxes for the dates are formatted as 'Medium Date' and dates selected using date picker or typed in. The report opens fine when using just the dates. There seems to be a conflict when I amended the query to use the Supplier criteria as well as the date criteria.

I have found this if this of any help; SELECT tblNCRDetails1.[Report No:], tblNCRDetails1.[Internal NCR No:], tblNCRDetails1.[Date:], tblNCRDetails1.[Supplier:], tblNCRDetails1.[Compliant Details:] FROM tblNCRDetails1 WHERE (((tblNCRDetails1.[Date:]) Between...

I didn't use SQL, I used Between [Forms]![frmSearchSupp]![txtStartDate] And [Forms]![frmSearchSupp]![txtEndDate] and [Forms]![frmSearchSupp]![txtSupplier] in the criteria fields of the query.

Hi, I am trying to open a report that lists all records from a query for a Supplier between 2 dates using a form to input the required parameters. The 3 parameters are; Start Date End Date Supplier These are on the form as unbound fields. In the query I have the following criteria; Date...

Hi CJ_London Thanks for your reply. How do you mean create a sub in the form?

I have a form where there is a Command Button to e-mail a report. What I would like to happen is that the Command Button will not function unless the Investigation and Root Cause fields on the form have had data entered into them. Command Button is named: View/Send Report First field that I...

Many thanks for your help on this.

DB now attached:rolleyes:

Hi isledogs, Appreciate you helping me out with this. I am still having problems opening the respective subform. I raise a new non-conformance by clicking on the ‘Raise A New NCR’ button on the Home Page, fill in the data and depending if it relates to an Internal or External NCR, click on...

Hi isladogs, I am having problems display just the one subform containing data. This is the code that I have used when the main form loads. Private Sub Form_Load() If DCount("*", "tblNCRDetails") = 0 Then Me.subfrm1.Visible = False Else If DCount("*", "tblNCRDetails") = 0 Then...

Hi isladogs, Please excuse my ignorance but where would I place the code? On the form containing the 2 subforms under 'On Load'?

That would defeat my original issue where every field will be on a form which would look rather messy. Is there a way to view only the subform that has data similar to only viewing a subreport that has data?

I don't want the other user to have access to editing the original data as 9 times out of 10 the non-conformance will be about them. They just need to enter data saying why it happened and whats been done about it.

The database is for recording Non-conformances (Internal & External). Depending on if the non-conformance is Internal or External depends on the information/data required. I have already set up 2 different DB's but the Boss wants them all in one with the 'KeyID' running consecutively.

That works great isladogs, many thanks. My next predicament is; Say I originally opened the main form (Form 1) then opened subform 1 and completed the fields. I then want someone else to open another form (Form 2) (from a hyperlink in a datasheet which will open the record selected) which will...

Hi, I have a table with 15 fields The first 5 fields are generic (including the KeyID) The next 5 fields relate to a particular scenario and the remaining 5 fields relate to another scenario. I have created 2 forms for the 2 different scenarios with the fist 5 fields being the same. The...

Hi, I appreciate that this thread is a few years old but it has worked great for me. I have tried to send e-mails to more then one e-mail address using this VBA code by inserting [txtReceipient1] [txtReceipient2] and so on but it is not working for me. Can someone point me in the right...