Recent content by carolineJ

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

Excellent! Thank you!

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?

Hi Nashman, I have done this and the decimals shows. How ever a number that was say 4.152 in Excel shows up as 4.000 in Access. The decimals have been deleted some where in the conversion process.

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

problem solved! thank you a lot BNPMike!

moving up so that BNPMike or anyone else can see it

thank you BNPMike, but can you help me a little more? I tried your second suggestion, i.e just write an insert query that will add all the new records but it din't work. I made a test table consisting of three product with product number and price, then I made a second table (identical to the...

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

No one has a clue?