I have an After update Event procedure as follows: Private Sub Envelope_Number_AfterUpdate() If DCount("*", "", "=" & Me.Envelope_Number) 0 Then MsgBox...

I have a field in a Data Form called "Section Name" and this is a Text Field where the user enters for example 1A, 1B etc. I would like an After Update event...

I'm trying to get some fields to auto update in a form. I have read several threads and looked at several examples all saying to use this: Private Sub...

I want to use the AfterUpdate event when a field (Me.NewANDI) has been filled. The field can be completed manually or auto-filled by a button. AfterUpdate...

I have a text field that is automatically filled by a calendar the user clicks to the calendar a calendar pops up and with the ok the calendar fills the text...

I have 3 tables titled "Dept", "Event", Student", Table Dept Fields a DeptID (Autonumber) & Dept (text) In Tabel Event I have the field : Dept In Table...

I have 1 form which i want to use for viewing (and adding) employee details. I have a combo box in the header of the form, cboSchemeID. Basically i want to...

I have a report in which I calculate the client's ages. That is fine. But in the final report I only want to list clients that are 62 or older. How can I tell...

I have a form that has the age of patients. But in the report i want to report the age in age ranges 10-14, 15-19,20-24,25-29 and so on . I want to be able...

1.calculating the current age using date birth field by access query. 2 nd how can I seperate the Name field (full name ) in to two name field like First...

I have a Form that gets its information from a huge Table of information. With the help of this fantastic group, I have created a Query which automatically...

I need help. I'm new at this and I'm trying to write a facesheet and armband that will calculate the age and also put it in Years, Months, and Days. Here is...

I need some help with figuring this problem. I have a table called - RETENSION with the following Fields- ID ( Autonumber) ISSUE AGE (...

I can't seem to find any information pertaining to the aggregate Totals functions "First" or "Last". All I can find is, "Displays the first/last record in a...

I have a many-to-many vendor database. I need to have Access to give me a "prompt" that asks the user to type in a category. The query will then access only...

Hello all, I have copied the following function from http://www.mvps.org/access/tables/tbl0012.htm When I try and run it I get the following message Compile...

Hej, jeg har lige fået denne Dell bærbar, som har en fingerprint touch, og jeg forstår ikke at den ikke beder om at godkende finger touch når jeg logger on....

Hello, I am putting my database (Access 2007) onto a network. The end users are using Access RunTime. If the end user runs the Mail Merge he ends up with...

When I try to add a template for the mail merge I end up with an error: Run-time error '5174': (C:\DOCUME~\Freddy\...\Temp\merge.888 Any ideas? Thanks

Is it possible to have an alert, based on a value in an Access database, sent to Outlook and create a pop-up reminder? I have a database about grant...