Recent content by Newuser26

?????? It might be I am being a bit thick...... what is RDBMS and how do I go about using it ??? Sorry for the dumness :-)

Yes, well sort of I have another form with the current date / time on it and between 17:00 and 06:00 the timer interval for the queries is set to 0 and then all other times set to 1 sec. Is this to quick ?? I can slow this down but not by much more as once the info has been checked I need it to...

Hi Sorry, more info I am using Access 2000, The code was: Private Sub On_Timer() DoCmd.OpenQuery "DeleteOK", , acEdit DoCmd.OpenQuery "DeleteError", , acEdit End Sub the timer is set for 1 sec. the delete queries are very simple, For the DeleteOK I have a check box called OK and if...

I'm am running a couple of querys, to append data to 2 different tables (depend on result of query) if OK.value = -1 then that data goes to OKrecords table if Error.value = -1 then that data goes to Errorrecords table. That works fine the problem comes when I try and delete the data from then...

This is an Access VBA question, as I have had my other questions answered in this forum I thought I was in the right place. Sorry. I will try the other forums

I'm am running a couple of querys, to append data to 2 different tables (depend on result of query) if OK.value = -1 then that data goes to OKrecords table if Error.value = -1 then that data goes to Errorrecords table. That works fine the problem comes when I try and delete the data from then...

Thank you Thank you Thank you Golom and macleod1021, Golom you got it it's so easy when you think about it Cheers all, happy man again ! :-)

Thanks macleod1021, I've checked what is Prod_ref and it is returning the corect value "964-000-691-000" that has no meaning to you but that is what it is returning. Yes it is in the database, as a test I created a new table (same name and field names) and put the above product in with a desc...

I am having a problem with dLookup, I have a Table called detail two of the fields are called product and desc. on my form I have a text box called Prod ref, that I type the product number in called Prod ref and have a button that when clicked it should return the desc from the detail table but...

Thanks for all the help, Crowley16 and macleod1021. The end user will have no way of changing data and records are not deleted. Sorry I didn't explain very well the first time. The Access database will be storing info produced be the other program. The end user can only view the info stored...

Ok thank you, I did think that was going to be the answer, but I was aways told if you don't ask you will never know !!

Hi, I am using an OBDC link from one program to write info to an access database, the link is fine - to test this I use the first database to write the info I need, then open up access and look at the table and the correct info is there. The problem comes when I have the form open and info is...

Sorry have worked it out now, it may not be the correct way but it works !! I used this code: Text10.Value = Description Units = Text3.Value If Text3.Value > 0 Then Me.EquipmentDetail_subform.SetFocus DoCmd.GoToRecord , , acNewRec...

Hi, sorry I am new to this so please be gentle. I work for a electronics company that buys alot of equipment in for PPE and need to keep a record of it. I have come up with a little database with 2 tables, Equipment and Equipment detail. The Equipment Table has Equipment Name and description...