Search results for query: *

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

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

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

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

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

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 have the following formula in an Excel cell- =REUTER|IDN!'GBPAM3L15M=ICAP,SECOND ACTIVY 1' which returns data from a Reuters add-in, but I mistakenly typed the GBPAM3L as GBPam3L, and now whenever I try to correct it by changing the 'am' to 'AM', Excel 'helpfully' changes it back to 'am'. It...

Under the list of currencies available for formatting a cell, I can't seem to find yen. Is there an addin or something else I need to install? Thanks

When I create an emf file & import it into Illustrator, any text over 64 characters long is split. Is there any setting or option I can use to alter this / find a way around this? Thanks

I am importing a slide from Powerpoint into Illustrator 10 (PC) as an Enhanced Meta File (.emf), which works fine. The problem occurs with text boxes in the file, which contain multiple lines of text. In Illustrator, they appear as seperate lines when I ungroup the shape after importing. Even...

I have created a Toolbar with buttons which, when pressed, change the style of the selected text to styles I have defined. Is there a way to prevent users add / removing buttons, or altering the names or formatting of the styles I've created? I assume I'll need to do it via VBA? Many thanks ..Bug

My spreadsheet sources data from the US, which includes US formatted dates (mm/dd/yyyy). We have a CorrectDate function (e.g. CorrectDate (F4) ) which comes as an Addin to change this to a UK format (dd/mm/yyyy), but I want to add a button to the toolbar so that when a cell is highlighted, & the...

Hello all, I am trying to open Visio and paste a chart into it from Powerpoint, and from there saving it as a .wmf, or.emf file, all via VBA, not sure of the code though.. I tried creating a new Visio Application via- Private VS As Visio.Application -but it wasnt having any of it! Any...

I have imported a chart from Excel into Powerpoint for tweaking the axes etc., but I can't see a way of finding out what names and properties Powerpoint has for each shape, e.g. Line 6, TextBox1 etc, etc.. Is there a pop up toolbar or an equivalent that I can view these in? Thanks G

Hi all, From VB 6.0, I am tring to print my code in colour, but it keeps coming out B&W. I've done all the usual stuff, looked in print setup, printer properties, even printed a colour doc to my printer to make sure its ok. Is there a hidden option somewhere?? Thanks Much Gary

Can someone tell me what file types Illustrator 9 (MAC) accepts to work with, & what have you found to be the best ones to use that keep formatting etc, as I have a chart in Powerpoint (as a .ppt file) & want to send it for prining with other stuff in Illustrator 9? Someone said .wmf format, but...

I have a macro to insert a text bax at a specific location in my page (along the right hand side, I use it to display graphs). However, I edit lots of text to the left of them, & whenever I delete beyond the top of the page, the text box jumps back & plonks itself over the graphs on my previous...