Search results for query: *

I have a field called month in a table with values from 1-12. In my query I want a calculated field that shows the name of the month instead of number, i.e if field month is 5 then the calculated field is "May". I think I can do it for two months (if month = 1 then "January&quot...

I'm now finished with the design of my DB. I now want to share it with my 25 potential users. We have a network with a server (G) that we all have Access to (certain folders at least). I would like a tutorial, FAQ or something that can guide me trough this cause I have no clue on where to...

I have a form called register a new project. One of the fields in the form is called project manager. It is a drop down list and the choices available are taken from a table with all project managers. How ever they are not sorted in alpabetical order so it is really hard for the user to find the...

I'm just done with my first database. The Access file is on my computer now I only have to distribute it to the users (about 25 people). I have no clue how to go on. I guess I should set up accounts and define what they can do and can't do and give myself and admin account, put the access file...

I was wondering if there is any way to lock an Access table at a certain field so that when you scoll to the right that field and those fields before that field are always shown to the left? For example if you got a table with lets say employees you want the field with their name to always be on...

Perhaps this is a silly question but is a possible to use another font style (for example bold or another font size) for certain posts in a report that you want to highlight?

I'm trying to import an Excel sheet to Access and it's going pretty well. How ever the Excel sheet I want to import dosen't show any decimals (of course the decimals exists but they are not shown). When I have imported the spread sheet to an Access table, the decimals are gone. I don't want to...

I have a table with products- One of the fields is product price. Once a month I get a new price list in Excel format from our parent company consisting of product number and the new price for each product. I convert this list into a a separate access table and run an update query which changes...

I have a report based on a query. The query in turn is based on two tables. The first table is a list of main projects and it has a counter as primary key, i.e the first main project has ID 1, the second 2 and so on. The second table is a list of projects where you have project number, project...

I have made a database over my company's investment projects. One of the fields in the investment project table is project manager. When the user registers a new project he or she can choose a project manager from a drop down list. The available project managers come from a table of project...

I have this bug in my query that really bugs me. The thing is one of my fields in the query is supposed to be a sum of two fields in a table, i.e Variable 3: [Variable 1]+[Variable 2] This works just fine, except for one case. When the first variable happens to be null (i.e not zero but...

Just a silly question. Does anyone know how to create a label spreading over two rows to save some space in your report? For example: "Final cost" could be written as Final cost instead. I have tried to just hit enter but i doesn't work.

Hi, this has probably been up hundred of times already. I have tried to search the forum for an answer for about half an hour now without any result (probably because I express myself different than someone with English as their native language) So sorry for posting this simple question: I...

Hi. I have a simple question. I have a table and a query that calculates values using numbers from the table. I want to change the name of the table because it is not very descriptive. However when I do this, my query dosen't work anymore because it can't find the table anymore. So does anyone...

I have designed a form for entering new projects into our project database. In one of the controlls the user should enter the name of the project manager for the new project. I have made this controll a combo box so that the user can choose a project manager from a drop list or just write the...

Hi I have a silly problem that I can't solve. I think the problem is that I'm new to Access but an experienced Excel user so I think "too much Excel" when I try to solve my problem if you know what I mean? I simply need to paste a column from an Excel file into the corresponding...

Gaaah! Now I'm angry. I'm designing a report from a table and in one field (price) I don't want any decimals. Therefore I have clicked on the controll for price in the report (design view of course), clicked the Properties button and set Decimals to zero. Yet in the report, price is still given...

Everyone in this forum has been so nice to me so I bother you with another silly question: Is it possible to rezise a report, for example shrink it to lets say 70 % of original size, when you print it out?`I know it is possible to do in access but that option dosen't seem to excist in Access...

Hi. I'm doing a report from a table in Access. The table contains information about my company's investment projects. Our projects is divided into two different project categories; Production or Distribution. Therefore, in the report all the Production projects should be listed first and after...

Hi! Hope someone can help me because my boss has asked me to create a report from a table in Microsoft Access. The table has more than 50 columns so I want to print it in landscape format. However there is no way I can fit all the 50 field names in just a little more than 2 pages. How can I...