Search results

aha...I see. Is the checkbox unbound?? Also, what's the error you get?

So is it possible, keytone, that you can post more information? How are the names being shown in the footer? Are they being populated from a field in the table or are those hard-coded on the report? Also, what is the logic in the database for an OCAT team member? You say you only want the...

It sounds like you are making it more complicated. YES, you should make the drop down list the same name as the manager field. Instead of Combo54, please rename it to Manager. Access automatically puts it's own name on a control until you change it. I'm not sure why Access does this in later...

You need to reference the listbox items as follows: For i = 0 To Me.YourListBox.ListCount - 1 if Me.YourListBox.Selected(i) = True then 'do something end if Next i

You can't. Use a listbox instead.

It sounds like you need to check for existence of the file in the forms open event and if the file exists, you want a checkbox to be checked and a button to be made visible? The button click event would just need to call each event of your other checkboxes Call checkbox2_Onclick() call...

guess I was too slow!

Maybe this solution would be overkill for what you are trying to do but, you could have a "complete" button on each record that when the user clicks it a window pops up that allows them to enter a completion date. AT that point you can determine if it's a dual date task or not and plug the...

David: It's not really like .NET or VB. You don't really need to reference the selected property or anything. It's simply this: if me.combo = "AA" then 'hide or show your controls end if

Why don't you have a checkbox at the top of the form so users can check it to show only records that have no status. You would have to use VBA to do this and check to see if the checkbox value is true and then change the recordsource of the form. In your checkbox after update event you would...

It looks like you need to open your main table in design view and change the Manager field so it is NOT a required field. This is your problem. I don't think the error is a result of the requery of the manager combo box. It's because a value is required in this field and on the requery the...

Can you provide more information about how you currently have your table of locations set up and how you have your form set up? Or are you creating a brand new form?

there seems to be a problem with your image. I can't view it.

http://www.dymo.com/media/UserGuides/AppNote2-OLEAccess.pdf http://dymodevelopers.wordpress.com/2010/06/02/dymo-label-framework-overview/ Here are a couple of links to developer forum for dymo labels. I believe I have a project floating around somewhere in my archives that uses dymo but...

oops. sorry carole, that is exactly what I meant. Sorry to confuse you! I mis-typed that - was thinking too fast. Hope it's going well.

You can have a main form bound to tblSerialNum, a subform on the main form bound to tblserialnumattributes with the parent and child fields property set to SerialNumID. On the subform make your AttributeID column a combo box with the rowsource set to : Select AttributeID, AttributeName from...

Carole: I would set up a lookup table for your attributes, and a SerialNum/Attribute table for your serial numbers and attributes rather than creating 50 fields across the table for each attribute. Your table structure would look something like this: Lookup Table: tlkpAttributes (note:the...

You will have to post your project. Not sure what else the issue is without more info.

Msgbox(dcount("*","NameofQuery") & " records were updated!") ---Correction----- You cannot use Dcount against an append query. Just tested this - sorry. Try creating a copy of your append query and convert it to a SELECT query and then do a dcount against that query.

Why don't you just install SQL Express on the customers own server and move the database there? OR is there a web front-end also hosted with the same provider?