Recent content by tobypsl

Yes I have tested using a range and multiple values and it delivers as expected. It's just when I try to set parameters it doesn't work.

I tried that already but same result. I'm hard coding them because the report contains number generated from a query with a variety of WHERE clauses representing various different scenarios. The command button (with the setparameter) opens the query with the parameters set to display results...

>0 throws a syntax error Between 1 and 3 gives Compile Error: Expected end of statement 1 Or 2 Or 3 gives items with the last value only (ie. 3 or for 1 or 2 it would give items with value of 2 only)

OK, so I've come up with a work around. In the underlying Query, I prefix the values in the field with the [Statuses] parameter with a T - so T1, T2 or T3 rather than 1, 2 or 3. Then in the query, rather than just the parameter, I have Like "[Statuses]*" and then for the range I can use...

Hi I have the code below on a button on a report: Private Sub Command53_Click() DoCmd.OpenForm "frmWaitMessage" DoCmd.SetParameter "Letter-Received", True Or False DoCmd.SetParameter "1A-Received", True DoCmd.SetParameter "Statuses", 1 DoCmd.SetParameter "Qty-Identified", 2 DoCmd.OpenQuery...

Sounds good, I shall look into splitting the input thanks CL_London

More through trial and error than know how I have managed to extend Martin Green's VBA & SQL Instant Query Script to include a textbox. I have got this working in his tutorial DB (freely available in his site and attached here). I can use this text box to search keywords in Job title, using *...

OK thanks, thought that might be the case.

I have a form that uses the 'web browser control' to display pdf documents linked to records by a filepath field. I am wondering if it's possible to do keyword searches on these documents? I am guessing the answer is probably no. The newest answer I found in the forum is from 2012 - so just...

solved ! in case anyone else has a similar requirement the answer is the code below. I appreciate that this probably should have gone in a forum other than Queries. This code basically searches through the temporary table for records of a certain status (in the example bloew the status is...

Several of the commands on my switchboard are used to open forms. The forms are defaulted to open in form view however a couple of them I need in Datasheet view. I have located the select code for the switchboard command buttons (pasted below) and guess the relevant lines are: ' Open a...

Hello I have a table 'tempallreview' that is populated and refreshed using a piece of code which I have pasted at the bottom of the thread. The code is necessary to create this table as it is actually a series of seperate tables (all with identical structures) concatenated. I use Access to...

I have emptied the recordsource for each of the text boxes and used a statement like: me.textbox.value=DCount("[fieldname]", "queryname") This does not speed the calculation up but it does mean the text boxes are not empty whilst the DCount executes, thus the form can be refreshed more...

moving the row source property I read in another thread that moving the rowsource property may speed up the form. That is, moving rowsource properties to an EventProcedure. I tried this by removing the form's me.requery in the event procedure but get the following error Compile Error Method...

The BE data all lies within a different DB which is Paradox. I have linked lots of tables from there and query them in Access to create reports etc. The form is simply a means of presenting a 'live' snapshot of work in progress throughout the day. I have many many reports generated using the...