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 biv343 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: slaga9
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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?
  8. slaga9

    export data to multple work pages

    I'm having issues getting exported access data to go to different excel work pages. this is what I am using on the on click property of my export function Private Sub exportcmd_Click() On Error GoTo err_Handler Const cTabTwo As Byte = 1 ' Excel object variables Dim appExcel As...
  9. slaga9

    lost password

    in a stroke of genius I managed to forget the password to a file I was working on a few months ago. I am the owner of the document, is there anyway of retrieving the password? thanks Sean
  10. slaga9

    Export a Query

    I have a parameter query where the user can select the filters to each field through combo boxes. I need to be able to send the results of the query to a template I have in excel. I have been messing around with some code I have found online, but so far I am only able to export results of...
  11. slaga9

    wildcard dates

    I have set up a parameter query. The user is able to select the criteria from a combo box and run the query. It is not limited to list so the user is able to use the wildcard property to return results from unfiltered fields. I need to be able to allow a wildcard entry into the date field...
  12. slaga9

    Wildcard

    I am trying to run a parameter query (w/ access), I am having major problems trying to insert the wildcard clause, mainly because my inexpierence with SQL. Now...my first question is, Do I need to insert a line which will permit null values? or will just putting in the wild card clause with...
  13. slaga9

    Export Query Results to Excel w/ Code

    I am trying to export the results of a query to excel. I have my current code posted below. with this...I can export the query as set up in the wizard to excel with no problems, however I want to be able to Query with parameters (ie select a date range, or specific employee) and then export...
  14. slaga9

    Excel...conditional adding

    hi everyone, I export the results of a ms access query into excel (that’s how management wants it) In excel I need to do some conditional addition; I'm not sure how to go about it. X Y Z 1 S 7 2 r 3 S 8 4 r I want to be able to Sum...
  15. slaga9

    summing data from multiple entries

    On a form I have 3 fields which I sum to get (total 1) for each entry. For each entry, I wish to be able to add the previous entries (total 1) to their own (total 1), to get (final total). does this make sence and is this possible? If so, what is the best way to go about doing it? Thank you Sean
  16. slaga9

    Summing Data from multiple entries

    On a form I have 3 fields which I sum to get (total 1) for each entry. For each entry, I wish to be able to add the previous entries (total 1) to their own (total 1), to get (final total). does this make sence and is this possible? If so, what is the best way to go about doing it? Thank you Sean
  17. slaga9

    too much information, to little room

    Once I run a parameter query and have my data ready for report form, I find that I have too many fields to fit onto one page. (which is all my boss wants to see) What I want to be able to do is arrange the fields on separate sections on one page. My Goal is this... run my query and open the...
  18. slaga9

    Change main datafile with form

    I have a main form (form a) which enters data into a main table (tbl a) then I have a parameter query which filters the data by up to 6 fields and displays it in database view. Then I have another form which displays the filtered data in its entirety (looks like the first form) Now in the...
  19. slaga9

    Join forms

    Hi- I have a database which tracks job numbers. Form 1 (Job_frm) enters data into a table (jobfile) (frmsearch) is a form that Queries by parameter to filter the jobfile so that only desired information appears. The results appear in a popup box in a datasheet type view. I wish to be able to...
  20. slaga9

    MS ACCESS- Query by form with combo box drop downs

    I am a very elementary level access user. I am trying to set up a database at work and am having some issues with Querying via a form and having it displayed on a sub form. I have started off with a large job file containing numerous fields pertaining to each job. I then took several of the...

Part and Inventory Search

Back
Top