Search results for query: *

I have a macro that i need to run daily. Is there a way I can schedule time for it to run automatically (like DTS)? Thanks for the help.

Can some body please help me format my date field to look lik Mar 08. I am using cross tab and i want the date field to be months so that i can use it as columns headings. The report should look like this: Sep 08 Oct 08 Nov 08 XXX YYY ZZZ XXX Any help is appreciated. Thanks

Hi, I have a single table containing metrics (fields) on the following: 1. Available working days 2. Actual Work days 3. Total Prouction 4. Average per day (Calculation: Production/actual work days) My question is can i get the calculation for Average per day. User will input Actual Work Days...

I have a start date field that i input date in it. I want to automate the field by identifying the start date which is equal to the first day of month. Can anybody help? Thanks D

When i drag and drop a command button it use to give me options (small screen) where i can pick my macro, query etc. Now when i drag and drop it just drops without wizard getting activated. Can anyone help? Dwight

I am trying to generate a report based on aging by using a crosstab query. Is this possible? As a work around i had made a crosstab and then a maketable query and was using that on my access report. I have client aging such as 0-30days, 30-60days and 60+days. If we do not have any client over...

Is there anyway i could get a random sampling out of a population of records for audit purposes? Example, If i have 100 records in a table i want 10 from the table to be picked for auditing. I would appreciate any input? Dwight

Hi, I am trying to have a field on the web pages (html) of access with an input mask of a phone number. Example xxx-xxx-xxxx or any other format on the page. I am able to do this in the table field with !\(000") "000\-0000;;# as an input mask. But how do i make the same or anyother format to...

I have a bunch of reports/charts/graphs that i have designed in Ms Access. The next step is to give presentation to the management using powerpoint. I searched the web, and in how to articles from Microsoft i could find a very lengthy code (almost two pages). Not sure that will help in making...

Hi All, I have an expression that is ExpStep1: IIf([actual loss] Not Like "",[actual loss],IIf([estimated loss] Not Like "",[estimated loss],IIf([exposurecalc] Is Not Null,[exposurecalc],IIf([exposurecalc] Is Null,"No Appraised Value")))) Actual Loss, estimated loss are the fields in the...

Hi I have a data type number that i use it in the query. I use the query to make a graph. The problem is in the graph the number of decimal places is almost 8 to 10. I want it to have only two decimal places. For example, I have a number 530678682. I use the number in the query and divide it...

I have a table that has a datefield and acctType. I am currently able to query the number of accounts opened for the current month as follows. DATENAME(month, DateOpend) and in the criteria field = DATENAME(month, GETDATE()). This would give me the accounts for the current month. How do i get...

I want to create a table based on a view. Can any one advise me where i am going wrong? create table AcctsFeb as SELECT * FROM dbo.AcctsMonthly2 WHERE (Jan IS NOT NULL) Thank you Dwight

I have a field (DATA type Float)with seven digits in it. I want to filter out the first three digits. I am using the following expression. LEFT (dbo.A_CombinedDeposits.ACCTNO, 3) it gives me the following 6007862 ------ 6.0 7006823 ------- 7.0 I do not know why it is adding decimal point to...

I am trying to append the existing Account Number to a table that has a autoincrement field in it. Can any one advise/mention code to accomplish this on the click event of a button. Example.Table 1 Name Amt AccountNumber (ComboSelection) ABC XXX 1234 BCD...

I want to filter records in DTS. I am transfering data from AS400. The format of the date field is 111805 and 11805. I can use the string WHEN len(LDEPD6) = 6 THEN substring(LDEPD6, 1, 2) + '/' + substring(LDEPD6, 3, 2) + '/' + substring(LDEPD6, 5, 2) WHEN len(LDEPD6) = 5...

I have the following code that helps me in passing a parameter to the sp from a form command button. Can any one tell me how to modify it such that when the user clicks the button it would say "Do you want to add a record" If the user clicks Yes then add record/execute the command else do...

I want to append the record based on the combo selection id. I am using the following code. Can any one please correct me where i am going wrong. I have copied the code from a book as i am not much familiar with VB. When i run the following code, it gives error "Object Required". Private Sub...

Can any one suggest how i can unite the following view into one single view. I am having twelve views for twelve months. I am looking to enhance the performance by making a single view (if it's possible). SELECT Name, Jan, BRANCH, ACTYPE FROM dbo.DDAcctsMonthly2 WHERE (Jan IS...

Hi Guys, I have a date field and the name of the account. I want to make a view/sp/function that would give me the 1. Number of accounts opend yesterday. I am using DATEDIFF(D, CONVERT (datetime, DateOpend), GETDATE()) and setting a criteria as 1 and grouping to know the accounts opened. 2...