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

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

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

Brilliant thanks - i didnt realise that changing the widt to zero would hide it. Thanks to both.

Thanks for replying - I thought it would be hard to explain..! That still shows the ID in the form field because this is what gets stored into the table. What i want to do is when the user selects from the drop down list, it stores the ID but shows the associated text (rather than a number)

that's great, thanks guys. If there's a box to tick where i can stop this happening as default, that'd be great. I've looked in the Access Options and the only obvious one (enable layout view) hasn't helped. Any suggestions? Have tried searching with no luck as yet

and i can't move the fields either....?