Search results

When I try the above I get the following msg: "ActiveX component can't create object" Does this help? PS: Uppercase suggestion did not do anything

@BlueIshDan - just left the office. Will try uppercase tomorrow @sneuberg - Could be because you have the same version for both then. I hope someone with a 'mixed' setup post their findings. ..

Hi all, I've been using the bottom function for a few years but recently tested it due to a time delay at a Client and found it now suddenly shows 'False' in the test code on my machine even though I'm running Outlook on mine. Could it be because I run Access 2003 but Outlook 2013 ? Is there a...

Forgot to add that I'm using Access 2003 (as per my signature) Thanks for the screen dump. From what I read elsewhere I'm surprised that you have Common Controls 6.0 listed. Apparently that was incorporated into the 15 Object lib. Anyway - that is just by the way and not related to my post. I'm...

Hi all, Recently I'm getting more and more issues with the Microsoft forms 2.0 object library reference I've seen a post where the User suggest that it must not be used at all So my question is - how do I get rid of it and what do I replace it with. If I try to un-tick it, I get the message...

Hi all, Just some feedback. Re-installed Win7 and everything working again as normal. The bad thing now is that we will never know what the actual problem was. It might have been some small missing/corrupt O/S file which could have been fixed without a re-install of O/S I'm just glad that it...

@spikepi - wow that is intresting - never heard about the "phantom break point". I tried the solution just now but it doesn't resolve it. To give you some sort of example - the code doesn't care if you put in lines line: On Error Resume Next It simply ignores it and still stops at the line...

@Galaxiom - thanks for clarifying my OP - yes this just happend all of a sudden from working db. So something is fishing. I tried as Uncle Gizmo suggested pulling everything into a brand new db but that gave the same errors. To clarify the errors: It would debug in code that there is nothing...

Hi all, yes is is not a spelling mistake... MDE is working but not MDB Since Friday I've been getting really weird errors when I run code that have been working for years. Even compiling the code works. I can then make a mde file and run it without problem but when I try to open my mdb file, it...

Just to report back for anyone else reading this post in the future. The example code below works perfect Thanks again for the out-the-box idea :)

Thanks guys. My mind was still stuck on the Export side. But I now see what he meant - it is a clever 'workaround' to create the XML file inside a text file but as a XML file type. Will try that as I'm sure it will do the trick

Hi Namliam, Sorry but I'm missing you on this one. What must I "open" and what must I "print" Can you be more specific to help me understand. Thanks again

Hi all, I need to export a Query to XML to be used in a PhP script. However the XML output format differ from the example I have. The example is far more simplistic so I need to get rid of the extra stuff. I assume that I would need to use a schema to correct this but I've been unable to get...

Got it after lots of tries and searches :)

Hi all, I need some help with the syntax of the following please: I want a 'Submit' button to jump to a URL which is madeup with the info of text input field. I have this so far: <FORM> Staff Number: <input type="text" name="staffnum"><br> </FORM> <FORM METHOD="LINK"...

Sorted - eventually :) For the record - when I specify the file, it works to provide the local path but when you doing a folder it gets all confused. So I added a "ChDir" command before the transfer line and then left out the local path Works well (Might make sense to someone working with WPut.exe)

Hi there, I'm battling with the script syntax for Wput.exe For many years I've been using it to upload a specific file to a server so it works fine for that. It seems like you can also upload an entire folder but I just can't get the syntax for it right. Can anyone help with the syntax to copy...

Hi all, I tried Data Access Pages for the first time ever and was wondering: I need to create a real simple login screen for users So my questions around data pages are: 1. Are they still usable or outdated - if so - what could I use in place of that 2. If I can still use them - how do I add...

Sorry if I was unclear: Day of emp of each person

Hi all, I need some help with a formula to calculate date cycles. Each person have an employment date on which a 3 year cycle is based. So at the end of their 3 years the cycle needs to update to the next 3 year cycle. For example Person Employment date Cycle Start 1...