Search results

The Lack of Response.... Did I post in the wrong place or is it obvious to everyone else and you're all waiting for me to find it myself? lol

I have a table of categories (Tbl Categories) and a table of Suppliers who fall within each category (TblSuppliers) which I need to be able to run mail merges from. I need to give the user the ability to • Send letters to all suppliers within a category • Send letters to several categories •...

Pat The example is great! Seems what I was trying to do was a cascading combo which used Dlookup! Thanks again for the help and sorry to boggle the mind :confused: Maxi :D

Pat Thanks for the reply! Just got around to having a look...... Think I might not have explained what I want to do properly though. On my Contracts_frm I have a field called 'Supplier Name' this is looked up from 'Suppliers_tbl' and is therefore displayed on the form as a dropdown box. If I...

Hi I have three main tables. Supplier_tbl which holds supplier details Contracts_tbl which holds contract details Owners_Tbl which holds details of the person is responsible for the contract I have forms based on all of these which are used for data entry (by the administrator) and a...

Solved! Thanks for the help guys. Managed to solve it! I was referencing my SELECT CASE function incorrectly and it was picking up data from another table by the look of it! Thanks again! Maxi

No luck...... Hi No luck with the test buttons I'm afraid. It's literally like there's no code attached to the button - I click it - nothing happens. I am pretty sure that it must be a problem with setting the SELECT CASE function up to begin with. Any ideas what the problem could be? Is...

Avoiding More Passwords Hi Thanks for the reply. I have actually got something set up at the moment using a command button but I really want to avoid having more passwords when I don't need them. That quote is from the sample database section where PaulReed uploaded his customised database...

Hi I am using a Select Case function change what different user levels can do on some forms where if they are case one, they can access a field on the form called [contractslink] as normal but in case two this field is disabled. [Contractlink] is a textbox field which is bound to a hyperlink...

VB Code - Can someone check this please? Ok...... Here's the code I am now trying to use for this. Can anyone tell me why this doesn't set the focus to the supplier record which relates to the contract and how I can correct it please? Private Sub Forms_Link_Cmd_Click() On Error GoTo...

*Groans at herself* :confused: I'm sorry to be completely useless but I still can't get it working. The form opens now but it opens on a blank version of the suppliers_frm and not the record relating to the contract it should be linked to. I've tried playing around the with code you gave me...

Error Message Max Thanks for the help but I am having a few problems getting it to work. I am getting the error message 'Microsoft Access Cannot find the macro 'Docmd'' Is this something I am doing wrong? Perhaps I am 'filling in the blanks' incorrectly. The form I want the button to be on is...

Hi Everyone I may be going about this the wrong way, since I am still pretty new to Access but what I would like to do is link two forms together using a command button. I have a form which contains all my supplier information and another which contains all my contract information. These are...

That's great Thank you so much Scott :D Maxi2011

Grouping the Dates Thanks so much for the help Scott. I wondered if you could just eleborate on one more thing for me. Ideally I did want to be able to do what you mentioned at the end of the post, which was to group the dates into 'Quarter 1, 2003' or 'Half 2 2005' etc and then have this as a...

Hi I am currently making a databse which stores contracts. One of the main functions I want it to perform is to retrieve all the contracts due to expire within each quarter (running from Jan-Mar, Apr-June etc), each half (Jan-Jun and Jul-Dec) and each year (Jan-Dec). These time periods will...