Search results

I have an idea of transferring a scaled down version of an Access databse to a PDA. It currently has the usual array of tables, forms and VBA code. It doesn't need to be Access, although a familiar coding language would be nice. Does anyone have advice / experiences with db application...

Hello I'm using a dictionary object for the first time, and it's behaving rather weirdly. The aim is to add all of the records from a 2 column recordset into the dictionary: Here's the code: [SIZE="4"] There are about 9000 records in the recordset, but I get an error on the 2nd record...

Hello Accessers I am looking for your advice on how to set an ADO connection object to use the very same ODBC - Oracle connection that Access 2000 opens for tables that are linked to an Oracle database. Rather than opening a new connection - eg cnnOracle.Open etc, I would like to access the...

Hello I've just started getting the following error, triggered by the command DoCmd.Close on a form in Access2000. The error description is: 'You can't carry out this action at the present time.' Error number: 2486 I've never seen this error before, and that piece of code (on a standard...

Hello I have a text field RawName which is indexed as 'no duplicates' In some cases, my program tries to add a new record with text in RawName that is identical to an existing record, except that it has a space before the first letter. It recieves the error that this would create a duplicate...

Hi I'm having trouble with code that runs a transaction to update numerous records, one at a time in two recordsets. To increase processing speed (I hope) a transcation is used, with the updates committed after each 5000 records are processed. This system has worked for some time. The...

Hello This is a rather open ended question, looking for your expertise on how to make best use of memory and disk access. I have an access database running some very large processing jobs, for example, importing about 12 million records from a flat database to a relational system using vba...

Hello I hope that there's a nice simple answer for this: How do I use Access 2000 vba code to copy a text string to the general windows clipboard, so that it is ready to paste in another application? Assuming, for example, that the text is in a variable strClip thanks Dan

Hi My problem is that my help system in Access 2000 VBA doesn't show help for ADODB objects. The ADO objects (eg connections, recordsets) work fine, appear on the pop-up lists as I type, and appear in the object browser. They even appear in the VBA help index. Whenever I click on one to get...

Hello I'm really stuck, with a piece of code that has worked in the past, but doesn't now. It adds a record to an ADO recordset based on an SQL query which joins 2 tables. The same unique ID must end up in the primary key of both tables. The primary key of one of the tables is an AutoNumber...

Hi I have a function which returns a recordset as its output. I want to use this recordset to restrict the records displayed by a form, by either adding a filter in runtime, or editing the RecordSource property to add a WHERE clause. I know how to do this if I was working with a table. For...

Hello I've developed an Access database with lots of VBA code. I've just gotten to the stage of deploying it on users' computers running with Access Runtime. Clicking form buttons to run certain routines causes an error, and the generic error message "Execution of this application has stopped...

Hi I have a recurring problem when I add an image as a background to a form in Access 2000. The graphics file may be 100k or 200k on disk, but when added, the size of the .mdb file blows out by as much as 10Mb! As a result I gave up on it, and have a very functional, but boring looking...

Hello I have a subform which is displayed in continuous format. For this problem though, I think it would be the same if it was a form, not a subform. Depending on the value of each record, I want to display different controls. For example, a combo box to set the value of a given field...

MSOffice Developer - VBA Productivity Tools Hello I have just installed Microsoft Office 2000 Developer on my machine. Office Developer includes all the usual Office programs, as well as a range of tools and code samples to help software developers working with office. The problem I'm...

Hello A simple question today. The DoCmd.OpenForm command has 4 view options to open the form" acDesign acFormDS acNormal (default) acPreview Does anyone know what acFormDS stands for? I haven't been able to find an explanation in the online help or via the object browser. thanks Dan

Hi I'm not impressed with the printout that you get by selecting print in the Visual Basic editor in Access 2000. It prints the code with no margins at all, right up to the page edge. For Microsoft, I'm surprised that I don't even get the basic layout options that you'd find in NotePad or...

Hello all A couple of questions about DAO recordsets on which I'd love your help.. Firstly, how can I create a recordset which is based on the contents of a table but is not 'bound' to the table. I want to be able to delete records from the recordset without affecting the source table...

Hello I am developing an Access 2000 application in which forms are altered dynamically based on options chosen by the user. The CreateObject Function places checkboxes and other objects on a form, and this works fine. The key line of code is: Set ctlCheck = CreateControl(frm.Name...