Search results

Hi, maybe this tutorial can help you a little. HTH Good luck

Hi, you can actually play the shockwave file within Access if you have the ShockWave Flash Object active x control registered/installed. You can read more about the procedure on how to achieve this here. HTH Good luck

re: Hi, is your application compiled? Have you tried to start it with the decompile command line switch? You can read more about this technique here. What's the general structure of the application? Are you using linked tables? Are you using a lot of code? How many records are in tables...

re: You're welcome. Good luck on future projects!

re: Hi, can you try to compact and repair the application under Acc2007 (make a backup before you do so) as well as convert the file to an ACCDB file format and see if there will be any performance differences. HTH Good luck

re: That's what I call an oxymoron ;)

re: Hi, Environ variables are actually very unreliable and can be easily be reset by the user. I hardly ever use them. API calls are much more reliable and perform almost all the same work. BTW...I did test some Environ functions in Acc2007 on WinXP and they work fine on my system. Make sure...

re: Hi, I think I've replied to your thread here HTH Good luck

re: Hi, I think the permission information is actually stored within the mdb file so importing everything into a new application will get rid of them and you would need to reapply them manually. There is a utility here which promises the following: I've not worked with this so I cannot...

re: Hi, can you post the code you are using behind the forms on open/load event. It seems as if that or the form itself is causing the issue. Have you tried to do a compact and repair on the application as well as importing everything into a new blank application just to be on the safe side...

re: Hi, for the deleting part either use the DeleteObject method of the DoCmd object or the SQL DDL drop statement in a loop. For the second part again use a loop with the TransferDatabase() method to link the new external tables. You obviously first would need to extract the names of the...

re: Hi, do you have additional versions of Office installed on the Vista machines or just 2007? Do you have the Set Can Grow and Can Shrink properties of forms sections set to yes? HTH Good luck

re: Hi, just create a new expression which returns the length of the value of your field and set criteria on it e.g.: UPDATE YourTable SET YourTable.YourField = "Something" WHERE (((Len([YourID]))<6)); HTH Good luck

re: Hi, I'm not exactly sure what you are doing as your code sample doesn't make sense to me...however I would strongly suggest using late binding with the CreateObject() as well as the GetObject() method. You can read their behavior here. Using late binding will also eliminate the need to...

re: Hi, as far as I know the single quote (apostrophe) character is the only comment character in VBA which comments out the whole line. HTH Good luck

re: Hi, as a general rule we do NOT want to store calculated values in table fields. They can be calculated at runtime on forms/reports or in queries just as you are. HTH Good luck

re: Hi, sure...use the like operator with wildcards in a query field's criteria area e.g.: Like "*" & [Forms]![YourForm]![YourControl] & "*" You could implement a subform on the main form which holds this search control where the subform is based on the query that uses this reference. On the...

re: Hi, I would suggest automating the IE object model instead. It will give you much more flexibility. You can either do that outside of Access with an IE instance...or use the Webbrowser Active x control directly within Access on a form. You might find these samples helpful: 01 02 HTH Good luck

re: Hi, check these two discussions: 01 02 HTH Good luck

re: Ah ok...can't be UtterAccess.com then ;)