What is the best way to have access autogenerate records? I have a table and form that has an asset field and a period field. When I enter an asset name I will also enter the number of periods to depreciate. How can I make access update another table that has asset and period. For instance...
I have one sheet in excel pulling data from an Access database every month. There is one record for each day. For instance in January, 03, I had 31 records. If I query February, 03, excel will pull 28 records. I have a second sheet that takes each record and displays the rows as columns and...
I have created a macro in my spreadsheet that refresh my external data spreadsheet and then saves the spreadsheet. Does anyone know how I could set this macro up to run every minute without having to keep Excel open.
I have a form that has a Charge field for entering a charge into a table. It also has a combo box with 2 columns. Column 1 is a description and column 2 is a percent value. When the user selects an item description and inputs a charge the total amount due (based on the [percent value]*charge)...
I have a form with a subform. Both forms are connected to individual tables. The main form has two fields: custname and custid. The subform has a relationship to the main form based on custid. The subform has two other fields: chargedesc and charge (currency). Basically the purpose is to...
Does anyone know how I would go about creating a form that would allow me to dynamically add numbers in a form field.
For instance:
I have a field called total charges. I want to be able to enter =10+2+5 as an example. The field should then display 17. This is how the cells in Excel work. Is...
I have a table that has a date field as the primary key. One record is entered into the table daily via an Access form. Is there any way that I could automate the creation of a record in the table. I want the table to automatically insert a record with the current date at 12:00am every day...
I have two tables in Access. Table1 contains a field for Items and a second field with a Percent for each item. Table2 contains a field for a Customer's Name, a field for Items, and a field for Charges. What I have done is set up a form that will let me enter in the Customer's Name, select the...
I'm querying my corporate database in access and I have run into problems with the way my db outputs dates. When I have a date field the dates are display as yyyymmdd or February 22, 2003 would be 20030122. This makes it impossible for me to perform calculations on the dates. Does anyone know...
I'm keeping a table of numbers products sold daily by different categories. I want to be able to calculate the sum of all the products in all categories sold by day, month, and year. Three calculations. Sales are entered into each category daily by date through an access form. The data is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.