Search results

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

Hello I have a form with 2 subforms set as Datasheet View and several text box controls. The Text Box controls were displaying information from a Query based on DCount calculations. There are around 9 controls each with a DCount Datasource with the exception of the first control which Dcounts...

user-defined function error that worked fine thanks Pat. I set the column names as suggested. The Crosstab queries a set of results generated with another query. The field in the underlying query that is used to generate column headings for the crosstab is [NType]. One of the values in...

I have a form with 2 subforms each based on a separate Cross Tab Query. There are no related records on the main form. I will be refreshing the form every few minutes so need to update the queries. What is the cleanest method of updating those two crosstab queries simultaneously ? Also...

My form is based on the following information.. qryNew Status, ObjectID, Name, Surname, Title, Filename The query selects records from a table Linked to an external DB with a status of 'new'. The 'filename' field indicates the location of a MS Word Doc which is opened, currently when a...

The active X browser control works well for something I am currently trying to do. I would like, if possible, to open the word file in the browser - but at 75% of the actual size. This will allow me to see the entire width of the document without having to scroll. Does anyone know how to...