Search results for query: *

Hi, Hopefully this is a simple one but i can't fingure it out for the life of me. i have this simple line... msgbox Time which returns the single digit of 9 instead of 9:10:11 the same thing happens with the date function. This is only happening with excel vba. When i try it in Access it is...

Hi, I have a text file which contains a null character which when trying to import into the database causes all the data after this character to be truncated. I am trying to automate a process which will import this every day and the null value will always be there. Please could someone...

Hi, I have a text file which contains a null character which when trying to import into the database causes all the data after this character to be truncated. I am trying to automate a process which will import this every day and the null value will always be there. Please could someone...

Hi All, I am looking to get into SQL server as I have seen many Access / SQL server jobs around and I have a few years experience with access / vba / jetsql. Could anyone recommend any good courses they may have been on or the most relevant qualification to aquire, I suppose i'm looking for...

I have 2 tables joined by the ID field (Autonumber), the autonumbering is currently up to about 4734 at the moment but for some reason when I try and create a new record it is assigning an autonumber of 3772 and therefore giving the error message "The changes you requested where not successful...

Hello, I have a database that has just gone live, about 20-30 people use it with no problems but when one person opens it, it only opens as the MSAccess shell, as if you didn't choose an mdb file and just opened the MSAccess application. I am completely stumped, does anyone have any ideas...

As the title suggests, when I click on the close button in the report preview the report reverts to design mode, this has only started happening since i added some code to the On Close event (now deleted), can anyone help? Also, is there any way to stop the report from prompting the user to...

I have a page that I have protected using a simple PHP. It also emails me if an incorrect password is entered. Although the Password works as expected, I still get an email notification. It is as if this line of code isn't working as expected: if(stristr($alert,"@")!==false) I fully accept...

My current PC has 4 HD's, one of which contains my copy of WinXP. This is my main and only PC for home use. I'm keen to take a look at this new Vista Beta 2 version and wondered if I could install this on another one of my HD's seperate from my XP, and in essence have 2 OS. Ideally at boot it...

Hi, I have a problem where I'm using a VBA macro to interact with mainframe database. Admittedly I did not write this macro, but amended values for it to work with my scenario. What it basically does is: - takes a value from Excel - pastes it into a screen position in the mainframe - stores...

Hi All, http://www.silence.me.uk This is the first time i've put any effort into making a web site. The purpose of the site at the moment is to have something to show to my potential new boss when I apply for an internal job at work. I would greatly appreciate any comments or criticisms...

Hi, Could someone tell me if it is possible to create a lotus notes mail, insert address / subject and some text and then leave the document open for the user to edit? I have managed to send a mail from lotus using vbs but not have it open for editing. I have scoured this site and the...

Hi, I am trying to create and edit memo's using smarticons. I have done this before but unfortunately my computer died and I lost my work. The frustrating thing is that I found a good example of what i needed to do last time (on this site) but this time I can't find one for love nor money...

Hi Guys, I want to copy some text from a web page which has a single strikethrough and paste it into a word document. However, word is deleting all the text with the strikethrough (presumably this is normal?). I have just spent 2 hrs looking through the options to prevent this happening. Any...

Please could someone point me in the right direction, I need to find all open excel documents and close them. If any are not saved, the user must be prompted and also the script must wait for all excel apps to be closed before proceeding with the rest of the code. This is a vague 'stab in the...

Oh my god this is infuriating me !! i have a form with a page break half way down. When i open the form it will not open at the top of the form like normal, it opens already scrolled down about an inch so you can't see the fields at the top of the form and you can see the fields at the top of...

Hi, I have the following sql which works fine in a stored query but i'm not sure how to get the result into a report control (txt box) SELECT Count(*) AS Result FROM tblClassActionData INNER JOIN tblActiveClients ON tblClassActionData.ID = tblActiveClients.Identification WHERE...

I have a table (Results) that contains two columns ('Acc' and 'Rec'). The Acc column can have duplicate entries. Each Acc will either have a currency assigned or a default of 999 or both. For example: Acc Rec --- --- 100 GBP 100 999 200 AUD 300 999 What I'm trying to...

Hi, I am just about to split a number of large databases in work so that I don't have the annoying problem of kicking users out every time I need to make an update. Before I do this I have decided to do a 'speed test' on a dummy database to see what the difference is(if any) between a normal...

I have a 'Maintenance' form in my database with a button called 'Archive All Verified Records' on it. When you click this, the code goes and looks at 4 tables, Each table has a boolean 'Verified' field. If in any record, Verified = true then that record will be sent to archives. Can anyone...