Recent content by Sonnyboy

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...

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...

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...

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...

Premy, I have used VBA to solve the problem. A Field called "FiscalYear" keeps track of what fiscal year it is, and everything is working fine at this point. I appreciate your interest and will probably have questions in the future. The reason that I have not replied to your questions earlier...

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...

I thank everone for their reply to my request. I have re-done my table and created a new form. I am currently working on another problem that makes the last one look easy. Thanks a lot Sonnyboy

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...

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...