Recent content by daz321

I have a access table containg a list of letter descriptions. I am linking to this table using an adodc connection, i would like the data items to appear in a drop down list box as a list rather than clicking on the adodc next button to get the next record.

I thought i had tried the single quote thing before but obviously not as it works now, thanks everyone.

I have a form that displays a letter history, basically the contents of a table, i would like to be able to search on various criteria, i am using the below code to search on letter_type but get a "No value given for one or more required parameters" error message. Private Sub...

i would like to do an append query and would like to include both data from an existing table and variable assigned in my VB code. Is this possible, as i am getting an error message saying: "Number of query values and destination fields aren't the same" my code is: Private Sub...

sorry [blush] I have created a project that combines with MS Access to create letters, using data from access and letter templates in word. I have different letter type depending on the data involved. I can run one mail merge but when i finish that, close word, and try to run a second mail...

Private Sub cmdFullRun_Click() Dim msg As String Dim Letter As String Dim Data As String Dim LetterType As String Dim AccessApp As Access.Application Dim DBPath As String Dim DropMacro As String LetterType = Left(lblLetterType.Caption, 3) DropMacro = Left(LetterType, 3) DBPath = "C:\My...

i forgot to say thank you.

i am attempting to run some sql from within VB that selects from an access table. The use selects which records they would like by entering the range of numbers into text boxes, i have used the following sql statement: Private Sub cmdPrint_Click() Dim AccessApp As Access.Application Dim DBPath...

I have a report that contains the following: "...the calculation of their weekly contribution is [FAC_ASSESSMENT] per week. Payment..." where [FAC_ASSESSMENT] is a value in a table. I have defined the column in the table as type currency, but when i view the report the value has the...

Is it possible to resize the tick box part of a check box?

Is it possible to add an column of type autonumber (rather than integer) to a table.

I have a make table query and would like to know if i can add a new field to act as a key (sequential numbers would do)?

I have created a project that combines with MS Access to create letters, using data from access and letter templates in word. I have different letter type depending on the data involved. I can run one mail merge but when i finish that, close word, and try to run a second mail merge i get an...

i have added the access object library and the error has gone, but the database isn't opening. i think the code is correct but i could (and have been) be wrong Dim AccessApp As Access.Application Dim DBPath As String DBPath = "C:\My Documents\darryl.mdb" Set AccessApp = New...

Not that i know of.