Search results

your syntax looks ok to me, but I am not using that type of syntax. If you look at the code on the top of the thread I pass the frm as an object and the run through the controls. The error comes out at the central line "call ... ". By debugging I found out that when the Ctr variable (declared as...

Thanks Micron. The names are consistent, i.e. the name of the control is the same name of the subform object. The reason I came out with form, sub and sub sub is this: the main form is "Offers", the sub form contains "OfferLines" (i.e. each offer is made of many lines, i.e. many products), and...

Well, in fact for me this is the first time I am doing this. Below is the screen shot of the main form in design view. The Sub and the SubSub appears in FormView but they are set to start with DataSheetView when you open them normally.

Thanks, though not very clear to me: I still have 3 objects in my form list (frmMain, frmSub, frmSubSub). But the frmSub and the frmSubSub are by default in DataSheetView: is this making the frmSubSub difficult to control? Should I change it maybe in continuous form View?

Hi DbGuy! sure, the SubSubform is added to the Subform, i.e. I added in design view. In fact the SubSubform is working ok. The only thing is that the code above is not setting the propoerties of the SubSub as I would like to. I have attached a screenshot. The error 2455 says "Unvalid...

yes, correct, it has the + on the subform which expands into the subsub

Hello everybody, I have form with a subform in datasheet view and a subsubform also in datasheet view. I have a routine that once the main form is open applies permissions to each control (like hiding colums) and when the control is a subform it goes one level below, i.e. runs throught the...

This actually solved the issue when changing the decimal separator to ".", but just after rebooting my pc. It was one of the first thing I did yesterday but it looked like it was no working in Access. I have no idea why, because out of Access didn't need any reboot. Still a little bit puzzled...

Hello, it happens also to unbound controls and text box. I created a new empty accdb file within a new form with unbound controls and still no change. As my pc has italian keyboard (with comma as decimal separator) I first suspected it was related to international settings of keyboard. But...

Hello, I noticed that on all my forms my both comboboxes or text boxes shows a comma (,) instead of period (.) when using the numerical keypad for input the period. This is happening even if the the system keypad is correctly set to English and out of Access the keypad gives correctly the...

Thanks, I will try to have a look at this. Sounds interesting.

Hello everybody I tried to search in the forum and internet but no results: I would like to include in my project an instant messaging system, i.e. a simple form wher you can type a text and send to another user of the database. I have a database with about 40-50 connected users, with a SQL...

Thank you, I have downloaded that file but it is giving some errors. I will try to understand the principle anyway.

Hello, I have tried to look through the forum about this but I didn't find anything on this. I am running a company database with SQL server backend and about 70 users. It would be nice to add a very simple user to user chat system for users which are connected to the database. Any...

Storing only the path of the file in the database is certainly good to keep the database size small. Anyway if the database has several users and not all users should see all the files then the management of folder permission becomes complicated or impossible. If you use a SQL server backend...

In fact at the beginning I tried to work (I mean as a "user") remotely like that, i.e. with the Access running on my laptop and pulling the data through VPN from the tables in the company LAN: but it had decent speed only with very small tables exactly as said: possible but impractical. Then our...

Thank you Lightwave, I must also say that this forum helped me a lot. Maybe I didn't make many posts but just because most of the answers were already there :)

thanks, in fact I am doing the decompile/compile everytime I publish a new accde. Sometimes I also export forms in text files and then re-import them in the front end, because I understand there may be forms which have been used and modified multiple times so it's bettere to "clean" by export...

Thanks Ben, this is also reassuring me, so I am not completely crazy! If you basically made a MES system based on Access I think you pushed it much more than I did so far! cheers from Italy

Thanks very much Ridders, this means that I have a very long way to go with my FE! I will definitely switch off the compact on close, in fact it may explain some of these (rare) cases of corrupted front end we had so far. Is there any reason why you distribute accdb instead of the accde? Any...