Search results

I would take a look at this. http://www.chilkatsoft.com/upload-activex.asp

Me.Recordset is most likely using a DAO recordset and not an ADO recordset, the second argument for a DAO type is different. 'From help file Moves the position of the current record in a Recordset object. Syntax recordset.Move rows, start The Move method syntax has these parts. Part...

I don't know any way to drag a form, but I know you can already drag tables and queries from access to excel.

Well I would say if migrating to SQL server is even an option on your plate then take it. You can still use Access as a front-end to your SQL server back-end, but then you eliminate some of Accesses biggest issues by housing your data in a more stable environment.

How are Tasks History and the Assests tables related, what is the common ID between these records? Or to put it another way, how do you know which record in Tasks History should get a specific Asset ID number?

Hmm, your tables should be in a separate database from your forms and queries, they should be linked to the front-end, it sounds like the only thing you are really updating is the data in these tables. That being said there are many opportunities for you to optimize and improve this process...

Well I've done several conversions here from 2003 to 2007, and they were mostly painless. There the majority of the Access specific things, like forms, queries, reports, tables, all converted over without any issue. The custom VBA code though had a couple snags, certain arguments left out in...

Well building a custom DLL may fall outside the time/money constraints you're working with then. Given the nature of the changes you want to make it would seem like exporting the data and re-importing it into the other system would be the cheapest/fastest method available to you.

So when I said middle-wear that implied some type of bridge between them, whether that was an import/export of the data from/to flat files, or building a DLL that can interact with both types of database format then using that along with some VBA code to access the data. There are many...

Programs are not forward compatible, I don't think there would is any way you could link or otherwise use an accdb file from a 2003 version of Access, without maybe some type of middlewear that could act as a bridge between the two.

Checkboxes are not a format option in Excel, they are objects, you would need to use automation code and the EMBED function to add checkboxes for each record in your boolean field. If you are an experienced coder this shouldn't take long to setup, if not, then I would suggest recording an Excel...

Well without seeing all of the code its difficult to say exactly why this is happening, but I would suspect it's related to a memory issue. While your connection is opened and being used the Garbage Collector won't try to free up the memory consumed by it, when you close, dispose, and reopen it...

This isn't running in Access is it, this looks like C# code.

If you change your declaration to an array you should be able to call the original function.

Function expandKey(ByRef simpleKey(), ByRef box(), ByRef rcon()) change the code in red to ByRef box

Your function defined the parameter for sBox as a variant array (), but your variable is not declared as an array, just a regular variant. remove the parantheses from your function definition and it should work.

Ahh, well you could also use the Len function on whatever your value type is. So if you needed a long you could use Len(Clng("YourLongValue")) and it would give you the size of 4.

Maybe this would help. http://msdn.microsoft.com/en-us/library/windows/desktop/ms677209%28v=vs.85%29.aspx

please see this post, it might be helpful. http://www.access-programmers.co.uk/forums/showthread.php?t=170250

You do know that workgourp and ULS went away with the accdb format, Access has the compatibility to use it so long as the database format is 2003 or earlier. Unless you downgrade your front-end to 2003 I'm not sure you can open the back-end through the front-end. As for creating a shortcut...