Search results for query: *

It's been a while since i've developed anything in access, and i've found that i have pretty much forgotten all that i knew. I have created a form with several queries, which update information viewed through a series of textboxes. These queries look up infomration held within the form. On...

When you run a select query, the results pop up in a table format. Is there a way of supressing this, so that the results don't pop up? Cheers Ian Grand

When inititating a query, i do not want the new table to appear. Is it possible to supress the table, so that the new data does not pop-up on the screen. I just want it to be discreet? Cheers Ian

I am running a query to find a user defined word within a string. Currently the code i use in the query is as follows: Like [Forms]![IANS_FORM]![Text7] & "*" However, this pulls through the text strings where the user defined word is at the start of the sentence. Is there a way to use INSTR...

I have a form where the user types in part of their address. I have the query looking up this textbox, but want it to find the addresses that contain the specific text string. What is the ocde i require to enter in the expression builder. I have tried "like", but to no avail. Cheers Ian

Does anyone have the HTML code to embedd/run an access form through a webpage? cheers Ian

I am running a query through a form, the updated information then appears in a list box within the form. How do i stop the updated table then appearing, as i am already viewing the information through the list box? Regards Ian Grand

Does anyone know if it is possible to apply a make table union query, and if so how? Cheers Ian

Is there a limit to the number of records that can be merged though a union query? Currently i have the following error occuring: "System Resource Exceeded

I have written a query that i have been using for the previous 9 months. This query simply merged 12 tables into a single tables. Each table represents a month, containing airquality data recorded for every hour of the day for that given month. The total number of records for all the table...

I have written a make table query which exports a series of addresses with an associated Easting and Northing. The idea is to link this new table to GIS using the two coordinates. However presently the easting and northings are saved as a text field, and to use them i need the new table to...

How can I make the form refresh and display the data just entered through the subform Ive already tried me.refresh but to no avail

Is it possible to set the date in a textbox when a specific query was last run. Ie i need the user to know the date that a specific table was last updated through a query. Cheers Ian

Is there a way of viewing the same record when shifting between different forms. ie if i am looking at record 2222 on form 1, then open form 2 i would like it to automatically be showing information on record 2222. Cheers Ian

Hope this makes sense. I have several forms linked via a series of command buttons. All forms refer to a central table. On the first form the user enters a UPRN (Unique Property Reference Number) and this looks at a central address database and pulls up the corresponding address. When...

I want to select a row number which is specified from a textbox. This number changes depending on the qantity of data been assessed. I have tried the following SQL but to no avail. SELECT TOP 1 * FROM [Select top [Text156] * from HOURLY_AVERAGE order by AvgOfNO2 desc]. AS T1 ORDER BY...

I am running the following SQL code, to select a row in the Table HOURLY_AVERAGE. I need to select the row relevant to the number stored in Textbox163. However the SQL code, does not work.....any ideas? SELECT TOP 1 * FROM [Select top [Text163] * from HOURLY_AVERAGE order by AvgOfNO2 desc]...

I have a Textbox (Text156) which calculates the row number that I need to find using the following code: =DLookUp("[CountOfExpr1]","COUNT_HOURLY_AVERAGE_DAYS")*0.0022 I then have a SQL query, which I am attaching to mousemove on Textbox157. This query is: select top 1 * from (Select top 19 *...

I am applying the following query, to select the row number taken from textbox 156, for the table HOURLY_AVERAGE: SELECT TOP 1 * FROM [Select top Me!Text156.Text * from HOURLY_AVERAGE order by AvgOfNO2 desc]. AS T1 ORDER BY AvgOfNO2; However, on running the code the following error is...

I have a Textbox (Text156) which calculates the row number that I need to find using the following code: =DLookUp("[CountOfExpr1]","COUNT_HOURLY_AVERAGE_DAYS")*0.0022 I then have a SQL query, which I am attaching to mousemove on Textbox157. This query is: select top 1 * from (Select top 19 *...