Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kpalazzi

    ACCESS CRASHES-DB now seems corrupt!

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

    query takes too long to load

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

    Prevent rounding #'s In Excel

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

    Prevent rounding #'s In Excel

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

    Prevent rounding #'s In Excel

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

    I have a report that I export to ex

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

    need macro to group in excel

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

    need macro to group in excel

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

    need macro to group in excel

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

    need macro to group in excel

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

    need macro to group in excel

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

    System.mdw file on network server

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

    System.mdw file on network server

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

    System.mdw file on network server

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

    Creating forms based on two tables, and partial populating with query

    ...customerid field of customer table. 3. Include in the query the joblist fields and the fields from the customer table that you want to prefill. **You don't need the customer name since it is already included in the joblist table. 4. Base your form on this query, and when you choose the...
  16. kpalazzi

    [color red]DOCMD.GOTORECORD updates current data....

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

    fill a combo based on first 3 characters entered

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

    Access Outlook subfolders from internet only connection

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

    Access Outlook subfolders from internet only connection

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

    Hosting our own Exchange Server

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

Part and Inventory Search

Back
Top