Search results

Around here you can never be to sure on how much a person knows. Good luck.

I have heard help called a lot of things in my day, but that is a first. Access help is on your hard-drive or CD-Rom. MS KnowledgeBase is on the net. Assess help is a less of a security risk that Access itself is. FYI 4U.

The only way I know of to disable code is to comment it out. Just pu a ' at the beginning of the line. hth.

No, you can not copy them, you import them. Just go to the section, like queries, that you want to import into and select file pull-down menu and select get external data and select import and then select the dbase that you want to import from. Repeat in all desired sections. hth.

Excellent point DocMan, I completely forgot about that. Thanks.

Default Behavior? There is no default on a cmdButton. As long as you comment out or delete al previous code, except the first and last line, only that code will run. Now is you have other procedures and modules, they could be affecting the code you just added. Try running C&R, hopefully that...

Try reading Access Help, under menubars. It tells you how to create customized menbars and how to call them. Personally I disable most of that stuff and I use chkboxes, cmdButtons and the like to do the things I want the users to do. Users can be very mischiefious and create havock when given...

Yes, I use search form which open when I click on a label. I have been slowly modifing then, so now you can click on one of the displayed records and it fills in the combo box or boxes. I even have gone as far as having one on a form in whcih you can click it and it closes the form and opens...

I have opened another form to the record I was working on in the original form. I used this procedure in the cmdButtons OnClick event: Dim stDocName As String Dim stLinkCriteria As String stDocName = "YourFormName" stLinkCriteria = "[Pkey]=" & Me![Pkey] DoCmd.OpenForm...

Maybe try it at night , when network traffic is light. If you have any problems then, run C&R and if the problem is still occuring, copy the code, and then delete the cmdButton. Creat a new cmdButton and replace the code. Run C&R again. Basically a little corruption of the old cmdButton may...

Your users maybe the problem, no patients. Sometime network traffic can get heavy and conjested. This slows the packets down, somtimes tramically. User, especially ones who don't understand computers or networks and how they work, assume that something, like a control, is not working...

Oh,sorry, thank you Pat very much for first finding that information. Thank you Doc for passing it on, and stay out of those French Quarter restaurants.

Doc Man, thanks for that tip on how to handle memo fields. I might have a good use for that sometime, I use three or four memo fields in a couple of dbases, so it is nice to know a way of handling them if they ever start giving me trouble.

The table will do the when it can not figure out what to do with data, aka type-o's and other things. Yes the code would have helped a little. Glad to see that it is now working for you, and feel free to use that module above to keep two users from working on the same record at the same time...

Right mouse the control you want to modify, in this case the form, which you select the upper left hand corner, and select properties. Select the Events tab, then locate the event where you want to add your code, in this case, OnActivate, then when you move the mouse across the textbox next to...

You might try this: Private Sub Form_Activate() Me.Refresh End Sub hth.

The value you are looking for is in the table, right? If so, try using DLookUp in the control's GotFocus event. As long as you are not working in a large dbase, DLookUp should work OK for you. Another idea would be to use a recordset and search via a loop. Outside of that, I am out of ideas...

Your welcome, glad I could help. Don't worry, by the end of your second dbase, you will be a pro.

I have never heard of locking tables, but I have heard of and use locking records. just create a moule with this: Public Sub SetRecLocks() 'This command set Pessismistic locking. 'If someone is poking aroundin a given record no on else can edit it...

I included a simple maintainance form, table and 2 modules to run it. I would use this for the maintainance form for your tables tblDisiplines and tblDiseases. In the form please note the way I crease a new record, also note the dehavior of the cmdButtons at the bottom of the form. Also...