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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eveCalypso
  • Order by date
  1. eveCalypso

    Connection to SQL DB

    Dear PHV, I feel a right ninny now! That was exactly the problem. Thank you so much. EvE
  2. eveCalypso

    Connection to SQL DB

    Good Day All, I use Access as a font-end only and linked SQL 2K tables as my back-end DB. My problem is that when the application starts up, this connection (maintained by Access) states that it does not have the username/password in the connectionString or a trusted connection to my SQL DB. I...
  3. eveCalypso

    Recordcount of subform

    Thank you very much for that! SubFormControlName.Form.RecordsetClone.Recordcount is what I was looking for, as I kept trying SubFormControlName.Form.Recordset.Recordcount My database is set up correctly with the correct referential integroty. It is logic within some items which reverses the...
  4. eveCalypso

    Recordcount of subform

    Good Day All, I have consulted the FAQ's but could not find what I was looking for - maybe you can help. This must be extremely simple, however, I can not access what I need! I would like to know what the recordcount is for a subform. Basically I want to know if there are any records at all -...
  5. eveCalypso

    DB Error Trapping

    Thank you for your help. I assume then that its a trial and error business picking up error codes that mean specific things. I find that quite strange - in my eyes there should at least be a standard list, which is what I am after. Best Regards, EvE
  6. eveCalypso

    DB Error Trapping

    Sorry about that! I am using ADO. Regards, EvE
  7. eveCalypso

    DB Error Trapping

    Good Day All, I would like to trap Access Errors which originated from a databasis query. I.e. Duplicate Primary Key etc - to give a better error message to the end user. I have figured out that I can use the Error Event for this, but that means that I will need a list of possible error...
  8. eveCalypso

    Closing All Forms + Catching Errors from DB

    Good Day All, I have two questions. I want to check for any open Forms related to my application when the application exits, and close any if they are open. What is the best way to do this? Secondly, I am doing quite extensive error handling of my own, but I would like to intercept standard...
  9. eveCalypso

    Update After A Row has been Deleted

    I have added a button to my distress, but what can one do :-) Thank you for your help and advice. Regards, EvE
  10. eveCalypso

    Update After A Row has been Deleted

    Good Day Mr Reay, Thank you for your reply, however, I am not in charge if the delete ;-) I just let Access handle that through its default 'Delete toolbar'. That is why I need access to an event which can tell me when the delete has completed. Options are to create a delete button on my...
  11. eveCalypso

    Update After A Row has been Deleted

    Hello All, I need to run an 'update stock balance' stored procedure when a user deletes an invoice item. For some strange reason the following events all fire BEFORE the actual delete takes place in the DB, namely: BeforeDelConfirm AfterDelConfirm Delete I need to know when the actual delete...
  12. eveCalypso

    Continuous form

    Dear PHV, Thank you for that - exactly what I was looking for! However, I have a slight problem, in that my background is set to a company colour (very light yellow), the conditional format background is picked up for the "not true" format, but when it is true - it only gives me the option of...
  13. eveCalypso

    Continuous form

    Good Day All, What I want to do is very simple, but clearly I am a bit dim :-). I have a view only form - which selects a load of transactions into itself - and I have set this form to be a continuous form (which I never really worked with before). What I am after is to make a change to the...
  14. eveCalypso

    Execute and sp_executesql

    Dear Zhavic, Thank you for your help - this is exactly what I was looking for :-)! Regards, EvE
  15. eveCalypso

    Execute and sp_executesql

    This is what I originally wanted to do, but couldn't get it working. This looks much better though! I thought a solution through SQL was possible. I shall give it a try tomorrow. Thank you so much for your help so far. Best Regards, EvE
  16. eveCalypso

    Execute and sp_executesql

    Dear Zhavic, Not quite :-) The options my end user have are as follows: "All" or specific ItemID (i.e. if specific ItemID has not been selected, do not let it affect rest of selection) Between dates (this is fine) "All" or specific invoice (i.e. if specific invoiceID not given, do not let it...
  17. eveCalypso

    Execute and sp_executesql

    I know, but then i have the problem i described above! rgds, eve
  18. eveCalypso

    Execute and sp_executesql

    I hall try that and let you know! Thank you very much! Regards, EvE
  19. eveCalypso

    Execute and sp_executesql

    Dear All, I am delving into dynamic stored procedures. I think what I want to do is pretty straight forward. I have 5 possible paramters of which only 2 will always be present (dates). So, for example: @anIDColumn int @toDate datetime @fromDate datetime @anInvoiceID int @BinID char(12) I...
  20. eveCalypso

    stored proc start with 1 parameter then change?

    Dear All, I am delving into dynamic stored procedures. I think what I want to do is pretty straight forward. I have 5 possible paramters of which only 2 will always be present (dates). So, for example: @anIDColumn int @toDate datetime @fromDate datetime @anInvoiceID int @BinID char(12) I...

Part and Inventory Search

Back
Top