Search results

Hi All, I have a main bound form which has tabs.On some tabs i m calling the subforms which are also bound forms. I am facing a problem in which access automatically saves the data eevn if u dont want to save it.In my subforms i have save button to save the data ..i am also doing some...

thanks..i know how to comment code.

see the other tab on the properties window.I know how to debug code but i dont know how can i disable that default behavior of command button. there is no problem with the code.it opens the new form .its just i dont want to open the new form on hitting the enter key. any ideas??

hi quest, i am also using the same code on the command button and it works fine. The only problem is the default behavior of the command button when it opens the another form on hitting the enter key. I tried to disable it explaining it in my first form.Any idea on how can i disable it?? thanks

that works wine .I am using the record selectors and on the click event of the details i m opening the other form.but i have to click on the record in the continous form and clicking on the record selector doesnt work. But when you click on the command button it shows the hour glass..how...

hi all, i am trying to find a solution for this.I have a continous form which displays records..for every record there is a command button which opens the other screen for that particular record. when ever i hits the enter key the command button opens the another form for the 1st record in...

hi all, i am also facing this problem just ny FE is a adp project.It works fine on all the users machine except the one. I guess its something related to the MS SP but dont know whats exactly the problem. is anyone faced this problem..any solution for this?? thanks a lot.

i think you should use 2 validations like this if (((not isnull(f1)) or (f1<>"")) and ((isnull(f2)) or (f2=""))) then msgbox("Please enter the value in the second box") end if if (((isnull(f1)) or (f1="")) and ((not isnull(f2)) or (f2<>""))) then msgbox("Please enter the value in first box...

Thats cool..i didnt know that..Thanks for telling me.Just a last question.when i will spilt the database the FE also have a mdb extension or it will spilt the FE as adp and the BE as mdb? In my code i am making connection like this db=currentproject.connection I think i have to change it...

Thanks for replying ..thats what i was looking for.I have worked on a adp project but right now i have started working in a mdp prj. So do u mean that we can even spilt a mdb prjects as a FE and a BE?? Could you provide me more details on this?? Thanks

Thanks for your reply but the problem with is just the opposite.I have worked in relational databases like sql server 2000. I am trying to create a small application in access..a mdb project.But this application will be running on different PC's(users) so how will i get a centralised database...

Hi All, Can anyone tell me how access works in a multi user environment or may be provide me any usefull links. Thanks to all.

hi all, i m new access projects.I have experience of working in vb and vb.net.Typically i know how to save/retrieve data in the central databases like sql server. Now i have worked in the .adp project which has a sql server as the backend.but i have to create a mdb project and i dont have...

hi all, i have .adp projects.I am facing a problem for which i dont find any reason.whenver i open 2 .adp projects they hang up.I have to kill the msaccess.exe It okay if i m running 1 project but i have to logout to open the second project.I can not run both at the same time. Any help on...

Hi All, I have a question..In VB we can make a exe of a Project.I have a .adp project..can i make a exe of .adp? Thanks to all.

I have solved the 2nd problem of versioning .Thanks to Ghudson..i serached and found a post by him. Anyone can advice me on the first problem.Is every user has to map the the network folder to their machines??Is this is the only solution?? thanks to all.

hi all , i have a adp project with the sql server200 as a backend.So the software is running on the client machines. I have a requirent to generate the xml files and then save them to a server or a shared drive . this is the code i m usig to generate the recordset and then saving it as...

Thanks..Yes i always check the empty string as well as the Null like If ((IsNull(Me.SomeControl) Or Me.SomeControl="" ) I just wrote that to give a example.I will take care to post things right in future. One more thing ..Once Pat pointed me out that all the validations should on the before...

hi, exit yout sub if the validations fails. ex- Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click If IsNull(Me!fieldname) Then MsgBox "Please select a fieldname", vbCritical + vbOKOnly + vbDefaultButton1, "Missing data" Me![fieldname].SetFocus GoTo...

I guess i cant http://office.microsoft.com/en-us/assistance/HP051868081033.aspx sorry to trouble u all.