Recent content by cturton

Hi: Working with a bank that wants a file from us so they can import into their check reconciliation program. Got the export from the accounting program working for the info they need, but the bank guy says he needs a file structure like this: (first row is header..don't worry about what the...

Thanks for the reply Hi: OK, I understand this. I'll give it a shot. Looks like it could be the medicine for the pain:D

Hello: This is for the purchasing guy at my client's office. He has 9 vendors he wants to track their on time delivery performance. The data comes from the purchase order tables in his accounting software, to which I've linked via ODBC. So far so good. I've created a query to pull only those 9...

Thanks for the follow up Great..thanks for the tip..I'm sure this will get me headed in the right direction!

Good question Thanks..I didn't make myself clear...I am working in a table called Master Schedule..so it looks like a spreadsheet (datasheet view) to the user when they use the data entry form, but there is a table structure behind the data. Thanks for your clarification

I'm developing in Access 2002 a mdb for our hockey club that is a scheduler for teams and practice/game times. I need a query that will find the team name in multiple columns. For instance....Team Name "Rangers" can be scheduled on a date and time where they are the only team on the ice that...

Peer to Peer Network Thanks Pat. That's pretty much what I told the folks. Appreciate your prompt reply.

Is it possible to install an mdb on a shared folder via a Windows peer-to-peer setup, then install a shortcut on the desktops without Access 2000 so they can run the mdb anyway? I wouldn't think this is possible without Access installed on each desktop, but someone smarter than I set this up for...

Thanks Carol! Live long and prosper! Casey

Hi! I have a datbase that tracks equipment rental. The user can use a query to see the datasheet I built, which tells him what equipment is rented for a specific date range. The user would like to click on the date field of a row in that datasheet to highlight it, then double click to open the...