Search results

hi i need to update some cells on my spreadsheet through VBA, i can use the refreshall function, but i only want to refresh the query on one paticular sheet how to i reference this paticular query and refresh it? HELP! cheers

i have this code: Dim db As Database ChDir Application.DefaultFilePath a = Dir("MAG.MDB") If a = "" Then MsgBox "MAG.MDB not found" Exit Sub End If Set db = Workspaces(0).OpenDatabase(a) MsgBox "MAG.MDB is now open" ' use database here db.Close which i am using to open a database...

I have a code to automatically send e-mails to certain e-mail addresses: Private Sub cmdSendMail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("sorting") Do While Not rsEmail.EOF strEmail = rsEmail.Fields("EmailAddress").Value...

i have set up a command button to automatically send an e-mail to certain recipentents when pressed, Is there a code which will automatically do this when the user opens the database as a pose for them having to manually open the form and run the command. Cheerz for ne help.

When sending an e-mail automatically cananyone tell me WHY i cant send it to a address which comes from a specific field in my database, without the recipentents being unknow and the macro failing. I have tried to overcome this problem in vba but failed, and help as to why you cant do this, or...

I am trying to make it so that if the value that the first part of the expression is less than 1, then a message "subscription ended" comes up, however this isnt working any suggestions as to why wud be gr8! DateDiff("y",[Magazine Records]![Current Date],[Magazine Records]![Date Subscritpion...

I cant get my data to update when my table i open and i run a query, last time i got a suggestion to do with locking, ne other suggestions?

Is there any was to run a query that does update the primary key?

can u set up ur database to automatically run a query each time you add or edit a record?