Search results

I have a form that is bounded to a table, and is set to allow addition only. When the form is open, and when user had typed data in certain fields, the record will be inserted into the table upon closing of the form. The problem is this (example): 3 fields. All are needed to have data. User...

Anyone? How come there's no reply? Is it because it's too easy/obvious and no one can bother...or no one know the answer?

In my access project, I have a few Linked Tables (to a SQL server on the network). Question 1: How do I get the connection string (via VBA coding) that each of the linked tables is using? Question 2: (If Q1 is not possible) How do I create an ADODB.Recordset from a linked table when I don't...

I've managed to get a report snapshot to send over to outlook. However, everytime it asks me if I want to allow access. I know this is a security thing implemented into Outlook but is there a programmatical way to bypass that box?

Thanks for your reply...I found that out just moments before I got your reply. Here's my new situation: Access now only serves as a frontend, the backend is a MS SQL 2000 server. My tables had been upsized and linked to the SQL server. However, how do I specify VBA code to create a temporary...

I have a command button with the onclick() action as below Dim curDB As Database Set curDB = CurrentDb curDB.Execute "CREATE TEMPORARY TABLE test10 (ID INT)" curDB.Execute "Insert into test10 (ID) values ('001')" curDB.Close The create statement gives me an error.... How do I create...

Ah....I see what you mean...thanks. (So it's quite different from PowerBuilder...)

I have a subform (datasheet view) inside a form. The subform is filled by a query based on data input by the user. From within the subform, the user will then select a particular row. How do I know what row the user had selected? Please help, I'm soooo new to Access.