Search results for query: *

Hi, I need to produce a query that will only ouput the values that are not present in a table. The example is... I have a dropdown box which will be used to select 1 of 3 times (06:00, 15:00 and 23:00) - but I want it to only show times in the dropdown which are not contained in a record for...

Hi BillyRayPreachersSon, Thank you for your help - the information that you provided is perfect. The email from which the link came from has been confirmed as a Phishing/Walware attack. I have had to write all this in another thread becuase what ever I do I can not submit a reply to my...

Hi All, I have got the following Javascript which I have taken from a possible Phishing/SPAM webpage. Can anyone help me decypher what is contained in the script? <script language=JavaScript> function decrypt_p(x) {var...

Monitor loses input intermittently… I am having an issue with the graphic output on my machine - the problem is intermittent with no pattern to it occurring. Whilst the machine is booted up the monitor just goes blank with a message saying lost input. I have replaced the graphics card and...

Hi, I have trawled through the FAQ's and searched for similar posts but can't seem to get what i need. I am using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, lcQueryName, strFilePathNamE, True ...to export my query data to an existing excel workbook. Then what i need to do...

Hi, I have read a lot posts talking about this subject but i just can't get some of the replies to work. So i have decided to post my own question... I want to export the contents of a query to a new excel file and then to run an excel macro (that formats the data - and sub totals) at the...

Hi, I have a quick question, How can I force the user to only enter text as capitals or automatically change any text entered to caps? Thanks in advance, Chris

Hi, I have a propblem with a popups appearing every couple of minutes. I was wondering if anyone can have a look at this log and let me know what to get rid of... Logfile of HijackThis v1.98.2 Scan saved at 11:05:37, on 07/09/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet...

Hi, I have been asked to add a button to a form which when clicked will run a query and then display the data in excel. The data is a list of totals in pounds. Can anyone point me in the right direction. I have seen this working on another database so i know it is possible. Thanks in...

Hi, I have created a database using access 2003. The machine that i am want to use the database on runs Win98 with access 2000. I have been testing the database thoughout the testing on both machines, once i left the finished database on the 98 machine a month has gone by with data entry...

Hi, I have created a database using access 2003. The machine that i am want to use the database on runs Win98 with access 2000. I have been testing the database thoughout the testing on both machines, once i left the finished database on the 98 machine a month has gone by with data entry...

Hi, I need help with referencing the root/main form from a sub form. Any ideas ? Chris

Hi, I have a funny problem really. I have created a database driven site and have it registered on google. The problem that i am having is that google can't see all my info in the database and so when seach is carried out i miss out. So, my question is, does anyone have any ideas about...

Hi, I have seen on a few site now that they have a facility where by you can see how many are logged on/ using the site. Does anyone know how this is done? I thought that they might have just looked at how many users have logged in to the site and then wait for the them to log out... but...

Hi, I have seen on a few site now that they have a facility where by you can see how many are logged on/ using the site. Does anyone know how this is done? I thought that they might have just looked at how many users have logged in to the site and then wait for the them to log out... but...

Hi, I am really stuck trying to work out how to code a button that will open up a program for a certian file. The database has a field that stores the path to a drawing. I need a button that when clicked will open the file with the right prog. Any ideas ? Thanks in advance, Chris

Hi, I have a two web pages - the first with a drop down that selects the date range for a query on a database and reloads the same page showing the results, and the second page which is a detail page for each of the results. Well what i want to do is have a back button that will go from the...

HI, I have a table that has 2 fields that hold dates. I am trying to order the results of the query so that the records with the most recent dates come out first. I can't work this one out - i can obviously return the results grouped by one of the date fields but not by both. Any ideas ?? Chris

Hi, I have a field in a MySQL database that h holds the now() function data. But i want to check to see if the field in the database matches today date. This dosen't happen becuase if i do.... if field = date() then.. it checks the time part too and so there for is isn't equal. What i need...

Hi, I have created a forum and have just added a time field in the database so that when i message is written the time is recorded and then can be displayed back next to the message title. This all works apart from the AM PM part. I have just tested it out, the time was 1:31:32 PM but the...