Search results for query: *

Hello, The result of using the 'select case' in the 'on current' event is that the entire continuous form gets the formatting of the selected record. This does not replace the effect of conditional formatting. Any other suggestions? Regards, Bit

Hello, Dropdowlists in excel are only linked to 1 column. You can however work around this. Add a column before your code and number each code from 1,2,3 to ... Add a column after the description and concatenate the code and the description in it. Now create a dropdownlist (forms toolbar) with...

This means you didn't give the correct name of the field in the code. Check in the properties of the field for the correct name. Regards, Bitbusters

Le, The indirect function returns "#ref" because the remote workbook you are referring to is closed. You could open them all before using the indirect function (e.g. with a button). Another solution you might use here is to create a little table on a new sheet with the team name in...

In your code change the line with "Screen.PreviousControl.SetFocus" by "nameofthefield.setfocus" and the focus will be set on the correct field before executing the search. Regards, Bitbuster

Jef, Just replace the 'like "*"' with the name of the field you try to display and it should work fine. Regards, Bitbuster

Darrylle, What I meant is that my solution requires creating an extra field in the table where you want to apply the function. This way of working is ok when that table is the only one where you apply the function. That's what I meant with a 'fixed table'. The disadvantage is that you have to...

Hello, Datasheet is really it says datasheet. So when you want to start with lay out, use the continuous form instead of the datasheet. Regards, Bitbuster

Hello, This can be solved easily with the Vlookup function, but as Skip mentioned you need a reference table with the values and the descriptions. Supposing range E1 to F10 contains the values to lookup (column e) and the descriptions (column f), the formula in A2 should look like this...

Darrylle, Bookmarks are good when you use a form. I want a function that can be called from the expressionbuilder and can be used in a query. This query will be used for further calculations. I found something else but it requires creating a new field in the table and filling it up via ADO or...

Hello, I also have a solution. I may not have all the errorhandles covered but it is a lot shorter and simpler to handle for a beginning programmer: Dim mo As Module Dim stline As Long Dim stcol As Long Dim eline As Long Dim ecol As Long Dim line As String Dim strpart() As String Dim...

Hello, To run SQL from code use DoCmd.RunSQL "SQLSTRING". Regards, Bitbuster

Hello, You can create a query that checks if some of the fields of your table contain duplicates. E.g. create a query checking on duplicates for the address and date of birth (exclude student number and name). Except for twins this will give you the list of duplicates. Regards, Bitbuster

Hello, To open a secured database exclusively: 1. open the database via the shortcut containing the reference to the mdw file and user info. 2. Login to the database with your admin userid and password. 3. Close the database without closing access. At this moment your user credentials are...

Hello, You might want to try the 'outlook' object. First add the 'microsoft outlook object library' to your references and then you can start using code as in the example below. Dim objOutlook As Outlook.Application Dim objOutlooknote As Outlook.NoteItem Set objOutlook =...

Hello, I want to create a function in VBA to display the value of the previous record of a field (except when it is the first record, offcourse). How can I do this so the function can be used in a query (via expression builder) and doesn't take too long to calculate (so don't let the function...