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 strongm 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: skyline666
  • Order by date
  1. skyline666

    Display list box items side by side

    Yes HarleyQuinn. There is a subform on the form, which has master/child links with Category (has them with an unbound text box which stores the categoryid for the selected category). I didn't mention this as I assumed that any change would make a difference as the links are with the unbound...
  2. skyline666

    Display list box items side by side

    HarleyQuinn, the tabs might work. Can you, on open of the form say, make a number of tabs dependent of the number of categories? So say there is 5 entries one day, when you open the form it makes the 5 tabs and populates the name with the category, and the next day theres 6 entries, so a new...
  3. skyline666

    Display list box items side by side

    I also want the users to be able to just click the category name, not have to open the combo box and click the category, thats why I wanted a list box originally. A messy way that could work is to have 5 list boxes, and set the rowsource to "select cat from table where catid = 1" on first list...
  4. skyline666

    Display list box items side by side

    Hi everyone, The 5 entries are categories from a category table. At the moment there is a next/previous category button, and the category is displayed at the top of the form. What I want is to remove the buttons and let the user click on the category name instead (with them all being listed)...
  5. skyline666

    Display list box items side by side

    Hi, Im using Access 2003. I have a list box on a form which pulls data out of another table. There are 5 values, but 1 or 2 more may be added in the future. What I would like to do is have the list box not list the 5 entries downwards, but going from left to right instead. Is this possible...
  6. skyline666

    Custom chart, add dummy row help

    Thanks Duane, i'll take a look at that tonight and over the weekend.
  7. skyline666

    Custom chart, add dummy row help

    Hi, This thread can be seen as a follow on from an earlier thread i made, but that thread was how to make the chart in question (thread703-1442834). I have two boston charts in Access 2003, with row source set to a query. What I want is to be able to have some sort of IF statement in the...
  8. skyline666

    Need to show random week numbers in a query

    Hi Terence, In response to your queries on how to upload files on here, go to this site http://www.mediafire.com/ . Simply click the browse button to find where your file is (if you have more then one file, choose a number before this, although I have ever done one at a time), click "upload...
  9. skyline666

    Trying to Open a PDF File with Hyperlink Property

    Hi nobull613, Apologies, if you are using the code I put up, you will also need this in a Module: Public Sub RunProgram(strProgram As String) Dim lRet As Long ' Execute the API call lRet = ShellExecute(0&, vbNullString, strProgram, vbNullString, vbNullString, vbNormalFocus)...
  10. skyline666

    Runtime Error 2501 on Cmd.Save

    Hi missinglinq, As this is a commonly made mistake, should this be made as a FAQ? Andrew
  11. skyline666

    Unselect item in multiselect list box

    Awesome, thanks Ken.
  12. skyline666

    Unselect item in multiselect list box

    Hi, I have two list boxes, one a single select and one a multi select. I have a button which unselects the item in the single select list box, but it wont work for the multi select list box. Here is the code I have for the button: Private Sub cmbUnselect_Click() Me.lstGrouping.value =...
  13. skyline666

    select data from 9 tables to 1 list box

    Thanks PHV, got it sorted with the Union query, here it is: SELECT Corporate3rdParty.Corporate3rdParty as ListName from Corporate3rdParty union select CorporateCommercial.CorporateCommercial as ListName from CorporateCommercial union select CorporateTechnical.CorporateTechnical as ListName...
  14. skyline666

    select data from 9 tables to 1 list box

    Hi, I have 9 tables (each with 3 columns) that are all similar to each other. Want I want to be able to do is select the data from the 9 tables (the middle column), and have them all put into one list box. So something like this: Listbox Tbl1 MidCol Tbl1 MidCol Tbl2 MidCol Tbl3 MidCol etc...
  15. skyline666

    Run time language sets - access

    Have you asked MS where to download them from? Ask them to specifically tell you where they are, or to send a link to their location. Andrew
  16. skyline666

    Trying to Open a PDF File with Hyperlink Property

    Hi, Im not sure about the settings part, but I have a button on one of my forms that opens up a word document, and it also opens a pdf file as just tested with a pdf file on my pc. Here is the code: Private Sub cmbOpenFile_Click() RunProgram "Enter path name here e.g. C:\Documents and...
  17. skyline666

    Coding of form names

    Does Forms![Vendor Information]!VendorID.SetFocus work? Also I assume there isn't a full stop after the '!' before VendorID in your code. Andrew
  18. skyline666

    Error 3134?

    Are the 50 or so fields all the fields in the table? If so you can just do SELECT * (which is select all). If not, and there are only a couple fields you dnt want to select say, then im not sure if theres a way of not selecting a field from all (for example 'select * but not field48') if you...
  19. skyline666

    Date / Time Issue

    I think TheAceMan1 was saying about preventing users from being able to open the date time properties (double clicking the time in bottom right corner, or date/time from control panel). Andrew
  20. skyline666

    Help turn select case code into a for loop

    Woohoo its working now. I made one that combines the currency and decimal, as I found that if you put in a decimal number in the currency, it doesn't give the right answer (puts in extra zeros in place of the decimal point, and decimal figures). Here it is: Function denomWork(lngField As...

Part and Inventory Search

Back
Top