Help Needed

[borg]

Please can someone help I'm a novice

I have made a data base But I need to make a quotation I have made a quote in the reports but when I go to a client projects and go to view the quotation the same quote number appears and the same client details appears I would be so gratefull if someone could help as I have been trying for three weeks.

 

[Lister]

You are going to have to give us a bit more mate. We have never seen your DB, and your description of you problem above is a bit vague.

Try to describe your problem a little bit clearer or post a (under 100k Zipped) small copy here for us to view.

And just a note, try using the Search link above. Heap of information on every subject there.

 

[borg]

Thanks for reply

I cant upload its to big of a file

I have created a db for work to enter clients and project of works
I can enter data in and it saves
I have put in a button to enter (preview quote) but when I Preview quote the clients name and address is not showing in the report and the quote number.

when it does show its the same name in the first field of the table I hope this helps.

If not I could upload it to my web page for someone to download to help me

Thanks again

 

[a.sinatra]

Compact and Repair it->
Zip it->
Attach it->
________
Plymouth Prowler

 

[borg]

Thanks here it is I at to zip it rar then zip it in winzip

Thanks

 

[RayH]

Base the Quote report on a query rather than on the Projects table. Then use the quote no as the criteria. At the moment you are getting a page for every record in the Projects table.

 

[borg]

Thanks for the help

 

[borg]

Sorry again but im still having probs with the db when i view the report the same name and address is appering in the quote when i am viewing in a diffrent name do a i need to put in a filter

 

[borg]

data base help

Here you are RayH Thanks for the help I have done what you said but nothing is showing I will be a happy man if you could sort it

Thanks again

 

[RayH]

In the Query, add this to the [Quote No:] criteria :

[Forms]![Projects]![Quote No:]

Also remove the grouping in the query, it looks like you don't need it but I could be wrong.

When the Quote Report is called, you are prompted for a date. Replace =Date() with =Now(). Don't forget to format the field to Short Date or whatever.

 

[Rich]

Why replace =Date() with =Now() ?

 

[RayH]

Why replace =Date() with =Now() ?

I have to admit to being a little confused by that myself. I would have thought it would have worked. But changing from Date to Now causes the 'Date' prompt to go away and the report will display the correct date.
Its not something I spent a lot of time investigating.

 

[borg]

RayH
you dont know how much it was doing my head in I would like to say thanks your the best it works perfect.

Thanks Again

 

[Rich]

You have a missing reference if Access doesn't recognise Date()

 

[RayH]

You have a missing reference if Access doesn't recognise Date()

You are quite right.
It was a reference to "Search Assistant 1.0 Type Library". Whatever that is.
It must have come with the download.
I unchecked the reference and Date() now works.