Search results

I have a table with data which consists of: 123 Mike 33333 123 Jones 88888 456 Smith 55555 456 Peter 7777 and I would like to show distinct rows of the first column based on the minimum value of the third column. Specifically, I would like a query to show only 123 Mike 33333 456 Smith 55555...

I have a DB in .mde where I want to anagrammatically open some Reports in Design view to change the ControlSource property of some Controls in the Report. The problem is that opening in Design View is not supported for .mde databases, so I am looking for suggestions on how to change the...

I have a Form with many DSum fields causing a small delay before populating the data. resulting for 2 seconds or more the DSum fields not to be displayed A would like to show an other Form instead while the calculations are performed, displaying a message like "Please wait data is loaded" I am...

I am facing a problem the solution of which may be piece of cake but still I can't find it. I want to convert the Date Format from American to British. I've successfully set the Format property of the field (at the Table level*) and the date is displayed as I want. But the problem is that when...

I've created a combo box in Excel but I figure out that it's not as powerful as the one in Access. Anyway my main problem is that I am trying to track the Enter key so since the ascii code of that key is 13 I've added the following event Private Sub ComboBox2_KeyPress(ByVal KeyAscii As...

I have a DB in Access 2003 which I want to deploy. I've already applied all the necessary security settings. I've also added a Form called frmInitialOpening which calls all the necessary initialization procedures. This Form is set as the startupform of the DB in order to be opened at the first...

I have a secured database with one admin account PAdmin1, who is the owner of the database. Let's call the mdw file associated with this database sec1.mdw What I want to do is to transfer the ownership to an other account, PAdmin2, which is defined by a second security file sec2.mdw. The...

I have a Customers table containing all my Customers personal data and a Form frmCustomers for handling them. At the Form there's a listbox displaying all the Clients (fullnames) for quick access. I delete the current record in my Form by calling the VB command DoCmd.RunCommand...

I have secured my mdb following step by step the below guide http://www.moretools.com/lessons/access_security.htm I changed the owner of mdb from the default to one I created, and also removed the default admin account. I tested all the permissions and the seem to work. Then just for testing...

After a year of work I've almost finished the development of a database (DB) in Access 2003. Before sending it to the purchases I reasonably want to secure my work. My ultimate goal is 1) to have a DB split in FrontEnd and BackEnd stored both locally at user's PC 2) user to have no special...

I've just successfully spitted a DB of 30+ MB of size to front end and back end. However the size of front end is roughly the original one and the size of back end is some KBs. Shouldn't have been the exact opposite considering that data are stored to the back end?

I am trying to call a function (contained in Form's own module) from the onClick() event of a button by assigning the function to the button through its properties as below =myFunction() The function has a single Optional parameter as below myFunction(Optional arg as String). The problem is...

I'd like to implement the visual effect of extending a (MEMO) field when mouse hovers over it. I mean something like the pop-up menus on websites. One solution I came up with is to use the onMouseMove action and then opening a form at modal view, without any margins containing only a text...

Is it possible to highlight the rows of a list box as the mouse moves from row to row? You know just like it happens with combo boxes.

I have a combo box and I want to highlight all its text text upon Click or Enter events. Doing so for GotFocus event is easy Sub Text1_GotFocus () text1.SelStart = 0 ' Start selection at beginning. text1.SelLength = Len(text1.Text) ' Length of text in Text1. End Sub and I...

I have a report which has two nested grouping levels like the following schema. Report --Group1 ----Group2 Inside Group2 there's a field holding the cost of the product and 3 True/False fields indicating whether the corresponding features of the product are available. What I want is to add 3...

I have a form for displaying the Club Members info (like Name, Address etc). I'd like on the top right of the total debit of each Member to be displayed. For that reason I construct a Total query. Problem is that when I'm trying to relate the MemberInfo form with this query, all my records are...

I need to display filtered data in a subform using a Tab control. Something like every day of week being a different Tab. My question is what's most appropriate? To place the subform inside a Tab control or exactly the opposite? What would be the pros and cons in each case?

I think it's mandatory in modern forums, being more necessary as the later grows. I may elaborate on if you wish, but I think that we all know or can imagine the functionallity of such a feature

I am trying to redesign an older DB for a school, to meet the new needs that emerged. I am totally confused due to the complexity of the problem. I've already searched in this forum and in Google but most articles are for simpler DBs. Well to get to the point. School has Students, Students...