Search results

Looking for guidance / books / help with this. Basically, I have a portfolio plan with about 50 linked projects. I have to manually export data into excel to manipulate and report. What I'd like to be able to do is have an Access database to read (or read/write - now that would be MAGIC) the...

Hi, I have a number of spreadsheets i receive from suppliers on a regular database that i have linked into my access 2010 database. The spreadsheets contain prices of stock we supply to customers, but some of these prices have more than 2 decimal prices. All the spreadsheets from the...

Hi there, I'm trying to copy an Excel formula into Access 2010 my formula (currently not working) looks like this: PRICE*(Round(Choose(MATCH 0,2,2.5,3),2.5,2.2,2.1),0)-0.01) The idea being that the PRICE will be multiplied by a matched number, if within a PRICE of 0-2, it will be...

I have a relatively simple spreadsheet that i am trying to import into a table (Office 2007). The data is copied from one tool (Primavera P6 - Proj. Mgmnt. Application) into excel - all good - top row contains field names. The data i am copying across is number of hours per month against...

I've built a database in v2007, importing various data spreadsheets from all our suppliers; it's for records and CDs. My requirement is two fold. What i'd like to do is create a form based on information from one table - tblalldata. I'd like to split this form into two sections: 1) - Top...

I'm appending a date to a table, with the format Now() Which is great as it gives me the date and time - thing is, i just want the date (not the hours, minutes) etc I have tried chaning the format property of this field to "short date", but no joy there. Any suggestions? David

Pretty straight forward question i think. Havent worked out a way of doing it yet, so any definitive answer would be good :rolleyes:

Using the query wizard, it's easy to set up a query to show all duplicate data. But how can i remove 1 instance of the duplicate? there's no restrictions on the data table

Hi, I'm using Access 2007 and two things I used to know how to do I have either forgotten or can no longer find. From within a macro I used to "setwarnings" to off so I wouldn’t keep having to click "yes" or "ok" - is there a different way of doing this from within a macro? Secondly, I...

I've an actions log database containing open and closed actions in a table called tblActions. I have another table called tblDefaults - this has a number of yes/no fields asking if the user wants to see open actions only by default when they open the form. I have a form for adding and...

this must be a simple one - I cant work out what I need to change on the form to allow me to amend the width of one field. Whichever method I use, when I change the width of one field, it amends all to the same width. Which form property do I need to change. Marvellous new feature in 2007? :)

I have a combo box in a table that shows text data and stores the Autonumber ID. That's all good. I have a form that uses this table, but as it's a form, i want to show the text rather than the ID... if that makes sense? I did think of using some code to show the text, but i dont know how...

I have created a table to store monthly forecasts and a form for the user to enter the details Details entered like this where the first line is the column header Line Item, month1, month2, month3, Total PC, £5000, £1500 Desks, £3000, £2000 Stationery, £50, £50, £50 As the user will be...

Hi, I have a form, just a splash screen with a check box that is in the startup form option. The checkbox is a "click to not show on startup" option. I want to attach a bit of code that a - closes the form and b - removes the form from the startup option any help appreciated. ;)

Is there an obvious reason why access would automatically create a 1-2-1 relationship rather than 1-2-Many? I want to change it 1-2-Many. Cant work out how to change the realtionship type Access 2003