Search results for query: *

Hi all. I've written the following code to enable the storage of 2 values in one form field using a colon as the delimiter - rather than redesign the form which we don't have access to do. select policy_key, substr(pol_notes,1, (instr(pol_notes, ':')-1)) netret...

Hi all, I'm having a rare old time with a feature of Report Viewer, passing details from a SQL query via Oracle - these don't appear to be an issue as not other parts of my report are failing, however this line in a report viewer cell is causing no end of grief...

Morning all. Not sure if anyone's asked this before, I certainly can't find a similar post on here. I've created an app in VS2010 which uses Report Viewer and needs to have this installed seperately - we have other software which uses RV, so I'm not bothered about including it in the build...

Hi everyone. I've been staring at this piece of code for a couple of hours now, and I can't see a reason as to why this would fail. I've based the code on something I've used on other platforms, but I'm still fairly new to Oracle... SELECT LOG_KEY, LOG_USER_CDE, LOG_SHORT_DESC, LOG_CRT_DATE...

Hi. I'm not overly sure on the process I'm working is best practice or even overly viable, I've been wracking my brains and could do with some input. I'm redesigning an aspect of our intranet, replacing a look up from a semi-managed SQL database and querying Active Directory, pulling out...

Hi. I bought 3 USB blue tooth dongles for £5, they work perfectly well for everyday use and I couldn't be happier. However... I have a proximity lock program that locks and unlocks my pc when I'm a certain distance from my PC and with these dongles having the range of 100m means that I have...

Hi. I have a form with numerous text boxes for a data capture solution which has 11 textfields, 3 auto populated, 7 for mandatory replies and 1 for an optional response. This app works well but I'm wondering if there's a better solution for error trapping blank fields rather than this... If...

Hi folks, I've been wracking my brain to see if I can work a solution into a problem I've been tasked with and so far haven't come up with much. I've got a simple form, one free text input and an output along with a button to fire off a query and return the answer. The table I'm using contains...

Hi Folks. I have a table with 10 columns and each column could contain 1 of 3 possible enteries. I've got a query that will sum 1 column and I'm trying to get my head around how to sum the other 9 columns, in 1 query. Here's the code, thanks in advance for any help. SELECT tblVotes.Res1...

Hi Folks. Over the past few months we're getting a reset somewhere in our telephone system that I'm finding almost impossible to track down. We have an IP406 that at random times, at least once a day - but not every day, appears to reset itself. This manifests as active phone calls dropping out...

Hi. I've created a voting form with (currently) 10 option groups comprising of 5 mutually exclusive radio buttons with the headings; For, Against, Abstain, Spoil and Proxy. So far I'm up to 50 buttons but their could be more option groups and I fear the coding will get messy. Here are my...

Hi. I've developed an intranet at work & they've asked if I could add the equivalent of an ALT tag to one of the combo boxes, which are created via SQL. Here's the code... <tr valign="top"><td><font face="Verdana" size="2"><b>Business Unit:</b></font></td><td> <SELECT NAME="BusUnit"...

Hi Folks, I have 2 queries that I'd like to combine but I'm having a rare old time figuring out the correct syntax. Firstly the table layout - tblLossEvent. The key fields are RiskCat which will only ever have 5 different enteries, ActLoss which is either 1 or 0 and LossValCurr which is the...

I've had a random thought that I need some clarification on please. I'm used to writing SQL SELECT queries in Access 2003 that takes part of the SELECT criteria from either textboxes or combo boxes, and wondered if it was possible to also make the table dynamic? SELECT FirstName, Surname...

I've got a form called frmReport which has 2 date textboxes which are used as search critera within a query. WHERE (((tblClaims.RecDate) Between [Forms]![frmReport]![txtManRepStart] And [Forms]![frmReport]![txtManRepEnd]) This query works fine when I launch frmReport as a standalone form...

For the life of me I can't get this query to work, does anyone have an idea? This particular data, I should have the following figures, but the Incomplete doesn't calculate. These figures are for work done on a particular day. The SLA MET & NOT MET figures don't need to match the RECEIVED, it's...

Hi Folks, Access 2003. I'd be grateful for a bit of a kickstart here. I've got a table with records that have a process day column, anything under 3 and we've met our SLA, 4 days or more and it's a fail. Here's the relevant data... RecDate RefNo ProcessBy CompDate ProcessDays 26/09/2007...