Search results

Hi Guido22, I'm trying to understand what you mean in order to answer you. You want the data to appear as it shows in the range A6-B24, & not like the range A30-B34. You don't want the three '9s' appearing, just one '9' in Cell B32? You've added that you already can do this using conditional...

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

Other websites & experts advise that the PID is not retrievable so back to the drawing board ...

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 TomH, I posted an issue about a timer on the below link; http://www.access-programmers.co.uk/forums/showthread.php?p=1213914#post1213914 It may help you create what you need together with what you already have done. Cheers

Thanks Rain but I was responding to Chris. I'll check out the link, Cheers Peter

This is seriously good now. You should post this as an example db as many would have a use for it as it is. If I use code with a name in it, I leave it there as trying to take credit for code you didn't (couldn't) write will eventually bring you unstuck ... Thanks again Peter :)

Thanks ChrisO, This is really good! Cheers. Might have to do an update ... :)

Hi ChrisO, I did make the changes you suggested for my version such as the date/time fields and the calculation of the elapsed using Finish - Start times. Otherwise, I think the reason for the time code was to allow people to make changes on the form without stopping the timer - (I think)...

OK, The database was located in this forum under 'Sample databases' (search under 'Timer') & I used it to help a friend who wants to create a performance monitor. :)

Thanks again ChrisO, I did originally have the fields saved as Date/Time but not on the one I uploaded. & also Thanks Rainlover for the tip on the SQL line, I'll remove it, Cheers Peter

Thanks ChrisO & Rabbie, The format 'Format(txt_Start.Value, "mm\/dd\/yyyy hh\:mm\:ss")' did the trick!! Also Rabbie, that's a handy tip to find the value although I used a breakpoint & hovered over the 'Start_Time' field variable in the code. I've never seen the format before, how/ why...

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 have found the error & how to get around it. I found that ESRI .shp (Shapefile) maps for Australia that held very granular data such as Postcodes were naturally bigger in Filesize than maps that had just Australian States info because these State maps for example were smaller...

Thank you SQL Hell Can you assist me though? There are files that 'make up' the details of a layered map, a .dbf & a .shp file. I have both of these files & I'm trying to get them into BIDS so they can align the latitude & longitude data with my postcode data that I'm adding in. The idea...

Oh hilarious ... No, stop it now please !! In Australia we call DBAs "Don't Bother Asking" because you're all too lazy & full of your own importance to give any quality assistance. Quite like your response really ... Please don't waste your awesome talent & try to eke out a living doing...

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

Mysteriously, I was able to right click on the legend names, select a different chart type & get it to chart correctly. Must be a glitch or something. I'll see if repairing Excel helps.

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