Recent content by ALANBELL1

Hi, Can anyone tell me how to automate (via a button in excel) a data transfer to the AS400 from excel. I have created a .DTT file which I can use manually via the 'excel data tool ......Transfer data to AS400' but I want to run this automatically when a user clicks a button. Any help would...

Thanks for your reply Don, but what I am doing is filling the combo box with week no's and dates then depending on the current date putting a default value in the combo box.My code is something like this: intc = Me!Cmbwk1.ListCount For inti = 0 To intc - 1 If datyrwk = Me!Cmbwk1.Column(1, inti)...

In Access 97 to put a default value in a combo box I code the following: Me!Cmb1.DefaultValue = Me!Cmb1.ItemData(0) and this works fine. However when converting this database to Access 2000 this no longer works and I cannot get a default value in unless I hard code one in.This is not appropiate...

Lorenzoaj, You can certainly play a wave sound in Access by inserting a wave sound object in your form.Suppose your wave sound object was called snd1, to play the sound you would code Me!snd1.Action = acOLEActivate. Hope this helps. Regards, Alan

Can anyone tell me how to format an axis title in an Access 97 chart via VB code. For example I want to change 'Quantity' to 'Value' dynamically.I cant seem to find any help on this.Thanks in advance. Alan