Search results for query: *

I'm trying to get the following to return false: SELECT TRIM(' EX7 5AW') REGEXP "^E|EC|EN|N|NW|SE|SW|W|WC[1-9][0-9]? "; Which basically should return true for london postcodes. I.E. if the first part (the textual chars) is in E|EC|EN|N|NW|SE|SW|W|WC and the second part (the numbers) is either...

Is there any way to retrieve the username of the currently logged in windows user? I need to do acheive this on access 97 running on windows 2000 Cheers,

(Apologies for the posting masacre today) Is there anyway to return the datatype of a bound field in Access97? I'm looping through each control on a form and need to know if the datatype of the bound field. Cheers

Is there any way to catch all of the fields on a databound form (access97) that have changed so i can store: the field original value new value in a history table? Any suggestions on this much appreciated, Dan

I have inherited an access 97 database which has loads of bound form objects. I need to catch the update record event and prompt to offer save or cancel. How do i cancel the update when in the Form_BeforeUpdate method? Any help much appreciated

I have 2 requirements relating to calculating worked time the first is to count worked days between 2 given dates the second is to return a date and time of a specified date/time less a specified offset (in hours). Clear as mud? Excellent, then i'll continue... I have the following tables...

I'm trying to execute the following oracle procedure from my app: CREATE OR REPLACE PROCEDURE sp_manual_order (i_order_no IN tbl_orders.order_no%TYPE, o_order_id OUT tbl_orders.order_id%TYPE, i_xfactory IN DATE) IS BEGIN --insert order INSERT INTO tbl_orders(order_no, client_name...

I have an array of values that match some of the values (as in valueMember not displayMember) within a multi-select listbox bound to a datatable. I want to select all the items in my listbox where the value is in my array. I can't seem to figure out the right syntax. I currently have Dim...

want to execute an oracle stored procedure sending parameters based on some vb.net form object values, which, if they are Nothing or "" (empty strings) then send the value Null to the procedure. executing the procedure from oracle works fine using null for parameters, and executing the...

I have the following stored procedure in oracle: - CREATE OR REPLACE PACKAGE pkg_machines AS TYPE rc_machines IS REF CURSOR; END; / CREATE OR REPLACE PROCEDURE sp_select_machines (i_order_no IN tbl_orders.order_no%type, i_profile_no IN tbl_profiles.profile_no%type, i_start_date IN...

I have a loop that part way through an iteration runs a function to send an output to an mscomm control and recieves a response from it. On each iteration I want to stop the loop at the point of sending the output and await for the response before continuing the loop. How can i make the loop...

Can someone tell me what's wrong in firefox's eyes with the below? When you hit the hyperlink nothing happens: - <script language="JavaScript" type="text/JavaScript"> // enter button for login script function submitenter(myfield,e) { var keycode; if (window.event) keycode =...

I have tried the following sql statement in access and it works fine, however when I run it as part of my asp it seems to just ignore it? I get no error and the code continues it just doesn't update the database? here is the ASP: - contactno = session("contactno") strSQL = "UPDATE client SET...

I've been trying to suss this for hours now with no luck at all. I'm trying to connect to a sql server database on a win2003 webserver running IIS6 (both IIS and sql server on same machine). I have set up the database and added a user 'CLUSR' with a password, I can log into query analyzer and...

Hi all, I have an AccessXP database, am trying to use dataenvironment to call up records into text boxes in a VB6 project. I have set up a simple form with 2 text boxes pointing at 2 fields in a table (using datasource as the dataenvironment, data member as the table and datafield as the...

Hi all, I have an AccessXP database, am trying to use dataenvironment to call up records into text boxes in a VB6 project. I have set up a simple form with 2 text boxes pointing at 2 fields in a table (using datasource as the dataenvironment, data member as the table and datafield as the...

I have an access database (db1), and i'm trying to use a data environment (de1)to view details of a table (table1). I've successfully set up the data environment and can drag and drop the fields onto a dummy form, however I can't seem to view any of the records. In the form I use the following...

I have an access database (db1), and i'm trying to use a data environment (de1)to view details of a table (table1). I've successfully set up the data environment and can drag and drop the fields onto a dummy form, however I can't seem to view any of the records. In the form I use the following...

I would like to run and display an MS access report in a window with an option to print. What would be the most effective method of doing this. Would I perhaps be better off generating the reports on the fly in sql? Any help will be very much appreciated. Cheers Dan

Simple relative saving problem: I have a macro that opens a new workbook and saves it with a filename, how do I save it to the same location as the original file (i.e. without c:\folder1\folder2\filename.xls) Currently using ActiveWorkbook.SaveAs FileName:=&quot;c:\folder\filename.xls&quot; but...