Search results

This one here: http://www.experts-exchange.com/Databases/MS_Access/Q_20296802.html Or this one here: http://www.kbalertz.com/kb_194206.aspx Faster in terms of least CPU cycles required. Any suggestion/comment is welcome.

What's the least CPU-hungry way of reading a certain value from a table? Any other way better than DLookup()?

Can I make the operation time of the Do While loop shorter? Currently, on my lappy (PentiumM 1.7GHz), the loop takes 6.5 secs (average) to go through 480 records... Set fieldObject = rst.Fields(changeField) Select Case changeOperator Case "Add" If fieldObject.Type <=...

I have two tables (T1 and T2, say). I update records in T1 using recordset (ADO). Then (immediately) I do a "INSERT INTO T2 SELECT....blah" query (ADOdb.Command), basically copying the updated records from T1 to T2. However...There seems to be a delay between "After the recordset update...

Since no one can help me with my previous two issues...here's a third one, which will help me decide how I should do what it is that I want. Question: Can I have a single recordset that is both "User editable" (from datasheet) AND batch updateable (via VBA code)?

I have a disconnected Recordset in batch mode. When I update the fields (via VBA code), the recordset status returns adRecModified....as expected. Now, this recordset is also hooked up to a datasheet. When user edit the datasheet (by hand, via keyboard), change data in multiple records/row, the...

I have a recordset (Disconnected) that's opened for UpdateBatch usage. certain values of the recordset are change via VBA code (say, Field1 increment by 1 for all rows/records). The recordset is also the .recordset property of a subform (in datasheet view). After changing the values of Field1...

I have a form that has vertical and horizontal scrollbars. How do I get the x and y value of them? (i.e. to see which portion of the form the user is viewing...)

Say I have a table [tbl1] and a recordset [rst1]. The fields in both items are the same. Now, how do I copy/dump/inject (what's the correct term?) the data from the recordset into the table?

I'm trying to make a report where sometimes there'll be 2 columns, sometime will be 5 columns...or maybe 4 columns. (User select which columns they'd like to show in the report/printout). The question is, how do I make these columns all pack towards the right hand side of the page? Here's an...

Everytime after I save a query, all the layout/formatting is lost. And the next time I open a query in SQL view, it's all sqeezed together again. I don't like that. It's not easy to read. Can anyone help?

How do I get the username of the logged in user (Logged in to the Access workgroup security)? I know how to get the username of the computer/system. But how about those who log in to Access?

When I insert a record that consist of a field that is "autonumber"...how do I get back the value of that into my VBA code?

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

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?

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

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.