Recent content by bestbefore99

Hi all. I have written an Access Database Application which converts another Access DB into mySQL. Fine enough. Unfortunately it uses the DoCmd.TransferText method to create an intermediate text file. When this command is executed, all DB objects to be imported are opened and you will see all...

What exactly does the clicking on the reset button (square)? I have a different behaviour in code if I first of running a sub click on the reset button or not. I have some global varialbles that obviously get initialized by the reset, but exactly does anybody know what happen to otehr things...

Hello again. I have received no answer to my previous post, so hopefully I get more luck this time. I have got a number of VBA applications running on top of Access, and Outlook. I would like to port them to a smaller portable device, because I want to have this applications running all the...

Hello experts. Having to run some VBA Outlook and Access applications to the smallest possible machine that does not run loud (no fan) nor consume too much power, and has GSM/GPRS/UMTS connection, I wonder whether some of you have tested if these small machines like the HPiPaq can run VBA code...

Thanks Bob. Actually we have at ERICSSON VB, what I meant is to have a tool that read the ASN.1 TAP 3 Specification and produces as output VB source code, or better VBA source code, that you can incorporate into a VBA Access Module, to avoid typing by hand a lot of Const or dimensioning a...

Hello progs. I have to complete a project which requires a specification for TAP3 Billing protocol available in ASN.1. Is there any freeware (or shareware) code generation tool that can compile VBA (or VB) code directly? Many Thanks Massimo

Hello folks. I need to create dynamically reports using VBA COde in a database. At the same time I want to protect the work done, by giving away an mde Version. However when using the CopyObject or Creating report at run time, I get an error saying that in mde you cant' create reports, etc...

Hello experts. I have create programmatically a form with a lot of buttons using CreateControl. For each button I want that when the user click on it, it changes color . I have created for all buttons (I may have up to 500 on a single form) the OnCLick function ctl.Onclick =...

Hi Duncan, I was more or less in your position a month ago, and after unsuccesfully looking in Internet, I decided to use the Powerpoint Objects to make customized graphical reports. Yet starting powerpoint is slow, and I am still looking for an alternative. Massimo

Hello Experts. I am quite finished with my Access VBA Application, and I want to add few graphic reports. Basically I need to display graphically some entries in a Access Table (Network Operators) and their relationship (Money Settlement for Interconnect) . The display should be possibly a...

THanks a lot NVSBe. My code for getting the list of tables however was Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData Open "C:\Tabelle.txt" For Output As #3 For Each obj In dbs.AllTables Write #3, obj.Name Next...

How do I find Table Properties in the Current Database? So far I have only managed to get information on Table Names, but I want more info such as Creation Date, Nr of Records, etc Thanks gurus! Max

Hello. I have implemented some special effects on Forms that use between others the Move Methods to open Forms with Holliwood like effects (Enlarging and Moving on the screen) This works well on Access 2002 on Windows 2000. However the Program crashes on Windows 98 with Access 2000 on the...

Hello experts. Access 2002 crashes when I hit the "Next Record" on a form (Customer) with subform (Contract) It produces a dump and ask me to send it to Microsoft for solving the problem. My system is Windows 2000 on a Laptop with 128 MByte memory and my database is very small...

I know the question is stupid, and I know the answer is simple, but unfortunately I have been navigating for two days the Internet and the VBA sites without success. I am simply trying to read records from several tables (Accounting Data, Price Lists, etc) from a local Access Database used for...