Search results

Thanks VBAInet for your reply, What I'm trying to do, with little success, is display data from Table 1 in a subform but in a different orientation to the table (some colunms to rows and some rows to columns as per my example). I am trying to do this by rearranging the Cost and Parts data and...

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

Thanks for your reply. This is SQL, not VBA, and when I use the syntax below, I get the Enter Parameter box popping up when I run the query as it does not create the textbox reference correctly and so does not find it on the form. SET MyFieldName1 VALUES (...

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

Thanks again Chris. That is a very comprehensive and informative description of how the query works and I'm going to file it away for future applications. Cheers Deutz

Thanks Guus2005, I'll take your normalisation advice on board and thanks for the code. Deutz

I must say, I'm very impressed. That works perfectly! I just added a sort by owner to group the owner rows. You saved me a lot of mucking about with extra queries or recordsets. It will take me some time to figure out how the SQL works. Are you able to provide a brief explanation of how the...

Thanks Chris, I'll see what I can find on concat records.

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

Thanks Trevor, I managed to find a solution by setting the the tabstop property of the textboxes in VBA to either true or false so that the focus moves to the correct control based on the key pressed.

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