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 bkrike 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: Gavuk
  • Content: Threads
  • Order by date
  1. Gavuk

    Transferring data from one workbook to another workbook

    Hiya guys and girls, Does anyone know of the correct way to assist in the following: I have a master workbook which needs to import data from various other workbooks (all columns the same etc). I have got it browsing to choose the next workbook to import but am struggling on reading the rows...
  2. Gavuk

    Excel tab control "Page" heading fonts

    Hiya all, Does anyone know how to change the fonts (i.e. Arial, 10 Bold) of the text displayed on each of the "page" tabs?? Cheers Gav
  3. Gavuk

    Asp to Access connection problems.

    Hiya all, I have inherited this problem from someone else. We have asp pages that call an access database. Every 2 -3 days we have to close the web server down (asp and access db on same server - i know!). I am assumming that the problem lies with connections not being closed to the server...
  4. Gavuk

    String Comparisons

    Hiya all, Having a touch of trouble. Inporting data from excel (not important) into a temp table before committing the data to the "real" table we want to be able to do a comparison on the "Organisation Name", to see if the details already exist. The best we have come up...
  5. Gavuk

    Adding a Browse button

    Hiya all hope you had a good weekend. I have a form on which i have a list of attachments. in the following format: File name : xxxxxxx File Path : xxxxxxx I want to be able to put a browse button next to the File path txtbox and the results of the browse to be displayed in...
  6. Gavuk

    Record Selection

    Hiya all, I am trying to pass an opening argument from one form to another. for example i am passing ID 4 to another form. The problem is that the second form is a access created form showing all fields in a particular table (using access recordselection buttons on bottom left of screen)...
  7. Gavuk

    PaperSizes!!!!!

    Hiya all, Does anyone know how to set pagesizes for an abnormal size the size of the paper is 80x190 (thats in millimiteres) i know it will something like this but could anyone help? ActiveDocument.PageSetup.PaperSize = 80, 190 ActiveDocument.PageSetup.Orientation = wdOrientPortrait...
  8. Gavuk

    Date differences in SQL

    Hiya all (again!!) I have a main table with an ordered date and a actual delivery date. Im trying to query the database for all the equipment that has been ordered and not yet been delivered oras been 7 days from ordering and not been deliverd. Does anyone know the SQl for this kind of...
  9. Gavuk

    Listbox row colours

    Hiya all, Does anyone know if it is possible to change row colours within a list view (built from a SQL statement! - rowsource not good enough access 97!) i want to grey rows that have a value of deleted within a main table. Any clues or a simple NO would would help. Thanks all.
  10. Gavuk

    Desperate help needed Report from a SQL statement

    Hiya all, Sorry about this a bit desperate here!! I have got a form that fires off a SQL statement that populates a list view. Basically i need the data from the list view to be transfered onto a report how do i set the form up to dynamically take the SQL as its feed?? At the moment they...
  11. Gavuk

    Enabled and Locked txt fields

    Does anyone know how to display fields on a form that can be locked dynamically during run time without them appearing as enabled???? i.e. they are undimmed when you choose the locked (yes) option. Thank you (access 97 by the way). Cheers Gav
  12. Gavuk

    Populating an array with a recordset

    Hiya all, Can anyone tell me how i can populate an array (and set one up) to store values from a record set? Cheers
  13. Gavuk

    Check boxes

    Hiya all, Help needed. got this form (access 97!!!) I have multiple check boxes on the form that can be checked when they are checked they are suppose to turn other vales on the form to enable or disabled. The problem is they dont all appear to fall into the: chk_box click event. i have...

Part and Inventory Search

Back
Top