Search results

I have 2 PC's one that has Access and VB6.0 installed on it and the other which just has Access. I can use the trim function on the PC with VB6 installed, but on the PC with just Access when using VBA, Trim is not recognised. I have looked at the references added for both versions and...

Hello, I want to be able to hyperlink to a MS Word doucment, but I want the path to be built up in access. I have a database field called SDRNO, the value of this will be the document name. Using access VB can how do I build this up??? Any help would be much appreciated. Thanks Chris

How do I stop Access from accessing a new record when I forward past the last record within a form? I currently have icons set up to allow a person to move bacward and forwards through the records. I want the form to stop at the last record not move into a blank one. Help would be much...

I have created an access database comprised of link tables connecting to my DB2 database on the Iseries. This has been working fine, but recently we upgraded to Iseries Access 5.2 with service pack, which changed all the ODBC drivers. I have since deleted all the link tables and re-linked them...

I would be for ever in debt to anyone who can help me resolve this. I currently have an access database which uses link tables to our AS400 database. I have a form over the main link table which a user use to log request changes. The data will be stored on the AS400. The database file has an...

I have a database which uses linked tables. I set the linked tables up using an ODBC datasource which I configured on my pc. It is a fairly basic configuration it just allows me to link the tables to our AS400 database. The problem is, that it works fine when I run the database on my PC, but...

I have a form which has been created over a linked table. I want one of the key fields to automatically increment by 1. I cannot alter the design of the field to auto number because the table is linked. I have created a query which gets the maximum number for that field on the database...

I am currently link to my AS400 DB2 Database using a linked relationship within Access. I am unable to update any of the records though Access. It keeps saying that the recordset is not updatable. I have set my ODBC driver to read/write but this still has no effect. Can anyone...

I have created an access application which I need to distribute to a range of users. The application is linked to our AS400 database using link tables and therefore could pretty much stand on it's own. Not all our users have MS Access, and we would need to buy more licences for them to have it...

I have two combo box's. The data in each combo box is loaded by seperate querys. The are 2 seperate lists of data that i want to load into combobox two, and I want to control which list is loaded into combobox two by the value selected in combobox one. (There are only 2 values loaded into...

I have created a logging application which has several forms. Form 1 is the form first displayed on entry and acts as a menu. The menu has several command buttons each one loads a different form. One of the command buttons when clicked displays a form which allows the user to enter data onto...

I want to display a please wait message on the screen until a query or print preview has completed. I have an access form where a user selects a query using a combo box and then clicks on a command button to run the query. Some of the queries take a few minutes to run, and though an hour glass...

I am using a DOCmd SendObect to send an e-mail. I am sending it as True so that the message can be edited before sending. The command is activated when a button is clicked on the form. When you first load the form the command executes fine. It continues to do so no matter how many times you...

I am trying to retrieve the contents of a field in a table into a text field which I have defined in VB. The problem I am having is actually doing this! I know a little about recordsets but could do with an example of seting a record set and retrieveing a specific field from a table. Unless...

I currently am developing a database to handle out IT Support Queries. As part of this I am creating an enquiry screen which will display the details of a query selected by whoever. Anyway i have created a form with a combo box (when droped down displays all the available query id's) this is...