Recent content by gyli84

With regards to the Disabling of controls if "Completed" = True, I have tried the code, modifying chkComplete to completed and it did not work, even when I placed it in Form_Current. What is ctrControl? Also is Me.Controls an expression for all controls on the form? Thanks for your help.

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...

Is there any easy way I can lock all the controls in the form if the checkbox Completed = True rather than listing them all? Also, with regards to enabling and disabling combo boxes 2 and 3, the form also shows calls that have previously been logged and have not yet necessarily been completed...

Does anyone have the Candace Tripp Cascading combo box demo they can send me. I've gone to the web site but there is a server error and I cannot download it. My e-mail is garyli@weconnor.com Thanks

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...

As an experiment I tried to set the value in CompletedCriteriaNo through code rather than as it being relayed from combo_CallstoQuery. I used: Public Function CompletedCriteriaNoSet() If Combo_CallstoQuery = 0 Then Me.CompletedCriteriaNo = "0" ElseIf Combo_CallstoQuery = 1 Then...

I have tried Yes Or No and also True Or False being displayed in CompletedCriteriaNo and it still doesn't work.

Sorry, I should have explained myself better. I mean that the options that I originally select on the form are still saved in the record in the "Calls" table but when I go through the records on the "Calls" form and look at them the last combo box is empty even though their...

As part of a helpdesk program I have a form called "Calls" where problems are logged and it's recordsource is a query drawing fields from the calls and staff tables. I have 3 dependent listboxes on the form used to define a problem. When I actually choose values from each combo box...

In creating a helpdesk database I have a form called "Calls" where calls received at the helpdesk are logged. Within this form there are 3 dependent combo boxes (your choice in the first restrics options in the second etc.) used to define the problem. As I wanted to be able to query...

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...

How do you do that? Isn't that exactly what my OpenForm macro does? You can still use the nav buttons to go to records outside the subset returned by the query though.

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...

Ok, solved the problem.

Within my company there are staff who log calls. They do not necessarily answer the calls themselves though. The calls are recorded in the database and the helpdesk manager assigns the calls according to who he thinks may be best able to solve the problem and thus the Assigned user field is...