Search results
-
S
Number Conversion
I am using Access 2002. I have a number, 35.1519519, that I want to convert to degrees, minutes, and seconds. I know how to do this manually, but I wonder if there is a formula or a simple VBA script that will do it for me. I have a table that the number is in, and I will create the necessary... -
S
Linking Fields
The title may be wrong, but that is the best way I can describe the problem. I have a form that is used to input data, and I am trying to discover how to do the following: When I choose a company from a dropdown list (I know how to do that) I want a field named "Expires" to fill in a date in a... -
S
Tracking Licenses
For those that like complications. I am trying to keep track of licenses issued to the skilled trades for work in our Town. Our fiscal year begins July 1st and ends June 30th of the next year. We issue licenses to Electricians, Plumbers, and Mechanics. The payment is variable, depending upon... -
S
Copying selected fields from one table to another
I am using MS Access 2002, and I have created a database to track permits issued by the City and inspections that result from certain types of permits. For example, new homes, and structures in general have a series of inspections that are required as the building progresses. What I would like... -
S
Building Form
I have a project that I have been working on for a while. As I learn more, I make changes. I have a table named tblPermits, and the form is frmPermits. My table may need to be broken into parts, but I am not knowledgable enough to know or how to do it. So far, I have modified the form so... -
S
Custom Form
To the members of the Forum, Good Morning! I have just recently started working with Microsoft Access, and I want to automate certain things to avoid mistakes. I am using Microsoft Access 2002, and I have the following table (tblPermits) that I want to use VBA with. The first field on the... -
S
Form Problem
I changed the format of a field in a table and I want that change to be reflected in the form that I use for data entry. Is there a way to update the form so that it recognizes that change. What I did was design a form, and then decided to change a field in the table. I wanted to set a custom...