Search results

That sounds easy enough, I will try that. Thank you.

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...

Thank you very much for the followup. I will give it a try.

Just for clarification, in the second sentence of your reply you wrote "So you can either add the...", what did you want to say after the word the? Also, should I add the code exactly as you wrote it, including the preface me? I am never sure what the me stands for whenever I see code...

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 will certainly try it. At least the conversion process sounds more promising than I originally thought. :)

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...

I guess that is what is confusing me. What file will I be distributing to each user (thankfully there are only 5 users anyway)?. Before splitting, should I remove DB file (Case Tracker) from the network, then split it "offline"? Then re-install the back end file to the original network...

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...

Disregard. A blindly stumbled upon the way to do it.

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.

To Missinglinq: Sorry for the late response. Your suggestion worked perfectly and only took me a few seconds to fix. I recall doing it a different way the last time, which seemed more convoluted. I really appreciate your quick reply and showing me a much quicker way of sorting. It's always...

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...

Thanks Brian. I knew it was simple, but couldn't remember the exact phrasing. Appreciate your help.

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...

Thank you so much. The Allen Browne site is where I got the calendars from the first time, but I couldn't remember the name of the link. They work perfectly and are easy to create. Unfortunately over time my brain neglected to retain the needed information. :) Which is another reason why this...

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...