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 Chriss Miller 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. garybug

    'Best Practice' question for forms, controls & their queries

    Ed Thanks for that, although I do like to have the querydefs so I can have a look at what's going on without having to put the form in design view. Joe Thanks, and your point makes sense about the workload. I'm sold! Regards G
  2. garybug

    'Best Practice' question for forms, controls & their queries

    I have a number of combo box controls on different forms, that in theory could use the same query. Is it better that I give them all their own query, so maintaining flexibility in case of future changes, or have them share the same query, and just change the column widths (i.e. to 0cm) as...
  3. garybug

    You do not have exclusive access to the database at this time

    First off - I had been stressing over this for ages, and can't believe it's something so innocuous as an Acrobat toolbar - but it was! Anyone know why?? Also, I didn't have to do an uninstall, I just did a 'Change' from the Add / Remove Programs entry, and removed the Access component - then did...
  4. garybug

    Have 2 parameters, want one to filter the other

    Thanks Leigh - also found this, which is useful too.. http://msdn2.microsoft.com/en-us/library/aa337426.aspx Ta much G
  5. garybug

    Have 2 parameters, want one to filter the other

    Hi all I have 2 parameters, pServer & pServerRoles. I want the drop down boxes to work so that when a user selects a Server, the other drop down box will only show the roles for that Server. Obviously I have 2 tables, where there are many server roles per server. At the moment I have 2 data...
  6. garybug

    String data type limit

    My fault... But it does raise another question! It turns out it wasn't the string, but the Collection I was using to hold the results of my search - as it will only hold 254 items(!). I'm going to look into a variable sized array or something. Thanks for replying though.. G
  7. garybug

    String data type limit

    Hi Hare Thanks, but this string is not populating a control, it's purely holding a SQL WHERE clause in VBA, which is then assigned to a LISTBOX Rowsorce rpoperty, then the listbox is requeried.
  8. garybug

    String data type limit

    Am I correct in thinking that the String data type will only hold 255 characters? I've found this as I'm trying to build a large WHERE clause in VBA, which will then serve as the Rowsource for a Listbox. According to the Access Help, it can hold up to 2 billion charcters, but web page...
  9. garybug

    Refreshing parameter default values from a combo box selection

    Dear all.. I have a combo box, where the user selects the month - this is then used as a filter parameter in my dataset query. However, I have another parameter, which is set to default value MonthSelected - 1 month. This works fine when the drop down box is used the frist time - but when the...
  10. garybug

    WORD: Set up so it is like typing on lined paper

    Ladies, ladies.. One relatively simple request generating so much heat! If it helps, I used the 'background method', and got it to work enough that I could show him the results. He was, on the whole, quite pleased. However when I explained the caveats of not using images, restricted formatting...
  11. garybug

    WORD: Set up so it is like typing on lined paper

    Fumei: Wise words indeed.. Skip: Good point, but by building a custom background I can set the 'lines' as I see fit in order to match the line spacing. I'm going down that route, so fingers crossed. If he says he doesn't like it, I'll do my best not to slap him about with my tea mug. Thanks...
  12. garybug

    WORD: Set up so it is like typing on lined paper

    One of our idiot bosses seems to think it will look good..! I can see what he's getting at, and I'm surprised there isin't something in the Options menu to facilitate this. I think I'm going to have to go down the bankground / line spacing route if all else fails. Thanks for the reply though.
  13. garybug

    WORD: Set up so it is like typing on lined paper

    Is there an easy way to do this.. Keeping underline on looks wrong, and creating a table doesn't work, since as soon as you move onto a new line it wraps the text. I though about creating & using a background and altering the line spacing to match, but that seems like way too much work! Any...
  14. garybug

    Is it possible to wrap long lines of text in a listbox?

    I.E., can a listbox entry exist on more than one line? Any clues would be appreciated! Ta much G
  15. garybug

    Importing an Outlook message body into Access

    IGNORE!! Sorted it! G [medal]
  16. garybug

    Importing an Outlook message body into Access

    I've got this working, but it doesn't import the whole message body, and stop after 665 characters. Do I need another data type instead of string? Code follows.. Ta much G.. Dim sBodyContents As String Set myolApp = CreateObject("Outlook.Application") Set myNameSpace =...
  17. garybug

    Customised "Help" text for User Defined Functions

    I have a few UDF's that take up to 6 input parameters. I would like to give my colleagues a hand in what & how they should enter the argument data. How can I create the same Help text as Excel does when a user selects a function in the Insert Function Dialogue box. E.G., selecting DATE returns...
  18. garybug

    Attaching a custom toolbar to a .xla addin for distribution

    Thanks all. I had a feeling I might need to re-create it each time. I think my other option would be to add it to a hidden workbook, but it's a bit of a cheap way of doing it! I'll go ahead & recreate /destroy it each time. Cheers..
  19. garybug

    Attaching a custom toolbar to a .xla addin for distribution

    I have written an Addin, and have created a toolbar that fires the DisplayForm function, but my problem is when I send it to a colleague, the toolbar is not available. I have tried the 'Attach' functionality, but it will only allow me to attach to a Workbook, not the addin .xla itself. I haven't...
  20. garybug

    Excel - Stopping excel 'correcting' the case of a formula variable

    I've played with all of these, but still no joy. :-(

Part and Inventory Search

Back
Top