Search results

a little background - I am in charge of a maintenance department that fixes aircraft for the military. I am about to deploy with 6 of these aircraft and I'm trying to make a usable "inspections due" calendar. I have some experience with Access but can't figure out how to make this work. the...

I apologize in advance if this has been covered, I couldn't find what I was looking for by searching. I have a fairly simple database that is storing subcontractor & spending data. I want to be able to select a job# and display all the data that pertains to it. This part works fine, but I...

I tried searching the forums and haven't come up with anything that sounds like what i'm looking for. I have a VERY simple database that has a list of personnel and whether or not they are available for an event. I would like to have a command button on the form where I change the availability...

To make a long story short I have a command button that runs a query and opens a subform based on that query. I want to be able to update the records that are returned (via the subform) but I am getting an error - "This Recordset is not updateable". I've tried changing the recordset property...

I have a query that selects from a table base on 3 entries (Name, BeginDate and EndDate) and should show me 12 other columns and their entries... I have 9 entries for a particular Name, but when i run the query i get 15 results. Some are duplicated but others are not and I don't know where to...

I searched and don't quite understand how to use a combobox selection to open a specific subform. I have a combobox with 14 choices and I'd like the specific subform to show based on the combobox selection (the data for each selection is stored in it's own table). If someone could break this...

I tried a search but wasn't able to find what I was looking for. I would like to be able to use a form to run a query in my db. I need to use name, begin date and end date and then have a button to run my query. My problem is that I can't get the unbound text boxes (for the dates) to use a...

I'm trying to figue out a way to make my database catagorize based on 2 variables, here's what i've got. one variable is age, [age] and is entered directly into the form the other is score, [pft total] and is a calculation performed with afterupdate functions. what i would like to do is based...

I've tried searching the forums and haven't found quite what i'm looking for. I would like to be able to change the source for a combobox based on another combobox. The simplest way i can summarize that is i want to be able to choose A or B, depending on my choice i want another combobox to...

I have a calender in a form, but it defaults to the day I placed it there (in this case Aug 20) but I want the default to be date(). Any suggestions? jim

I want my database start form to maximize on open, but the other forms to remain as I have set them. Right now I have in the onActivate event DoCmd.Maximize and it maximizes everything. Any suggestions?

i need to import a list of names from another database. They are stored as 3 fields now: [last], [first] and [int], I want them all in one field that should show "last, first int". How do I go about doing that?

I forgot to alphabatize my reports when I made them. Is there a way to go back and do it, or do I have to remake the reports?

I have a form with many fields, 3 of them are [male / female], [height], [maxweight]. The height/weight standards are differant for men and women (for the military), and I have them saved on 2 seperate tbls. Here's where it gets tricky (to me). I have a combobox on the form that lets you...

My switchboard has a subform on it that doesn't allow me to change the data (in this case check boxes). If I open the subform alone it allows me to, only when viewing it through the switchboard is it locked. Where do I change the property to allow updates?

hopefully this is an easy one :) I want to force the user to choose an item from a combo box the FIRST time they open the database. Then I want the db to use their choice in the title of the report already built. Do I need to make a seperate report for each choice? thanks in advance

i have a table that has job title, but i need to seperate them into 2 groups and sum up the totals. The titles are id'd 1-9, 1-5 are one group and 6-9 are the second. So my ? is how do i get the query to sum up the total of people with TitleID=1-5 and a second total where TitleID=6-9? I'm...

i have a combo box that pulls information from a query. I want to populate 4 other fields with the appropriate columns after update. I just haven't figured out the code yet :( I have the columncount & width property figured out, I just don't quite understand how to get the other fields to...

I have placed a command button on a form to open a report, but rather than show me just the information on that form, it gives me every record on the table. How do I make it just show the current information? thanks

I am setting up a database to track a call log (I am going to be a recruiter for the Marine Corps soon). I have a query built to show me anyone I haven't called back in 6 days. The problem is I need a way to mark a call as updated if I have called more recently. In other words only query the...