ad post and related fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maria - 14 Jul 2006 12:46 GMT

This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in one table by typing it by hand when asked to.

It should add the counter automatically and then it should create
related posts referring to that ID in the related tables and ask me to
enter the values for those.

The tiong is I can't even get started on adding to the main table... I
tried typeing [xxx] in the condition field but when i ran the question
it automatically wanted to enter 140 posts without asking me what to
enter so that can't be the way.

/Maria

Reply to this Message

Duane Hookom - 14 Jul 2006 16:38 GMT

Do you have some table and field names you could share with us? Also, try to
explain better the functionality you are hoping to achieve.

Signature

Duane Hookom
MS Access MVP

> This seems like such a simple thing to do but I just can't seem to get
> started. I want to create a query that allows me to enter the Name and
[quoted text clipped - 10 lines]
>
> /Maria

Reply to this Message

Maria - 17 Jul 2006 11:38 GMT

It's all in swedish so I'm not sure if it helps but here are som of my
table and field names.

Table: Huvudtabell
Fields: ID
Namn
Syfte

Table: PDF-er
Fields: ID
PDF
InDesign

Table: Bildoriginal
Fields: ID
Bildfil

ID is the field were they all relate and Huvudtabell is the main table
containg the primary key.

What I wanna do is that when I add a field to Huvudtabell Access ads a
field with a matching ID to the other tables and asks me if I wanna
fill in the file names.

Duane Hookom skrev:

> Do you have some table and field names you could share with us? Also, try to
> explain better the functionality you are hoping to achieve.
[quoted text clipped - 17 lines]
> >
> > /Maria

Reply to this Message

Duane Hookom - 17 Jul 2006 14:23 GMT

Is there a reason you can't just display the Huvudtabell in your main form
and use subforms for PFD-er and Biloriginal? If that isn't reasonable, you
could use code in your form's After Insert event to append records to the
related tables.

I'm not sure what you mean by "asks me...". You could follow the append
queries with MsgBox() prompts and opening editing forms.

Signature

Duane Hookom
MS Access MVP

> It's all in swedish so I'm not sure if it helps but here are som of my
> table and field names.
[quoted text clipped - 44 lines]
>> >
>> > /Maria

Reply to this Message

Maria - 18 Jul 2006 08:45 GMT

The reason is that every time I enter something in Huvudtabell I want
the Access to asks for the files that goes with the my entry but you
might be right that it's possible to do with sub forms.
Thanks anyway.. I'll try to get take this further woth the help from
your clues.

/Maria

Duane Hookom skrev:

> Is there a reason you can't just display the Huvudtabell in your main form
> and use subforms for PFD-er and Biloriginal? If that isn't reasonable, you
[quoted text clipped - 56 lines]
> >> >
> >> > /Maria

Reply to this Message