Search results

I posted a similar question but maybe complicated it too much and therefore got little help on it :( Basically the following IIF in the criteria in my query doesn't return all records when value is NULL; can someone tell me why...

It would be nice to know how to that as well, but in this particular case the choice on the form's combobox specifies the order type to be displayed(querried). Therefore, each time there is only one order type displayed and I need to display indivduals(unique) who used that order type. So...

I have a query which displays two fields: client ID and order type. I want to be able to display the client only once per order type. I tried to use GROUP BY order type but that gives me a missing expression message. I also thought of using UNIQUE as YES in qry properties but I'm not sure as to...

I have a query which based on some fields on a form should display a set of records. In case when the user doesn't specify anything in the combobox on the form (value=NULL) I want the query to display all the records (like "*"). For some reason when i put the following in the criteria of the...

Hi, I finished a db for a client to help her keep track of the classes she teaches, her students and other related info. The db has several tables and one main form with subforms. I read that it was a good rule of thumb to design the fewest posible forms to make the navigation centrilized and...

I read some solutions to replacing a default Access icon for forms. However, I was wondering if there is a simple solutioin to removing them all together without causing an error?

I think the changes will not neccessary be limited to one or the other, so I was wondering if there was a different solution. In addition, it is not a network so everything will be sitting on the client's single PC.

So I finished my database :) ... then it was time to make it look as if it wasn't an Access DB. I read all the very helpful threads on converting to MDE, hiding access window, starting up my form, placing an icon in my main form title bar so I'm almost set but before I go ahead here is my...

I'm having troubles understanding and picking the right event for a particular action in forms. For example I want to set the background of a form to "15911239"; which event do I pick? I know that Oncurrent will work but I don't neccessary want to "set the color" whenever the record changes...

The problem is that I cannot use a label becasue the only thing I was able to show/hide on a per row basis in a continuous form was a text a textbox. In the end I think this is the final solution I'll use for the problem posted in my first post: 1. Create a textbox with source...

Ok, I still can't figure why this doesn't set the value for my combobox :( Private Sub NewClass_Click() DoCmd.OpenForm "frmClassRegistration", acNormal DoCmd.GoToRecord , , acNewRec Me.IndividualID.Value = Forms![frmIndividuals]!IndividualID End Sub This only opens the form...

Can anyone tell me how? I read various pages on conditional formatting and wasn't able to figure out where to insert the vba. And ff I try to initiate the code on any event (either oncurrent, onLoad) I'm back to square one where ALL buttons change at once and that doesn't help in my continuous...

Thanks. However, like I said even though I check Is hyperlink property to YES i still don't have a property with hyperlink subaddress. It normally should be under properties, right?

http://www.access-programmers.co.uk/forums/showthread.php?p=457389#post457389

new ideas So I'm still working on this one and figured some workarounds (rather ugly I'd say) based on another post. Maybe it will serve as a springboard for someone to find the final solution to this problem. New idea: Instead of a button for every record I created a text field with source...

I tried that as well but the problem stays the same: The button appears or disappears for all records in the continuous form and its visibilty is always based on the first record. I want the button to appear only for the records that have something in the note, so the user knows there is a note...

This doesn't work for (my) combo box and I think for combo boxes in general?

I have a form open with an Individual ID (autonumber). A button opens another form (frmNewPayment) in which i would like to add new payment. The frmNewPayment has a combo box with 2 columns (IndividualID, LastName). IndividualID column is bound and hidden. I want to set value in the combo box...

Thanks for all the suggestions. However, this still won't work. First of all, if I right click on a button there is no "Conditional Formatting" available (like in the case of a text box). Therefore, I tried to initiate some code but the problem is when and where? As I said in my first post if I...