Search results

DBGuy, appreciate your help!

I have a text box on my Form with some details relating to each Name1, Name 2 etc so when I selected Name1 from the second combobox I would like to display their records. Sorry if I wasn't clear the first time, appreciate you taking the time to assist me.

Thank you, I will try use the Case statements.

Thank you all for the replies! I just noticed DBGuy that I can select and view the values but it doesn't filter the list. It's not acting as a filter as I would have expected. Any ideas? Thanks again

I figured it out, thank you for your help. I hope you have a nice day.

It is! Thank you DBGuy, your help is much appreciated. May I ask how you managed to do it and if it would work if I had 10 column names and I only want a subset of them to be included?

Thank you!

Thanks for taking the time to reply. I did and either it's different to my problem or I'm just not smart enough to get it. In combobox 1, I have a list of column names in Table A, a,b,c,d,e - these are not linked to anything. I need combobox 2 to "read" combobox1. if the answer to combobox1...

Thank you I have searched everywhere but unfortunately I am unsuccessful in my attempts. Is there a way I can pass the value from combobox1 to a select query in combobox2? i.e. if combobox1 = 'a' "select a from Table A", if combobox1 = 'b' select b from Table A. I'm really stuck on what to...

I don't think I explained myself too well. I have a combo box that has fields a, b ,c ,d ,e... These are column names in table A In combobox1 - I will select a or b or c or d or e combobox 2 will then show me if a - customer names in Table A if b - customer addresses in Table A …. Thank you

so combo box1 has the column names and combox 2 will apply the filter

Thank you for the reply. What I want to do is apply a filter on the table based on the value I enter into combobox1. If I choose "name" in combobox1, I can then filter the table on the value I select in combox2. Sorry I'm still in school and not too technical, I am just learning Access in...

Hello, I hope someone can help me. I have a combobox with an on focus event that is equal to "customer name", "customer age", "customer address", these are all column names in the Customer table. I would like a second combobox that will query the customer table based on the value that is...

Hello All I am very new to Access and I hope some of your experience and knowledge can help me out. I have a main Form called 'Orders' that can have 'OrderTypes' that are constantly being updated. I am looking to create a subform (sub form will be a pop out window) linked to the main form...

Thank you for the replies.

Thanks all for the replies. I didn’t explain myself too well. I have 50 stock orders that are due on business days throughout the year. They are due at different times. What I was looking for is vba code that will add the entries into a table based on dates. for example, if I have 1 purchase...

Thank you for taking the time to respond. I have say 50 tasks, some are monthly, daily, weekly, some start on the 12th, 21st etc. I need to run a database query that shows me which tasks are due in the current month. I have the task list and when they are due, I’m just wondering how I could...

Hello All I have a question which I’m sure has been asked a million time’s before. However I am unable to find an appropriate solution. I am looking to schedule recurring tasks for the year, some are weekly, monthly, annual. Of these tasks some start on the 1st of month and others say the...