Search results for query: *

I have a requirement to develop a database that has a Master form with a combo box and a detail form with a second combo box. This arrangement reflects the one to many relationship of the tables underlying the forms. I have been trying to understand the mechanics of combo boxes in making this...

I have a button on an Access2003 database that calls autodialler to make a call to the number held in the text field of a form using: Application.Run "utility.wlib_AutoDial", strPhoneNum It works well but Autodialler then presents a window (or as I see it a nag) entitled “AutoDialler” showing...

Please could anyone help modify a query for a report. Currently the query shows a list of payments due for the coming month by accessing a payments table with a parent of tblContract with a parent of tblCustomer. It shows each client, their bank (.NC field) , PaymentDue and uses the...

I have a simple query which I am using to retrieve the first record found for each post code from a customer database. It doesn’t matter which of say 5 records for a postcode is returned but it must return one and only one. I have tried using the first() function but I am either using it...

Hello. I need to return the SUM of sales between two dates and save them into a variable. I have a query that returns all the sales but I can’t see how to get it to sum them all up and return a single cell with the value of all the sales ie 5,756.34 instead of a long column of values. I have...

I have written a small routine in VBA originally using MS Word VBA but now in Access VBA. The sub( ) is triggered by a Button on a form. It Opens ‘Word’ and ‘Firefox’ copies the initial web page and pastes it into ‘Word’. It works but for one thing. Once started it runs down as far as...

Please could someone tell me if it is possible to access the value of the bound column of a combobox in a table where its columnwidth is set to 0. I need to be able to display NAME in table view for the user but I need to be able to get the ID value from a regular query. I have 2 tables The...

Hello I wonder if a Word vba expert might be able to help. I have created some template letters as word documents which contain tags which can be searched and replaced from an MS Access application. An example tag is <<T-CU-FirstName>>. When I press a letter button in Access I want to be able...

Hello. I am new to classes and have not used bookmarks much but I have use for saving a bookmark and a string to a 2D array, used as a ring buffer. I have the code working in some forms but use it so much it would easier if I could develop it into a class. The problem I face is that in the...

Is it possible to run a procedure when I open a specific document. I have tried a simple - msgbox "Hello" - in the This Document | Document_Open() but see no message box when I open the document. I would like to be able to resize and position a document when it opens and possibly start other...

Hello. I have manually added a field called 'TestField' to Outlook2003 Tasks. I would like to be able to create a task from MS Access using VB and set the value of some fields including the user defined field. The code I am using sucessfully creates the task and sets a built in field, if I...

Hello Could anyone help with what is probably a simple query showing totals by month. I have a table tblPayments which contains years of payments and includes the following fields: PaymentDue, PaymentCleared, Amount. I would like a query that when run shows a list of PaymentsCleared totalled...

Hello. I need to be able to append records from a mobile database to a main database whilst maintaining relationships. For example a salesman returns with new orders contained in a master(tblClient)/detail (tblContract) relationship. The tables are exactly as in the main database with both...

Hello Could anyone help with changing the ‘display control’ of a yes/no field in a table. The problem I face is that I have created a table using a query run from a module. One of the field types is a yes/no. On opening the table the values displayed are 0 or -1. I want it to show a...

Hello I wonder if anyone could help with a sort of reverse lookup query where I am starting with a complete string and need to find a row containing a sub string of it in another table. The first table contains 4 fields from a monthly bank statement (tblBankStatement): Date, Transaction Type...