Search results for query: *

Excel & Access 2003 I have set up a simple macro to import data from a spreadsheet, appending it to an existing table in my database. The macro uses action "TransferSpreadsheet" with arguments Transfer Type: Import Spreadsheet Type: Microsoft Excel 8-10 Table Name: CONTACT File Name: H:\RR.xls...

Using Excel 2003 I have a table with merged cells showing the owner of items. I would like to unmerge the cells to show the owner on each row next to the item with no merged cells. Is there any way of unmerging merged cells and adding owner name to each of the unmerged cells. I have to do this...

Visio 2003, Excel 2003 I know how to Create an Org Chart using Excel Data, however I would like to maintain this link, so that I can update the excel spreadsheet and then refresh the Org Chart. I cant seem to find this option with out re-creating the chart, by importing the data, this means I...

I am having problems adding records to my database, the insert statement seems to work ok, but I have an error when the execute command is reached. does anyone know where my problem is? <?php //try first to connect to the database. if we can't then end $dbh =...

I have an oracle database, the format of it is: table travel_request ( request_id number(5) not null, dbdirid number(15) not null, origin varchar2(128) not null, destination varchar2(128) not null, depart_date date not null, return_date date, purpose...

In my form I am trying to add a new record, the code to add a record works correctly. I am trying to add a check which displays a message box, if the user atempts to add a record which already exists. I have attempted to do this using the code below, the code I have added (which does not work...

I am trying to update a text file depending on a value entered in a form, the text file's format is Name ID Approval Derek Smith 1 Pending Gopi Chan 2 Approved The values retrieved from the form will be either Accepted or Rejected for the Approval field and the id eg 1. I...

When I change a <!--#include virtual=&quot;/includes/topnav.shtml&quot; --> to the php equivalent <?php include (&quot;http://es.cib.db.com/organisation/policies/includes/intranet_search.shtml&quot;;); ?> the page it is on stops working? The page is a form, it looks perfect but the submit...

I know this is simple but I am not sure what is wrong, I am trying to implement a password field, but when I reference it in the resulting page from the form the password variable is empty. Does anyone know why? The password code for page one <code> <input type=&quot;password&quot...

I am trying to send an email depending on a variable value, the code, is correct in that it does go into the correct branch of the code however the mail is not sent, does anyone know why? I have included the code below, thanks in advance <code> if($TravelRequest[3]==&quot;CGB&quot;) {...

is there a way to send variables via a page redirect, as you would with a form using the &quot;GET&quot; method? can you simply include them in the header eg header(&quot;Location: action.php?Name=Derek&quot;)

I am trying to peform a page redirect, the code I am using is: <code> <?php ob_start(); if($SubmittedDepartDate==$SubmittedReturnDate) {header(&quot;Location: action.php&quot;);} ob_end_flush(); ?> </code> However I recieve the error I have listed below, does anyone know why? Warning: Cannot...

PHP I am trying to use a case statement which switches a numerical value for a date eg 32 is 1st February. When I print the Max Date value to the screen it out puts 216, which is a valid date within July. However I get an error from the case statement outputting the default value, does anyone...

I currently have a template for a page which includes .shtml pages and Javascript code, when I add php code to this page and change the extension to .php from shtml, the page formatting changes, I know that I have to change the syntaxt in my include statements, but dont think I am doing it...

I am having a problem refering to the result of a drop down menu from a form. I have included the relevant code below the first section of code is the drop down menu which is populated from a text file. <code> <select name=&quot;Forname_Drop&quot;> <?php for($rowCounter=0; $rowCounter <...

XP, Dell 2300 When I first installed XP onto my computer it did not pick up the driver for my monitor, and used the default monitor set up. I turned off the default set up before installing a new driver, this means that now when XP loads, the monitor display is blank. Is there a way to turn...

I have a pivot table which dislays a subset of data dependant on certain field selections, from a query in an Access database. eg field 1, field 2 are drop down menus, I want to limit the details in field 2's menu to the relevant fields from field 1's selection. if field one equals Blue, field...

Crystal 8.5, Word XP Hi, When I export reports that are in A4 format to Word using &quot;Exact (Word) Format&quot;, the reports change to &quot;Letter&quot; Format. Since I would like to automate the exporting process, this has caused a problem as I have to manually change the reports back to...

VBA Access I am using VBA to send an automated email, using data from an Access table, the email works fine I just have a slight query with formatting. is there a way to tell the send object to go to a particular position in a line. eg message= rs.Fields(&quot;forname&quot;) &...

Crystal Reports 8.5, Access XP Hi, I have a problem that my database is growing so large that subsequently running reports on it is taking far too long. I was wondering if there was a way to run a make table query (In Access) usings an ID as a parameter, WHERE clause (which is passed from an...