Search results

I don't see where in the function you would exclude Saturday and Sunday? Can you please give me an example of how to exclude these two days? I know that I want to exclude 1(default Sunday) and 7 (Saturday) but "days to exclude" is not part of the function. So how can this be done? I am...

I am trying to write a query that looks at groups of records for averages and maximums but the records are only from Mon-Fri (Trading Days). I have a query that runs everyday and compares today's close to see if it is greater than the maximum close of the last 20 trading days. I want to use...

I am trying to replicate a triple moving average function in an access query that I wan to run everyday. This is what I have so far: Table: CurrentMonthData Fields: Symbol, Delivery, DDate, Close Field: DDate Criteria: Date() Close: (AVG(Close) From CurrentMonthData...

I have a table that has the following fields: Symbol, DeliveryMonth, DDate, Close. This table has information for a large number of different commodities. I am hoping to run a query against the table and find breakouts. I am working on the actual query but my question is this: If I have only...

I have been successful at getting some code to create an Access Table with all of the contract data in it. I have a button that runs some very nice VBA code to do this. Now for the next step. I want to run a query against the entire table that will tell me if today's close in each of the...

I have a table with the following Fields: Symbol DeliveryMonth/Year DDate Close I am trying to evaluate today's close in relation to the close from the previous 20 trading days to see if it is a new High. I can create a query that looks at the contracts between date()-21 and date()-1 to get...

I have a form (New Subject) that is the result of a query of three tables(Subjects, Encounters, Intelligence). The relationships of each are One to One. I also want to have a form(Subject View Only) that has two sub forms in it. A Main Subject Form and a sub Form for Encounters, and a sub...

I was in the Form creation process when the error occurs. I don't remember the exact wording but it says that Access has experienced and unexpected error and must close. If I have 2 sub forms things are alright, but when I add the 3rd I get the error. These are government computers so I don't...

I am working on a database for work and I have one main form named subjects. This form has three sub forms that I have been trying to include. But Access doesn't seem to like it when I have all three and it gives me an error message saying that access has to close down, and it does. I tried...

Bump. Can anybody help me please?

I have a look-up box for other numbers. I have manually typed the list as it is only 4 different possibilities. But each possibility needs a unique input mask to ensure proper inclusion to the record. Is it possible to have separate input masks for each of the 4 options in the drop down box...

I have created a number of forms. I know it was bad designing on my part but I decided to put an input mask on the date fields. Is there a way to say update all fields without actually deleteing the field from the form and going to the list and re-dragging it to the form? I have a few...

I almost forgot, I am using Access 2007 if that has any bearing on the problem. I had a programmer at my house and he is used to using 2003 and he came up with this code: Private Sub ckAccept_Click() If Forms![frmHide]![ckAccept] = True Then Me.cmdAccept.Visible = True...

I'm Retarted. (Now I can move on) I need more help. I thought I could just put the code Me.ckAccept.Enabled = Switch(Me.ckAccept, True, True, False) below the Private Sub Check_Click() and above the end Sub and it would work. I think I have a fundamental flaw in how to apply the code. To me...

I have a form that will be the warning banner entry point to my database. The Form will have an explanation of the rules and then a check box("ckAccept") if you agree to the rules. I want to make it mandatory that you check the box before you are able to see the Accept button to go into the...

Quote: "You've got i all figured out! Nothing much to add. You can inmport the spreadhseet using the Transferspreadsheet command" O.K I have been told that you can use the Transferspreasheet command to do this but I can't seem to find where the command is. I created a form and put a button on...

For some reason you can't conditionally format the check box (yes/no) But what I really want is for the whole record's background color to change if the Target check box is selected. It works if you use a yes or no Text field with a list lookup, so maybe that will have to do. But it only...

I have a field named: Target that has a check box (Yes/No) option. I want to conditionally format the record so that it shows up with a red background if the Taget field is Checked (Yes) in a query. Can someone help me with this? Thanks:)

I have a rotating number of tables that are created from excel spreadsheets that are imported. The Tables will change, but when they are there I need to be able to create a query that will merge them all together so I can run one query against all the tables. In SQL I know you can use a * to...

Thanks Guus2005, I greatly appreciate your help. I'm not asking you to do the whole thing for me but just guide me along as I go. I understand completely. Everybody is busy. Anyway, the data nees to be in ONE table. So I can then run one query against all the data and get all the contracts...