Search results

Hi, I'm rebuilding my laptop which is a Toshiba portege M800 with Windows 7. I have the OS disc but when I boot from the DVD drive all goes well until I get the message that it will keep all my data in a folder called 'Windows old'. I want to completely remove all files on the C drive but...

Hi, I'm working on an Excel 2007 file that has a Column of Data Validation Drop Down lists in Column 'A'. Depending on the value selected from the Drop Down, I have added Conditional Formatting (CF) rules to shade the row (Up to Column 'R') a certain colour. I've set this up for about 20...

Hi, I have a Cube file with 24 months of data & one field has Revenue amounts. I want to nominate 3 consecutive months & add those months Revenue data together. Rather than use something like [Month].&[201206],[Revenue] + [Month].&[201207],[Revenue] + [Month].&[201208],[Revenue] is there a...

Hi, I have inherited a 2003 db with unknown PIDs for the Group & User security. When trying to alter User details, I'm asked for a PID, so I'm trying to find the PID for the existing users. I've gone to unhide the systems tables to get a dump of the data & hopefully find the PIDs but no...

Hi I've added some code to a database form I copied from this forums sample databases. The database has a Start & Stop field & I want to save those times to a table, hence why I needed to add some code. I've created a table & using my added code, the times save to the table OK but will...

Hi I have an ESRI map with 2,900 rows of data including Geometric data to place the data on the map. The map doesn't seem to be able to cope with this amount although I've heard & read that the limit is 4,700 so I should be able to see the whole map?? Is there a background setting for this? Any...

Hi I need to create a template map for the Reports section in BIDS for Australia & also some for the Australian satates as well. I've tried downloading ESRI maps but get the error "No spatial data in the file" when I use them to build a map report. I need to get the correct map files...

Hi I wonder if anyone has had this issue, I have a table with 5 Columns, 4 formatted as Currency & 1 as %, the values for the Currency are vastly different in each category but when I chart them, they overlap the previous values?? I've tried changing the Format back to General, no luck. I...

Do Libraries need to be Referenced by Users?? Hi I'll change this post to a simple sentence that may be clearer than the original text below; New Post; If I'm a User of a file that (for example) is built in Excel but also references Outlook do I need to ensure I have the Outlook library...

Hi I have an Access database & an Excel Workbook. I want toi do most of the reports I need in Access but would prefer to use Excel for the charts. I don't want to link the Access tables to Excel or have a copy of the tables in the Workbook. I'd like to use a Formula as a Series for the...

Hi I'm importing a spreadsheet into Access & want to change some data before it is imported to suit the database. I have a field that is of the 'General' datatype, most values are doubles eg; '1.7' When add code to replace '?' with '0' or just "", it still won't convert correctly & deletes...

Hi I have a workbook with 2 worksheets, wksht1 & wksht2. 'wksht1' has column "A" which contains numbers (Long) with duplicates. 'wksht2' has the summarised column of numbers from wksht1, no duplicates. I want to select a number in wksht1, find the value (String) that is 10 Columns to...

Hi I have two fields on a form, one is Owner (Text) & the other is Cost (Currency). Each record will have a Cost value entered & the Unbound Text box should sum these amounts for that Owner as they are entered - There will be a separate Text box for each Owner. Does anyone have any...

Hi I have read about the need to create a form with an unbound field reading the values available to do this, but does anyone have a working example? The steps I've taken; Create the query Create a form with an unbound field that has the options available as a drop down I leave that form...

Hi I have 2 spreadsheets in one workbook, one spreadsheet has the date & time in 2 columns in the following format; Worksheet 1 Date Time 31-Dec 11:20 PM ------------------- Worksheet 2 Date Time 31/12/2011 23:20 As you can see, one spreadsheet...

Hi I'm trying to add a '0' to a phone number field but cannot get my code to work & was wondering why it doesn't. Here's the code; ------------------------------------------------------------------ Sub add_zero() Dim i As Integer Dim j As Integer Dim k As Integer Dim l As...

Hi I have a database that will send emails through Outlook (Office 2007) based on a queries results. I want to limit the number of recipients to be added to each new email so it doesn't exceed the allowed number. There could be 100s of recipients & I'd like to split them up. Has anyone...

Hi I have some Mail Merge code which works fine, but when I go to run it again, it recognises the query object previously created & errors err no 3012 - object already exists. I want to know how to have the error handler delete the query although sometimes the query would not have been...

Hi As 2007 Access doesn't have user level security, I've applied a simple password entry form for the User to access the Front end, the code looks at a table for the Username & checks the password matches the password entry. Problem is when I apply password encryption to the Back End, the...

Hi I'm getting a 'Sub or Function not defined' error when the MS Access 2007 code comes across 'WNetGetUser'. I'm trying to out why this happens as I believe it's because the Reference Library isn't available to it. I can't work out though which library is required, any suggests??