Search results

Table Org--Has my Analyst and which institution that report too. Their Program name..etc The Final_Table has the institution with the program and thier budget. I ran a query to pull this data. I also have blank fields for the Analyst to make change to the budget according to thier...

Here is my DB..

Hello Minty, I got rid of the "Distinct" and I have been able to update my query. Now the problem is that my blank fields for the user to input data into, will still not allow me to enter data into those fields. Any ideas?:confused:

It's not allowing me to upload my DB and yes I need to save Field B input into the first orginal table (One of the two tables being used for the query). I know I have a problem with my query..as once I run it I try to edit and it's not allowing any edits:banghead:

Thanks Markk...I will try that as I need to have six input fields. Also I noticed if I take out the DISTINCT...it gives me two records exactly the same. Any ideas

Hello JHB, First of all how do I do that ...and I have one table the is linked to ODBC...you will get errors

So I did remove the "Distinct"..but then my details in my form disappear. I conquer one problem and then come up with another.

But then if I bound it to a field I can't enter anything..please help

I am able to do paste a screen shot...i am able to put it into a email. That's weird

hello i removed the DIsTINCT in my query to move some field to be updateable on the form. Once I did that my detail section of my form was empty ..why and how do I fix this problem

Has far as the relationship page I only have the Final_table..I have tried several different relations and nothing is working

SELECT DISTINCT Final_Table.ID, dbo_tblOrgLook_master.Analyst, dbo_tblOrgLook_master.Org, dbo_tblOrgLook_master.OrgName, dbo_tblOrgLook_master.CostCenter, dbo_tblOrgLook_master.Fund, dbo_tblOrgLook_master.PEC, dbo_tblOrgLook_master.ProgramName, Final_Table.[Org Name:], Final_Table.Field2...

Thanks for helping..anyone else. I am trying to update a field from my query that is from my table. I have two tables coming into the query..

I am trying to enter in accounting info for each different analyst into form. I have two tables one with the Analyst and who they report to and what institution and the other table with the budget for each analyst. I made a query to draw the analyst and other info they need and the budget for...

Just trying different things :banghead:

I am trying to input info into my form I got Me.TotalBC1.Value = Me.TotalBC1.Value Now it's saying the "Recordset is not updateable" and I can't find it for the textbox where to change it to an updateable field

Hello, I am not sure what to call these items except as action items. Where can I go to figure out what is Me.txtX.Value I understand the Me and TxtX is the text box...but where can I get a list of the actions. .Value .Locked etc... I am new to Access..Only three months into making...

I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every...

I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every...

I did both with runmacro..is that okay? I have one other question. You look like you know what you are doing and I have not gotten anyone to help with this if you don't mind