Search results for query: *

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 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...

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 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 am trying to open access from VB, as i need to run some queries/macros to manipulate the data before i use it within VB. I am using the following code to test open the database. Private Sub Form_Load() Dim LetterType As String Dim AccessApp As Access.Application Dim DBPath As String DBPath...

i am creating an access application, using data from an oracle database, the application produces letters containing financial information (incomes/pensions etc) for that years agreement. The users would like to select the year for the agreement, but the date when each income was created (added...