Search results

Here's a strange one..... We have only 4 computers in our office. Our DB backend is SQL server and due to constant corruption of the database from multiple users, each user/computer runs its own separate copy of the mdb file. I have set up a small form in a separate database to allow me to...

I guess it really doesn't have to be external. I just thought that it would save me the trouble of opening up the computer and configuring. I will look into that. Thanks.

I'm wondering if there is an external hard drive backup system that you can set up to make simultaneous backups of data. What I mean by that is when I write a file to a particular directory, it will also be written to the backup hard drive at the same time. I don't feel the need to make daily...

I have a report that uses Chr$(183) - the bullet point symbol - to separate certain parts of text. When this report is exported to a text (.txt) file the value of this character changes to Chr$(250) which is the character "ú". Does anyone know of any solutions to this problem? Thanks

A Yes/No control can have one of 4 values (if not null). True or -1 (same thing) False or 0 (same thing) If you want it to return a 1 for yes and a 0 for no (or null): Abs(Nz(SomeField))

Strangely it stopped happening (knock on wood) as sudden as it started happening, and I didn't change a thing. My icons haven't moved in over a week now and for a while it was happening several times a day. Of course this doesn't mean that it won't happen again, especially since I jinxed...

That's understandable in extreme situations but in this case there are a few people who occasionally forget to fill in that field and they just need to be reminded that they made the mistake. Thanks

Excellent....thank you!

I know this topic has been covered over and over but I've searched and searched and can't find my answer. I did find one post with a link to a possible answer but the link was broken. My form has a required field. When a user attempts to X out of the form I have code in the Before Update...

That did come to mind but I've had Norton Anti-virus installed on this machine for the last several months with up to date virus definitions long before this started happening. I would think that Norton would pick up something like that.

This is weird.....this morning after starting up, the desktop layout was correct. Sometime between then and when the Norton anti-virus "all is working correctly" box popped up 1 minute later, the icons rearranged. Just now I opened Flash and while the program was loading, the screen flickered...

There haven't been any error messages when exiting programs, starting up or shutting down, and no errors when using Flash right before they became rearranged. Puzzling....

I don't know if it's just a fluke but the icons just rearranged themselves without even shutting down the computer. I was working with Flash and when I closed the program the desktop was rearranged just like it was this morning. It was in the right order when I opened Flash so something...

Funny, just this morning it happened again, and then I received a reply to this thread.... Actually I am the computer administrator at work and we only have 5 machines. It's a small office. I tried the layout.dll and it seems to work. Although (I assume) this will not stop the icons from...

On my work computer (Windows 2000 professional) recently the desktop icons have started rearanging every few days. Last night when I shut down the computer they were in the right place and this morning for the second time this week they have been rearranged all to the left side of the screen...

Excellent! I could have done this using VBA and recordsets but I figured there must be a way to do it with a query. Thanks for your help!

Thanks for the reply but I'm not having any luck with it. I tried SELECT ALL but it is not selecting the duplicates and the autojoin query is returning all records, and then some. I've attached a sample DB. The only 2 names that have more than one occurence on the same date are 'Mary Smith'...

I have been pulling my hair out over a query application and I'm looking for some help... For instance, I have a table with [PrimaryName], [SecondaryName] and [JobDate]. I want a query that will display if there is more than one occurrence of the same name in either name field on the same...

It has nothing to do with looks. This explanation is from MS Access help.

Not sure what you mean by "OR" all the fields together.... Basically the query will return records where the keyword entered is found in [Field1] OR [Field2] OR [Field3] OR [Field4].....etc....