Search results

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

[SOLVED] Taking the whole Input Mask Value not just what is entered Thank You for the answer. I already have an idea how to solve this, I was just wondering if there was an easier way, as usual there isn't. Thanks Again.

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 haven't tried that because I distribute accde versions of database not accdb.

Well, a more general info would be that I had a piece of code which unpacked the zip archives using installed winzip version. I tried to remove the necessity of having winzip installed so i found a piece of code that extracts the archive but with native windows winzip extraction method, and this...

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 was thinking more like, create a query, store it in one place (maybe back end db, the tables that query uses are in the same database, but are also linked by the FE, as the query itself should be) and then link to it from different front ends. Can queries (from the BE db) be linked to (like...

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

Or I could use unmatched query (with one of three possible joins) as record set source (query definition) and then check the values in it in both tables. For now, I edited the tables manually (from within that query) and it worked like a charm :D Thank You for all suggestions. Consider this...

No, but after some more reading on the net I've solved the problem with the either left or right join on the tables. But in spite of that, I am really curious what programming logic could be applied to solve this problem in VBA?

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

The variable was initially getting its value from one field in the record set I was opening during runtime. I have changed that and now the variable receives value from two concatenated record set fields ( txtMyVar = rs![field1] & " " & rs![field2]). I've found out what was causing this. On my...

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

Where do I check for this option?

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

Could You please explain then, which table from the three would be forms main data source and since my filed is in third table (tblDete0) how may subforms should I have? What about the Inconsistent updates option, what do You think about it? What can go wrong if I use that option? Thank You

Which is more secure development environment than access? I was using some code example that does some encrypting on text string by rotating the characters in it, but I had problems with it, because when I generated encrypted licence on my machine, it decrypts it wrong on the user machine...

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