Search results

I have a Query where 3 of the fields are linked to 3 combo boxes on a form. how can i get to kick off the query from the from. at the moment I set the values on the form the go back to the query and run it. I would like to be able to run it from the form. Sometimes not all the values in boxes...

Not sure if this proposal is allowed, if not apologies. I am fairly new to Microsoft Access and need some help with 1. Provide a template of a FORM that is linked to a query which allows user to input parameters via dropdown list boxes which is populated with data taken from the...

I have a query which i would like to convert to where when excuted it pops up a list box of all the values in the respective field for the user to select one or more to filter on. Thank you in advance Desmond

For information When an application called Oracle Discoverer is used to retrieve data from the same tables there are no problems.

I know, but I have checked all the fields they are Memo not text

I have a Query that is truncating the data it obtains from a field in a linked table. The source cell is a memo and the Make-Table Query field is also memo. I think it may be something to do with the " " it has around the data. This is the source data "The migration of Broadband...

It appears that the table in question is does not allow update/append how can I change this?

Is it better to run a Make-Table Query against some linked Oracle tables or a delete row query and then a append query. Which will be more efficient? I anticipate the process will be required to be run weekly

I have a Make-Table Query which every time I run it first deletes the existing table then recreates it. The problem I have is, I have any query which runs against the table which gets deleted. When you open the query the field references are missing. How can I get round this problem? Does...

I have a Make-Table Query via an ODBC connection to some Oracle tables. It returns 12500 records but takes approx 10 mins to run. I have been advised to convert it to an SQL Pass-Through Query which I am told will improve the performance. 1, How do I covert to SQL Pass-Through Query 2, Will...

I have created a switchboard using the switchboard manager. I now wish to add some graphics and make the form and buttons bigger Can someone advise me how to do this? Regards Des

I run a Make-table query on three Oracle Enterprise data wherehouse tables via ODBC. I am retrieving about 12500 records which amounts to approx 5.6mb; this takes about 10 mins over an 8mb broadband link. What is puzzling is when I put more parameter to restrict the rows returned it takes...

I have created quite a bit of functionality via Queries, Macros and Modules. What I like to do now is have nice user friendly interface which would be presented to the user when he opens the application. From the interface he could run macros etc. I have no idea how this can be done and if...

Can you covert a Make-Table Query back to a query or do you have to set up a new query again. thank you in advance Des

Sorry the field is a memo field does that make a difference

No just a normal text field

I have a field in a record which contains the text string "BTR Consumer E2E Template" which I do not want the query to bring back. In fact any record which contains the word "Template" any where in that fields I do not wish returned I have entered - Not Like "*Template*" in the criteria...

I have created a macro which runs fine. I now wish cut and paste the code into a module how can I view the code the macro code. thanks in advance Desmond

I have a query which queries some Oracle Enterprise Data Warehouse tables via ODBC. In a field that contains text I put a Criteria of = "BTR Consumer" and run the query. But the query brings all the data baack it does not filter the data. Nobody in the office know why. I tried = "CORE" on...