Search results

I think I've sorted this out (at least I've got a way that works). If I use the Query Analyser to make the changes with an Alter Table statement then it seems to be OK. Adding a dummy column in the designer and then deleting it with the Query Analyser also seems to work. Seems to be a...

I've migrated an Access application to Access/SQL server using ODBC System DSNs and it's worked, however I now need to add a column to the main table. I've added the column to the data definition in the test copy of the database using the Enterprise manager and, if I open the table using the...

I think I've sorted this now, I'd just like to leave a note in case it helps anyone else. It seems that the fact that I have multiple installations of Access on my PC (I have to support Access 97, Access 2000 and Access 2003 applications in my job) caused the problem. It also seems that I will...

I've had a look at your relationship diagram and I think you need to re-structure your database. A good example of the problem is that the "Artist" table contains the same information as the "Title" table and, because you've defined relationships with both of them and the "product" table, you've...

If you've still got a copy of the original database you could try splitting the databases into back ends (containing the information) and front ends (containing the code) then linking the new front end to the old back end. There are tool for this in the AddIns if you have them installed and they...

Is the form a multiline one? If it is you have to exit from the new record before you close the form; the easiest thing being to click on another row (it doesn't matter if it's an existing one or the blank row that appears when you start creatin a new one). I've tried all sorts of things to...

Have you tried setting the permissions manually on the files after they have been copied? It's possible that the "Everyone" you've given permissions to is actually the "Everyone" relating to your PC. In that case it's a different "Everyone" from the one on the target PC (annoying but sometimes...

One thing to be careful of! If any of your users are on different LANS (Local Area Networks) you run a serious risk of corrupting the database when they all start to use it. If all the users are located on the same physical site they are, probably, on the same LAN but have a word with the people...

I have Access 2003 and the Developer Extensions which allow me to package solutions and distribute them with the toll-free run-time set. When I run my applications on the development PC with the "/runtime" switch the applications work fine but when they are installed on a PC without Access 2003...

Try this: Set up your word document as a mailmerge document specifiying the source as the database query (have a look at the help in Word if you don't know how to do that). Then insert the merge fields in the right place in the document and save the document. When you open the Word document...

Thanks Bob. The problem was that I was trying to work with the recordset from the OnClose action where I now realise it's invalid. I've put the operation in the OnClick event of a button on the form and it's fine now!! Do I feel like a dope????

I guess that the text before the colon is just that, background text. If that's the case you can use the following: msgbox " Statement ID: " & me![IDControlName] & vbcr & _ " Parent: " & me![ParentControlName] & vbcr & _ " Statement Amount: " &...

I've been using recordsets in Access 97 and Access 2000 and now I have been trying to use them in Access 2003. If I use this code (which appears to me to be correct according to the online help in Access) then Access complains at runtime that ADODB.recordset is an undefined user-defined type...