Recent content by MSAccess_newbie

Thank You Doc Man & Big Foot, I wasn't doing it like that, I was building the query from the tables directly within each form I create, so it was kind of tedious. But I see it makes sense as you suggest to make a base query first and then build the form on it. (As long as the query is...

Hello John, Thanks for sharing... According to this artice, This seems to be the only concern for my case (as I don't intend to use earlier Access versions) "If you change the Expression after data has been entered into the table, the existing results may not be updated correctly (through...

Hello All, My question is, should I be using calculated fields in my database tables in Access 2010 or will it come back and bite me somewhere down the road? My assumptions are: I don't need my database to be backward compatible so I don't care if it wont run in Access 2007 or earlier. I...

Hello, HYG, I've attached my DB here after converting the linked tables to actual tables & removing a lot of the irrelevant forms & tables. Somehow now the problem of editing all same ID records is no longer there but what I'm seeing is two identical records of the same ID on the 'Local'...

Hi Rodmc, Good idea to show them, for troubleshooting its easier... I have a one-to-one relationship because one table called 'projects' has all the projects basically contains the Project ID Project Name, description etc.... The other table contains the Project categories. Since the project...

Hello rodmc, Yes I tried it after making all the PK fields visible. It does the same thing exactly. "If not how do you know its not just updating the one record, cos your only seeing one part of the key ie the ID" I can see it because the table lists all the records so I see several...

Now here's something weird... When I input a value on the front end, it sets all records with the same 'ID' to that same value. However when I look at the back-end table, only one record is updated (which is what I expected in the front end). Problem is here that the record that's updated is...

Hello All, I have a form which reads from two tables linked with multiple keys in a one-to-one relationship. Primary Key is based on four fields as follows: ID Year Submission Version On the form I only show (use) ID, since the users don't need to see the other Primary Fields. The form...

Problem solved. This thread was very helpful. http://bytes.com/forum/thread200547.html I needed to re-create the linked table and check the save password option to avoid the login prompt from appearing every time it's accessed.

Hi All, Im trying to run an access query from excel which takes parameter inputs. I'm using the code from this link modified for my DB http://www.ozgrid.com/forum/showthread.php?t=76848 My problem is the query pulls data from an SQL server connection which prompts for User ID and password...

For anyone who runs into the same problem, I tried this which works (probably not the best way) SELECT [2GFullWk_Tab].Week FROM 2GFullWk_Tab GROUP BY [2GFullWk_Tab].Week HAVING ((([2GFullWk_Tab].Week)>Format(Date(),"ww")-"5" And ([2GFullWk_Tab].Week)<Format(Date(),"ww"))); I also found this...

Hello, I have a table which stores information weekly. I have a field called weekly which increments 1, 2,3 ...etc. Id like to query the table for the most recent (highest) 4 weeks. Can anyone help with the sql?