Recent content by Oreynolds

I relented to resizing all my forms sadly……

OK, I will give it a try removing the locks. To be clear we do not have multiple people editing the same quote record simultaneously. We do potentially have people viewing information records simultaneously. The main problem occurs with adjacent records. At peak times there could easily be 4...

Thanks for your reply Pat. Whilst I take your point on the potential for record locking, in my organisation accessing same records simultaneously does happen regularly. For example part of the DB is detailed information and procedures for technical systems on sites (Site Records). So DB users...

Hi! I came across this thread and wondered if you could help me and confirm in your opinion the best option for record locks. I run a DB that has approx 10-12 users simultaneously using it. I currently have record locking switch ON for 'Edited Record'. We get issues on a regular basis where...

Guys - Thanks for your help. In the end I solved the problem using @arnelgp solution. Whilst the DLookups were slow using the report recordsource I created a temp table and then used that as a recordsource for the report/DLookups and now it loads in a reasonable timeframe. Thanks

Hi, thanks. This is the SQL of one of the source queries. I have 3 of these that are then brought together in a UNI query. SELECT IIf(Month([InvoiceDate])>11,Year([InvoiceDate])+1,Year([InvoiceDate])) AS FY, "Jobs/FRAs" AS Type...

This is what the report needs to look like when formatted correctly:

Thanks for this, much appreciated. Your solution does essentially work, however when I build this into my report it takes around 10mins+ to load and format itself! I presume there are no other solutions that would be quicker?

Hi, I have a year on year report which shows three group values for each year. I would like to use conditional formatting to show if the value for each respective group has increased or decreased from the previous year. This is what my query data looks like when filtered to two years. So in...

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?