Search results for query: *

Well, how do they say: "The only constant thing is change..." I have a couple of databases on our LAN, all the users has (had) a copy of MS Access on their various pc's. Our old IT company is new something of the past and so is everyone's office licences. Only a lucky few will have this...

I had a similar problem once, only I didn't intend to delete that file(don't think you can or are supposed to). I wanted to work on some tables but coudn't access it. As far as I understand, that file indicates that someone (who could be anyone) is logged in to the database. Is this database...

Yeah, thanks, and your's takes less time AND space...

Thanx Chaz! Didn't know about that one. I suppose I can get along without the help of vbscript afterall! I have, in the meantime, found another alternative as well - just for info, but pleeze help me right if the following is wrong (it works in practise though) : dim flsysobj, thefile,thesize...

See the search facility is not working!? I want to run a procedure that is dependent on the evaluation of two files' sizes. As the one grow it's larger size will be used as condition to update the second file. This I need to build in an Access procedure but I don't know vbscript that well. My...

Thanx AvGuy, seen in hindsight it makes more sense to take your advice and Import rather than Link. Even though it is the same table (with a couple of new records) one would repeat this procedure when needed. The records are "imported" to the second table one-by-one anyway, so if this procedure...

Ja, fanx Mike! I know, but hey, I am from a 3rd world country, so we have to be satisfied with the crumbs on the floor. Not that I am reflecting my problem on you but how would you feel like paying almost $5000 for one software license for the latest MS Office pro package? Well, in my country...

I am using an Access 97 Database that contains a link to an HTML table. I have no control over this table because it is generated and updated automaticaly from other software. My database is based on the info from this HTML table which is compared to a second resident table. New records are...

Thanks Ya ALL! I haven't tried out all the suggested option yet, but I couldn't find anything saying "missing" and checking/unchecking didn't work in my case. I then did as Hap007 suggested, I imported the frontend to the sick PC and that immediatly remedied the problem. Although I cannot find...

No suggestions yet?...Well, I have explored other avenues and have decided to rather work in 3 phases. Phase 1 - limit the amount of faxes in the desktop/user interface to 10 or less. Phase 2 - run a "compare unmatched query" on a second table that resides in my database with the HTML table...

One of the PC's in our LAN using my database wouldn't run the VB code that contains the above functions. We run Office 97 in a Win 98 environment... Which libraries contain these functions and where should I be looking for the problem. I compared the library references on my own pc with those...

Hi, I am working on a database to manage, and make incoming faxes available on a network server. The faxes come in on a fax machine on a standard landline. It also has a network adapter that sends these faxes as .tif images to an e-mail address. Or so I think it works. Then there is what I will...

Thanks JGillespie! That is a quick solution. I think(hope) that the average user wouldn't figure that out, maybe I'm a bit too paranoid...

[dragon]Once upon a time I tried to use a custom toolbar to enforce some extra security in a database. You know what I mean that there is some places you just don't WANT users to be going to. In my nervous outbreak I took out some options in the start menu as well and ended up locking myself out...

Thank You Roy-Vidar! To be honest: I took this long because it took me THAT long to completely process and file the last posting you sent me. This was worsened by the fact that the saved Access query still complained about an "undefined function". Well, my (and your's thankfully)...

Thanks Roy-V! I have tried it. The function seems to work just fine but I don't know why I get this runtime error: "Undefined function in Expression" Maybe I am missing a step somewhere? I have written a seperate module with the following: Option Compare Database Public MyValue As...

I have two different databases with tables that have similarities. The first database has a table with "temporary" information. The second database is used for "formal" information. It is in a invironment where you would typicaly have a customer enquiry, you would therefor...

Thank you MinusM! To be honest I wasn't even aware of the existence of a "left join query" Your suggestion seems to be working just fine. I haven't got that far studying my SQL for Dummies handbook that far yet so I do apologise. It is a bit tough to have a full-time (non-IT) career...

I have this rather sizy (+- 100 000 records) table for products. I need to update this table frequently by downloading a text file. Now I import the text file with the help of a standard import specification and macro - Easy so far. Now I have two tables : The old one that I use and that needs...

Thanks Quehay - I will do just that!