Search results

All I want to do is to use my query to return a list of names in a random order. What is the secret to easily doing this? For example: The query consists of a list of staff members by last name/first name (approx 65 names). Is there a way to have the query list these names in a totally random...

Access 2010 One of the Field Names in my table is titled ActionDeadlineDate, with Date/Time selected as the Data Type for the field. On one of my forms I have created a text box based on this field. Under Properties/Control Source for this text box I have inserted the following formula...

I have a large DB that was originally created using Access 2002-2003. It links to five other smaller DB's so it is fairly robust. Is there an easy way to convert this DB to Access 2010 (which is the version our org is currently using)? I have a sinking feeling I will have to re-create the...

Access 2010. I plan on splitting a small DB so other users on the network can simultaneously work in it as needed. For example sake the the DB is named Case Tracker and is located in a network folder named DBS that each user has access to. Once I split this DB I will then end with two...

I have an Access 10 DB that includes 299 names and other associated data relevant to these names. I have a need to drop 249 of these names that are no longer needed in the DB, and just keep the 50 names that would remain in the table. If I am in the table is there any way to somehow...

Using Access 10 I am unable to turn off the alternate row color function for my report. The icon is on the toolbar, but is grayed out so I am unable to select it. Thanks for anyone's help.

I have a combo box on my form where Row Source=Facilitators and Row Source Type=Table/Query. "Facilitators" refers to a one column table named Facilitators. This one column table contains a list of last names of a dozen or so staff members. The field name of this column I just left as Field1...

I am not sure where to ask this, so if I am in the wrong forum let me know. This is just a general question. If two people need to access a specific DB, but are not connected via any kind of network, what is the best solution that would allow mutual access? One user is located in one part of...

In my query I want to enter a new expression into the Field row that will restrict the query to a date range from the current date (whatever it may be) to a date 60 days previous. I know the expression for a specific date range would be something like the following: =DateDiff("d",[name of a...

Quite awhile back I created a form using Access 2003 in which I included three calendar icons. Clicking the icon would open a small calendar. The user could then click a date in the calendar and the selected date would automatically populate the appropriate form field. We recently upgraded to...

When the end user completes making entries in a form, I would like the user to be able to forward a copy of the completed form via e-mail. I know I can create a button on the form utilizing the SendObject macro and set the applicable action arguments, but this creates the following issue. When...

I wasn't sure in which forum to ask this question, but here goes. I need to know the formula for determining the number of days between the "current" date and an earlier "fixed" date. The report shows cases that are still open in our office. Besides other criteria, I want the report to...

(Access 2007). I am having trouble creating a macro for a search button I want to place on my form. I want users to be able to click the button and then search for a specific record in the database based on the criteria of that particular field. Form Name= frmInventory Text Field= HPDNo...

I am running Access 2007. On my switchboard I would like to create a link to a stand alone PDF file located in a folder outside of the database. If I go to the External Data tab in Access it allows me to link to many different types of external files (text, HTML, XML, etc.). But I don't see...

We have just updated to Access 2007 from Access 2003. As with any MS Office upgrade it requires weeks of wasted time learning where MS stuck once familiar commands. But that's another story!!! To wit: Having just created a form in Access 2007 that includes many text boxes, I now need to...

I know I should know the answer to this, but it's been awhile since I've had to design a query. I have a table that includes a column named Status. Data entry for this field is limited to only two options: either Open or Closed. One of the queries on this table includes Status. If I want the...

I have yet to figure out how to insert a hyperlink in a report using Access 2007. I want to link to a Word doc on my computer. In Access 2003 it was very easy. Help.

Regarding an Access 2003 db that sits on a network. Occasionally one or two users will not be able to open the db (i.e. clicking on the db name in the Explorer directory tree will result in nothing happening at all) until everyone else has closed out of it. 99% of the time this group of six...

I have a calculated field in a report that keeps a running dollar total of invoices. The field name in the table is InvoiceAmount and the calculation is =Sum([InvoiceAmount]). Everytime a new invoice amount is entered in a form it automatically updates the report with just the new total dollar...

I have a report that lists the total number of mediation cases we have processed, along with other related relevant data for each record. The report is sorted so that the individual mediators are listed in order by their last name. This way we are able to easily keep track of the number of...