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

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

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

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

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

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

Help, My company has had our e-mail hosted by our sister-company. They ran the exchange server and hosted our DNS services. Now I am bringing up our own Exchange server in our office. Since Outlook is already installed on our PC's do I need to reinstall it? If not what changes do I need to...

I have an Access database with forms saved as web pages.  I have an intranet.  I saved these forms in Frontpage and use hyperlinks from my intranet to access forms.  I use a workgroup file with my database.  This worked fine for a while.  Today I...

When I go into a user account from User Manager for Domains, and go to Profiles, I try to put in a home directory path so the client connects to that path every time they log on.  I put the correct path in but when the client boots up or logs on it never automatically maps the...

I have created a subdirectory in the root directory of my IIS server.&nbsp;&nbsp;I am trying to publish a web site from frontpage 2000 to this subdirectory.&nbsp;&nbsp;I can publish to the root directory but not to subdirectory on a remote IIS server.&nbsp;&nbsp;Why??<br><br>Thanks,<br><br>Kim

I have an Access database with forms saved as web pages.&nbsp;&nbsp;I have an intranet.&nbsp;&nbsp;I saved these forms in Frontpage and use hyperlinks from my intranet to access forms.&nbsp;&nbsp;I use a workgroup file with my database.&nbsp;&nbsp;This worked fine for a while.&nbsp;&nbsp;Today I...

Whenever I look in the event viewer of my PDC, in system view there are dozens of these events:<br><br>Web Proxy Server = source<br>125 - event ID<br><br>&quot; The web proxy service has received 5 requests from the internet port during the past 300 seconds while internet publishing was...

Hi,<br><br>I have an NT 4.0 Sever and Windows 98 clients. Can I automatically create a home directory with win 98 clients?&nbsp;&nbsp;If not, how can I configure a mapped network drive to be the default &quot;save in&quot; and &quot;save as&quot; drive in win 98? is this possible?

I have a machine which I have installed Win2K Prof.&nbsp;&nbsp;I need to edit the bios.&nbsp;&nbsp;I cannot figure out how to make a boot disk so I can do this.&nbsp;&nbsp;(not setup disks, BOOT disk).&nbsp;&nbsp;Please help!!

I have a NT 4.0 server which is also my DHCP server and Proxy Server.&nbsp;&nbsp;One of my client wants to connect to a another Wan using Virtual Private Networking.&nbsp;&nbsp;I am being told the VPN will not work with Proxy on a network because you need a direct link to an ISP.&nbsp;&nbsp;Is...

I have a database with multiple forms.&nbsp;&nbsp;I need to track data changes to the fields in each form. I would like to be able to copy each form and call it form.history.&nbsp;&nbsp;Then use the before update procedure on the form to copy the record to another table or form before the...