Search results

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

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

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

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

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

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

For a no. of reasons I am having a problem publishing ASP's of some Access 2003 Queries. It is probably because the underlying data is in a different DB and queried via linked tables. However I am able to publish any table that is local to the MS Access DB. So am planning on doing the...

Hello I have a Access 2003 DB that queries a Paradox DB via linked tables. The reports are easier to generate that way as the Paradox DB is a commercial product. I would like to publish the Query results on an office intranet as ASP's. This seems to be a fairly straight forward process which...

The code pasted below creates a union query for a set of tables (J000171, J000174, J000178 etc) and stores the results of the query in a table called temp. The first piece of code queries the ‘status’ field of a table rjobs for those records with a ‘status’ field of “Live”. Another field...

(This is a modified repost - which hopefully makes sense) I am using Access2003. I am trying to set up a fast method of creating a union query. I have a jobs table that stores info about jobs with a separate table for each job that pulls together info from elsewhere when a review is conducted...

I have linked tables from a Paradox database to Access 2003. The Paradox database has several hundred tables, I am interested in querying a set of them. The set of tables I am interested in are generated automatically by the database, each time certain entries are created a new table is...