Search results

im using a new version of access... in 2003 there was a compile database but i cant seem to find it... where should i be looking?

So, my database appeared to be working OK yesterday however I occasionally saw an error in my "Update Event" script on one of my combo boxes. today, now when I try the combo box, I get a immediate crash. If im assuming its the same combo box, here is the code for that box: Private Sub...

yes but that would involve loading a combo box which I dont want to do. regardless of if you can see it or not, the amount of information the combo box will hold will be enourmous.

that would put all the info into the combo box. instead, the info i want to display is from a large table with sections getting populated based on the value from the combo box. I still want to display each value seperately in its own box, as i said, the above method works however its...

I have combo box that searches records. When that record gets picked, I want to fill in some other boxes corresponding to the record... I have a method to get the data but I want to know if there is an easier way. in the afterupdate field: Dim dbs As DAO.Database Dim rstReq As...

this worked as I wanted it to, thank you. one query though... the "Color" is not a unique value, hence sometimes (if i select "no") I see two "Blacks" in the drop down. is there any way in which I can remove the duplicates? EDIT: replace "Select" with "Select DISTINCT"

The values are either "No", "Planned" or "Completed" so when I select "No" the "Color" combo box should contain all of the colors that also have the "Serviced" filled in as "No". the source of this is in a table called "Services" and the column name is "Serviced" the actual fields are called...

when I select "Color" I get a message saying "Enter Parameter Value" and it wants me to enter a value for "Yes"

so using my previous example I would want the "Serviced" result to filter the "Color" they are in a table called: "Services" so in the vba i would put: Me.Colorcmb.RowSource = "SELECT [Services].Color, [Services].Serviced FROM [Services] WHERE Serviced = " & Nz(Me.Servicedcmb) & " ORDER BY...

the option group is throwing up the error, and the rest of the controls are fine.

Is there a way in which i can link three drop down boxes together? Ill create an example of what I mean... Ill attach a Excel file which contains two identical filters, one of them where the filter is turned on. If I select the "Serviced" filter, I am left with three options for "Make" and two...

Cant do that because KeyContent must be a variant as it is an array... so to re-summarize what is trying to be done: go through a list of fields, lock and disable them and change the BG Color to gray. If they are a option or tick box, the background cannot be changed therefore those need to...

it appears this is true, but im not sure why the data source is necessary... im planning to create a form which has a set number of records which can be searched through a drop down field... then when that record is picked, it will search through the database to find the corresponding fields...

Ive been designing a database but i just encountered this problem when opening my database (specifically a form) and im not sure what it means or what it does... it asks me to put in a value or something for 4 columns in a table but the 4 columns dont exist in the table.... all the fields in...

bumping: still having the same issue

Variable. I tried something liek this: For Each Var In KeyContent Var.Enabled = False Var.Locked = True If Var.ControlType <> 105 Then Var.BackColor = RGB(217, 217, 217) End If Next Var to try and bypass coloring the option buttons (as...

because its not using all of the controls on the form, just some of them. (its a large form) which is why I looped them like i did. Alternatively I could separate the two out (ones with a backcolor and ones without) and do two loops however if I could just do something like... On Error.Number =...

KeyContent = Array(Me.Field1, Me.Field2,Me.Field3,Me.Field4) If Me.Field1.Enabled = True Then For Each Var In KeyContent Var.Enabled = False Var.Locked = True Var.BackColor = RGB(217, 217, 217) Next Var Else For Each Var In KeyContent Var.Enabled =...

Yep, this worked, I finished with: Dim KeyContent As Variant Dim Var KeyContent = Array(Me.Field1,Me.Field2,Me.Field3......) If Me.RecNo.Enabled = True Then For Each Var In KeyContent Var.Enabled = False Var.Locked = True Var.BackColor = RGB(217, 217, 217)...

I have a button on my form which locks (and disables) some fields. by locking and disabling fields, I am able to change the back color of the fields to a "grayed out" look to warn the user that they cannot change the contents of the field. some of the fields that I have disabled are in fact...