Why doesn't it work?

[Tech]

Hi there.

I am needing help and am struggling. I am wondering, how I would include the name and address of the employer in the vacancy form. I tried making a subform and make a form from the client table but no luck at all. it just doesn't work.

I don't know what is going on, so can someone please help me? I am new to this, and it's for my uni work. I have missed alot, due to personal and family problems, and have only went back today and have this to do for friday, well, more to it than this. so please, any help is appreciated.


the link to what i have done so far is:

ftp://temp:temp@techftpserver.co.uk/radjobsmine.mdb

Thanks again.

 

[Tech]

ok...

well, for any of u nice ppl reading, i updated the database again, everything is done except for this little problem, and a report, which should be easily enough to do.

thanks again

 

[WayneRyan]

Tech,

Thanks for your honesty...

What you need to do is design your vacancy form.

On the form properties choose the data tab,

On the line where the SQL, click on the right margin.
In designing this query you must add the Clients table, it will
make the joins for you, Then double-click on the client number,
name and address.

Exit the query design.

On the form, add the three new fields making sure that you
set their control sources appropriately.

That's it.

Good luck,
Wayne

 

[Tech]

finally!

thanks for the reply

ok, done as u said, but there is no sql thing there.....

help..

 

[WayneRyan]

Tech,

On the Data tab, the first line, there is:

SELECT [vacancy].[agent], [vacancy].[description], [vacancy].[client], [client].[name], [client].[address] FROM ...

Click on the three dots at the right and proceed ...

Wayne

 

[Tech]

on the data tab, I have:

Record source, then after that I have the 3 ...
then there is:

filter,
order by
...
...

so, is it the record source I select?

 

[Tech]

I really need a STEP by step for dummies guide....for this part, including the query...sorry

 

[Tech]

i think i got it but the vacancy subform doesn't move the records, when u are looking at various records on the A4 Vacancy form.

this is what I done:

use a wizard to create a form from the client table.

then save it.

put a subform in the A4 vacancy form.

selected none for the defining the field links.

create the query in the form properties of the vacancy. added the client table, added ID, name and address.

made it a continues form for the subform, ran it, all there but the subform won't move records.

I'm I doing it wrong?

 

[WayneRyan]

Tech,

Paste this on the RecordSource line: (ONE line)

SELECT [vacancy].[agent], [vacancy].[description], [vacancy].[client], [client].[name], [client].[address] FROM client INNER JOIN vacancy ON [client].[id]=[vacancy].[client];

Then click on the three dots and add the fields to the
query, etc...

 

[Tech]

thanks for the reply.

now, do i enter this in the MAIN vacancy form or the subform in the A4 vacancy form?? sorry for the questions

 

[WayneRyan]

Tech,

You enter it in the Vacancy subform. LOSE the new subform
that you just created.

Wayne

 

[Tech]

shoot me.

i'm so sorry Sir, I do appreciate this. I REALLY do

um, i'm just confused.

I have got the MAIN vacancy form, shows ALL details for the vacancy.

then now, I just made a form of the client table. named it as addy

so, in the design view of the vacancy form, I add a subform, this is to add the addy form. correct? going about it the correct way?

then, do I select none or define a fields link from the addy subform????

then do I just copy and paste that wee piece of code in the vacancy form properties, and hit the 3 ... and add the ID, name and address from the client table?

please correct me if I am wrong.

thanks again

 

[WayneRyan]

Tech,

Looks like its email time.

Post your address and I'll email you my version.

Wayne

 

[Tech]

sure, sorry Sir.

u can upload ur version and rename it....or email it to:

ahmeda86@hotmail.com

thanks again

 

[Tech]

no reply here....