Search results

FYI Here is my code that I worked out the problem with!! I began to experiment with coded solution once my brain ran out of SQL ideas.. This can easily be expanded to a more general soln. Does anybody know of a better solution? Function UpdateSMART_Eval_Obj() 'UPDATE tblPMT_15 SET...

[qry6_1_3_Latest] in my query design is simply a query which lists the "SMART Eval obj" ([qry6_1_3_Latest].[SMART Evaluation Objective])for each Row -- [qry6_1_3_Latest].[QuestNo] ... and the more I think about it, the more I think I need VBA to cycle the rows. Thanks for making me think ---...

I think i might I have to use some VBA ... now that I've banged my head even harder!!

Sorry Minty ... It's not that!!

Hi Guys, I have racked my brain over this :banghead: !! Probably something very simple:o I want to run an update query on a table called "tblPMT_15". The update will be from a query called "[qry6_1_3_Latest]". Fig 1. shows the problem. Those things which remain constant are the [Question ID]...

Thanks Paul I'll try that!! Regards, Marty

Hi there, Is there a programmatic (VBA) equivalent to: double-clicking at the top of a column when the entire work sheet is selected, making all of the columns automatically change to perfect column width? Been looking for a couple of hours!! :banghead: Regards, Marty H.

I have the same need for changing the sql ... but this: me.controlsource = "your sql code" me.requery does not seem to work ... I must be missing something!! I have placed this code in the Form_Load() event! ... but it it doesn't even compile?? :confused:

Does this assume that Field data is order of the Table?? Can you give me the generic method for the insertation of data given two tables (1--> many)? Does this also work for Autonumbers?

Here is the schema: (1) PK, PField1, PField2 ---> (Many) FK, FField1, FField2 The PK and the FK are related one to many. Simple... How could a simple question like that have some many questions?

Hi Gina, I'm in the mood to learn ... What were you thinking?

Yes.... and I've found @@IDENTITY to give the right PK (to make the FK in the second table) Is that what you mean?

How do I "grab" the PK fields as it is an autonumber? :confused:

I've had a chance to look at it some more... and it works wonderfully!!

Thanks for the quick reply... Can you elaborate?? I read through the entire post, and I'm still a little confused -- does @@IDENTITY work for ACE (or JET) and do you have a sample? I've never seen it at all!

I am entering huge amount of data (which was finally normalized) with SQL commands. In this 1:M schema, the first “insert” is simple, but the next INSERT requires that I get the foreign key from the first INSERT. What is the simplest way to do this? TIA

I am confused you say: >> Users is a subset of Employees How can it still be a subset AND "The data stored in Users table is only needed for users" ? Regards, Marty:confused:

I also realize only NOW that my simplified solution to the problem may not be so good... the employees only deal with certain institutions, while the rest of the responders MAY deal with the same institution and it may be dumped into the "Other" category!!

Well, the employees (inside the government) know that they deal with certain institutions only, where as the rest of the responders outside of the government can enter any institution they deal with. So there is the dilemma... Regards,

Hi nschroeder, Why not just have one table All the Employees and have an attribute in the table that defines whether the Employee is a user or not... Just a thought... Marty