Search results

If you want the user to enter the percentage and don't want to worry about whether they remember to put .175 in the text box, what I do is place some code behind the after update event of the text box: me.txtboxvalue = me.txtboxvalue/100 That way, if someone enters 17.5, it will show up as...

I'm assuming you're using a query as your recordsource. Just go to the query and add the join field from "contacts" to the query grid.

I pulled this from Access help...does it give you what you are looking for? Count the number of records in each group in a report 1 Open the report in Design view. 2 Add a calculated text box to the detail section. 3 To display the property sheet, make sure the text box is selected, and then...

Have you tried the "on no data" event of the report? I would suggest that you place text field(s) on the report that are normally not visible, but if there is no data, they become visible and say something like "no data this month" or "0" or whatever.

Tom, You need to set the filter lookup property of each field to "always." EB

You need to create error handling code that handles the duplicate index error. Generally, I place this on the "On Error" event of the form... Private Sub Form_Error(DataErr As Integer, response As Integer) On Error GoTo ErrorHandler Select Case DataErr Case 3022 'duplicate...

to get the hang of SQL, you can build a query that performs the action you want to perform...then click View/SQL View. This will give you the syntax in SQL. You can copy and paste this into your record source of your form. Alternatively, when you are in design mode of your form, in the Record...

This isn't a macro, but ....create a module and place this code in it: Function IsLoaded(strFrmName As String) As Boolean ' Determines if a form is loaded. Const conFormDesign = 0 Dim intX As Integer IsLoaded = False For intX = 0 To Forms.Count - 1 If...

Assuming you have a field called "DOB" on your form, place this code in control source of the field called "AGE": =DateDiff("yyyy",[DOB],Date()) This will give you the age based on the DOB. EB

Or, place the code in the control source of the unbound field AGE - take out the "[AGE] = " and just start with "=DateDiff....". [This message has been edited by Elana (edited 05-17-2002).]

I have a similar situation based on whether it's a US address or a foreign address. This is what I've used to change the input mask depending on what country is selected in the countryid field. Select Case Me.CountryID Case 224, 39 Form_frmUwrContactsSubform.Phone.InputMask =...

Hey Pat - Thanks for your input - sometimes I get so bogged down in the details I can't see the forest for the trees. I hadn't even considered your solution and it's so simple! I guess the good news is that I learned how to use the seek method on a recordset, even though I don't need it for...

Or, you can use If Me.NewRecord = True then...

Well, I guess I figured it out myself. Here's what I did and it seems to work great: Private Sub Form_Delete(Cancel As Integer) Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("tblSuspense", dbOpenTable) rst.Index =...

I need some coding advice here. My two tables are not one-to-many related so I can't cascade delete. I have a table where my user enters file notes. The user has the option to create a suspense item for the note. When the user elects to create the suspense item, I have placed code to...

Never mind - I figured it out. I was having a case of the vapors -

I'm spacing out here - I have a subform that displays a datasheet list of "to do" items for a particular insurance claim. I want to be able to filter the "to do" records with a command button where the user can show all "to do" items or only those items that are currently outstanding. I want...

Hotmail might have kicked it out if the file is too big. I sent you an email to your yahoo.com address.

My experience has been that the longer it takes to figure something out, the easier the solution actually is. My guess is the answer is really simple, but I can't see what you have so I'm working in the dark. Would it be possible for you to just send me the form in a zipped file so I can...

You need to place brackets around any control name that has spaces in the name...which is why it's much better to make object names one word (advice for the future!) Since it looks like some of your names are multi-word you need to place brackets around them: WHERE [Customer table].[SRPS Rep...