Search results

So the both of you prefer to have a local error handling system for things you expect and use a generic one for unexpected errors. The last one would log the errors to a place where you can recover the information. It seems logical but still it creates a lot of work. Take some silly issues...

I'm trying to come up with a strategy for error handling but I guess I can use some tips. Basically I see using a general module would help me out a lot. I would not have to create in dept error handling in my procedures. Currently I have a public sub which logs the error in a text file. I...

Thanks to both. That really helps!

Hi, I just got a simple question in regards to functions. For example this one: Public Function writetotext(source, destination As String) ' writes source to textfile Const ForAppending = 8, ForReading = 1, ForWriting = 2 Dim fs, f ' create systemobject Set fs =...

Hi Bob, just checked: this is indeed the case. I'm a bit embarassed now... :-/ Kind regards

Hi Bob, defineerror is a function that appends some text to a textfile. It is located in a standard module. Kind regards

Dear all, I'm trying to add a logging function to my error handling but this seems not possible. On error goto errorcheck ...some code... exitnice: exit sub errorcheck: defineerror ' log error details to textfile resume exitnice Error message: expected variable or procedure...

Hi, I have created a recordset based on an SQL statement: sql = "SELECT * FROM tblusers" rstbe.Open sql, cnnbe, adOpenKeyset, adLockOptimistic Is it possible to get the value of the record with the highest id number (flduserid), based on this recordset, but without altering the SQL statement...

This seems to work. Thanks! :)

Dear all, on a continuous form I'm having an issue with a combobox. Hopefully one bright member of these forums is able to help me. The rowsource of this control is linked to a table 'users'. One field in this table is a 'yes/no' field which is called 'active'. This field simply indicates if...

Dear all, my application consists of a back end & front end. From the front end I want to do some simple SQL operations on the back end. First thing i would do is connect to the back end like this: ' connect to back end cnnbe.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Database...

Dear all, in my database I'm keeping track of many events that occur in my business. One of these events are system maintenances (start time, end time, system affected). Suppose that a maintenance is about to start I would like to see a message box warning me about this. The only way I can...

Yes you are right! :)

Dear all, please see below a stripped down version of my code which I used to send mails in HTML format. I have 2 issues: - how can I preview my mail before sending (this may also solve the second issue) - everytime I send a mail, outlook needs confirmation. Any way to turn this off Set...

I'm trying to protect my database from the basic users, more then I'm trying to keep the experts out. I've built custom menu bars, toolbars and shortcut menus (all very minimalistic). I have password protected my code. I'm thinking about providing an mde instead of the default mdb. And now, I...

Did they improve this in the 2007 version by the way?

Hello Rob, I have succesfully implemented this feature and it does perfectly what I need. Kind regards, Hans B.

Holy crap, that's great thanks! :eek: Kind regards, Hans B.

Dear all, I would like to have a custom shortcut (right click) menu that only contains: - copy - paste So none of the filter, sort, delete, add record, ... crap that is there by default. :rolleyes: Can you point me in the right direction? I just don't know where to start. Kind regards, Hans B.

Dear all, people can easily bypass the startup 'security' by holding shift. In that way they can see and edit all the tables that are linked to the back-end. Same goes for mde files. Is there an easy way to prevent users from being able to enter tables. Like a simple password protection...