Recent content by Geoff Convery

I've an application which extracts to Excel then opens a mailmerge template to print documents using that information. I had it working for both Word 2000 and Word 2007 specifying different ways of opening Word depending on the version. I used Shell to open the 2000 version Shell...

Yes John, you do need the third table. If you don't have it you would need one column in the Attachments table for each type of door and you'd need to add another column to the table whenever you found that a given attachment was used on more door types than any other. This is classic example...

How about defining global variables in a module to hold the values you want to transfer? I presume that you would have a button on the first form that opens the second one and, if that's the case, you could set the global variables using VBA code under that button before you open the second...

I have an Access front end to a SQL Server db one function of which is to provide an export to Excel using a query and the OutputTo method of DoCmd. This works perfectly in my development environment (WinXP, Access2003) but, when I implement it on my clients computers on the same corporate...

I think Rabbie would be correct if each item of furniture had a unique serial number which John actually wanted to record in his database. As it's a costing database I think Gemma's right. What I would do is have a third table (tblItemUsage, say) with columns txtDoorStyle, txtFurnitureItem and...

If the database containing the main tables is on the same computer as the modules then it shouldn't make any difference. If they are on another computer on the same site then it might make a bit of difference but probably not. If they are on a computer at another site then you probably will get...

Running the SQL from another computer returned the correct name. Looking at the list of available servers, though, we have two available servers called "(local)" with the brackets, one called "\\SERVERNAME" with the backslashes and one called "local" without the brackets. What we don't have...

Hi PDXMan, Thanks for the suggestion. I tried using the Query Analyser to run your query but it wouldn't connect to the server (a bit like "There's a hole in my bucket dear Liza") The response codes were "Msg14 Level16, State1" and referred to [ODBC Server Driver] [TCP/IP Sockets] invalid...

We have a SQL Server 2000 box which supports a number of SQL Server databases. To administer these databases we have been using both the local Enterprise Manager on the server (via Terminal Services) and PC-installed copies of Enterprise Manager accessing them the server as a remote server. The...

5 seconds sounds like an awfully long time for a form to open. Are your clients working over a Wide Area Network? If they are then a) any degredation in preformance for whatever reason will be magnified and b) I think, personally, that they're in danger of the data becoming corrupted as Access...

Hi Kempes, I have the following thoughts A) It's silly but have you tried compacting and repairing a copy of the corrupt database? B) Is your live database split so that the front end contains the code and the back end contains the data C) If it is do you have an up to date backup of the front...

Two thoughts, Steve, although I've no direct experience of your sort of environment I wonder if a) You've got some sort of virus or malware infection either on the server or on the workstations, or b) There's an undetected hardware problem on the Linux server. A few years ago I had had a...

Depends how much of the memo field you need. If the first so many characters are enough have you tried defining the target Excel column specifically as a maximum size text column (I'm not too hot on Excel so I don't know what the maximum size is, but I guess 255 characters like Access). My guess...

If the tables have one-to-one relationships do you really need to have them as separate tables? There's only one record for each vehicle in each table so why not have just one large table with all the columns in it?

What you need is a "Code Signing Digital Certificate". I found out all I know about them (which is rather more than I want to know but rather less than I need to know) from the MS Knowledge base; but the articles there would strain the definition of a "Good Read" I'm afraid. It depends on what...