Search results

The buttons look ugly I thought, wanted to give it a more sleeker look similar to the Northwind 2007 version. But I have 2000 version and transparent button back is not supported here unless you know different.

Hi, I have labels as my buttons and use the click event to carry out there navigation function. As with normal buttons you can use the Me.buttonname.Enabled = False to disable it. But I want to do something similar with my label. I tried Me.labelname.OnClick = False but its looking for a...

are you able to give me a simple example of how this is done?

Hi, I have two forms: frmsites = Main form frmlog = other form I have a button located on "frmsites" to open "frmlog". The code behind the button is as follows: Private Sub new_query_Click() If intAccessLevel < 3 Then MsgBox "You do not have access rights to create a new query"...

Hi Ling, Your solution was perfect and I dont know why I didnt spot it. Maybe you are to help me with this other issue too. I have been trying to get this click activity to work but I keep getting errors. My code is below: Private Sub view_closed_queries_Click() Dim qrycounter As String...

Hi, I create this combo box but I keep getting error 3464 type mismatch. My code is below and would be grateful if anyone is able to point out the error. Oh by the way and I am not sure if it makes a difference. I do have a subform on the form too. Here is the lookup: Row Source =...

Sorted, you missed the "s" off panel: Me.StatusBar.Panels(2) = StrUserName Just out of interest what is the thing for date and time but the time to continue to update automatically?

Have I got this right or have I completely missed the point. God i feel like such a noob. Private Sub Form_Load() Me.StatusBar6.Panel(2) = StrUserName Me.StatusBar6.Panel(4) = StrComputerName Me.StatusBar6.Panel(6) = StrAccessLevel chkScaleControls = True chkScaleColumns =...

Great form password, How do I have text in my first input box because its just blank?

Is there a step by step guide on how to create a status bar on the bottom of forms. Im looking to incorporate "whosloggedin" & "date&time" & "computername" Ay help is really appreciated Thanks guys

Great I will have a look at that, and I assume it is possible to show the login status from this too?

Hi, This question is probably mainly for DCrake. Within your login system you developed. I want to put a field/box in the bottom of the form to show who is logged in to that screen and what the name of there computer is. For example: I have just logged in and at the bottom of the screen...

Well it doesnt necessarily have to cover it, even if the form stops just above like normal window behavior in windows. What is happening is the form is over stretching behind the taskbar by a few centimeters

It is set to Popup, so not sure whats going on

Has anyone used the Resize me script provided by Jamie Czernik. It seems to work fine but I cannot seem to get it to bring the form to the front of the windows taskbar. Any ideas?

For some reason I thought it would be a more difficult answer than the obvious. Just wanted confirmation really. I now understand that if I want to save the record prior to close then I use: DoCmd.RunCommand acCmdSaveRecord DoCmd.Close

Hi, I understand that you can using "Me." to declare that the item you are referring to is in that form. I want to create some generic buttons on all my forms for example Save, Close Form and search. The normal format of closing a form would be: DoCmd.Close acForm, "frmsites", acSaveNo...

Hi, I created a combo box and typed the following under record row source: [SELECT tblsites].[* FROM tblsites ORDER BY [tblsites]].[[sitesdescr] But it will not work, when I tried to use the wizard to create a combo box that will select the record based on the drop down value it stated...

It worked !!!!!!!! Thank you so much, I appreciate your help :):D

Thanks man, I will make those changes. I will also look to make some changes to incorporate a close form button too. I will let you know what happens