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!

  • Congratulations Chriss Miller 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: *

  • Users: pat731
  • Order by date
  1. pat731

    Microsoft Macro Specification field

    Thank you for any support on this matter but I figured it out myself and if anyone ever has this problem please feel free to email me directly.
  2. pat731

    Microsoft Macro Specification field

    That is what I am trying to figure out how to look at the export spec the action arguments say Transfer type: EXPORT FIXED WIDTH Specification Name: Site Export Specification table name qryExtractSite The specification name is in the drop box...do you know where i can see that or what esle I...
  3. pat731

    Microsoft Macro Specification field

    I need to make changes to a database that a person is no longer with our company and I don't know how to add a field and change the macro to export to txt. I have to add a field to the table that is 2 digits. I updated all the queries and when I run the macro it doesn't show the field I added...
  4. pat731

    Upgrade to Access 2003 Report LOCKup

    I have recently upgraded to Access 2003 operating system XP, and since then my DATABASE I built will not let me produce new reports and save them. I am able to add to tables and make new queries but not reports. Any ideas what to do about this? thanks
  5. pat731

    ACCESS 2003 LOCKED UP

    I built a database using ACCESS 2000 with XP Operating system and recently switched to Access 2003. When I tried to change a report it wouldn't let me save the new report? Any ideas?
  6. pat731

    SAS Extensions 9.1

    Thanks Chris but it didn't work - I don't know what the issue is.
  7. pat731

    SAS Extensions 9.1

    Thank you I will try it again in the morning but I believe we tryed that but I will try again. Patty
  8. pat731

    SAS Extensions 9.1

    Wow I am sorry about the way I worded that thread. Operating system is XP SAS is 9.1 We just had the software loaded and all the old files are still on the computer but when we try to open an old file it doen't give us an extension to open, so if we try to OPEN WITH sas isn't one of the options...
  9. pat731

    SAS Extensions 9.1

    I need to know how to add the open with list for my new 9.1 Program. Can anyone point me in the right direction
  10. pat731

    Visio Database Question

    Beltic, I am trying to connect an Access datafile to Visio and when I try to use the Database wizard it stops me at the part that asks for the stencil! I am using visio 2000 and access xp if that helps.
  11. pat731

    Access Combo Box Form

    I think I found a solution to this question. Instead of using a combo box use a regular text box - and instead of using a control button to select new record I used duplicate record and it keeps the cost center and the date and all the end user has to do is key in the other fields until he wants...
  12. pat731

    Access Combo Box Form

    In answer to your questions.... First, I didn't realize that it was posted in the Office rather than ACCESS, thanks for the idea. What version are you using - XP Does your form have tabs - page tabs? NO PAGE TABS Does your form have subforms? NO SUBFORMS How did you create the data for the...
  13. pat731

    Access Combo Box Form

    I have created a form for inputting data and I created a Combo box with the cost numbers for the departments. The end user sometimes has multiply forms to input into to form for the same cost number But when he clicks on the control to ADD NEW RECORD he has to select the cost number again and...
  14. pat731

    ACCESS xp Parameter Date Report

    How can I set up a combo box in access to stay on the selected label/field until I am ready to change the label?
  15. pat731

    ACCESS xp Parameter Date Report

    Thanks Blorf but I have a month Query but now I want to make that a report based on the parameters of MONTH, YEAR.
  16. pat731

    Exporting Access to Excel into formatted xls.

    Is there a way to export a query from access directly into a formatted spreadsheet without messing it up?
  17. pat731

    ACCESS xp Parameter Date Report

    I have a database that I would like to build reports off of queries by Month, Date and Year. I tried a parameter but it didn't filter the Months. Anyone have a simple solution for me to build a Monthly report for each month? Thank you in advance
  18. pat731

    Visio Facilities Planning

    I am new to Visio and was wondering about the reserve engineering option. I have an access database with my sites numbers by building numbers and square feet per room use. Is there a way of using this database to align or set up my visio. Any help will do. Thanks
  19. pat731

    ACCESS Query ? Multiple Counts Duplicates Sum

    can I do that from my querie view or should i do it with the sql view. thanks I am still learning
  20. pat731

    ACCESS Query ? Multiple Counts Duplicates Sum

    the result i would need would be 333-33-3333 02 65 1 444-33-3333 02 71 2 I need to count the ssn by their activity code with the Highest PPE. Then sum the ppe in all activity codes; does that help

Part and Inventory Search

Back
Top