Search results for query: *

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

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

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

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

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

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

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.

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

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

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

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

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.

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

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

IGNORE!! Sorted it! G [medal]

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 =...

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

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

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

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