Search results for query: *

I querying a union query.... can this be a problem?

Thank you PH, The query works fine in Windows XP, but it displays plain text in Windows 2000. I could not figure out a way to use HyperlinkPart method inside a query. Is it something to do with the version of access I am using?

Hi, I have a SELECT query to display records matching the specified criteria. The record has a hyperlink field linking it to a pdf file. The problem is, a SELECT query displays the hyperlink as plain text. Is it possible to get an active hyperlink from a query? Any help is appreciated...

Hi, I have a question with regard to using table names as public variable and use it in the code(in the form). I have many tables with different names like JhsTbl,JieTbl... I want to use just one form to edit/add values to the above tables. Is it possible to pass the Table name as a string and...

Hi All, Is it possible to have a new ID created for each record whenever a form connected to that table is opened? Autonumber option is irreversible, the main reason behind my question Thank you. Pradh

I was able to figure it out myself. Using something like this DoCmd.RunSQL "INSERT INTO JIENEW (JIEA) VALUES (11111111)" Me![PartNumber] = DLookup("JIEPartNo", "JIENEW", "[JIEA]= 11111111")

Hi, I have one form containing fields from two tables. When I load this form I would like to create new records in Table1 and Table2, and update the key ID(autonumber) of these records to text boxes provided in the form. These ID's will then be stored in the Table 1. Any hint is appreciated...

Here is the way its arranged I have 2 Tables - "Table1", "Table2" Table1 has fields "Size", "dim" Table2 has same fields "Size" and "dim" but these are default dimension of the product. CustomOrderForm has a combobox "cmbSize" and textBox "dim" On choosing size from combobox, the default...

HI, I have a form where the controls get populated from two tables, "main-table" (all records)& "dim-table" (default dimensions of a product) based on a combobox selection. Once the form is filled with default values from table 2, the user still can change these values to create a new record in...