Search results for query: *

I have received a request to enable tableview from a form, but I would like to allow only viewing and a return to the formview. I have told the user to use interactive filtering, but they insist on being able to view similar to an Access table. Is there a way to keep Pdox from spawning a new...

Is there a built-in function that returns the network log-in name? I am using Access 97 and want to put the username in the table whenever a record is changed.

Is there a way to get a drop-down list of the valid entries for a field? I'd like the drop-down arrow to appear when the user lands on the field, and then the user can select the value...or start typing and get an autofill of the nearest value in the valid list.

Is there any way to get Access to accept more than three fields as the link to a subform (1-M relationship)?

I have a table which requires [Faculty_ID] to be entered; I have a combo list box which allows the user to see the full name of teacher. In the underlying table the ID# is stored, but the (last) name is displayed. I would like to display the full name from the related FACULTY table (without...

I have an append query where the two tables have the same structure, and have a single field primary key. I have manipulated the data so that there are not duplicate values. However when I run it (SQL below) I get the error message that there are key violations. Is there a way to troubleshoot...

I would like to put a data validation rule that forces [End Time] to be greater than [Start Time] (leaving out for the moment an end time that falls into the next day!). I did put a >![Start Time] in the [End Time] field, and this works for ending time, but if [Start Time] is null upon data...

Coming from Paradox, I'm pretty confused about how to place a field on a report from a related table. I set up the links in the relationship screen, placed an unbound text box on the form, and then set the data source (using the elipsis) from a table+field in the list. It's a simple many->1...

I am doing a school application where "Spring" semester is 1, "Summer" semester is 2, and "Fall" semester is 3. I would like the order to display as: Spring Summer Fall I have created a Semester table with these entries with SemesterOrder as 1 through 3. I'd...

I've just inherited an Access database and application which needs modification. I've programmed with Pdox for 10 years, so Access has some frustrations associated with it. Does anyone know how to create a 1->M form where there's a 1->1 lookup (display) on the many side of the form? I've...

I am a newbie with Access: I am trying to display fields from a table in the database (linked 1->1 or M->1). I have done subforms which show child records (this is very easy in Paradox, which is the database I've programmed in for 10 years). What I'm looking for is e.g. show the name of a...

I have the following code, to try to add records to a date table. I simply want to add sequential dates up to an end date and the corresponding day names (later adding holidays and weekends, but keeping it simple for now). I get a SQL error when I run this. Dim myday As Date myday = #1/1/02#...