Recent content by IANGRAND

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

How?

I run the query through a form, the user inputs a key word, in this instance part of their address. Then running the query searched an address database and brings all relevant addresses into a list box, but then the results also appear in the pop up table for the select query. It is this that...

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

RowSource property: SELECT [Find UPRN].EpochDescription, [Find UPRN].LandDesc FROM [Find UPRN]; SQL: SELECT AQMA_ADDRESS_DATA.UPRN, AQMA_ADDRESS_DATA.ADDRESS FROM AQMA_ADDRESS_DATA WHERE (((AQMA_ADDRESS_DATA.ADDRESS) Like "*" & [Forms]![IANS_FORM]![Text7] & "*"));

It is a select query. The query looks up a user defined word, searching through the text string. It then selects any address containing the key word. I have these results lined to a list box, so all addresses appear in a form. However, the addresses also pop up in the table produced from the...

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

Great stuff, works a treat. Cheers Ian

It's not right, Like [Forms]![Form1]![Text7] probably not using it correctly. Ian

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

How would you use this method, would it be in the sql of the query?

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