Search results

I have a table which has a yes/no field, in the table everything displays as either Yes or No, unless you click on it to edit it, whereby No become 0 and Yes becomes -1. This isn't a big problem as users can only access forms. On the input form this is a check box, checked for Yes and unchecked...

I currently have a print button and Module to run a mail-merge through a query, of the current results on a form. When this is run, I get 3 documents open, the template, the merged document and another word document saying mail merge errors even though it works fine. At the beginning you also...

:banghead: I started using the security wizard and it quickly dawned on me that I didn't know what I was doing. So I removed what I was doing, or at least I thought it did. Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or...

I have a combobox on a form linked to a table. The format of the column in the table is Yes/No. The form which inputs into the table is also set to Yes/No. However of the form below, even though the combobox is set to Yes/No, when you open the box it displays as -1 for yes and 0 for no. How...

Everything on the database is working and the funtion, as you can see, with the help of Pr2-eugin, also works. This is just cleaning up, bug fixing and making everything run easily rather than what happens in the screen shots below. I am trying to get a database to produce a letter using fields...

:banghead: I have two forms each linked to their own table. Form 1 has 6 fields 2 of which appear in form 2. Form 2 has these 2 fields and 3 of it's own. When you go from form 1 into form 2 clicking the button I would like it to look and see if there is already a record for this in Table 2...

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

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

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

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

I haven't done anything like this for 10 years and it seems to all be forgotten: I will tell you what I have at the moment: 5 tables. Supplier (Supplier Number, Supplier Name, Currency, Payment Terms, Contact Person, Contact Number and Supplier address) Inco Terms (Inco terms, Inco terms...