Recent content by diasflac

Hi JHB, so to be used as on click event or inserted within the existing code? The IIf comes up with a compile error: Expected: Case

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

The code I'm using at the moment is: Private Sub Print_Click() DoCmd.OutputTo acOutputQuery, "RFQ Query", acFormatXLS, "H:\Request for Quotation\Merge.xls" Dim oApp As Object Dim oDoc As Object Dim sTmpltName As String sTmpltName = "H:\Request for...

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

Yes it did, de-securing and removing ULA restrictions cannot be done while none of the accounts have any access. The solution will require something more hackerist it would seem. I've remade it using a back up now anyway so I don't need a solution, just wasted a day lol.

It will let me create a new user, but I cannot give any rights (I only need read access rights to copy information into an older back up) as I have no admin rights. I've tried google but there's nothing specific. All I need to do is be able to read and copy the tables to the back up which has...

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

Everything appears to be correct, I've set everything up again, including the query. Still 0 and -1

I deleted it and recreated. It was displaying yes/no up until I added the tag so it can filter the subform. I'll paste the code, is there anything in here which causes the type to change from Yes/No? Option Compare Database Option Explicit Private m_colCombos As Collection Private...

The first form which inputs into the table also displays as Yes/No, the form which filters and displays results in a subform shows as -1 and 0. I'll attach a screenshot.

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

Excellent! Thank you both, it's all working now.

In table for first form - RFQ is text and RFQ Reference number is autonumber In table for second form - RFQ is Text and RFQ reference number is text. RFQ Reference number counts up but has "FY13-" as a precursor so I can't change this to a number, I don't think anyway.

Hi, Apologies for the delay in response and thank you for your help. It all works except if there is already quote information in the table, it doesn't bring the correct record up? Here are screen shots of the errors: