Search results

Dear Richard! Thank you very much for your helpful answer. Well, I am probably going slightly mad, but I have tried this method last week and it did not work. Now, I tried it again and it works. So I am not really sure what is going on. But I suppose I have done some syntax mistake. Have to see...

Hello, Richard! I am back to you! All works fine, but I have one problem. The syntax you suggested works fine with SELECT of one table. If I created SELECT statement with INNER JOIN of two tables, I got the error message that the system cannot find the second table. Any clue or hint how to fix...

Hi, Banana! Well, I think I have made a mistake. In my test, I used SELECT statement and I think it is the problem. Concerning your suggestion about SSL I think it makes sense. Since I am not a specialist in this field I passed your suggestion to my colleauge and I am sure we will study it...

Dear Richard, dear Banana! I am back to you with some feedback. At first- thank you very much for you ruseful support! And- both suggested methods worked out well, I am very impressed. Thank you. Banana- only one unclear point is- what WITH ROLLUP statement means? Any specific function? I have...

Dear Banana! Thank you for your suggestions. Well, we do not use ADP. Normally, we distribute MDE clients. Why ADODC? It was only the idea as we have experience with it in VB6.0 developing. We developed a hige system for collecting the data from production (BarCodes) and we store it into MS SQL...

Dear Banana! Thank you for your quick reply. I am not quite sure with the first part of your reply. Concerning the second part- I have done following: 1) I have placed ADODC ActiveX DataControl object on one Form. I set up Connection string (working) and its RecordSource as "StoredProcedure" and...

Hi, folks! I am fighting with one idea with no success. I have a data in MySQL (MS SQL) and the access client, normally with linked tables in it. But is it possible that I have a chance to avoid linked tables at all and to set up (somehow) the datasource/recorsource for forms and its objects...

Hello, George! Thank you for your reply. Well, we have developped many applications, but only a few of them are, I would say, critical. I will try someting concerning Table security and I will see. I will keep you informed. Regards Krava

Hi, folks! I spent some time by reading a different threats concerning this matter. To be honest- I did not find the answer I was looking for. We develop the application always this way: 1) The data is store on the server in MDB file, password protected 2) The client application does not...

Hi, folks! It took me some time but I have tried and it works fine! Thank you very much for your great help! Kind regards Krava

Hello, gentlemen! Thank you for your help! We will try and I will let you know. With only best regards Krava.

Hi folks! I have a problem I could not find in the forum, but maybe I used a wrong words in criteria. So- does somebody know how to avoid opening the same Access instance (the same client) twice (or multiple) on the sam PC at the same time? I need to get some checking mechanism that would not...

Hi, Pleasure! Thank you for your idea! I will try it and I will let you know. With only best regards Krava

Hi! Thanks for the answer. Maybe I am looking at my problem from wrong direction. I cannot print (I cannot manage) on the printer because if I use the system settings (Windows) and driver it offers me only A4, A5, Envelop etc. sizes of the media. Of course, in the report I can setup my...

Sorry, I did not get that.

Hi! So I am back here after a long time. Anyhow, I am facing one problem with direct printing to GDI thermo-transfer printer. We have to print out the BarCode labels that we print only with using a SW package that came with the printer. I was wandering you any of you have any experience with...

Hi, Tobias! What I would do is that I would place a blank label into Report header. Before opening the report I would ask user for Text to be displayed in the header by e.g. Inputbox object ("NeededText=Inputbox()"). Then I would set up the blank Label Caption property with received text from...

Well, I did not mean a normal save command. What I meaned was the code sequence to save the data from unbound form, e.g. update query or recordset update or somethng else. Krava

Hi, Chris! If the both forms are based on query it should not be a problem. I am only wondering about the syntax I have given to you and the error message you got. Could you try to use this: SubformName![FieldName]=[FieldNameWithCalculatedValue]? Krava

Well, you are probably right. But it depends on if the fields of the form are bound. If not the save procedure is needed. Some of client applications require to work kind of "Offline" to prevent unwanteed chages. But most of them not. Krava