Access 2003 - Report Problems

I hope someone can help, I am at my wits end on this. I am doing my taxes and made a database to make retrieving and totaling my information easier. I finally figured out how to retrieve a report from a table but when I did, a field I had hidden on the table portion came up on the report as well. My question: How do I hide the field on the report that is hidden on the table? Question 2: How in the world do you get a field to add and have the total come up at the end? It seems so easy but I cannot make it happen. Ideally I'd like to get it to calculate it at the bottom of the tabl

Continued frustration with relationships and queries

So I thought I figured out how to create relationships and run queries but now I am running into a new problem. I will do my best to describe it. I have a table that I am using from prior months with all the Regions, Sub-regions, cities, and zipcodes. It has multiple months of data. After I create a relationship between two tables at the zipcode level I then create a query to fill in the Region, sub region etc, I end up getting 1000's of duplicates. The table that I am mapping from has many months of data while the table i'm mapping to has 1 month. How do i tell access to on

Grouping Form

I am would like to create a form that displays data based on what the user selects. Ex...I have a table the has customers and their orders. Each customer can have more than on order. I would like to set up a form that a user can select/lookup a customer and all their orders appear in a list format. I would also like the user to be able to add in new orders from the form. Is this possible?

Which Version of Office 2007 to Buy?

Hello, I get academic pricing for office, and for me Office Standard 2007 and Office Professional Plus 2007 are both being offered to me at a cheapter rate than the Home and Student Edition 2007. But it seems that Standard and Professional have more to offer than Student? Are the basic programs (word, excel, and power point) the same in all three software versions? Why get one over another? Thank You for your help.

Pass field value selected in Combo Box to SQL Query

Hello, My form displays a combo box populated by a SQL SELECT statement. The user will select a row from the combo box. I then want the value in a field of the row selected in the combo box to be used as the selection criteria in a SQL statement. The SQL statement is a nested SELECT and the value selected in the combo box is the selection criteria in the inner select statement. The problem is how to pass the value selected in the combo box to the SQL query. Also, I have the following problem . When I call the SQL query by clicking a button, a window popups asking me to ente

Updating Date with Update Query

I have inherited an Access 2003 database that has a table that stores Invoice Number, Invoice Month, Quantities, etc. A user in my team has pointed out that while each record has the Invoice Number filled (because it is part of the primary key), many records are missing the Invoice Month (an optional field.) This user wants the Invoice Month filled. I created an update query to fill in the blanks in the Invoice Month field. In the design of this query, in the "Update to" field I am using an expression like this: IIf([Inv Number]=2,1/1/2010,[Inv Month]) I was planning to run this

Opening a database with a new form

Hi I am creating a database in which when users open it, it defaults to a single form. At the moment, when they open it, it opens on a record. Is it possible to open it so that it's a new form (i.e. record) instead of a previously created record> Thank you in advance for your help.

multiple column lookup

My multiple lookup column displays 97203 15 12 when I want it to display 97203 C025 Portland The data for the lookup column is stored in another table in these columns primary key (autonumber) value 1 value 2 Thanks! I have tried everything I can think up----twice.

HELP!

OK I admit that I am a beginner and know next to nothing about Access. My boss is asking for me to create a database and include some relational, indexing, and sorting options that seem pretty basic to me. However, I am quandried as to how to accomplish this. Let me break down the project here: I am creating a customer database. This database needs to include the customer ID set as the primary key. Then I need to include the year the customer was active, for example 2010. Then I need to include all the customer data, such as first name, last name, address, city, state, zip code,

Reports

Can I use Access to create multiple reports for printout? I have a table with many records. At any time people need to be able to printout a report for each record based a date or range of dates. When quried based on the query range I could have anywhere from 0 to say 100 reports to print. Is this possible?

Search My Report Help

I made a report from a table that is a list of files with their hyperlink, a description column, etc. I want to make a report that has a search button at the top, and can be searched by All columns or the few columns I have. I have tried to search for answers and am new to Access. Can someone give me a good resource, give me some code help, or tell me if this is possible?

Still confused on relationship queries and similating a vlookup

Normally I would just dump this into excel, but the file that I am dealing with has over 1.5 million rows so excel can't stomach it. Here is what I have done. I have one table (MAIN) that is my main table. It contains all the raw data. I need to convert a city code to a city name. I have another table (CITY) with the conversions from city code to city name. Both tables contain all the city codes. All I want to do is put the city names into my MAIN table next to their corresponding city code (there are about 4000 different cities). I have related the tables relating the ci

Create a query to merge records with two fields as criteria

I've got 2 tables, one with company locations/addresses and another with contacts for the company. Table 1 has an ID field for the company name and and ID field for the location (for that specific company). Table 2 has each contact's name with the ID fields for company name and location. For instance, Ajax Co has ID of 1; it's NY location has ID of 3. Joe Smith works for Ajax in NY. How do i create the query to pull on ID field first and then on the location field?

Information retrieval based on non-unique fields across separate tables

I am pretty new with Microsoft Access database trying to retrieve information from a very user-unfriendly database build by some genius who never uses the database himself. Most people have trouble retrieving data and just did manual copy and paste from Access to Excel (imagine the pain not mentioning the amount of potential errors). That should give you some idea how unfriendly it is. However, before I start wasting my time doing manual copy and paste, I would like to see if there is another way out (which I believe there always should be). The situation should not be difficult but I l

Can access work with multiple FX rates?

I have to produce a monthly report that uses employees data. The yearly salary will be in local currency and I will need to create a query (and a report) to divide the salary by 12 so I get the monthly gross salary and each month I will need that monthly figure to be calculated in USD. But the FX will change on a monthly basis (but the past months will stay the same). can access do that if I have a table with the FX rates by market and month? Every month I will update the FX rates and will need the monthly figures to re-calculate. THANK YOU!

Uppercase 1st Letter

How do I format a field so that the first letter is always capitilized. I know to use the greater then sign to display text as all caps, but I just want to make sure the first letter in a customers first/last name is capitilized.

How many tables .. in Access 2007 .. are there limits ?

Hi, Is there restriction for number of table in Access 2007... what are maximum number of tables can be used..? thanks in advance... Dr. Khalak

Contact Record Sort

I have a database with over 200 records and the primary key is an auto number for each contact. When the information was exported to the database, it was exported with last name sort and each individual has a unique auto number. When I add new contacts to the database, it generates a new auto number which is fine, but the new contact with last name starting with "A" is the last record, can the database sort itself with last name before closing? Deeds37

Auto Fill

I'm trying to enter employee training information. I want to be able to type in an identifier (last name or employee number) and it will bring up information showing what training they received, and the date they received it. I know I have to make a table with all the information I need, but that's where I'm stuck. I dont' know what to use (form, query, etc.) and I don't know how to set any of that up. Basically, I'm totally lost :( Any help is GREATLY appreciated!

microsoftin.com as a google organization

none ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=2a52b5ed-b0a2-450e-a610-5b131cccbadb&dg=microsoft.public.access.gettingstarted

Tab control within a tab control

Hi I have created a Case Management Database which has 5 themed sections: Personal Information, Personal Assessment, Personal Plans, Case Notes, and Other. I also have created almost 30 forms dealing with different information that must be collected on each participant. Withing the Personal Information themed section, there are at least 8 forms. In Personal Assessment, there are 8 forms, and etc. Is it possible to create a tab control within a tab control or should I create a subform which includes all the forms for each section and then put these subforms into the tab

Conditional Formatting

In my data base I am asking to color code field "A" in green if the amount is less than filed "B". I have also asked for field "A" to highlight blank records in purple. Can you ask for different colors and different criteria of the same field? I tried doing this and it worked for only the purple expression and highlighted in green the oppposite field of my expression? I hope this make sense? -- Merlin

Query will not sort

I have made a query and it will not sort one of my fields. I thought it was a simple query but maybe not. Field: Area, Sort Ascending Field: OrderNumber, Sort Ascending Field: Status, Criteria Like "*Y*" Field: Week 1, Criteria Is Null It will do everything except sort on the order number. -- Lenee

Date, Time location Stamp

Sometimes when proposing a meeting the Date time location get put in the message box. How do I initiate this to happen for all meetings? see below example When: Wednesday, February 24, 2010 9:00 AM-10:00 AM (GMT-05:00) Eastern Time (US & Canada). Where: Lupine - 8 - SR *~*~*~*~*~*~*~*~*~* -- CharleneN

Problem with report

I have built a query that is sorted by last name and when I hit run it works. When I put it in the control source of a report it doesn't sort it correctly. What am I missing or doing wrong? -- Lenee

Update UnitsInStock

I have a problem with my UnitsInStock value. 1- Req4 form contains an entry field for QuantityIssued 2- Products2 table that contains the UnitsInStock value. 3- Req4 table contains Request detail data The forms record source is a query that joins the 2 tables using a product number. As it is now the user must manualy change the UnitsInStock on the form by substracting the QuantityIssued from the current UnitsInStock. I want the UnitsInStock to update itself after the QuantityIssued is entered. I have tried AfterUpdate code and expressions with no luck.

Query Problem

Hi, I have this query but is not working. SELECT BKAR_INV_NUM, BKAR_INV_SONUM, BKAR_INV_INVCD, BKAR_INV_INVDTE, BKAR_INV_CUSCOD FROM BKARINV WHERE (((BKAR_INV_INVCD)=' ') AND ((BKAR_INV_CUSCOD)="SCOENE0100")) OR ((BKAR_INV_INVCD)="X")); I need it to show all records for SCOENE0100 that the BKAR_INV_INVCD are either "X" or " " Thank you all

Having problems understanding sub-form selections and uses of comb

Access '02: Hi all, I guess i'm having fundelmental problems getting my sub-forms and combo boxs to work for what i'm trying to attempt. I've posted my first problem with use of 'drop down combo box" and getting it to show me the text in the destination field already. I've made progress with that. Now i can't get a grip on the use of sub-forms and combo boxes for my next part. So i don't burden you to much can anyone recommend any useful visual demos or examples for these. The online help is of no use to me for my needs, and i can't find anything specific at the online sup

How do I retrieve my ID code.I have already registered.

I am trying to put my ID number into my product number area but after registering no code is coming up. What do I do?

marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 54393

Contato: marvendas@gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ 1900.00 Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar! Audi a3 automatico Audi a3 1.8 t automatico Audi a3 1.8 turbo automatico VW Golf gti automatico VW Golf 2.0 automatico VW Golf 1.8 turbo auto

Combining two fields in a table

I have a 5-digit zip field and a 4-digit plus-4 field. I created in my table a 10 digit newzip field, so that combining these two make a 9-digit zip that looks like this: 60016-2345. I have no problem creating this in a query, but I want this to be in a table, and then I will delete the existing zip and the plus field, then re-name the newzip as zip. How do I do this? Can I convert it from the query into a table? I know this is basic, but I'm really new to this -- Barry

Forms Field List

I am using a form that someone else had created but I wanted to add a check box to it. I added a field in the souce table but when I go to the form in design view the new field is not listed. What am I doing wrong?

Open mode

I have Access DB 2003 that I splitted it to front end and back end. I will put the back end in shared drive and the front end in users' hard drives (4 users including me). No one except me needs to make change to the front end. Should I set the open mode of the back end to "Shared", the front end of each user to "Shared" and my front end to "Executive"? Thank you. Gina

Fiscal Six-Month Periods

I have a database with a bunch of dates in it. I'd like to create a new calculated field that designates the associated date in a six-month period through a query. The periods go from April 1st to September 30th (1st half of our fiscal year) and then from October 1st to March 31st (2nd half of our fiscal year). So, a date in OBLG_DATE of 6/1/09 would be designated in the new field SFY_SIX as something like 2009S1. A date of 11/13/10 would be designated as something like 2010S2. Thanks for your help to this quite novice user in advance.

Counter

I want to add a column to an existing query that is a counter. Example of data and desired result below. The criteria is: If Name, Symbol and Date are different, counter changes; if Name, Symbol and Date are same, same counter as line above. I read about DCount but was unsuccessful. Any insight or direction to reference material is most appreciated. Name Account# Symbol Date ANDREW 12345 AAA 08-Jan-09 ANDREW 12345 AAA 20-Jan-09 ANDREW 12345 BBB 20-Jan-09 ANDREW 12345 BBB 28-Jan-09 BOB 98765 CCC 30-Jan-09 BOB 98765 CCC 30-Jan-09 BOB 98765 CCC 30-Jan-09 Want Counter

Data type mismatch

New to Access 2007 I'm putting together a database. One of the fields is test scores which have a value of 0 through 100 OR "ND". They aren't willing to get rid of the "ND", so I have the field set to "Text". Is there a way to create a validation rule that limits input to these values? A combo box with 100+ values seems awkward. I tried: Between 0 and 100 OR "ND" but I got a type mismatch error. Thanks

Form field sizing & alignment troubles, using related tables

I've got 1 day under my belt with Access, so I don't know a lot more than I do... I'm "scrubbing" attributes from blueprints that we have scanned. At the moment, the blueprint scan is identified by a bar code, not very helpful when you have 1800 of them. My Access database will list the bar code number as the primary key along with attributes (water, sewer, sidewalk, easement...) listed on that blueprint. Our goal is to generate reports can be run considering street address, and the attribute(s) in question, allowing us to view only the scans of blueprints that would pote

Images and thumbnails questions

Hello-- I am running XP Pro, with Access 2007. I have several folders, each with hundreds of image files-- most of these are photo .tifs. I would like to make a database that contains the file names and key information about each file (date it was taken, what it is a picture of, etc.). I want this database to be searchable by users, who will be prompted to enter criteria for specific attributes ("The photo(s) you are looking and from what year(s)? _____________"); users must be able to answer in plain language-- the users cannot be required to enter any code or anything othe

installing office home and student

I purchased a copy of office home and student and was wondering if I needed to uninstall the copy that came preinstalled on my computer before installing the new copy.

looking for CD1 for microsoft compatible 3 comp 3

i am trying to down load microsoft word for one of my kids projects

Access 2007, Query's prompts parameter twice

For some reason my query's ask for a parameter twice when run. I then copy the code into a new query, delete the old query and rename the new query to the old name and everything works. It seems regularly this will happen and I have to redo all that are affected? This access 2007 install has the latest patch from MS. Am I doing something wrong here or is this documented somewhere so I can fix

How do I get rid of "getting started with Microsoft Office Access"

I've just "moved up" to Office 2007 from Office XP. How can I get rid of the annoying Access startup page, "Getting Started with Microsoft Office Access", or at least modify it to get rid of the "Featured Online Templates" and "Microsoft Office Online" frames. I prefer a clean, uncluttered interface, as in Access XP. I know that you can avoid this by opening a database file directly, but that isn't always the most efficient method of working. Thank you.

open form/subform at specific record

I have a form (repair status) the has the same field (work order #) as another form which is actually a subform(work order detail) to a main form (Customer data). What I want to do is double click on the field (work order #) and have it open the form (customer data)/(work order detail) at that specific record. I selected On Dbl Click to run a macro that opens the form where both field match. That works but it pulls the customer data form and the work order detail but it goes to the first work order detail associated to that customer not the specific on i clicked on. Any id

New User Help with lots of information

I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the

Ten calendar harm one of the products

Ten calendar harm one of the products www.laptop-battery-inc.co.uk/spy-pen.htm

field references in forms

If I have a form "myform" with recordsource "mytable" and the table contains a field called "id," I can reference the current value of that field in expressions used for controls in the form by myform.id. This is true even when there is no control bound to mytable.ID on the form. I can "print" the value of myform.id in the debug immediate window. If I try the same thing for a form whose record source is a query, ? myform.id produces an error. Why the difference? And a corollary question: what's the most efficient way to test the values of expressions, for example the con

Photo Directory Template

I am looking for an Access 2007 Photo Directory template. I am trying to make a members database that will print a photo directory for our church, but I am having a hard time because I don't know Access well enough to make the form and report work right together. Any help is appreciated! Thank you!

Change receiving email for microsoft.public.access.gettingstarted group

I am retiring 2/26/10 and I need to change the receiving email for this and other groups to my home email address. I went to two places that I thought would take care of it but the one place wouldn't let me put in another email address. I believe I could only change the sign- on name. THe other place said I couldn't add a gmail address because the group couldn't go to a gmail address. Please help!! Thanks

outlook 2010 beta

i'm not getting any replies from all the questions i have asked on discussion groups .Why is this? where do i access the replies for my questions only? Secondly, i have installed the MS Office 2010 beta and am not recieving any mail inbox or showing any sent messages even though i am sending and the outbox is empty and i am recieving but the inbox is empty, I check the box here to notify me of replies and recieve nothing

57 R4I :COMPRAR

Nuevo Modelo R4i para Comprar R4i para nintendo Ds, Ds Lite , Dsi y Dsi XL http://www.elotrolado.net/hilo_r4i-comprar-nuevo-modelo_1373328#p1718911991 www.Dsiconsolas.com Chao T_bV,.e*u<>l%SO@vLKJDv,P)