Search results

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

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

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

Please can you help me find the issue to my problem that is probably hitting me in the face. I have an unbound form to which i use an append query to post the data from the fields on the form to a table. The table is set up very simple and has a primary key which i will never duplicate as you...

Guys, Please can you help me find the issue to my problem that is probably hitting me in the face. I have an unbound form to which i use an append query to post the data from the fields on the form to a table. The table is set up very simple and has a primary key which i will never duplicate...