Recent content by macca

Yes, however I have it working now

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

Thanks to all. It is now working :)

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

Sorry bob, maybe I have not explained it too well. the Select case was being used in a function. The problem was I could not get it to find a string with a wildcard (*) at the end of it

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

No If you look at the spreadsheet you will see the data is in sperate fields. All you are suggesting is concatenating the fields. Never mind I have worked it out anyway:eek:

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

Please note there is no gap in the 67 character string, it is just the way it appeared on the thread submission form. A little bit more information, because of the 67 character string there are more than 3.65E+94 permutations, so a look up table is not an option What I will look to achieve is...

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