Search results

Hi, and thanks in advance. I am using Access 2010 and have a single table (tblData) with about 100,000 rows with an ID field (ID) and a date/time field (Tmst). Each ID can appear one or more times with one of two dates. In the example provided, the date can be either 23/11/2015 or 1/05/2015...

Hi and thanks in advance, I have a single table in Access 2010 with about 500,000 client records that I am trying to query. Each client ID can appear in the table multiple times with different letter codes from S to Z. I want to return a list of distinct client IDs where the client has code X...

Hi and thanks in advance. I'm using Access 2003 and have a subform (continuous) that has a set number of rows and columns, so I don't want it to scroll at all. Textboxes in the subform are locked but users can double click them to update data via another form. The problem is that when you click...

Hi and thanks in advance, I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view. Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform...

Thanks in advance. I have two tables, table 1 and table 2 as per below. I want to update table 2 with values from the Cost and Parts fields in Table 1. My question is, how would I match up the fields so that the data ends up in the right slots in Table 2? Table 1...

Hi and thanks in advance, I have an Access 2003 db with a table that I want to update from values in form textboxes that are unbound (via an update query). I need to update the MyFieldName1 field with values from textboxes with names that are derived by concatenating MyFieldName2 &...

Hi and thanks in advance, I'm using Access 2003. I'm trying to formulate a crosstab query and having a bit of difficulty. I have a table with fields: Owner, Area & Status My data is stored in a single table like this: Owner.....Area.......Status Jack.......Area1......Green Jack...

Hi and thanks in advance, I am using Access 2003. I have an UPDATE query (which crashes) where I am trying to update a table with about 50 columns from the result of a query. The field names in the query match the fieldnames in the table but the table also has a lot of other fields as well...

Hi and thanks in advance, I am using Access 2003 and have a form with a Tab control that has a few tabs, each with rows/columns of unbound textboxes. I am looking for a way to enable the user to navigate across and also down (via arrow and Tab keys) similar to spreadsheet navigation...