Search results

If you are launching this program via the Shell command you will need to use API's to move the window, try FindWindow to get the window handle, and MoveWindow to move and resize it.

While ACCDE files are compiled, they are not executables in themselves, you still need Access or the Access runtime client installed on the host machine, does your end user have either of those installed?

If someone steals the back-end, it would be easy to break into the database and get the data, especially programmatically. The problem you have is any code you could potentially put in place to protect your database would need to be run by Access itself, if someone were to write something in...

Re-writing the application in a new programming language, such as .NET, C++, or your choice, but otherwise no, you could not do this in previous versions of Access and you cannot to it in current versions, an Access database requires Access to be installed to use the built in forms, reports...

None that I am aware of. In terms of security Access is pretty light, you would need to invest in SQLserver, Oracle, MySql or the like to better ensure data security.

You could accomplish something like that through VBA code and an AutoExec macro...however those can be pretty easily circumvented. There is no guaranteed method to do what you are wanting to do in Access.

hmmm, I guess I don't understand what you're trying to accomplish then. Sorry :(

records are not stored nor retrieved in any specific order unless you tell your query using an ORDER BY clause. Try adding a sort by one of the columns and then see if things line up as you expect.

If you are trying to do calculations do not use a text field data type, it should be numeric. Secondly if you have decimal places the datatype should be double or currency depending on your needs.

I don't know of an absolute way to do this, but what I've done in the past is use the FileLen function to get the size of a file, wait a few seconds and hit it again, if the sizes are the same then I make the assumption the file is done being written.

VS can't handle any VBA functions in the query. You won't be able to use them and get the query to work in Visual Studio.

If you are still using the 32-bit version of Office...then I don't think this will work. Based on this MS article (http://msdn.microsoft.com/en-us/library/ee691831.aspx) it seems that Office 2010 64 bit version has the new VBA 7.0 and these new data types, but the 32-bit version does not. That...

Well the delete code is commented out... But assuming that you actually remove the comment mark ', the reason your sheets aren't getting deleted is because you're using the ActiveSheet property, change that to the same method as the previous line (objwb.Sheets(z).Delete)

So I looked at the MicroTools Access Wiz, looks like a slick product...but I would urge caution. I think it may convert forms/reports that were built using the form or report wizard pretty well. However if you are using a form that is heavily supported by custom code I would be skeptical about...

Easiest way might be to redirect to a text file then open that up and read the info. Shell "typeperf ""\Memory\Available bytes"" -sc 1 >>C:\Temp\output.txt", vbNormalFocus

Create a new Macro and use the OpenQuery macro command, in the arguments area put in the name of your query, repeat the command as many times as necessary.

Access is basically single threaded (excluding timers perhaps) so you can put 8 queries into a macro and it will run them one after another, but not at the same time, can't really think of a way to do that.

Well let me say whoever is requesting the output like that is an idiot. ;) But I cannot think of an easy way, I think some custom VBA code might be needed, opening up a sorted recordset and looping through it building your output file might be the way to go.

Well you can rewrite the application code into VB.NET or another .NET language, and I'm not sure what version of Access you have (2.0 probably) you will need to port the data over to the new database format, I'm pretty sure 2007 cannot create anything prior to a 2003 format, I think it can still...

yes it is possible.