Search results

Hi All, I am working on a database that is being used to track Guaranteed Investment Certificates. I have designed a crosstab query that pulls financial company names down the left side, has months across the top and it calculates the dollar amounts in the grid. It tells me the amounts by each...

Here's a dumb little problem for you: I've set a parameter to ask the user for a start date and an end date. The prompt I want to display is a bit long (Enter Start date for account maturity ex:m/d/y) but I think its needed to prevent error. However, the parameter prompt won't re-size...

Greetings, I have a designed a form that allows users to send an email to a list of clients from Access. There are three fields: subject, message and attachment path. If any fields are left empty I can pop up a message to the user and allow them to send the email without the particular...

I need to not only calculate a person's age based on their date of birth (no problem with this) but also the age they are closest to. It's an insurance policy thing. If a person is 47 years old but within a half year of being 48 (closer to being 48) then I want that age to appear in a calculated...

I want to capture a form as an image (or a Word document that keeps the design of the form and doesn't simply export the fields to a Word document) so I can email it to a client to print off and sign. Something similar to producing report snapshots would be great. I've tried to export the form...

I want to highlight the control on a form which has the focus so users can easily identify where they are on a form. I know how to do this - I have a function which, when called from the GotFocus event, changes the background of the control to yellow. The problem is I want an easier way to call...

I have a list box (lstname) based on a Table. The list box is bound by column one (ID) and has a second column (manager) containing a name. I want to double-click the appropriate row and have the name appear in a text field on my form. I've tried Me.txtMytext.Value = lstname.ItemSelected and...

I have several fields associated with each client ID for the names of dependents (dependent1, dependent2 and so on). They are stored in the same Table and of course, in the same record. I want to fill a list box with these values so the user can select one to fill out a form. When I attempt to...

I have several fields associated with each client ID for the names of dependents (dependent1, dependent2 and so on). They are stored in the same Table and of course, in the same record. I want to fill a list box with these values so the user can select one to fill out a form. When I attempt to...

I thought I could reference a control on a tab control as if I was referencing it on the actual form: Me.hiredate = Now() It doesn't work for some reason. Before I placed it on the tab control there was no problem. Could someone let me know how to reference it properly or give an explanation.

I set the Order By of my form to LastName, FirstName but when someone changes this order to look for something quickly it resets this property the next time the form opens. I've read several posts about this topic already and I attempted to set the OrderBy property of my form OnLoad but I don't...