Search results for query: *

When creating an Access2007 database, is there a simple way to have the entire ribbon to be not visible at all? I read all through help and I can't seem to figure out how to make it go away.

I have a query and it is doing just as I want it to. It displays each record, and also has a field called 'status' that can have five different values. The possible choices in this field are 'selectstatus'(the default), the other choices are, 'monitoring', 'working resolution','deferred', or...

I have a report that its record source is a query. In the query I have a field called 'status'. In that field there could be 5 different possible text values.(these values came from a combo box on a form) Is there a way for me to count the number of occurances of each value? The reason for...

I have a form that has a drop down combo box with the names of 3 people, and an All option. When the user makes a selection and presses the button, they see records from one of the three people, or all of them. In the underlying query, I have a table where the names of the people come from in...

I currently have a combo box on a form with the names of three different people. If the user selects a name, it correctly will display all of the records that has that person's name associated with it. Works great. What I would like to do is have a 4th selection in the combo box that says...

I am using Access 2003. On my report I have text boxes for display and they are quite large becuase there may potentially be a lot of text that was entered from the form, that I want to display. The problem is that if people only write one line of text for example, the report leaves a large gap...

I am using a datediff function to calculate the number of work days between two dates. The problem is that when the form opens, I seem to have to have a value in the fields that are part of the datediff function, or else I get an error becuase the fields are null. I also experience this problem...

On my form, I created an object using the 'tab control' button. I have a number of fields on the 6 different tabs that I have created. The problem is when I switch from tab to tab, I seem to get left over lines on the screen from the previous tab. If I click back and forth from the different...

I have a form that is based upon a query. When it opens up it displays all of the records. This is working great. I have a three combo boxes on this form. Box 1 is name, box 2 is project, and box 3 is workstream. They all have values in them that the user can select. This is working great...

On a form I have a calculated field which divides a couple of fields and produces a number which represents a percentage. I then have another field which the control source points to a field that is in my table( I'm using a query as the forms Record source). I use a 'me.temp field = field in my...

Is it possible to do a sum of field B, only when field A has the value of 1? Example: =IIf([A]="1",Sum([B]),"") The problem with my statement above, is that it is doing a sum of all of the records of field B, whereas I only want it to sum the records that have a value of 1, in field A. I...

I have a form where I have a drop down combo box that has 3 values, 1, 2, and 3. (field A) I have another field that contains numeric data.(field B) I also have a third field(field C). I would like the control source of field C to display the contents of the field B if field A=1. In other...

I have a main form which i call weeklystatusfrm. On that form, there are 3 sections/subforms. PartI, PartII, and PartIII. There is a date field on each form. I would like to open the weeklystatusfrm and show the records on each subform sorted descending. Does anyone know how to do this?

On a form, I would like to click a button, i want it to clear the contents of almost all of the fields on the form. Since I don't want it to clear all of the field, I will need a command that I can specify which fields to clear the contents from. I couldn't find a function or command to do...

Access 2003. On a form, I would like to click a button, i want it to clear the contents of almost all of the fields on the form. Since I don't want it to clear all of the field, I will need a command that I can specify which fields to clear the contents from. I couldn't find a function or...

I have a form and upon clicking a button, i want it to clear the contents of almost all of the fields on the form. Since I don't want it to clear all of the field, I will need a command that I can specify which fields to clear the contents from. I couldn't find a function or command to do...

I have a form with a combo box field called 'status' and the choices are either 'open', 'closed', or 'all'. I have created a query that in the status field, looks at the choice the user has selected from the combo box on a form. something like, [forms]![myform]![status]. anyhow, the problem...

I created a table already and set the field property to ole object. I created the field on the form and set the control to the field in my table. Now how do I allow the user to insert an attachment? Please help.

Here is the issue: My database has linked tables to our mainframe computer. Records are being update throughout the day on the mainframe. In my database, I have a table which is an exact copy of the linked table, but not linked. Currently in my database, when you enter it, I delete all the...

Please help. I have a database that is split. It uses many internal tables, but one of them is linked to our mainframe computer for its data. Anyhow this table can have between 12 and 18 thousand records. It gets purged weekly. Here's the situation: My table contains records from...