Search results

I have these 3 combo boxes filtering results into a subform. Private Sub Combo5_AfterUpdate() If Len(Nz(Combo5, "")) > 0 Then FindRFQsubform.Form.Filter = "[RFQ Title] = '" & Combo5 & "'" FindRFQsubform.Form.FilterOn = True Else FindRFQsubform.Form.Filter = "" FindRFQsubform.Form.FilterOn =...

Hi again, I have two forms. "ViewRFQ" and "Quote". On the "ViewRFQ" Form, when a user selects the RFQ Reference Number it will bring up the already created RFQ record. The user can then click a command button called "Quote" this asks whether a quote has been received and changes the status, it...

Thanks Alex, I was afraid you were going to say that. The query is part of a mail merged letter, and a big one at that (44 fields now), the filter means a letter is produced for that specific record. This query has had all sorts of problems (I have a few threads on it), creating another one...

I have a subform displaying a table of results. I have used this code to have a combo box filter down the results: Private Sub Combo5_AfterUpdate() FindRFQsubform.Form.Filter = "[RFQ Title]= '" & Combo5 & "'" FindRFQsubform.Form.FilterOn = True End Sub This works except I would like it to...

Thanks Alex, I've used the link and managed to get it working for one of the forms. The only problem is there are two forms which use this query both using the same reference number. Is there anyway to make the !Form!FormName!FieldName work for 2 forms at once? I tried an OR statement with it...

Hi, I am using a query as part of a mail merge, there are two forms that use the query, create and view, both forms use the same table. When I click the print button the query runs, and mail merges in a word document. What I need is a filter on the query which only shows the record currently...

I'll be honest, I never checked your module, it worked so I left it at that. It all seemed to work but I only had one record to use as an example, it's not until I've finished all the other forms and done a last run through to make sure everything is working as it should that I've realised there...

How do you tell the query to filter to the result you either just created or were viewing the form? Sorry for pestering, my deadline to have something that works is tomorrow 10am, I should ask for a pay rise :P

Now I feel silly. Now the database is completed I've begun testing everything. There are a couple of problems with the export to word. The code uses all results of the query and mailmerges all of them in the word document, even if I select a different record you just see the first record. Is...

I've created another form, well a copy of the form in regards to this thread. This is simply to view and amend an RFQ. It has a print button too, however even though the code is the same as it's using the same query and form data I get this error message. "Run-time error '2302': Open...

Nevermind, it's working now, I created a new form from scratch and it works. Same code, no explanation to the difference. Thanks for your help Paul.

That has now produced a different error, it's still not moving records so I'm now getting the, you're creating duplicate index's in this field error. :confused:

I am currently using this code. Private Sub Combo17_AfterUpdate() If IsNull(Me!Combo17) Then Exit Sub With Me.RecordsetClone .FindFirst "[Supplier Name] = " & Me!Combo17 If Not .NoMatch Then If Me.Dirty Then Me.Dirty = False Me.Bookmark = .Bookmark End If End With End Sub It works on another...

Removing the control source worked, there seemed to be an issue with CmbFind as it's used in another open form, just renamed the combo box and everything worked fine. Thank you.

This is the 3rd one I've tried, didn't save the other 2. Same results either way. Private Sub cmbFind_AfterUpdate() If IsNull(Me!cmbFind) Then Exit Sub With Me.RecordsetClone .FindFirst "[RFQ Reference] = " & Me!cmbFind If Not .NoMatch Then If Me.Dirty Then...

Not sure why this is happening, I have written a code to look up by the unique reference number rather than use the wizard to avoid this error happening... The field is restricted to list only so you can't actually edit the number. For ease of use you cannot scroll by record and I need to...

I have a very large query which combines fields from several tables. For some reason Access seems to not like this many fields in a query, all are required. Once too many are added some of the fields become renamed to - "tablename"."field Name". This in itself isn't a major issue as users cannot...

I am creating a database at the moment that needs to be so user friendly, that a monkey could use it. I would like to separate the Amend and Create record function into two different forms. What I mean is; 1 form to create a record - At the moment it already jumps to new record, but I would...

Hi Paul, The XLSX change worked, I've narrowed down the merge fields to be in the query, it seems when I add too many fields into it, it renames some of the columns with TableName.Column Name - It's only on these fields and changes which ones if I re-do the query. I should be able to solve...

Hi Paul, Thank you very much, everything works now exactly as it should except for: I have already manually input the mergefields from the query, yet 4 fields come up with a box saying the mergefields are invalid, I can either remove them or replace them with valid fields. The valid fields are...