Search results

In the "On Open" event procedure of the form that being opened: Forms![YourSwitchboardName].Visible = False will hide the switchboard In the "On Close" event procedure of the same form: Forms![YourSwitchboardName].Visible = True will unhide the switchboard

It is also in access 2000.

You are correct, that you can edit the data and create queries BUT, you cannot open any of the forms to see how they are setup. The forms are the GUI of the database that let you control how the data is entered, manipulated or printed so that the user does not have to know how to use Access to...

Sorry ! DoCmd.OpenReport stDocName, acViewPreview

After: stDocName = "Recharge schemes all data" Add: DoCmd.OpenReport stDocName

Just to throw my 2 cents in. I would suggest setting the text box to Enabled = Yes, Locked = Yes, Have a command button next to it to enter the bar code, have the command button pull up a small unbound form (Pop Up = Yes, Modal = Yes , a couple of command buttons to accept or cancel), Use this...

You can save the form with "AllowEdits = No" and in the On Open event set use "Me.AllowEdit = True" to turn on editing. But, the more important question is what is happening with your form (or with the user) that you need to lock the form?

A relative path will not work because access does not see the starting folder of your path the same way that you see it. For example if you pull up the linked table manager, the browser will start in "My Documents" or maybe "Desktop", and that is where it will want to start at in its relative...

To check if any records were returned you can use: If Me.Recordset.RecordCount < 1 Then MsgBox "No Records Found", vbOKOnly "Then set things back the way they were" End If

In Explorer or My Computer if you look at the properties for the mapped drive, it will show you the server name. Then you can use it in your path instead of the drive letter (as noted above by Gemma-the-Husky).

It is doable. You need to convert your queries to SQL statements and use the SQL for your recordsource or filter (after you make sure all of your statements work, then you can delete the queries). Then, when you convert your Mdb to an Mde there is no code to access.

I agree with boblarson. It would require a fair amount of error handling (for the "What if they do this?" situations). As I stated previously I have never tried to hide the Windows taskbar, and I probably never will unless someone could prove to me that I can't screw it up to the point that IT...

You can't do it with a message box, but you could use a pop up form with a combo box to accomplish the same thing.

Haven't tried to do this, but it might be possible if you can figure a way to combine these 2 methods. http://www.tek-tips.com/faqs.cfm?fid=2562 http://www.daniweb.com/techtalkforums/thread32248.html

This link has some more info. http://www.pcreview.co.uk/forums/thread-1162440.php

You can add an error handler and test for error 8301, then just add "Resume next"

DoCmd.GoToRecord , , acNewRec Will take you to a new blank record.

In the On Click of your command button: Me.cboCahsier.SetFocus In the Got Focus of your combo box: Me.cboCahsier.Dropdown

For your label: Type in spaces, no text Set the following Visible = True Back Style = Transparent Border Style = Transparent You will not be able to see it in form view, but sill be able to click on it.

I think the "On Current" event handles that. Hope this helps?