Search results for query: *

Thanks the () did it!

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

Are there any other environment calls that could be of use? Do you have a link to a resource for this at all? Thanks guys!

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,

Thanks for the speedy reply, apologies though i didn't explain well enough what i wanted. Is it possible to find the datatype of the database table field the control is bound to? I.e. whether a textbox is bound to a field of type text or memo. 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

Audit Trail" that was the term i was trying to think of! cheers guys will check it out

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

For future reference if anyone is after the same thing: Select Case myMsg Case vbNo ' dont update table and move record Me.Undo Case vbCancel ' dont update and dont change table (new values remain) Cancel = True End Select Cheers for your help guys!

thanks, whilst we're on the subject how would i am trying to achieve the following: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim myMsg As Integer myMsg = MsgBox("The record has been changed, do you wish to save changes?", vbYesNoCancel, "Save Changes") Select Case myMsg Case 6...

thanks for the quick response snerting, unfortunately i'm getting an object required error. I have literally just added Set Cancel = True to the Form_BeforeUpdate function, anything else i should be doing?

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

correct, I hadn't initialized the command: .SelectCommand = cmd

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