Search results

Hello and Welcome Mukmoor :) Also please don't use the reserve words like property as your fields names.

Thanks Janr, I have a table tblQty with the combination of Primery key for SOFID and ItemID field. The reason is SOFID and ItemID should be unique and no Item could be repeated for the SOFID: SOFID|ItemID 1|1 1|2 1|3 1|4 This works fine with the above combination but, if user select...

Hi folk, Does anybody knows how to control the the below msg to something like this through VBA: "The Item: " & ItemNo & " already exists in the table." instead of this: Msg: "The changes you requested to the table were not successful because they would create duplicate values in the index...

dude I am too tired right now, tomorrow will go through it and will try to understand what exactly you want :) take care till than.

Hello varadu, I guess you want to hide the database window from your users so nobody can access the tables etc? Here is a useful thread which solve this problem. This is ghudson's post... The below function and command button code will allow you to use a password protected input box to...

Okay, so what will happen, if you call the same code on form current event, or on form on activate event? did you try these???

Nice user name :rolleyes:, in a first glance it looks like a shrek's donkey... lol

Hi, This can be obtained like this: Hope this give some idea!

Instead of using Dlookup in Case statment, Report based on query is more faster, better and prefrable..

look like a full project code :). can you make it simple? nobody will have time to read all this and give reply. where is the main cause of problem?

you are right, but I disagree with you in certain situation if the needy is trapped with troubles and he/she searching for help rather to find the way to comes through... any how, without knowing the exact cause of the problem nobody is perfect to solve it.

Spike as the OP is new and has less experience with the VBA, It would be better to upload the sample db for analyzing it to go through and trap the bug.

It's look like that either Me.ScheduledNumber OR Me.CourseMInDel has a Null Value " " in your your field. if so, then nz() function should solve this: Private Sub Frame76_AfterUpdate() If (Me.chkFinal.Value = -1) And nz((Me.ScheduledNumber < Me.CourseMInDel),0) Then MsgBox "There are less...

The best solution is to hide all your queries etc is to Split your database (with fe and be) and make the accde front end file to give your user to work with it. They will not be allowed to work directly with your queries and form design. Hope this make sense.

It's not clear that Me.ScheduledNumber and Me.CourseMInDel are numeric??? Hope this gives some idea.

Great! I used this many time and the nz function too, but if you see &"", logically it something looks meaningless :) anyhow thanks for clarification.

Bob! I will ask one question? What is the meaning of & "" in the above statement?

Hi, What is the... strTableName and strFieldName in your code? The field will not be added with same name in the table... Hope this help.

Hi, check your query, it should have the criteria for Field1 Or Field2 and Field3...

It's sorted out thanks!