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 guess i don't understand, I open the report and it gives me a prompt. I enter the # and press ok. I'll have to try using a form and get back to you. Thanks Edit - It is only one parameter (Job#) that will be used to filter the data. I couldn't figure out how to make it work from a form...

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'll give that a try, thank you very much.

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

Nevermind, I'm an idiot. I searched here and the answer was in the built in help files :(. Sorry for wasting your time

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

still no joy I'm beating my head against my desk as we speak...How in the world do I make a textbox show a particular column of a table based on a combobox's entry?

in the afterupdate for Resolution, click the ... and choose code builder. In the code builder insert this: [date resolved]=now() i believe that will get you where you want

ok, new approach... I have all the class and scores in 1 table (5 columns) how would i go about making it display a differant column based on the selection of an age from a combobox. column1 = score column2 = young age group class column3 = middle age group class column4 = old age group class...

I need them to actually input an age, the report that will follow shows actual age. I have been trying using a seperate tables and treat this like a cascading combo box (each table has scores 1 - 300 and the class value for each score is in the second column) so based on age (ie "17" or "18" or...

Completely over my head please elaborate a little, I am still WAAAAYYYYYY new

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

thank you Rich, can you believe that most of the problem was that I was spelling calendar like this: calendEr just goes to show you how much the details matter, thanks again

I'm horrible with SQL Rich :( do i put that exact code in the form's "on load event" or somewhere in the calender?

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