Search results

I went for this option, works like a charm and is simple too. Thanks man!

Dear all, I have a query which I would like to export to excel. I have created a form with a combobox for this. When I click the export button the following code is triggered: DoCmd.OutputTo acOutputQuery, "qryuserlist", acFormatXLS, "H:\", True The issue I have is that the query accepts a...

Well, it's a multiuser application, with currently just 2 users, but with potential for more. It would be nice to at some point have some control over who enters the application. You know what, I will forget about the entire 'remember me' feature and use global variables instead. It saves me a...

Too complicated. I was maybe thinking global variables, but then the 'remember me' function would not work.

Dear all, I'm creating a custom log-in screen (with user name & password). At this stage, when a user logs in with the correct details, I'm storing his name in a table, tblcurrentuser. Later when I need the user's name I can just look into this table and add his name to an automatic generated...

Thanks Keith, this has helped me indeed. I'm able to open the recordset and display it on the form. I would say I'm pretty familiar with access but on the other hand totally new to the entire ADO/recordset scene. So I appreciate all the help I can get. The purpose of the application is to...

Dear all, I would like to display the results of an sql query on a form. However, the data I want to display are 'confidential' (system, userid & password). One user can have access to several systems. I have a back end database where are the data is stored. This back end is password...

Neat, I knew there would be a simple solution. You have helped me to create a descent treeview control where only the relevant categories are showing. :)

Dear all, I have a table categories and a table items which are connected by a 1 to many relationship. Categories are: - cars - electronics - foodstuff Items fall under these categories and could be: - radio - computer - apple I would like to retrieve the categories for which an item...

Nevermind: Response = acDataErrContinue

Ok, so I found out how to trap the messages. I use the on error event: Instead of select case err.number I needed select case DataErr This allows me to display my custom message. The only thing I need now is to know how to suppress the original message. Kind regards, Hans B.

Anyone? :(

Either that's not the correct err.number or I'm doing something wrong... At what stage do you suggest I trap this error? I tried: - form unload - form close In both case the error message still pooped up. My aim is to trap when somebody tries to exit the form by: - clicking a custom close...

You cannot add or change a record because a record is required in <table>. Simple question (simple answer too I hope). How can I trap this referential integrity error? I would like to create a more user friendly message.

Hello Rabbie, I came up with this: ' fields Dim usergroup() As String Dim receivers As String ' create array usergroup ReDim usergroup(0 To Me.lstusers.ListCount - 1) For i = 0 To Me.lstusers.ListCount - 1 usergroup(i) = lstusers.ItemData(i) Next i ' output array For Each i In...

Can you be more specific? The rowsource is a dynamic sql statement...

Dear all, I have a form where I keep track of computer issues. The form contains a listbox which shows the names of the affected people. At most the list ranges from 1-5 users. My intention is to send an alert to the affected users by e-mail when the particular issue has been solved. My...

Thanks Jon. That was the initial solution that I was looking for! :)

No, I wasn't. That's a very useful remark. I guess it will also make my calculations easier with 2 fields (fldstart & fldend) instead of splitting them up.

Dear all, in my table I have the following fields: - fldstartdate - fldstarttime - fldenddate - fldendtime Can I calculate the time that is between those variables using an expression? fldenddate.fldendtime - fldstartdate.fldstarttime = "x days and x minutes" Kind regards, Hans B.