Search results

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

got it, thanks for the help Rich.

yes, i'm trying to count them. I used what you last posted, but it doesn't return a total, it is extracting the appropriate records and assigning them "1" as a result. I tried using count, and sum and it doesn't seem to make a differance.

like this? IIf([TitleID] Between 1 and 5,[worker]=+1,0) IIf([TitleID] Between 6 and 9,[supervisor]=+1,0) and will that work if the numbers are 1 or 5, or must it be between them?

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

Jerry, you are officially my hero! I should have thought of that.

The query has these fields [MarineName], [MarineRank], [MarineDutySection], [MarineSSN] and [MarineShop]. Combobox is [Name], and it's source is [MarineName]. I want other fields in my form to fill in the appropriate information based on what name is selected. I used the following code...

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

YAY Got it! I think what was throwing me off was that [myid] & [idfield] happen to be the exact same thing in my case. It works fine now. Thank you all for your patience.

let me see if i have this. I have it using an autonumber to be the primary key. this field is called [ReqNum]. so [myid]=[ReqNum], but what does [idfield]= ?, the name of the form that contains the field in question? sorry, i'm just not overly familiar with the lingo of database's. thanks...

I'm afraid I don't understand, what is [myid] in the example? Wouldn't this prompt you for input?

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

It only shows me the first entry now, am I adjusting the correct property? I opened the query in design view, and in the top portion where you place the tables you want queried I am right clicking and setting the top value to 1. I'm trying to get it to query me the most recent call for every...

I found a website that I use to make logo's for my own database's, what better tribute than to submit it to the people who helped me build them. CoolText

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

i searched on google for pictures of what i wanted (in my case my squadrons emblem) and inserted them onto my switchboard(use design view). jim

is there a way to make a command button email a report to an individual (the same individual everytime). My database tracks an inventory of hazardous materials, when I get to my "low limit" I order more. The database has a report that identifies this for me, but I like streamlining things...

in design view, select the field that you want queried and in the criteria portion enter "Canada" (be sure to include the "" around Canada). This should return all records with Canada in that field. I don't know if it is case sensative though. Hope i helped, heaven know's i've gotten enough...

i got it, thanks for the help

this is the route i'm trying now: when an item is checked out the [qty checked out] has an after update query macro that subtracts it. then the [qty checked in] has an update query macro that adds back in all the items not expended. the first part works great, but for some reason the second...