Search results

First, thanks for the reply. Second, I have seen something like out there, but could not apply succesfully. I have been searching for ways to capture certain commands (including command buttons) but did not saw any example of how to do it. If i correctly understood, you are trying to get an...

Hi there all. Here I am again, and with new and "amazing" problems to be discussed. As usual, I have been digging in the web, and little or no solutions available for my problem. Well, at least, not "easy" ones. After strugging a little with data base saving system (denying auto-save...

Okay, I am not going to discuss you this way, but thats my opinion. As example, what's going on with splitted data base? I think this is a total multi-user interface, loading "front-ends" in guest comps, and retaining "back-end"(tables), "secured" in server. In any case, thats my experience...

Thank you so much for the reply dfenton, and thanks for the hints as well. I am not a programmer, and have learnt vba for access in just few months, so this kind of things is going to happen so often. In any case, nobody here said to me how to proceed with this, so, at the end I finally...

Use Jamie's module to do so. Will do automatically for every form, and will work in access 2007 too quite smoothly. http://www.jamiessoftware.tk I have applied it succesfully in my huge data base with no problems. Also use the Peter's window manipulation module (v3.1) in order to do litte...

Okay,finally, after tons ofs tries, I did it. This is how I proceeded. To avoid Access 2007 to save on close event, just used this code Private Sub Form_BeforeUpdate(Cancel As Integer) denyflag = TempVars("denyflag") If denyflag = True Then Cancel = False Else Cancel = True End If End Sub...

Okay, finally succeded avoiding access to save data, but in the other way, it wont save in any case, so I had to do some tricks. In the form's beforeupdate event I set this code: Private Sub Form_BeforeUpdate(Cancel As Integer) If denyflag = True Then Cancel = False Else Cancel = True End...

Okay, then, assuming I can do something to make access to show the "Cant save data...:", how can I catch that message, and modify it? Thanks in advance

Well, thats the key, how do I code something to avoid data to be saved? I have obtained sometimes the "Access cannot save this record and bla bla bla...", but this is ramdomly, and I havent controlled it yet. So, here is the new question: some code to avoid access updating? Need ideas...

Avoiding access to save on close event [Solved] Hi there, Okay, here I am again with another access problem. I have some troubles when saving data in bound forms. Here is the picture; I got a bound form with some textbox/combobox/checkbox controls, that appears on blank once form loads in...

Re: From listbox to data sheet form... rowsource to recordsource (solved) Hi there, finally I got it. Thats how I did. 1.- Used the first approach Dcrake told to me, I mean, creating one data sheet form for each table, with same name as table. Once there, inserted code in EVERY data sheet...

Okay, copy that, thank you so much. Tomorrow I ll give a try to this and will reply to this thread. Thank you so much for your kindness, and have a nice day/week. Best regards Morg

It is a good approach, but it got a big security problem. This database is a protected one which will be expected to be on a server. Server will have limited access, and of course, with multiple users viewing reports that could be a chaos. In any case, the problem is not setting up the server...

Okay, I will trust you. Meanwhile I'll keep thinking about. It is better two thinking that just one: I dont want to make others work in something that it is just my problem. So happy my questions are not so stupid as I though at the beginning. Regards Morg TIP: Well, the excel approach...

Okay, then, it is much more complicated as expected. As you stated, maybe I found another solution, but maybe tricky to code. Thats it: 1.- Select a table 2.- Generate dinamically a form of such table 3.- Call it and fill in with wanted data 4.- Once done, and exit, destroy dinamic table...

Well, as I said in the beginning, there are about 41 tables, and no one have the same fields amount, so thats why view form should have a data sheet format. As I already said before, I am using this form because listbox limitations. In the case I have sent to you, there is just one table with...

Sure, no problem, here you are. Currently I am unavailable after 13:30 GMT-1 (Paris/Madrid official hour), so dont worry about. Hope everything is ok, and glad to meet you. Best regards Again, sorry for being an ass pain.

No luck yet. So, here I am again, and here it is a very cut down version of this part of database. Just one stupid table, and related forms to work with. Hope I havent forgotten anything. Still with this stupid table no luck. I am sure it is a very stupid thing, but enough to drive me...

Well, here I am again. No way, it seems I got a poltergeist. (TIP: Sorry in advance for my speech if I sounds quite incorrect. I am not english native.) I did the following on the commnad button: elementscb = TempVars("elementscb") fieldcb = TempVars("fieldcb") finalchoosecb =...

Well, thanks again for the reply. This is fast and accurate. Glad to be here. In any case, as you say syntax "appears" to be correct, because as I said there is a double check with listbox. Listbox is acting as a "preview", so listbox show results correctly. The problem is data sheet...