Search results

Good afternoon, I was wondering if anyone knew where Access 2000 project/library files are normally stored on a PC. Any assistance would be most appreciated. Regards John

Hi, Having a Front End and Back End was my plan, but for some reason when trying to create my Back End by Importing the tables from my Access 2000 backend Access 2007 complains, but as already identified it's appears it's not Access 2007 but the security settings/protocols our IT have in place...

Hi, Yes all ran on a local network which is locked down tightly, because of the nature of the work we do, the regulators require tough, tight controls, so every time I tell Access that my folder is a trusted location, it complains that there are security settings/protocols in place that say...

Hi, Thanks for your response. It would appear that our IT have some security settings/protocols in place that are preventing Access 2007 from performing as it should, so I will have to wait for them to have a look and see whether or not they are prepared to relax those security...

Hi, Thanks for your response, I wasn't aware that you had to tell access to trust folders, I've never had that problem with Access 2000. The new Access 2007 database resides in the same location as the existing Access 2000 database so I would have thought that it would automatically trust...

Good afternoon Folks, I'm having some trouble with Access 2000 tables on importing into Access 2007 in that once I have imported them from Access 2000 into Access 2007 I get the following error message: "Security Warning Certain content in the database has been disabled" and there's an...

Hi Namliam, Thanks very much for that, most helpful and something new learnt. Regards John

Hi, Thanks for your response, I'm not clear on where you put the "H" can you be more specific as to how it would look and where "H" would be placed. Regards John

Good afternoon Folks, I hopeing someone can help me here. I have a spreadsheet that records timings for individuals processing times and I have a totals column that totals up those times, but because the time format will only calculate up to a maximum of 24 hours and then it starts again...

Hi pr2_eugin, Thanks very much for your help that worked a treat. Regards John

Hi pr2_eugin, I've uploaded my spreadsheet have a look in the Totals tabs and you will see what I'm trying to do, I hope. John

Hi pr2-eugin, on entering your code/formulae as is but adding and equals sign at the begining in the cell, it brings up a message "too few arguments" = Left("25.75", Instr("25.75", ".")-1) & ":" & Mid("25.75", Instr("25.75", "."))*60 & ":00"

Hi pr2-eurgin, forgive me for being a bit dense, but I'm not writing code, but writing a formulae in a cell so would your code snippet translate to cell references So for instance I have 25.75 in Cell reference G106, so how would I translate your code into a formulae. using it as it is...

Hi Pr2-eugin, Yes I was aware, what I am doing is performing a calculation of total hours and I want to display it in time hours, so I'm guessing I'm gonna have to brake it down into parts and then put it back together as a string, but looks like time format. I hope I'm making sense here...

Hi I would be grateful for some assistance I want to convert the decimal number of 25.75 hours to proper time i.e. 25:45:00 I want to display it as 25:45:00 Any assistance would be most appreciated. Regards John

Hi AccessBlaster, Thanks for your response, and I appreciate your perspective but I need to know for sure whether or not Access 2000 will run in Windows 7. I appreciate that people are moving to later version of Access that are more compatible with Windows 7 and that those version are cross...

Good afternoon, I'm not sure if this is the right place to put this but here goes: I currently have MS Access 2000 and it is quite a comprehensive database that has been built over a few years. The company I work for are now moving to Windows 7 and a statement made was that MS Access 2000...

Hi JHB, Thanks very much for your assistance, most appreciated. Regards John

Good day, I have a bit of a problem trying to create a running total in my report, I get so far and then when I view my report I noticed that some records were not actually producing a running total. I have two tables one that stores the history of text files that exist and the fields are as...

Hi Namliam, Thanks for that, not sure what you mean by disambiguated them. To be honest I've only ever used DAO and I always declare where it is required so based on your information I believe I should be ok. Regards John