Search results for query: *

Nope, that doesn't work :( any other suggestions guys? Surely there must be a way of passing the password through... I know MS can do some silly stuff... but surely this would be a rather large oversite? http://www.simpleits.co.uk http://www.tazforum.thetazzone.com "Google is god...of the...

Hi, I'm trying to query a remote DB with a password using SQL only. Ie no linked tables, no VBA just the SQL. I can do this for a DB without a password but can't seem to do it for one with... here's what I mean: SELECT * FROM table1 IN "C:\remote_db.mdb" That works great when the DB isn't...

Yeah, that was the first thing that I did and he does have all the correct permissions. It seems to be the way access is treating the linked file. What I mean is that it is exactly the same message that you would get if you were trying to directly open a DB file that someone else had already...

Hi, I've got an odd little issue... Where I work we have a number of Access DB's all split in a Front End/Back End config via linked tables (Access used for both, FE is in MDE format). This has been working great and all DB's work fine... except... We had a new user start the other day and...

LOL, I did consider it and i do use the cross tabs when manually working with the data, but I was certain that there was a simpler query so i pursued that route. thanks though http://www.simpleits.co.uk http://www.tazforum.thetazzone.com "Google is god...of the internet" - Me ;)

Well actually the reason for denormalizing was that the customer demanded it... There is not just a single table in this format, but three, stock, price and units sold... the customer wanted the output to be an Excel report that graphed each line individually over the week... therefore having...

Despite lespaul's advice i was sure that an SQL solution wasn't only possible, but really couldn't be that difficult and would certainly be quicker than working with recordsets and individual records in VBA... and i was right! For anyone interested, here it is: UPDATE [4_week_sales] INNER JOIN...

Yes it is too late as there are many other files that are dependant on that table structure. http://www.simpleits.co.uk http://www.tazforum.thetazzone.com "Google is god...of the internet" - Me ;)

Hi, I'm trying to write an update query but its not working as i want it to... i'll explain! Table1: ID, Day1, Day2, Day3, Day4, Day5, Day6, Day7 Table2: Date, ID, Unit, SellingPrice Table1 contains unique ID's and then price data for the past 7 days. Table2 contains actual dates in the...

ahhhh... genius... thanks a lot i have it working now and its much simpler: Set oApp = CreateObject("Excel.Application") oApp.Visible = True oApp.Workbooks.Open (File_path) strSql = "Select query" Set rs1 = dbs.OpenRecordset(strSql, dbOpenSnapshot)...

Hi anotherhiggins, i thought about doing that but it does feel like a bit of a bodge... it would mean that the user runs the macro, selects the first excel file to export to, that exports, has an auto run macro on startup that then asks the user for the final excel file to export to and then...

Ok then... can i ask a different question... if you had a table that was anywhere between 6000 and 18000 lines long and 29 fields across how would you export it via VBA/Macro to a specific sheet in a specific workbook? Thanks http://www.simpleits.co.uk http://www.tazforum.thetazzone.com...

Sorry, file_path is set in exactly the same way... just earlier on in the code and so it wasn't copied... http://www.simpleits.co.uk http://www.tazforum.thetazzone.com "Google is god...of the internet" - Me ;)

Hey All, I'm trying to export the result of three queries to an excel file. The sheets that the queries need to end up in are named sheets... lets call them apple, pear, orange. Below is the code that i'm using: strSql = "select query here" Set rs3 = dbs.OpenRecordset(strSql...

Its not because of that, its to prevent users running DB's that may have malicious code embedded outside of VBA modules, rendering Macro security useless. These DB's may come from and source... most obviously via e-mail. Here's a better explanation from the first link i placed above. What...

Hi, Yes i was at first to. Firstly what level is your macro security set to, and what does the message say (as there are 2 or 3 that could be appearing)? If you have your Macro security set to medium or above (which really you should) then you will ALWAYS get the message saying "this file may...

Ok, i thought i would let anyone reading this know where i am at with this project. As per my last post, unfortunately the suggestions so far in this thread were not feasible. So what i have done to date is to move all of the code that was in user forms... to VBA modules and then called the...

JoeAtWork: Access is running in Sandbox Mode, that gets rid of the warnings, however it also blocks (with no error messages or warnings) any unsafe expressions rendering this DB useles... hence the need to re-code those sections ;) Crowley16: Yes, you can change the registry settings to a lower...

Hi, Recently at work we have decided to make the move to Access 2003. We are now running with Jet 4.0 Service Pack 8 and as a lot of you will know that now causes problems with unsafe expressions. For us we now have a business critical database that wont run... Now in the short i have...

Hi, I have been trying to do exactly the same thing as HughLerwill's Verse 3. I have already got it to work by setting a reference, however as i explained in the thread posted by HughLerwill at the top of this thread setting a reference is not an option in my case as the file will not always...