Search results

I just meant to populate the control so that I could select an individual record. Maybe I am trying to do too much here but I just wanted to ensure that the control only showed those tools which were in the selected location, rather than all the tools in the tools table. I got rid of the...

Here is the zipped database. Thanks for your patience

Sorry, my database seems to exceed the limit for attachments even when I zip it. I will try to get a shrunken copy

I will send you on one shortly. Thanks for your interest

I have a tools stores database and am working on a form to issue tools from one location to another. I have set up combo boxes for: from_location to_location tools_id the tools_id combo box is based on a query which searches a tools_in_stock table for all the tools which are available in...

Had a look at the bugs on the link you mentioned and my problem isn't amongst them. Back to the drawing board. When I look at the references in the Code View, I see MS Graph 11 Object Library ticked. Is this the correct?

I don't think so. On the Help on MS Access it says Office 2003 SP2. I will have a look at the link anyway. Thanks.

I have an Access 2003 report which has a graph on it. It worked fine for a long time. Recently it has been displaying a message "Windows installer preparing to install" and "Installing Microsoft Graph Feature" and this takes about a minute to go through whatever it does. I was wondering if...

I have developed a small application in Access 2003 which I wish to distribute to some friends who have Access 2000. I have tried using the packaging wizard for 2003, and put the packaged version on a CD and installed it on their PC's. I can then go into the application on their machines but...

Thanks very much. I will "bind" it immediately

I have a table in tabular form on a form. The table has a field PrintBill which is a checkbox. When I click on this field in one row of the table all the other rows are checked. I only want to check the rows one at a time. What am I doing wrong? below is the code I use...

The SQL worked fine as well. Muchas Gracias.

Thanks Neileg. The DCount() did the trick. I have yet to get the SQL part right. (DELETE * FROM TableName)

Thanks guys. The reason I check a table which I have just deleted is that I am trying to add records to a blank table in a loop, which, the first time round will be empty, but subsequently will definitely have records. If the key of the records is the same I just want to update. I will try the...

I am using this function (AreThereRecords) to check if there are records in a table which I have to start from scratch each time I enter a form to check whether it is empty or not. I use the function a number of times successfully on other tables and it works but on the table I am...

You were perfectly right. I used the extra quotes and it worked! Thanks very much.

ditto I have exactly the same error with exactly the same bit of code. To make matters worse, I have similar code elsewhere in my project and it works perfectly, and I cannot find a reasonable difference between the 2 sets of code, which would explain the error message. Not working code...

Thanks guys. That is just what I needed to know. It will probably be better to persevere with the packaging wizard for another while. Geoff.

Considering the difficulties in packaging Access software, I am wondering about the feasibility of converting my Access project to VB and distributing that instead. Has anyone done this and if so how difficult would it be. Does it mean a complete rewrite or can I use existing forms, reports and...

I have Access 2003 and have an mdb which I want to market. I have been testing the packaging wizard on a friend's machine. He has Access 2002. If I just copy the mdb to his machine and access it via 2002 I get an error to say that MSCOMCT2.OCX is missing. If I use the runtime version produced...