Search results

In the past I've been able to design programs at home using Access 2002, and then bring them to work via a thumb drive for general use at work. Lately at work I'm getting an error right after copying the database from the thumb drive to the workstation at my job saying, "this is a read only...

Interesting. On my way to work. Will get back to you. Thanks!

Thanks, Pete. Unfortunately I'm not looking for words per se. I'm sorting cookies - so the field I'm comparing with might be something like "owner@support.microsoft[3].txt" which is the actual cookie, and I want my query to compare an acceptable word such as *microsoft* with that string. In...

More Specific Request Thanks Rabbie... I keep going back to my Access Bible for basics. When I get time, I'll study the VBA and SQL books I picked up recently. Here's something that's really puzzling me. I was able to create a simple query for my little database using as criteria something...

I've created a rather simple Access program that I use to import an employee's cookie summary txt file. I then sort the cookies for 1) time of day, and 2) appropriateness. I found a way to create the queries - in simple design mode using criteria - but I want system administrators in other...

Thanks - it works now! Your comment helped me to realize maybe all I needed to do was delete that one field break marker - the one shown in my jpg between the time and the AM/PM designator. Once I deleted that extra marker, the time imported perfectly. Thanks again! Pilk2008

I'm able to do the import, but I can't get the time of day to show up in military format, which seems more useful when I'm wanting to filter out certain blocks of time later on. The attached jpg shows the format of the source txt file. The time is shown as 09:30 AM for instance. The attached...