Search results

Yes, of course I knew the name, but that's not the way I could find it. I could find it by creating a loop trough db properties and it displayed itself there. Even if a person don't know the name he can loop trough the properties and find it via elimination process (I suppose he can read about...

I have a security system in my application that depends on one custom property in which I store licence which my application uses in order to work. I've just found out that I can open this property (from another access database, even when the database containing the property is in an accde...

I'm a little confused by the terms here (flag method, flag table). Could You explain in little more detail what do You exactly mean by these terms and how do they work? Thank You

I have two applications which share the same back end database but they do not use it in the same time. What I need acctually is: When I add new record in the table, from workstation A application, I want to be able to monitor in application on workstation B, when that new record was added, and...

I was wondering can 3-tiered architecture be implemented in a standard access 2007 VBA application? If it can, would i use ADO for connection to database? Would queries act as stored procedures? For the record, I'm not talking about using access as FE to SQL server or MySQL or Oracle, I'm...

Here is it: '*** CREATE PARAMETERED QUERYDEF (Query) *** Dim db As DAO.Database Dim qdf As QueryDef Set db = CodeDb ' Because this code runs from Library Reference ' Otherwise db would be equal to CurrentDb, when the code resides in running ' application Set qdf =...

I've solved the problem guys, thanks for Your replies, I will post how I did it later and maybe that will cast some light on what I was reffering thank You again.

I have a query that is basically the same for several of my applications, the only thing that differs is value in the WHERE clause. I know that several applications can use this query if I put it in code library and make a reference but here's what troubles me: I would like to create that query...

I've noticed that once I add reference I cannot delete it and add it again but instead access automatically adds another one. Can I edit existing reference? How would I add one and delete it trough VBA code? Thank You

Thnx Bob. Can You please tell me how to dynamically reference library from FE database? Where do I need to put the IN statement because I'm accessing data in tables that are in library. Also this function where the SQL is is in library module, and I'm calling it from FE. strSQL = "SELECT...

I've created library reference as an accde access database. In it I have 9 tables and 1 module. When I add reference to it from VBA Editor I don't see the tables in the database just the code module. I've read in access 2007 bible that I can use tables as well as forms, code, and reports. What...

I have another question that involves the time that has passed and where it is stored. Which is better candidate for storing the time, registry or created database property? I want to be able to save time but in such "format" that it cannot be changed outside my program. If I save it in the...

That solved the problem for opening it, thank You ;) Now I'll elaborate it and write if anything remains unclear. Cheers.

Yes there is, and I enabled all macros but then the error was on Form1_Open, Me.TimeOpened = Time(), can't find project or library. The thing i'm missing reference to is microsoft office xp web components, now, I have office 2007 installed, can I upgrade the installation? Does office 07...

Can You do it now http://www.access-programmers.co.uk/forums/showthread.php?t=194059, thanks

No, because there are 7 pictures (screen capture), from within the database also, and on them You can see that there are no tables, queries, and the code won't work, because it's missing some functions. You'd best download the zip and see what I'm talking about.

I'm getting couple of errors when I try to open this database. I also had same problem with the first posted version. How do I open this? Thank You

I've copied it in another class module as a public sub. Now I have two problems. 1) From within the sub, that was part of a forms class module, I'm referencing one text field on one particular form in application. Now when I copied it to separate module, that reference is gone. Can I somehow...

No problem. Better late than never ;) Cheers!

Can I read content in a folder (with subfolders) and then display all that as a tree structure in a list from which I can make selection? From where do I start here? Thank You