Search results for query: *

Morning Just wondering if it is possible to conditionally format a rwo of cells based on one cell's contents. The cell in question would have validation set to pick from predefined list. If user picks option "A" for example. Can I turn the entire row's BG color to red...? Hoping you can...

Morning guys. I have an issue with outputting data from Access to Excel you might be able to help with. What I have done is developed a macro (so designated users can edit it) that auto outputs a query to excel. I'd like to do this on the last working day of the month. preferably without...

Guys I'm sure there's a FAQ or post about this but couldn't find one. I need to have a workbook execute (open) another (linked) workbook on the "BeforeOpen" event. I just need some help with the syntax if possible... ---------------------------- Cogito Ergo Sum [jester2]...

Hi guys I'm using the following: But guess what... It doesn't work. Do I need to reference the specific worksheet or maybe a named range also...? It's being presented in static HTML. ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------

Morning Everyone. I have a bit of a problem you might be able to help with. I am using FrontPage to prsent some database results from a database and it works OK. However, I ant the database connection to point to a database located elswhere on the network (as this will save time and effort...

Hi all I'm using MS Access and FP to display some ASP pages and wanted one of the fields to automatically open an application and a file within that application. The code I am using is this: The "ECO154017" is generated within FP using the "Hyperlink Properties" and "Parameters" options...

Hi all. I need to create a link to a named range in an excle workbook from within another application. Any suggestions...? I'd like the link to be live (people can update the workbook) but a static link would be OK. ---------------------------- Cogito Ergo Sum [jester2]...

Guys I know there's a Visio forum and I've searched both the forum and other groups in earnest to get an answer to this and hope this willl be the best place. In essence: I am trying to link and excel workbook into Visio. However, when I use the standard menu commands I get mixed results...

Morning I may be barking up the wrong tree here, or maybe even in the wrong wood altogether but here's what I would like to do: Have date Z in field b greater than date Y in field a. I assumed that the valiudation rule for field b could contain the following: But of-course, it's Access and...

Guys I know there's a Visio forum and I've searched both the forum and other groups in earnest to get an answer to this and hope this willl be the best place. In essence: I am trying to link and excel workbook into Visio. However, when I use the standard menu commands I get mixed results...

Morning everyone I've developed a form which is tied to a table and I want to use a filter on a particular field. However, the properties dialog does not appear to have an option to do this. Can it be done using VBA...? e.g. field x = Design Actionee and I only want to display records on this...

Morning all. I have a form with a command button that uses Outlook (Outlook will be the default mail application on users systems). however, it simply sends a mail. Can I have it open the mail and allow the user to edit this prior to sending...? ---------------------------- Cogito Ergo Sum...

Guys Ever come accross the following error message in VBA (MS Acces) I get this even if I copy the database locally and execute a command. Not all commands, just some. Strange. I'm actually contemplating rebuilding the code. ---------------------------- Cogito Ergo Sum [jester2]...

Morning guys. Hopefully an easy one here: I've developed a form with various text boxes and a button corresponding to each text box. I'm thinking of ways to use just one seperate form with a calendar control that populates the various text boxes. User clicks Button A, Calendar pops up, they...

Morning Everyone I have an Excel workbook and one of the worksheets gives the user a button which when pressed should display a dialog box prompting them to ensure they have correctly located their cursor. If they select Yes - it should execute the code to insert a group of pre-formatted cells...

Morning guys. Does anyone know how you can create a security certificate for your own server without having to pay one of the authorised companies...? I'm trying to test out security on a home server before rolling it out to the company and paying for it so just need to be able to activate...

Morning guys. Does anyone know how you can create a security certificate for your own server without having to pay one of the authorised companies...? I'm trying to test out security on a home server before rolling it out to the company and paying for it so just need to be able to activate...

Hi all. I've developed an ASP page that captures and Uses some ASP variables such as referrer, browser etc. How can I then store these variables in a database for example...? ---------------------------- Cogito Ergo Sum [jester2] www.discworks.co.uk ----------------------------

Morning guys I have a database that appends the current system date to a table. This table in turn sends that information to a query which in turn is sent to another query that simply returns the max value (which should be the last record). What I want to do is this: Compare the last entry...

Guys I'm still having a problem presenting hyperlinks on an ASP results page. Problem is thus: I have a hyperlink address (full URL including the http://) presented in an ASP page. However, despite setting the database field as a hyperlink it does not display as such on the ASP page - just...