Search results

Thank you both for giving me some more food for thought. As I have no experience of code I tried redesigning my main form for adding new users and have managed to get my form working once again. Once I realised the sequence of what sql was trying to commit I was able to work around it. Thank...

Many thanks for your reply. I am afriad that the resolve is out of my realm of experience, SQL and VB programming is an area I've never touched. However, I think I will re-think my design of my form for adding new records to see if I can find an alternative within my level. Thank you for your...

Re: (ODBC--insert on a linked table failed) Failing on Constraints I checked the sql error logs and there were no logs for my problem. I have been trying various things and have run sql profiler and have found that I am able to insert data into the 1st form but when I try to enter data into...

Hello I have an access 2007 database and have migrated all the tables over to SQL 2005 Server Management Studio in order to add security to my database. I used the access wizard for migration via triggers. One of my main forms is used to add new users or it can also be used to modify any...

Thank you all for you help! I have now managed to resolve my problem by looking more closer at my relationships and how delete changes cascade works. By removing the 'delete cascading records' option between only the relevant linked tables my rewritten error message now appears when any...

Thank you all for your replies. Sorry for not responding sooner but have been side tracked. I will be looking again at this problem of mine shortly. Thanks again.

Ignore my last message, I just needed to be the letter 's' at the end of Set Warning.With the SetWarning commands it now deletes the selected record and closes the form. Although the standard Access message no longer appears, nor does my tailored message and it also now takes away the...

I added the code in red but when I try out the command button on my form it jumps straight back into VB with a Compile error: Method or data member not found. Set Warning is highlighted on the DoCmd.Set Warning False line.Thank you for the tip also.

I have now managed to replace the DoMenuItem for the Run Commands. :o)Aplogies for forgetting to add my code. Here it is .... Option Compare DatabasePrivate Sub Combo19_BeforeUpdate(Cancel As Integer)_________________________________________________________________End SubPrivate Sub...

Hello againThank you all for trying to help me. I am still struggling to get this to work for me, despite trying your suggestions and code. It may be that I am doing this wrong as I really am a complete VB newbie.There are no event procedures at all for the form. What I have is a form based...

Thank you Evan for your suggestion. I have tried it but it doesn't seem to make a difference, unless I am missing something?? Kelly

HelloI have a database that has a table that contains addresses which can be associated with various individuals, i.e. 1 address can be shared by many individuals. I have created a form that provides a user with a function to delete addresses that are no longer used. However, as expected when...

Thank you for your quick reply. I have looked at the link attached but I am afraid I am still somewhat unsure. Could I please ask you though to clarify a couple of points for me if you wouldn’t mind as I am a little confused? I now have the following 3 tables... tblIndividual IndivID -...

Hello. I wonder if anyone can help me please with my normalisation. I am fairly new to access and do not write code. I am using Access 2007. I am currently creating a database which will include a contact details area for each individual. Each individual though could have multiple addresses and...

A possible solution??? Thank you both for your help. Unfortunatley, the User is not prepared to provide the list of types for each category (stents, balloons, wires etc) to allow me to set up individual tables for them to select from, as there are hundreds of each. A possible data input...

Hello I wonder if anyone can help me? I am currently creating my first Access database and in the planning stage but have come across one problem area. I need to create a database that holds and reports on information recorded on a clinical form. The section of the form I am stuck on...