Recent content by t3nchi

my departments seems to want to add some sort of notification feature to our database. It's supposed to notify the department when a certain date is approaching. How do you even begin to think about adding this feature into Access? I don't know where to start. I'm no Access guru. :confused:

I want to create a query that pulls up records based on 1st quarter,2nd quarter....January, Feb.... How can I do this without writing a separate query for each one?

It's a whole nuther set of data that I need associated with the same info. For example, I have Company A. Company A has a set of data (address,phone,name of CEO). It's more exclusive. So table 1 will look like this: Company A, (254) 292-2932, George bush Company B, (232) 207-3939, Dick...

I have a mainform. I select from a couple of combo boxes. Based upon these selections, it pulls up appropriate info in subform #1. There is a field in subform #1 which I want to populate a field in subform #2 with (automatically). What kind of "event" is this? After/before? I tried everything...

Yes, basically that's it. I have an idea but not organized yet. Let me see if I can figure this out...getting close.

If there is no way, please let me know there is no way so I dno't pursue empty air.

bump bump......

anyone? i'd appreciate some help, thank you all

Hi everyone, first off, I did a search of "combo box fields" and it turned up some results but after going through them, I still didn't think it answered my question. I want to create a combo box of fields from a table. After selecting a field, I want to choose from another cbo either "Yes" or...

Is it possible? My departments wants a calendar that reminds us when a certain date is approaching. MS Outlook has that calendar. Can we integrate them somehow? Or do I have to write something in Access(is it even possible). Or do I just have to look at different software out there? Thanks.

thanks mst

I have 2 cbo boxes : Year and Company A certain year might have multiple entries for the same company. I want to have the company listed once instead of multiple times. How do I do that? Thanks.

I just got my arse handed to me. That code you put up, I misinterpreted its use so I didn't put it in. Now I know that THAT was what solves my problem. oops... thanks man! I had just created the Command button and didn't write the extra code in.

I think that may be what I'm missing. Let me try it out. Yea I saw that but didn't think it had anything to do with my problem.

Hi ansentry. Only 1 table for all three forms. Just dif queries picking up dif fields for different forms. Add mode = form opens completely blank (so you can input new record) Edit mode = form opens with a record displayed...you can scroll through them And yea I figured my queries wouldn't be...