Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Newuser26

  1. Newuser26

    Running a Delete Query dumps me out of Access

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

    Running a Delete Query dumps me out of Access

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

    Running a Delete Query dumps me out of Access

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

    Running a Delete Query dumps me out of Access

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

    Running a delete query dumps me out

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

    Running a delete query dumps me out

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

    Dlookup returning null value and/or runtime error

    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 ! :-)
  8. Newuser26

    Dlookup returning null value and/or runtime error

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

    Dlookup returning null value and/or runtime error

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

    Using ODBC to write to a table

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

    Using ODBC to write to a table

    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 !!
  12. Newuser26

    Using ODBC to write to a table

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

    Microsoft Access new records

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

    Microsoft Access new records

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

Part and Inventory Search

Back
Top