Search results

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?

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