How do I select a row from a listbox so it shows as selected. Microsoft
suggest using:

Forms(formname).Controls(controlname).ListIndex = index

but this will produce an error, as the property is read-only. Various other
combinations dont seem to work such as

myLstbx.value = index (index provided)

Unless we need to requery the listbox after to get the new value to show...

Tony

I'm using an ActiveX listview control (MSComctlLib.ListViewCtrl) on an Access
2007 form. I noticed that on records where the listview contents exceed the
height of the control, the vertical scrollbar does not appear as it should.
I tried adding the line

Me.lvwContacts.FlatScrollBar = True

to the Form_Activate event of the form, but it did not solve the problem.
If anyone has run into this problem I would be very appreciative of any
advice.

Ken

Can someone direct me to information on the VBA needed to copy values on a
form in a particular format so that I can paste them later? I appreciate any
help. Thanks

Brennan

I'm curious to find out what other folks are doing with regard to sending
bulk email out from an Access table/query.
Are they coding (vba) this themselves and sending out one email at a time
or are they extracting the data from Access and then using a 3rd party
solution to send out the emails?

Just curious,
Thank you,
Thomas Kroljic

ps - if this is posted in the wrong area, I apologize. Please let me know
which forum would be correct.

Hi all,
Is it possible to have a time field in mm/dd/yy hh:mm:ss format, and add
time to it, if the time is in an hour format? I have tried using DateAdd,
but am unsure how to do hours, minutes and seconds
For example, I have the date of 01/01/08 08:00:00 AM and I would like to add
6.92 hours to it. Would I need to calulcate the minutes and seconds from the
.92 first (55 minutes and 12 seconds) or is there a way I can add 6.92 hours
and have the end result be : 01/01/08 02:55:12 PM
Help is always appreciated, thanks!
-gary

In Acces 2003, I've designed a popup form that allows the user to specify
certain filter criteria. I do an ADO lookup based on those criteria, and if
records are found, I set the main form's "Me.Recordset" = the recordset I
found via lookup and close the popup. There is a subform in another tab,
Linked by a key value in the main bound form's associated table.

When the user attempts to change a field and clicks to post the change, the
following message is displayed:

-------------
Write Conflict

This record has been changed by another user since you started editing it.
If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will allow you to.. (etc, etc, etc)
----------------

The options provided are:

Save Record, Copy To Clipboard, Drop Changes

I had this code that worked okay in prior access versions

What do I need to cahnge to make it work in access 2003 and in 2007? See
Below:
also how do I put in a browse button so I can go find it. I have inherited
this code, and I am a beginner.

Is there a way to put a timer on it and make it do it at night when there
are no users in it?

Thank so much in advance

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim dbCodename As Variant
Dim dbdataname As Variant
Dim dbcodebak As Variant
Dim dbdatabak As Variant
dbCodename = "location of database or path to it goes here"
'dbCodename = "P:\92\database\my.mdb"
'dbdataname...

I posted here last week, and tried everyones help along with searching the
forums, but have yet to figure it out.

I have a table (MODU) with 13 columns, each a different characteristic of
offshore drilling rigs. Im trying to create a form that has 13 combo boxes,
one for each table column. I need to be able to choose any combo box, select
something, and the other 12 combos use what was chosen to filter whats in
them. Then be able to choose another random combo box, choose something, the
rest filter, and so forth through all 13 combo boxes.

I would post the codes i have thus far, but i have about 3 different
approaches, each from someone differents take on the situation.

Any help is appreciated.

I'm displaying a form containing weekly spending figures. I want to show a
cumulative spending amount on each week's line. Ideas?

I can't remember the simple test for alphanumeric in a field. I've seen it a
hundred times, but can't find it. I have a text field (it's the 'sheet name'
from an Excel spreadsheet...) that I need to verify contains only
alphanumeric characters. Quick method? (A2003)

Thanks in advance.