Search results for query: *

Hey, I have a For Each loop in my code that returns every book's details, from a category, into a table. The details of the book are displayed in a table: http://www.crabback.com/brehonPress/category.aspx?id=5 I want to display the list in 2 columns on my page. Is there a way to use the for...

Hi, I've written a script on a workbook that runs on startup, imports a bunch of .bas and .frm files into the personal.xls, and then closes. The point of this is to update, over a WAN, 500+ employees Excel to contain macros and menus for the macros It works great EXCEPT for one .frm file which...

Hi Can anyone tell me if it is possible, and if so, how do I get the current value of the printtitlerows in Page setup to read into a variable in my userform? I can send a value from my userform to set the printtitlerows, but I can't seem to get the value read back into my form. [ponder] Thanks...

Hi I wonder could anyone tell me what settings (if it is possible) do I change so that an HTML format email sent from Outlook 2000 opens in the correct application eg. my document.doc opens in Word, rather than Internet Explorer? Thanks Crabback

Hi can anyone help me get my commondialog.filename to give the unc path rather than the mapped drive? Crabback

Hi I have a macro that creates an email message and sets a link to a file in the the body of the email. I want to write and additional sub that will allow the user to add other links to the body of the same message - is this possible? How would I do it? (I'm thinking there is probably a better...

hey I wonder can anyone help me. I'm trying to write a macro that allows a user to browse for a file and then inserts the file path and name as a link in an emails body. I have code in a function (but I don't think it will work) that opens an instance of Word openfile dialog, and allows user...

Hi I'm sure this is simple but... I have written a macro into Words Normal.dot and I've been asked to do a rollout of it to one Department. I know nothing about performing group policy rollouts though! Can anyone give me some pointers or send me some good links/FAQs? Thanks in advance Crabback

Hi, I am trying to open a browse window in Word. I think the code should be something like: Function BrowseFolder() As String 'This opens a browse window and collects path as return value With Application.FileDialog(msoFileDialogFolderPicker) .AllowMultiSelect = False If .Show Then...

Hi I've written a macro in word that when run copies the file name and path into a new document as hyperlinked text, and opens the document for emailing. I want to recreate the same macro in Outlook 2003. At the moment as long as I give the file and path in the code, it works fine... But I...

Hi, I'm developing an asp.net site that uses a MSSQL Server 2005 Express database for its content. My hosting company has told me I must create the database directly on their server by using their online control panel, which I have done. To create the tables I must use the Management Studio to...

Hi, I wonder can anyone help me? I have an app that uses an access database, and I've been having issues with updateable queries running on the remote server. I finally found out from the hosting company that this is because I must connect to my database using odbc dsn. I can create the dsn no...

Hi I have a web app that uses an access database. I have set the security permission for the iusr account on the database folder, subfolder and files, yet when I try to change data on the web page I get this error: Operation must use an updateable query. I don't know why this error is happening...

Hi, I am using Windows XP Pro and I have IIS 5 installed. I have a web app that uses an access database. I keep getting the 'Operation must use an updateable query' error when I test updating the database on the live site - although it works perfectly on the localhost. I know this is to do...

Hi, I have a web app that uses an access database. I keep getting the 'Operation must use an updateable query' error when I test updating the database on the live site - although it works perfectly on the localhost. I know this is to do with the permissions for my IUSR account, and that I should...

Hi all I'm looking for a bit of guidance rather than an actual solution I think... I have a number of reports written that have some very complicated calculations on them so it is impossible as far as I can see to get them into one query, and so I use dlookups on the reports for these...

I have a s2k Database that I have just inherited. In one of my views I have an aliased field that uses the calculation convert(varchar, Floor(cl_call_Logging.Time_solving / 60))... can anyone tell me what the Floor() function is? I thought it might be a user defined function but its not listed...

Hi all! My report looks at a companys risks in different currencies listed individually in rows. on each row a risk is evaluated as current risk and potential risk in local currency and then converted to euro and shown as current and potential risks in euro. The report should be viewable as a...

Hi all! I have a report built on a union query thats pulls data from 2 tables - Faculative and SpecialAcceptances. Each table has requestDate and answerDate fields, and my query works out the delay in days between the two in a calculated field called 'Delay'. The query also has a calculated...

Hi I have a union query that pulls data from two tables, I want to also create a calculated field that will insert the name of the table each record is coming from. I tried using... SELECT DISTINCT MSysObjects.Name FROM MSysObjects When I ran this as a standalone query it returns one column of...