Search results

Yes. The way I have done it, is to use the Package and Deployment Wizard (an add-in in Office Developer) to create an installation package to include the database itself (.mde or .mdb) as well as the Runtime files. This package can then be installed on the users computer, so that the database...

Hello Whiterower I don't have a brilliant answer, and am not sure exactly what the problem is. What I can say, is that you should not need any other products to successfully install Office 2000 Developer. You shouldn't need Visual Basic developers software (eg Visual Studio 6). You might...

Good. Sounds like I'm on the right track (more or less). The data I'm dealing with comes from numerous separate datasets which are being combined into a far more efficient relational storage format. I'm hoping that once all the data is in the format I've designed, the large scale processing...

Thanks everyone Yes Pat. I am using VBA. I used the word script loosely (and wrongly, I guess) to refer to programming code in general. And in relation to all the suggestions: a) Thanks heaps Pat for the transaction / commit suggestion. I'll give that a try. In fact, the program already...

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

Thanks GHudson Now correct me if I'm wrong, but I think that acCmdCopy is the same as the copy function on the edit menu, in that it only works where text on a control has been selected. I found a good solution from one of the old posts to this forum, which works in my case where the text to...

I should add, that the text to be placed on the clipboard is not in a form control - there is no form open while this code is running. That means that accessing the Copy menu command is not my preferred solution. cheers Dan

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

I'm still keen to find a solution to this. Can anyone let me know, is this a universal problem with Access 2000, or do most people have the ADO help working?? cheers Dan

Thanks Tim Looks like this is the problem. The ADO help file was not in its folder. I've copied it from the CD to its correct place now, and it works when you open it directly by doubleclicking on the file. However, ADO items that appear in the Access VBA help index or in the Object Browser...

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

Hi Potts I think your approach is elegant. I have a similar need to jump back and forth between forms, and might try this. Now the reason your code isn't working, I believe, is a variable scope problem. The variable frmInvisible is a local variable, which exists only within the function...

Thanks llkhoutx I'll give this a try. In the interim, I came up with a different solution. This was to open the two tables as separate recordsets, and create the new record in each concurrently. The code then updates the first recordset and retrieves the autonumber value after update so...

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

John You may have already tried this but... you could try addressing the recordset explicitly, and then using the edit and update commands before and after you assign values. Dim rst as recordset Set rst = form.recordset Then to assign values you could refer to the fields directly Eg With...

I have used the Package and Deployment Wizard that comes with Office Developer 2000. It helps you to distribute customised Office applications, such as an Access database, by doing two main things: 1) Creating an install package containing all of the software elements required to run your...

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

Problem solved Thanks very much Pat & ghudson :D It was a references problem as you both suggested, although not with DAO. And those articles were a big help Pat. cheers Dan

Thanks Pat Sounds right, as I am using DAO, which is not the Access 2000 standard. But how do I find the article you recommended? I've had a look in the MSDN library that comes with Office2000 Developer, and also briefly on MSDN.microsoft.com cheers Dan

Hi Stephanie Can you simply write code to populate the spoilage and freight fields, to execute as part of the AfterUpdate event on the Distributor field? It could be in the same subroutine, and just happen after the code for the Warehouse combo box, or as a stand alone sub that is called by...