Search results for query: *

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...

How do you expect Access to know what is changed in error or what command is given in error as oppose to on purpose? However here are some general ways of error proofing data entry: 1. make any fields that automatically fill and won't change disabled with the fields enable (yes/no) property...

I have a form with a subform. The subform is based on a query. I have a combobox that lists customer names on the main form and fills in the fields on the subform based on the combo selection. This works great except the db will hold 90,000 + customer records so I need the combo to fill...

You mean I can have Outlook in the office use a .pst file instead of default mailbox, put it on the server and when Outlook opens it will find the .pst on the server? If so, then when my user takes his laptop to jabip, should it be configured to use the same .pst file on the server in the...

I have an exchange server and Outlook 2000 clients configured for "corporate/Workgroup" in the office. All my users have computers at home where Outlook is configured for "internet Only". We all create subfolders and rules to move messages around as they come in. When...

No, we will be taking all control from our sister company. We want nothing left on their server and no connection. I want to store messages in the private info store as oppose to using personal folders like we do now. Can I incorporate our .pst files into our private info store mailboxes once...