Hulas
Last Activity: Apr 7 '08, 07:08 PM
Joined: Mar 13 '08
Location:
-
No, I don't think I have really found what I need. I will try to be more descriptive and let's see if that works. I have a table 'FoodandBeverag e' and this table has a field called 'Restaurant' whose data type is Yes/No. Now, I want to set up a form that has a list box with (yes or no), such that if I select 'Yes' from the list and press the 'OK' button I should get all the records whose check boxes are checked. Likewise, I if I select 'No' from... -
Sorry for not being so descriptive about that. I have a table whose one of the field is a check box. Now, what I have done is I have created a form that has a list box with 'Yes' or 'No'. The form also has a button call 'Ok'. Now, how should I programme the 'OK' button such that if I select 'Yes' from the list box than it will give me all the records for the field whose check box are selected. Likewise, if I select 'No' from the list box than it...Leave a comment:
-
Your code works fine with most of my forms, but it doesn't works where I have a combo box that pulls up more than one record. Any suggestions on that.
Thank you for your help.
HulasLeave a comment:
-
Thanks ADezii it works just fineLeave a comment:
-
It seems like I wasn't to specific with my request. You can consider any form with bunch of records to fill, that has a 'Save' button and 'Close Form' button on it. After filling up all the records, if I hit 'Save' it will save the data entered. Likewise, if I hit 'Close Form', it will close the form (Note: I have programmed the Close Form button so that it will not save the data.). Now, how should I programme the 'Close Form' button such that if...Leave a comment:
-
How to search query for a check box
There are some fields that have check box. Now, how do I search a query such that it will prompt the user to enter Yes or No, so that when I select Yes it will give me the records that are checked and vice-versa for No.
Thank you
Hulas -
No.
Thank you for your concernLeave a comment:
-
I fixed the pop up box problem, but that's not what I am looking at. The formula concatenates the two fields from Headliner and Act Name, but I don't want that. Lets's say if I have Michael, Jordan, and Brian for Headliner, and Ashley, Jannifer, and Britney for Act Name. Now, with the combox for Headliner, I should be able to scroll down to see all these six names but they should not be concatenated. Right now I am getting Michael Ashely, Jordan...Leave a comment:
-
How do I make sure that the user has saved the record before closing it
Guys I have a form with a 'save' and 'close form' button. How do I make sure that the user has saved the record before closing it. What I am looking for is that I want to modify the 'close form' button such that if a user selects the 'close form' button without saving the record, it will pop up a box that will say something like this" You haven't saved your record, do you want to save now;Yes or No"
Thanks you for considering... -
Sorry Joe, it still doesn't works the way I want. It pops up a massage that asks me to enter the Act Name. I am looking for a cmobo box to store both the Headliner and the Act Name information so that when I scroll down I can pick the one I need. For example let's say I have two fileds: Country and State. I have a form and I have a combo box for State. Now, when I scroll down the combo box for State, I should have the list for the records that are...Leave a comment:
-
Joe,
I made up those ID's so let me tell you exactly what I have and what I need. I have 'Act Name' and 'Headliner' as two fields of the same table 'Entertainment' . I have these two fileds as two combo boxes of the form 'Add Entertainment'. The records of these fields can go upto 1000. Now, I want to set up the 'Headliner' combo box in such a way that it will not only show me its own records but it will also show me the records for...Leave a comment:
-
Display two fields in a single combo box
Guys, I am still having problem fixing this. Let's say I have two fields in a single table called "Identification " and those fields are called ;ID1 and ID2. How do I get these two fields in a single combo box in a form. I know how to do for one. It should be set up in a such a way that when I scroll down I can select either ID1 or ID2.
As always thanks for your time.
Hulas -
Hulas started a topic How to add two fields to a single combobox and how to modify the close form buttonin AccessHow to add two fields to a single combobox and how to modify the close form button
Guys, I have two questions.
(a) How do I add two fields of the same table to a single combo box. For example if I have two fields ID1 and ID2 in a table called Identification, than how should I design a combobox in a form such that when I scroll down I get to see both the ID's.
(b) I have a (Close Form) button on a form. Let's say I am adding a new record from a form and I am half way filling up everything and suddenly... -
How to get a combo box for query criteria
Guys, I spend hours trying to solve this problem on my own but no progress. I am using a query and right now I have "Enter ID Number" in the criteria box. But, it is not possible to remember all the id's, so what I want is a combo box in the message box, that will still ask the user "Enter ID Number" but instead of having a blank box I will have a drop down list of all the id's so that I can scroll down and just pick my id instead... -
How to disclose attributes of an entity
Ok, this is little tough atleast for me. I want to design a form that has all of my seven entities and I want a check box next to each of those seven entities. Now, when I click any one of these check box, I should be able to get its attributes with a check box next to it. That means initially its attributes are hidden and they pop up as soon as I select the check box of the main entity. After I am done selecting the attributes that I want, I want... -
How to customize switchboard background
Guys, I want to add text and change the background for each screen on the switchboard and as always my question is how do I do that. If I open the switchboard in design view I can customize the background that will apply to the rest of the screens, but I have no clue on how to change the background for each sub screens.
Thank you for taking your time.
Hulas -
How to update records of a form from the combo box
Finally I made up my mind to give up and ask you guys for help. I have a combo box which I want to update its corresponding records as I make the selection. For example I have a combo box that has list of different countries and its attributes are state, city, zip code etc. Now if I select the country name from the combo box I want its attributes to update. Right now what I am doing is I am selecting the country name and than I am hitting filter... -
Transfer data from one list box to the other
I am designing a database prototype for my senior design class, and there are is a problem that I don't have any idea about where to even start. So, anybody out there, I will highly appreciate if you can take some of your precious time to help me out.
Consider I have a list box with three attributes (State, Region, and City) of an entity called Country. I should be able to select one or more than one of these attributes and there...
No activity results to display
Leave a comment: