Recent content by gyli84

If someone can tell me how to enter the criteria so that it will search for records where a certain checkbox field is True Or False then i can make this form work. I Know that when you create a query you can enter 0 Or -1 to do this or True Or False, but if I create a query which reads a textbox...

Private Sub cmdSoftwareQuery_Click() On Error GoTo Err_cmdSoftwareQuery_Click Dim stDocName As String stDocName = "Software Query" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_cmdSoftwareQuery_Click: Exit Sub Err_cmdSoftwareQuery_Click: MsgBox Err.Description...

I am trying to create a form where controls on it can be used as the criteria for a query. I have a table called computers which also has certain software titles on it of yes/no data type to indicate whether that computer has that software installed on it. The computer table is linked to a staff...

THANK YOU CHRIS!!! THE REQUERY ON FORM CURRRENT GOT THE LAST COMBO SHOWING AGAIN, YOU ARE THE BEST!

Is the cascading combo box example in the Downloads section? If it is I can't access it as there is a server error. Can someone send me the file? garyli@weconnor.com Thanks. P.S How did you solve your problem disgruntled? Did you have a problem getting the value in the 3rd combo to display as...

Does anyone know how to program 3 dependent combo boxes (where the values in the previous combo box limit the values in the next). I have tried a method you can use for 2 using queries as the rowsource but in trying it for 3 when I display them as part of records on a form the last comob box...

Is it possible to have a form whose recordset can be changed to that of a different query. I have lots of different queries all with the same fields but different criteria and what I would ideally like to be able to do is to have ONE form and then click a button (one for each query) which would...

I have an "OpenForm" macro with a "where" condition to filter the records on a form displaying calls logged at a helpdesk. The user can still use the record navigation buttons at the bottom to view records outside of the filter though. Is there any way to stop this so the button to which the...

I am creating a helpdesk system and have secured my database with User Level Security and Workgroups and have a script which determines whether the current user is a member of Admin or just a User. If the 'CurrentUser' is not a member of Admin then a checkbox (Assigned User-The member of staff...

I have managed to solve the problem as to disabling a form field if the currentuser is not admin but still have the following problem: I have a textbox on the form called "Logged By". I have a value on another form [Forms]![Helpdesk Staff Switchboard]![Name] which has the name of the person...

I have a textbox on the form called "Logged By". I have a value on another form [Forms]![Helpdesk Staff Switchboard]![Name] which has the name of the person logged in and I would like for this value to be entered into the "Logged By" field on the "Calls" form when the user has finished logging...

This code looks at whether the currentuser's login name is "Admin" rather than if they are a member of the "admins" group. Does anyone know how it can be modified so it checks whether the user logged in is a member of "Admins" and if not the form field is disabled?

Someone told me that I might be able to try: If CurrentUser = "Admin" Then MyTextBox.Enabled = True Else MyTextBox.Enabled = False End If I tried this but even though I was logged in as a member of Admin the textbox was disabled, perhaps because members of Admin are also...

I have enabled access user level security and workgroups with my database. I have a "Calls" form with the field "Assigned Calls", what I want to be able to do is for this textbox to not be enabled if the person logged in is a "User" as opposed to a member of Admin. Does anyone know how to set or...

As part of a helpdesk system I want users to be able to log calls. I have a helpdesk staff switchboard and as part of it I want a button that when clicked will direct the user to a NEW RECORD in a form called "Calls". I think this might have something to do with the DataEntry property in VB. I...