Search results

The form I am working on has a table for the record source. When I sort on a certain column in the table - no problem. However, when I allow the user to view the form in Datasheet view, the sort options are disabled when this column is selected. Any ideas? Thanks.

Why would the sort options become disabled when certain columns are selected in datasheet view?

OK, but what could have I done prior to creating the form to get the desired results?

What determines which record is displayed when my form opens? It currently displays the first record (ID = 1) from the record source (table). I changed the sort on the ID column to descending, hoping the form would show the last record when opened. It still shows the first. What am I missing...

I'm sure this post will convince one and all that a newbie is lurking. After looking at many sample databases and running many trials on my own, I'm confused as to when a person should create a query (as opposed to using the table(s) as the record source). Is there a hard and fast rule as to...

That worked great. Thank you.

Is there a way to make the current date look "clicked in" when viewing the calendar in form view? Thanks.

I have 3 tables in an old database I am trying to convert to Access. 1)Employees, 2)Equipment, 3)Assignments (stores what equipment has been assigned to which employees). I would like to have an Employee combo box at the top of the form. When the user selects an employee, all equipment...

What is the best way to clear a form after the user has saved? What I mean is to make all fields empty and move the cursor back to the first field ready for more data entry. Thanks in advance.

You might be able to add a Yes/No type column to your table and assign the records you don't want to include = No. Then query on records = Yes.

I have two similar queries -- both outer joins between two tables. However, the join lines appear different. On one join line, there is a symbol that looks like an 8 laying on its side on one end and a dark arrow with a 1 on the other. Can anyone tell me where to find the meaning of these...

That worked great. Thanks a lot!

I've seen other posters run into this problem, but I still haven't been successful with any of the replies. My column (text data type) contains strings such as 1016+45, 695+00, 818+12, etc. It sorts in the order listed; I need it 695+00, 818+12, 1016+45. I have tried the Val function which...