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

    Can I highlight records on a form?

    Hi Henry, Thanks for that tip, I'll try and give you a bit more information now!! I would like to highlight the text boxes if through the whole of the recordset, or the result of the query, an individual paramter remains constant. Say the source of the form is a query with 20 fields coming...
  2. gavintennant

    Can I highlight records on a form?

    Hi, Can anyone tell me if it's possible to highlight records in a form? Basically, on a form, I have several text boxes set up to view the records. It would make it easier for the users of the database to see at a glance which of these changed with each recordset (or which did not change?) I...
  3. gavintennant

    Populating records in a table

    Thanks, I'll give this a go!! Much appreciated
  4. gavintennant

    Populating records in a table

    Hi, I want to populate the new table with only the headers (fields) from the exisiting tables. Basically, I have about 20 tables each with at least 40 fields in each. It is these fields I want to put in a new table (in one column) so I can select from a combo box. I would rather not have a...
  5. gavintennant

    Populating records in a table

    Hi, Can anyone tell me if the following is possible, if so, how I would go about it or any other ideas I've not thoguht of!! Okay, I have several tables and I'm trying to build a form with a combo box on it. This combo box should contain all fields from all the tables. (or a selection of so...
  6. gavintennant

    Export to excel, Multiple listbox --> multiple worksheets

    I managed to get this to work now, managed to take the original code and hack it about abit so it looked up lista and listb then created seperate worksheets on the same workbook. Clever eh, not as good as you ppl yet, but working on it!!
  7. gavintennant

    Export to excel, Multiple listbox --> multiple worksheets

    Thanks Vika, I had tried the Outputto action aswel, never seen this TransferSpreadsheet command. I'll give this a go but I don't think this has the ability to create multiple worksheets. Thanks again though!
  8. gavintennant

    Export to excel, Multiple listbox --> multiple worksheets

    Hi, I have several forms with more than one list box on them. Basically, I already have some code that can take a list box and export it to an excel spreadsheet. My problem is that I want to export these multiple list boxes into one spreadsheet with multiple worksheets. Can anyone out there...
  9. gavintennant

    Using Multiselect box for input to a query

    Hi, Can anyone help me with a problem I'm having? From a list box I'm trying to allow a user to select multiple items (multiselect) then use the selection as the input to a query. Is this possible using multiselect and does anyone have some sample code for this? thanks very much in advance Gavin

Part and Inventory Search

Back
Top