Search results

Hi I have a form called "frm_Q_all" and it has 2 text box fields called "ASP" and "CAT". These fields are from a query called "Q_all" I want to keep the form open and have these fields to refresh every 30 seconds. When I press the Refresh All button it works but Imy code below does not work...

I want to update a date field (called dater) in a table called tbldate. The function dow gets the week day based on the system clock e.g dow= 4 The function prevdate then calculates which date to use based on a Select Case, e.g 28/07/2009 The problem lies in the function dated, the...

I have a database which displays a form "Plasma1". This form has a timer for 5 minutes, when it closes this form to refresh the tables/queries another form called "frmRefresh" displays a message "Data refreshing Please wait". This is on screen for approx 3 minutes. What I was wondering is can...

I wonder if any one can help with this one, shown below are 2 examples of strings in a field called PROCOM Occurred: EnterMeterReadings; Reason: Reading greater than upper limit; Session: 0A52BE4293.worker1 MSPSubmitMeterReadings; Reason: CANNOT BILL LATER THAN 29/02/08, DATE AMENDED FROM...

Can anyone help me with this one ? Attached is a spreadsheet showing data from an Access table. The Ivd Id field has produced 2 records. I need to show this detail on 1 row. I have tried using crosstab queries to do this, but there a lot more fields than the ones shown and the processing...

A strange request but I hope someone can help with this one I have a table (tbl_Econ) where I have to delete a specified number of records from a table. It does not matter which records as long as I delete the exact number e.g On a form text box I enter the number or records to be deleted...

I have part of a query that checks a string and returns a 2 letter code. the string is 9 characters long and consists of 1's and 0's, but it is picking the wrong 2 letter code String Code 100000000 AC 010000000 AR 001000000 CD 000100000 MC 000010000 MR 000001000 PLS 000000100 PS...

can someone help with this. I have 2 fields in a query tbl1_nbil = 3 tbl2_nbil = 0 however when I add them using Bill = [tbl1_nbil] + [tbl2_nbil], I only get a few of the added numbers in the calculated field. In some records it works, but in the majority it does not It onl seems to add when...

My problem is that I need a VBA routine to check the 67 character DNA string and return a Process Name in a field called Process. I do not want use Excel as the number of record often exceeds the Excel row limit ContactID DNA 4479850...

Can anyone help with this. I have a query called trigger, which has 5 fields as follows CONTACTID..............INV...............MSP..............SMS..............TRIGGER 456.............................................11......................................MSP...

I have a 67 binary code string produced from a query which concatenates these 1's and 0's. What I need to do is have access decide what a particular string value/range is and return the process name. e.g 1100000000000000000000000000000000000100001000000000000000000000001. The process name...