This is driving me mad.
I need to update my website but can't FTP at all.
I am running Windows XP Home edition with SP2, a McAfee Anti-Virus and firewall (port 21 is open), the Windows firewall is turned off, this all goes through a netgear router with a firewall on it as well.
I have another...
Hi
I am trying to automate an email process from Access. In a query I have fields such as firstname, lastname etc and an email address and a path to a spreadsheet to be added as an attachment.
I want to be able to click a button on a form (for example) and then send a personalised email...
Hi,
A simple answer would be to create an Access database with two tables set up as a one to many i.e. The issue would be the one table and the historical entries would be the many table.
Regards.
db
Thanks white605, I knew I would have to play around with the API. This is a new version of my code - again, it isn't that elegant - but it works. The user I am writing it for wants to merge around 2000 separate documents. votegop - I'd be interested to see your solution. Anyway, here's the code...
I have written some code to automate a mail merge which merges an query with a Word MM document. But I want to save each of the letters separately with a descriptive file name. This is the code I have written (thanks to a user here for part of it!). The problems I am trying to solve are (1) I...
Or you could create a query using an IIF statement which will convert your text and then base your report on that:
Method:IIf([Address2]=1,"Credit Card","Personal Cheque")
The alias for the column is Method.
This could also possibly be done by amending the control on the...
In the code you have, you are assigning an alias to the result ie the recordset will contain a field called iToStore. The field has to be assigned to a variable. This is the code I wrote that works:
Private Sub cmdCount_Click()
Dim rsStores As ADODB.Recordset
Dim strSQL As String...
Select the cell (or cells), click 'data' and 'validation', click the 'settings' tab and change the 'allow' drop down to list. In the text box type "yes, no" (without speech marks), when you enter the cell you will see a dropdown arrow.
I have written some code to automate a mail merge which merges an query with a Word MM document. But I want to save each of the letters separately with a descriptive file name. This is the code I have written (thanks to a user here for part of it!). The problems I am trying to solve are (1) I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.