Recent content by Oreynolds

Hi, I am trying to split this long IF statment up across two lines so its not on one huge long line but it won't let me, what am I doing wrong?! Thanks If Me.Chk2Discipline = True And Me.Chk3Discipline = True And Me.Chk4Discipline = True And Me.Chk5Discipline = True And Me.Chk6Discipline =...

Hi, I have the following insert into statement: Dim RS As DAO.Recordset Set RS = CurrentDb.OpenRecordset("SELECT * FROM OrdersCheckBoxes") RS.MoveLast RS.MoveFirst Do Until RS.EOF If RS!FireCheckBox = True Then...

Hi, I have built a dynamic cross tab query to return the last 3 years of invoicing totals per customer which works fine. I intended to then use this for a report but didn't realise its not as simple as this. My dynamic crosstab query is as follows: PARAMETERS...

Hi, I have the following sub routine which loops through a number of records and outputs and saves a PDF of the report in its respective folder. I am trying to make the process more efficient by it not opening the report each time and rather have it do it in the background. The trouble is when...

Hi, I have a simple form with list box on showing data from a query that the user can filter by changing dates in two date boxes. In the query the criteria on the [SentDate] field is as follows which all works fine: Between [Forms]![frmFindQuoteRecord]![txtStartDate] And...

That’s interesting. Are you manually printing to PDF from a report print preview because mine appears in list when PDF’d in that way too. It’s when I PDF it using a VBA procedure that is doesn’t work. If you are using VBA to do it would you mind posting your code on here?

Hi, thanks for your reply. So, since the post I have been concentrating on the following: 1) Removed all lookups from fields within tables 2) Removed all indexes not necessary 3) Removed a number of historic now unused table fields and adjusted queries 4) Adjusted queries to only query exact...

Hi, In our DB a lot of our reports are PDF'd out of Access for which we use VBA functions to achieve. In some cases these PDF's are saved to a local directory for use/distribution by the user. In all the office apps if you create a document or PDF something it automatically appears in the...

Key press was used as it effectively gives you a dynamic 'search while you type' facility. It is brilliant when only a few users are logged in but as soon as the numbers increase it slows right down. I don't want to use the AfterUpdate as this requires the user to tab away from the field. I...

I have experimented with all sorts but text boxes filtering the results of the list box is definitely the best solution for our application. The screenshot below is an example of one of the search forms we use. It is very powerful and allows the user to very quickly narrow down the records. In...

Hi, unfortunately I think the wildcard is fairly essential in our application given the potential variations in search methods for certain records. Thanks

Thanks for this looks like an interesting solution which I will try

It appears from all my web searching that this is a relatively common problem (trying to use the enter key to trigger an event without effecting cursor position) and I have now solved it as follows: Private Sub txtSiteName_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then...

Hi, I have a form which shows a list of records. To help the user find the record they want I have a text box txtSiteName which the user types into. On the OnChange event of this there is the following code: Private Sub txtSiteName_Change() Me.txtSiteNameX = Me.txtSiteName.Text...

Ok thanks, yes this is something that is used potentially daily by the users