Search results

Hi, It would like to filter employees - the first two criteria make sure a certain language pair is met (must criteria) and a third criterium contains a field of expertise. Every employee can have up to three fields of expertise whereas only one of them must match the selected criterium in the...

Hi! i am having the problem that my database which I want do distribute (packed with developer extensions) is opened read-only. After some searching I found a possible solution to add a path as trusted location so the message does not pop up any longer. Below you'll see the reg entry I found...

Thx - but the form_open also didn't work: Private Sub Form_Open(Cancel As Integer) Me!Liste2.Requery End Sub--> there is still a loop, i.e. access doesn't stop to execute the query. Also when I click on a line in the listbox, it gets refreshed again, even though I have no on_click event in the...

Hello! I have a problem with listboxes which I refresh via Form_Current(). Access continuesly refreshes the listbox, so it is impossible to work with it. Of course, I only want the query to be executed only once and then nothing else should happen. THIS problem only occurs in case I have a...

Hi - I am still looking for a good software solution to protect my access application. So I wanted to try a free tool version first: I decided to try ActiveLock (http://activelocksoftware.com) which seemed very promising concerning how it locks the software to the hdd serial or whaterever...

It's a click on a button that triggers the requery: Private Sub Befehl26_Click() Me!Liste31.Requery End Sub I don't understand why the requery doesn't happen only once but is repeated everytime I scroll after I've clicked the button.

Hi!!! Couldn't fix this one for 2 hrs now, so your help is appreciated!! :-) I do fill a list field with a sql query working with functions, too. The query is initiated "on click". The query: [CODE]SELECT quotes.QuoteID, quotes.QuoteDate AS

....still on the phone?? ;) Would be nice if you could share that piece of code with me. thx, frank

Hi! I did now manage to select e.g. the filename from the attached file in the table with the following code: Public Sub AttachmentsAuslesenII() Dim db As DAO.Database Dim rst As Recordset2 Set db = CurrentDb Set rst = db.OpenRecordset("SELECT ID, text.FileData, " _ &...

Hi!! I am working with Access 2007. In my application users can store files in the database. For that I am using the attachment - datatype. When a user sends an email from Access through Outlook I would like to attach this file (if there is one stored in that record). Sending and everything...

Hi! I think u got me wrong. I don't want to convert currencies at all. A user should only be able to choose a standard currency and then get the responding symbol with it next to the monetary value. How is that possible? I read something about doing that with a new format, but I have no clue...

Hi! I would like to offer the user of my application the choice of which currency he wants to apply for bills etc. From what I read so far I understand that the standard currency is taken from the regional windows settings. How can I now format my monetary fields in a way that they are...