Recent content by kpalazzi

I have an Access XP database that holds 7 ot 9 different programs - each program has its own set of tables, queries, forms and reports. All of them share a payment and commission structure so those fields are the same for each table and they also share modules that update these values. After...

I have a form with many controls based on a query. The query links 3 tables and has well over 100,00 records in it. There is no parameters, I need to use the query instead of the table to get info from three tables. However, when I open the form it takes 3 minutes to load. How can I make...

Ok, when I export from Access from the table, it is correct, when I export from the report, it is incorrect. How can I make an export spec in Access to automate the export process? Kimberly Palazzi kpal29@hotmail.com

My access fields are set to Double, fixed w/ 2 decimal places. When it is exported to Excel, I am not sure how excel formats them but when I try to format them to Number, 2 decimal places, I don't get a change. I found an article in the MS Knowledge base (q214118) that gave a solution of going...

I have a large file in Access with many currency values. In Access I have these fields formatted with: number, fixed,2 decimals. When I output the report to Excel, my totals are off by anywhere from .01 to .20 cents. I think it is because Excel is rounding off my numbers. How can I prevent...

I have a report that I export to excel. It groups rows by Field1. The query the report is based on subtotals the value of each field1 group. My report looks like this field1 Value Subtotal aaa 2.00 6.00 aaa 2.00 aaa 2.00 bbb 1.00 2.00 bbb 1.00 I...

Can you give me sample code to change something that looks like this: Unit # PO Number Value 55555 aaa 75.00 54125 aaa 75.00 Total aaa 150.00 into something that looks like this Unit # PO Number Value subtotal 55555 aaa...

I agree. But this is an invoice for a VERY picky client that wants it to look eacactly as they want it, and they want blank rows inbetween the groups. Also, they want the totals to the right of the group, not the bottom, is there a way to do that, I didn't see that option in the Subtotals...

ALRIGHT!! That works great. Now, is there a way to insert a blank line in between groups of data? And maybe leave out the bolded "TOTAL FOR MJH45263" That is the PO Number under each group? Kimberly Palazzi kpal29@hotmail.com

How do I record a macro that does data sub-totals, I have never done it before? Kimberly Palazzi kpal29@hotmail.com

I import a query of information into excel. Then I have macros to do "clean Up" stuff like change heading names. I then have insert a line between groups of PO Numbers and subtotal the value of the PO Numbers. Can a Macro do this? Kimberly Palazzi kpal29@hotmail.com

ok, GREAT. Thank You. The shortcut works. However, each user can also just open Access and get to the db, or they can browse to network drive and get to the db. I know I need to take all permissions away from Admin account after I give myself all permissions, but will this do the following...

ok, do you mean I need to type 3 paths in the shortcut to the database each separated by parenthesis in the following order: msAccess.exe the database the workgroup file? Kimberly Palazzi kpal29@hotmail.com

I have an Access 2000 database that I created from my pc and saved on the network drive. I ran the security wizard and created a workgroup information file. I created the 7 user accounts I needed. Then I created shortcuts on all the users desktops, pointing to the database on the network...

You can base the form on a query. 1. First, you must create a lookup field in the joblist table to lookup customer name from the customer table. 2. Create a new query using joblist and customer table. Create the relationship (if it doesn't already exist) by clicking on the Customer field in...