Search results for query: *

I am trying to query a mysql database using PHP. I have a function in a seperate PHP (PHP File A) file which I call to connect to the database in PHP File B: PHP File A: =========== function RS_Connect() { // Database Connection Settings $RS_Server = "RSDB"; $RS_Settings =...

Hi all, I've the following formula which compares two date fields: ' Evalulate Forecast & Actual Dates dim DateForecast as date dim DateActual as date dim Result as string ' Comparision DateActual = DateValue({dtblDMC2163Options.D_MSV_A}) DateForecast =...

Hi All, I've a function that opens an Excel Object and worksheet, and then attempts to put a variable's content into a cell. When the variable (which is a String) has more than 256 characters in it, Excel refuses to insert it into the cell and gives a Error 1004 Application-defined or...

Hi All, I've an Excel application which queries a database table, and uses the results to populate a combo box. However, the table has lots of duplicate values in it - I'd like one of each to appear only, hence a SELECT DISTINCT requirement. I'd also like to sort them in ascending order, so an...

Hi All, I have a form with a textbox which I monitor for the user pressing 'Enter' on their keyboard. My function looks like this: Private Sub tbxPassword_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) ' Attempt login If Enter Is Pressed If KeyCode = 13 Then...

Hi All, I query an SQL Database via VBA and wish to return results from the recordset into variables. The problem is that some of the fields, although populated on the Database, don't show values in VBA, or, they show values, but then mysteriously change to 'Null' when I try to do anything...

Hi, I have a SQL query I am running in a form which pulls in some fields from two tables. Two of the fields, one from each table, has the same name. How can I reference each field specifically in order to refer to the correct field? Everytime I try anything other than the following, I get...

Hi, for the life of me I have no idea why the formula below isn't working. I have 11 'Stages'. Each one on its own in its own formula does what I need - flag '1' if the date is over 1990. However, when I combine them into a single formula, the formula returns zero. Not all dates will have...

Hi, I have 28 numeric fields. I wish to count the amount of null fields for each row in the details section. I can't for the life of me get the formula to work - and my knowledge is sketchy. This is what I've got so far: // Total Categories Containing Scores numberVar CategoryCount := 0; if...

Hi, I have a report with three tables, all linked. tblSite > tblOption > tblNotes One site can have many options, and many options can have many notes. I want to list the Options, and have a column showing the latest Note for each Option. I do this by putting in the Detail row the Option...

Hi all, I work in an office on Outlook, running on MS Exchange Server. I receive about 9 emails a day I need to forward to an external consultant. I've set up a rule to do this, but it is not sending the emails. I have dug around and read that Outlook won't auto-forward to external addresses...

Hi All, You've probably come across this problem many times. I've read numerous articles on this, but none address my particular problem. I have a form [frmLedger] which has a subform [frmInvoice] which in turn has a subform [frmInvoice_Items]. I have a calculated control which is in the...

Hi, I'm using CR10. I have a report that works fine and shows information based on a given month. The Report uses a date parameter to ask the user to select a date. The report then only shows data where the month and year of a date field is equal to the month and year of the data parameter...

Hi, I'm no javascript expert - so have hit a brick wall with this. I have a spry repeat list of image thumbnails. I want to use lightbox to show the enlarged images when they are clicked, but lightbox won't work because it is initialiseing before the spry list is populated. How can I overcome...

Hi, I've just moved into a house and am looking to install twin network points in all the rooms - both using Cat5e. I'd like one to be a network socket, and one to be a telephone socket (to accommodate Sky Digiboxes if needs be in the future), but want the choice of swapping them to network...

Hi, I have a Site report which has a section in the RH showing the notes for the site and any Jobs done on the Site.. These notes come from two tables - {tblSiteNotes} and {tblJobNotes}. I have put a subreport in my RH to list all of the notes (the main section of the report will show data, so...

Hi All, I have a database with the following hierarchy. All levels link immediately to the one above: {dtblSites.SiteID} {dtblOptions.OptionID} {dtblJobs.JobID} {dtblAudits.AuditID} {dtblAudit_SubScore.SubScoreID} I have a report that has the following groups: G1: {dtblAudits.D_Audit_Date...

Hi All, In our database we have the option of specifying if a date is 'not applicable' on a record by selecting 'n/a' on the database's front-end. As the date field cannot store a string, the database uses the date '1901-12-31' to store this special value. Whenever the database sees this date...

Hi All, I have a CR10 Report which shows the amount of surveys and site starts per month, for two contracts. It has the following format: GH1: Grouped by 'Month' GH2: Grouped by 'Contract' Details (contains sub reports) Details contains a Subreport which lists 'Survey_Dates' and a...

Hi All, I have a report in CR10 which has data as follows: Records are grouped by 'Contract' and within each Contract are Sites. Each Site can have multiple Audits. Report Header (Here's the problem): ----------------------------------- Need it to Display Chart of 'Average' 'Max' value of...