Search results

Thnx a million! And what if we have a situation where the third column is not unique? Common in join tables. Then the data would like 123 Mike 33333 123 Jones 88888 456 Smith 55555 456 Peter 7777 789 Julie 33333 I suppose the answer is to dynamically create a unique key via a query? Something...

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

Thank you pbaldy! you save me from many hours of work!

That is exactly what I wished to avoid! Basically, I have a few Reports with some Controls each. I want user to be able to set criteria for each of the Controls. If I implement this with different queries I'll need one query/report for every combination of the criteria! That's why I'm stack...

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

What I mean is how the D*() functions are work. Each time data is changed on any record, the are being automatically recalculated. Do your functions have the same ability?

Thanks a lot for your suggestion. Taking a look at your code I can see that you call from your Sub the "lengthy calculation", which is just a procedure, and when it is finished you call the hourglassoff function. The above solution requires that the lengthy calculation is performed by a...

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 was requested to build it that way, so I suppose it is my problem too. Anyway, I am supposed to build different versions for each Format, since users comr from different countries

You are right at the first part of your post but the problem is that it can not be implement in my case since the program will be installed in client machines where users don't have permission to change the regional settings

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

Ok, I was asked to design a kind of list having the following features: List will consist of (at least at the beginning) a single column with the cell of the first row to be used for data entry (that's why the Enter key). User will type the desired data and press the Enter key 1) If the...

I was afraid of that. So what are your suggestions?

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 thought that too, but the startupform option has precedence over the autoexec macro. In other words if you have declared a startupform then you simply can not open any other Form before than that using the autoexec macro.

Any other suggestions?

I think you misunderstand my sayings. Since this DB will be deployed I can't manually (from the menu) change the startupform, that's the reason I have to set it programmatically. I emphasize the word change because as I wrote, I use a form (frmInitial) only to run some initialization routines...

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

thanks a lot guys!

Ok, thnx a lot for the help. I would like to ask this again because it sounds a little weird to me. The line of code If Me.Dirty Then Me.Dirty = False is equal to DoCmd.RunCommand acCmdSaveRecord ?