Search results

Thank you khodr. I tried with compiling there is no problem. But about autoexec macro I do not have any idea about it. Please can you tell me briefly on what is that?

Hi Khodr I tried with Compact and Repair database. But again it started to give the same error. The error comes only if I open the database after few minutes. When I first open I get the error and when I close and reopen I wont get error. I am confused!

Thank you khodr. I will try with it.

Hi everyone! This is the problem I am experiencing for the first time. When I open my saved Database I am getting an error saying "There was a problem sending the command to the program" When I close it everything works normal. Any one has any idea about this error? Why I am getting this error?

open your form in design view-in the property sheet of your form you will see record source-there you select your query to which you want to bound your form. I hope this is what you are asking.

Store calculated value in one variable.

Bound your form to query(control source) As per me its better to have primary key in a table.

Thank you pr2-eugin. Its working fine now.

Hi! I have a form which contains listbox and a button. When a user clicks on the button i want to open another form only if something is selected from listbox. If user clicks on the button without selecting anything from the list box i want to display a msg saying the user to select something...

Hi Andy! Well come to the forum. I am also new out here. I joined recently. Hope we will enjoy learning access from each other. :)

Hi Shimsham! You can use a button to add new record. In click event of the button add this code. If IsNull(txtItem) Then 'validation rule to not to accept blank record MsgBox "Please fill the required fields", vbInformation txtItem.SetFocus Else Set cnn =...

You can go to Microsoft office button-access options-current database-choose over lapping windows instead of tabbed documents than restart your project. Hope this will help.

Hi! hope we will enjoy the forum and get to learn a lot...

What is the problem you are getting? Actually I tried your code and when I increased the size more then 100 and 600, its working fine. With 100 and 600 its not working.

Hi sarohap! Actually I am also new to access but i Have worked with such case. You can make your user id as primary key auto number in your table. When you enter new records in your table you do not have to enter user id it will automatically get entered. I have pkDetailid in my table which...

I am using Access 2007 And I have add code to the Before Update event of the Form still its not working. Its an unbound form. thank you... Hi everyone! I found the solution. If IsNull(txtItem) I used this code and now it's working fine. thank you every one.

Thank you Galaxiom and joemach, I tried both of your suggestions but its not working. I even tried to put my code into the BeforeUpdate Event of the Form but its of no use. Is there any other way? thank you.

thank you but How would i code the validation rule or is their any other way for this validation rule? How do i make my form not to accept the blank records. thank you...

Hi everyone! I have a from to enter new data in a table but i want to use validation rules to not to except blank records. I tried this code: if txtItem="" then msgbox("Please fill the required fields") else code to insert new data end if It is not working. My form is accepting the blank...

I have a form to enter new records in a table. But when user enter empty record i want to display a validation text to to fill the required. I tried this code. If txtItems="" then msgbox("please fill the required fields") else code to insert the records. end if with this code its...