Search results

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...

Too big to post. But i found out a couple more things. Anytime the form is in "add mode", the ID doesn't match. The 2nd form will start a new ID. Only when it's in "edit mode", then the new form will have the same ID.

BTW, his forms deal with 1 table. I have three forms. Each comes from a dif query. All queries are querying the same table however. Do I need some sort of special query (joint queries or something)

That's what I'm trying to figure out.

I need to revive this topic because I still haven't solved it. I have a form in Add mode. I enter date in the form. I want to click 'Add Record' and want a form (that has other fields related to SAME record from first form) to pop up in edit mode. These fields are empty. Ansentry's code didn't...

I leave access open (switchboard showing). And when I lock my computer to go do something and unlock it when I come back, the VBA windows pop up. I have to close the VBA app. Any idea why this is?