Recent content by pafcpilgrim

Solution to Problem 1: Create an onchange even that uses a DLookup to check the entry you have enterred to see if it exists then prompt where necessary. Or leave it blank and set the field property "Required" to Yes(NoDuplicates) then you will get an error when trying to save anyway if the...

Please give us reasons to what you want to acheive

Thanks Shadow, i thought of that to start with the only problem is that there several departments, and we need the top 50 sales for each department not in total and not have to do several queries. Any ideas with this? Thanks for you help.

Just export the report in RTF format, there is no ".doc" export format option available. Hope this helps.

Guys, We have a sales query for the transactions by each department asc by total sales for each line which at present we then export into Excel and take out the Top50 sales lines for each. What we would like to know is how can we generate a report or query to show the top 50 lines for each...

Hi Guys, Does anyone have a simple DB which show you how to transfer items between two list boxes. I would be most appreciative.

I have a simple report form where a list of reports appears from a combo box, then when the user selects a report it detects if it is date specific or not. The on change event of the combo box checks with two of columns to see if the dates are required, if they are it will enable them. The...

Unique identifier Pat something i have noticed on a program at my new job this week (not access but a VB application) linked to SQL server is the Purchase Orders system. You open the form add the items you need then when you click save it then assigns a PO number but there have been times when...

I have pasted the code that SJ posted on another thread that any changes to a record will ask the user to save before closing the form, this located in the beforeupdate event. Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then Cancel =...

Guys i have created and automatic table linking system so if a user moves their data file (BE) or it for what ever reason the database file cannot read the linked tables it will prompt the user to select the new location and re-establish all the links to the tables in that data file. What i...

I think what Pat says is a very valid point, so just want to expand on it more. If you think of the amount of data that is possibly transfering between a network be it local or wide if you allow a user/s to open a bound form up and display all the records and then let them search it or edit it...

Sorted now, but sorry i didn't use your method. The problem i still had was getting the file location into the SQL query, so i searched the help file and managed to work out how to connect to another DB get the list of table names and then create new Table Defs to the curr DB to re-establish the...

Thanks didn't realise you could do that in an SQL Query in all the years i have been using Access!lol I will try it though seems a lot easier that using code to link and get the information. Thanks for replying

I use Office XP and it won't let me convert a 2000 file format to an MDE File is there a reason for this? i don't want to play around with workgroup files so a simple self created login will do me as long as the user cannot get to my code. Any help much appreciated. rgds.

Guys i have tried to seach the Forum but can't find a solution to my need. I would like to get a collection of table names from another DB, what i am trying to do is populate a table with a list of table names that the front end links to and their paths once a user has selected the data file...