Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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