Recent content by DC27

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

Thanks for the reply, but i'm way behind you on this one - i think you've assumed that i have a form in palce and command buttons setup to attach this code to? I'm not that far into it yet as i dont even have the form setup. I tried with a split form, but cant work out how to limit what is...

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

date() has done it - many thanks David :)

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:

complete duplicates. there's normally two copies in total, sometimes three. I want 1 record remaining

thousands unfortuntely...... Any other ideas?

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

is there a way of marking the thread as "answered"?

that's sorted both thank you

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