Search results

Is it possible to implement PKI infrastructure using Microsoft Access 2007 or any version? If the answer is Yes what is the starting point for creating this. Thank You

I wanna create a time stamp field in accdb database. Which datatype for the field and default value should I use? Thank You.

[Solved - Kind of] Form locks itself I recently made some changes to my code and now I'me experiencing a problem when I execute that code the previous form (which is the applications main menu) locks itself and I cannot close it and none of the buttons are working. The new piece of code that I...

Can I check if the text box on the form has its control source missing? If it can can someone provide a code sample please? In which of the forms events could this be best done? I was thinking forms Open event. Thank You.

The database should be able to store images on scanning and then retrieve them and print if necessary. Is there some special technology in designing these kind of databases? Are there some special scanner devices to use for this purpose? Is there maybe a special software? Where should one start...

I have a need to create a function that will compare the changes between two database back ends (which fields are in one and not in other, their types, etc.), and then be able to create all the new tables, fields, etc. from one database to another. I know this is no small task, and I was...

I have a fairly complex database. I've noticed that one can use the object dependencies option to see which objects depend on which. The code in my forms events use a lot of query definitions which depend on queries. Is there a way to see which functions depend on which query, that would make...

I have an input mask in one of my text box fields. The input mask has this value: "Чл. 2. ст. 1. тачка "0"." My problem is when I enter the value database saves only what was entered (a single number in range from 0-9) and not the entire text (and I need the entire text, with the entered number...

I don't wish to get into the details here, I just wanna know is there a known issue already why piece of code that works in accdb does not work in accde mode? Thank You

Is there a way to see why access 2007 application crashes after certain period of working time? How to see if there is maybe memory leaking or something that can cause this? One thing a can say, when I made my application to be more complex this started to happen, when it was simple and on other...

I have a query that fills a combo box in 5 of my front end applications. I was wondering would it be practical to store it in code library (one place) and then reference in FE-s? Can someone explain how do I bind that query to be the combos record source? Thank You

I have changed record source of a form from single table to a query that joins two tables. I also had to set Cascade Updates in the relationship between the two tables in order to be able to edit the PK field on a form. After these changes, when I try and edit PK field from form I'm getting this...

I need to create a procedure which will be able to check if some value in field of one table doesn't exist in the field with the same name and data type in other table. I'm using two RS-s method to loop trough the data of both tables. Anny suggestions? Thank You

I have changed the source of one variable in mt program and when I try to assign it to forms control I'm getting this error. Can someone explain what this error means? Thank You

I have back end database with several tables which resides on networks server. 2 applications on different workstations are connected to this database. Sometimes we are experiencing that application no 2 (no 2 because it's the second in the row that connects to DB) causes this error. I haven't...

I wasn't lazy and I did some reading on the topic, but none of the solutions (except Dynaset [inconsistent Updates]) solved my problem (including all the join fields in query, and make relationships cascade update). I have one form with query from the picture as record source and I controls on...

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 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...

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...