Search results

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...

Move the focus to a control on the main form, not on the sub form which is what your code indicates.

There should be no reason it doesn't work the break point is there just to help us see how the code runs and what values are being set, so if it works fine when you use it there is no reason why it shouldn't when it runs through on it's own. Try changing your code to the following just to make...

Still no Joy Strange i think its the date part of it for some reason, your first option kept returning Null and the second didn't work? Thanks for the samples though. If you or anyone else can think of anything let me know i will come back to it again later, i'm sure you all know what it's...

Guys, Why do i keep getting a Null return value even though i know the data exists. x = DLookup("Week_Ending", "Tbl_Agent_Production_TC", "Week_Ending = #" & txtWEnding & "# and agent_ID = '" & txtAgentID & "'") All my other Dlookup's work fine but they don't contain date values so i must...

I had this problem a few years ago, and i ended up creating my own calender which gave me more flexibility. You can't do it with the basic calender control, try looking up some code in the newsgroups or the internet. I don't have the database with the code to hand i'm affraid, sorry. If you try...