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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by slaga9

  1. slaga9

    export query results to excel

    thanks for the response ED2020. I have decided to take this project in a different route. I have now given each site a separate query and separate export function. The first site opens the excel template, and exports the data. I want the 2-5 query's to export the data to the open excel files...
  2. slaga9

    excel export VBA

    thank you for the response as well as the direction for later posts. I have decided on taking this project a different route, however I have another question for you. I have broken down each site into its own query. and given each query an export command button. the very first option opens...
  3. slaga9

    export query results to excel

    I am trying to move the results of a parameter query to a formatted excel file. I use 2 command buttons on a form, the first to run the query (works) the second to export the data to excel (driving me insane) I am having problems having the information go to different work pages based on some...
  4. slaga9

    data to different worksheets based on criteria

    thanks for the reply. However, I really need to the data to go to different sheets on the click. If I were around I would use your recommendation, however I am returning to school in a few weeks and I know that based on the people who will take over generating the recovery report, it would not...
  5. slaga9

    data to different worksheets based on criteria

    I am using access to export a parameter query into excel. Upon the arrival of the data on the first workbook, I was wondering if it were possible to have the data duplicated onto other worksheets based on some criteria (location). example...all of the entries on the DB have a location. In...
  6. slaga9

    excel export VBA

    I should also mention that upon hitting the export to excel command, the excel file does open. just no data gets passed...I'm assuming my problem is in identifying the record set? and by that i mean I really dont know also...sorry about the lack of TGML on that last post!
  7. slaga9

    excel export VBA

    I am trying to move the results of a parameter query to a formatted excel file. I use 2 command buttons on a form, the first to run the query (works) the second to export the data to excel (driving me insane) I am having problems having the information go to different work pages based on some...
  8. slaga9

    Protect Data in Form View

    thanks alot! thats exactly what I am trying to do!
  9. slaga9

    Protect Data in Form View

    Is it possible to protect the data on the form level without installing user level security? If data must be deleted I would like the only way for it to be possible is to go to the table in datasheet view and remove it there. The reason for this is that I am having trouble with users...
  10. slaga9

    Help with a formula

    thanks! this should take care of it! SL
  11. slaga9

    Help with a formula

    Iv recently run into a problem with the database I have been creating. It stems from two user-entered fields, hours paid, and hours worked. The user enters information at weekend (employee, job number, hours worked, hours paid, pay period end) the information then gets exported into excel I...
  12. slaga9

    export data to multple work pages

    Hi VRoscioli, thanks for the reply. I am not having much luck. The error msg is run time error 3061 "to few paramters" the line which is returned highlited is Set rstOutputCurrentDb.OpenRecordset(sqlString) = however I get the feeling that I am going about this the wrong way. any...
  13. slaga9

    File changes formatting when opened on other pc's

    My file is used by several people on the network.However, when it is opened on a computer other then my own the formatting all changes on the forms.(pictures resize, windoes dont show all the icons, etc.) is there an option I need to select? Thanks Sean
  14. slaga9

    formatting: adding decimal places

    hey everyone, it works, in the table i changed the data type to currency, and the format to fixed, in the combo box , I changed format to fixed it works, the zeros only show up when there is a decimal, and the dollar sign doesnt show up. thanks Sean
  15. slaga9

    formatting: adding decimal places

    I have had to go back and make changes to my DB to allow databases in a field in both the table, and its form. I have tried going into design view and changing them but even with decimal selected under field size and format, but it still goes back to 28.0 when I try to enter 28.5 any suggestions?
See more

Part and Inventory Search

Back
Top