Search results for query: *

Thanks both. The end user(s) are aware that they will need to use a colon or they won't get an output and they're ok with that. I'm more used to doing this sort of thing within the front end, it seemed a bit more clunky to have it included in a sql statement, but it seems to run without any...

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...

Are all new URL & Email address plain text after making your AutoCorrect changes? Have you cleared the tickbox in the AutoFormat tab as well? Cheers, Jon

Hi Auguy, I have a similar feature on a form, the combo box uses a Data Bound Item, with the Data source set to an existing table adapter against the User table. The Display Member is the Username and the Value member is the Primary Key of the table being queried. I have the left the Selected...

Not an overly tecnical response, but considering you're using Access - I'd use Windows copy and paste to create the archive and manually purge any historical data, then compact and repair?

[code] =IIF(SUM(Fields!LIVE_NET_RETAINED.Value) <> 0, sum(Fields!LIVE_NET_RETAINED.Value) / IIF(SUM(Fields!LIVE_NET_RETAINED.Value) <> 0, (SUM(Fields!VARCONV.Value)), 42), 0)code] Thanks Andy - I'd played with a nested IIF about an hour before, based on something else I'd found and dropped...

something along the lines of... objUser.Put "homeDirectory", "\\Server\HomeDir\SAMAccountName" objUser.Put "homeDrive", "H:"

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...

Are there compatible Vista drivers available for your printer? If not, you could try installing 7zip which will allow you to view the contents of the .exe file and potentially drag them to your desktop to help with the installaion.

I tried to remove IE8 when I upgraded to Win7 and got nowhere fast. Also tried Chome, IE9 and then put on the latest stable release of FireFox, which uses less CPU than either of the other browsers I tried. While it doesn't fix the issue, it does make it go away!

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...

Thank for the tips Dagon.

Hi Carp / Mufasa, Sorry, typo on my part - the sql is actually WHERE TRUNC(LOG_CRT_DATE) =TO_DATE ('18-FEB-2011 00:00:00', 'DD-MON-YYYY HH24:MI:SS'); Not really sure what I'm expecting to recieve in the dataset, nor am I overly 'aware' of what the datatype DATE should store. All of the data...

Thanks Dragon, that worked a treat, and thanks for the note with the Date criteria, hadn't really realised that before! The date format in the database I'm working with shows dates as DD-MMM-TT, so 22-FEB-11 would show for today. Thanks again. Cheers, Jon

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...

If you don't need to rely on username & password (if your users have already logged into a networked workstation) you could use http://stackoverflow.com/questions/677112/how-to-get-logged-in-users-name-in-access-vba to pull the UID from their login details?

We've recently upgraded to IP office - Avaya 9620 & 9630's, have similar problems with ambient noise and it turned out that the headsets that we previously used (Plantronics CS351) are incompatible with the new kit. A good test of this was to have the other person hit the mute button on the...

AVG Mobile Security 1.24 for Symbian

I'd should probably also add, that if I had time I'd be inclined to export the data to Excel check the integrity and import back into freshly created, identical databases...

You'd open the main table in design mode, and assuming you have an AutoNumber field as the Primary Key, you would remove the PK from that field, change it to a number - save the table - then add a new AutoNumber field as PK and remove the original field. I can't think of a tool that does this...