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?

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

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.

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

I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do. How do I do that?

How do I write a query to find the last audit date? Let's say the table looks like this (year,company,audit date): 2004, Company1, 6/3/2004 2005, Company2, 2/2/2005 2006, Company3, 3/7/2006 2008, Company4, 3/2/2008 Let's say I want to add a new record (in the year 2010) and pull up the last...

According to this code, I assume it's opening a form and linking the 'dateIncidents'. I want it to link another field as well. How do I modify it correctly? What I basically want to do is: 1) Click Add Record 2) It opens a new form that displays a bunch of new info to enter...which is related...

This is what I'm trying to fit into the control box. Maybe there is a much better way to do it so suggestions are very welcome. I don't know if I can even use "!" in the IIF statement. And I think it's too long, so it's invalid. What I'm trying to do is to check if all those fields are passing...

I have two date/time fields with a date & a time (ie. 1/1/2005 1:00 am) I want to use the datediff function to calculate the different in hours between the 2 fields. I followed the MSDN instructions (aka datediff(h,startDateTime,endDateTime) but got an #error How do i fix this? Thanks.

I want to add a textbox to my forms that either says "Yes" or "No" depending on what a non-visible checkbox is. My forms look funny with checkboxes all over the place (Yes or No fields). My reports would look better with "Yes" and "No" rather than checkboxes. The question is, the control source...

I have 3 forms. I open the very first one (main form). From there, I wrote a little VBA in the 'Add Record' button that if a certain checkbox in that form wasn't checked when I click 'Add Record', it would open up the 2nd form. The problem is, when I open up the 2nd form and enter info, the...

I have 2 time boxes with times in them. How do I get the 3rd textbox to display the difference between those times?

I have a form with a subform. The mainform has 3 combo boxes in which I select the right choices to pull up the right record in the subform. I want to generate a report for that record only. As of now, what I did was use a 'open record' macro. But this preview-prints all the records instead of...

I have a combo box whose row source comes from a table. I want ppl to be able to select from the combo box but I don't want them to be able to make any changes to its content (in the table). How do I do that? I've fiddled around with the Lock features in the forms but I cannot get the right...

I have a combo box which I pull values from a table which has 2 columns. When I pull down the menu, both columns show but I want the 2nd column to fill out the field. Not the 1st column (which it is doing by default) How do I fix this? Thanks.

Why does my subform appear in my mainform even without me choosing anything from the mainform combos yet? I have done this 'Choose combo and the subform appears' deal before and usually the subform doesn't appear until I select the combo. But now...the subform's showing, even if the fields in...

I have 2 combo boxes which I select a 'Year' and an 'Incident'. Based on 'incident', a listbox lists whether it was a 'bad' or 'good' incident. I only want my subform to pull up the record if the listbox says 'bad'. how do I do that?