Recent content by ranfan

Hi Micahel, I wasn't sure what "post an email" meant. Do I email you directly? Anyway, we do need to keep Access for our sales data. That is where every ad from our paper is entered ( nd has been done for 9 years). The actual sales info can't come from the reps. I just need to have...

Hi Storyteller. We are a weekly newspaper 1. 9 years worth of customer and sales information is in ACCESS on network. 2. Have downloaded a trial version of ACT for reps to try before we decide to implement. I imagine they will each have a copy on their machines. But I might need access to run...

Hi Storyteller, (Excuse my lack of techical knowledge). I had created a new database with the customers table but I imported from old dbase instead of exporting into new dbase. It works your way. But I want to have the reps working the main customers table that i will be updating in Access...

I am trying to import a table from Access 2000 into ACT 6.0 (using the add-in ACT Access). I can import the sample database Northwind. But when I try one of my own I get an error message saying "Cannot access your application. The workgroup information file is missing or opened exclusively...

One more Question: The bundles are working great. But we want to limited the minimum size of the last bundle (Twentyfive_rest) to 10. So if its 9 or less it is added to the previous bundle of 25 (twentyfive_int)? Any ideas? thanks.

Thanks for all your help blom0344! Everything is working now!

Thanks, I changed the table. Also, I e-mailed you for an example.

Thanks for the quick reply. I have the first query finished. I am confused about the table config. It should have name, date, twentyfive_int and twnetyfive_rest fields, right?

I am trying to create a query that takes a customers delivery amount and break it into several records (labels) for a store. So if a store needs 120 papers and the bundle size is 25 then four labels will print out with 25 on each and one thats prints 20 (instead of one label of 120 which I can...

thanks, I'll try that!

This is a add-on question: I have a table set up this way. If a record is changed can the Date() update?

I have a table with a DATE field that is automatic, =Now(), when data is entered inot the record. Can this be updated if new data (via a form)is entered into the record? thanks.

I have a table with a DATE field that is automatic, =Now(), when data is entered inot the record. Can this be updated if new data (via a form)is entered into the record? thanks.