Search results

I have a form with a subform, with the proper one to many relationship with their respective tables. Everything looks good in design view and in the properties window... but in form view, the subform doesn't display anything, not even the empty text boxes in the details section (new record). ...

I have to create a form with 39 fields to fill across...I can only fit 20...any ideas? I'm really stumped..

I need to navigate the recordset in the main form from the subform. The main form displays the parent record, and the subform the child record for data to be entered. After data is entered, (in this case only one row) I need to do a .movenext in the main form recordset...preferably on the...

Ok...I know that the best way to set up a table is to work across (columns) with the items you need to store a piece of data for, and let the data work downword (rows). But what if each item needed 3 pieces of data? What I have is a list of items, that needs to be updatable, that each month has...

I have 5 fields on a form used for inputing a new record. 3 of them are autofilled with data from a different table than what the form is linked to...and the other 2 are user filled. Only 4 of the fields get INSERT(ed) INTO the table that the form is linked to. At first, the 2 fields the user...

Ok, a while back I set a setting for the enter key behavior when it hits the last field in a record on a form, to go to the first field in the same record, as apposed to the first field in the next record. Now I need it changed back and for the life of me I can't find where the setting is! Has...

Is there any way to automatically fill in certain fieilds in a new record on a form? For example, for adding multiple records, certain field data is the same for each record, until changed by the user...as they go the the next record, I would like those fields to be auto-filled with data from...

Does anyone know how to use the Excel WeekNum() function in Access?

I am trying to update a single record at a time through a loop. But on the first trip through the loop it tries to update all the records at once. I am trying to update a list of records that have a start date and end date, starting with a user given date that is stored in a table. Here is my...

I am trying to extract data from a field in a table to a variable so I can use it in a comparison within VBA. But I am getting a type mismatch error and I can't for the life of me see where the mismatch is... here is the code.. Dim dbsSubwayDB As Database Dim rstSnapShot As Recordset Set...