Search results

J'ai presque la même probleme I converted a French Acc97 to Acc2002 french and english (2 versions of the same dbase), and everything worked out well, except in some of my complex reports, the sub-reports came up quite strangely - none of them worked and on the screen they looked like list...

Got it working I don't know why the DoCmd.Printout printed my switchboard, but I have used code to set the Switchboard to invisible, then back again after printing. It works just fine. Also, I got the copies parameter to work again. This old system is a bit buggy, and its a bit difficult...

I abandoned the Access inputBoxes in lieu of a home-made version (an unbound form) that I have a print button at the bottom to print multiple copies of a report. Here is the heart of the code (to print NumPatrons #of the report MABriefList): If NumPatrons <= 0 Then GoTo ExitTournee...

You're right. I guess I just didn't look thoroughly. It is in the CODE section. I downloaded it and will begin experimentation on a copy DBase.

That did it. Thanks again. This thing finally runs smoothly.

Couldn't find it. Thanks for the link. I went there but couldn't find anything resembling the re-naming utility.

Does anyone have experience with the Re-naming wizard available in the following link: http://www.acc-technology.com/rnwiz.htm I have written a behemoth and I try to be consistent, but my own naming protocol isn't as good as the LESZYNSKI convention that I have recently learned about at our...

I have a hospital patient database that keeps each Medical Record Number unique -no duplicates (MRNum). I absolutely must block duplicate patient entries. To add a patient users click a button which opens the Form in add-mode. First field is Name, the second is MRNum. On-exit, if the...

That worked. Thanks again Pat. That works just fine. As for eventualities that have truly varying numbers of columns, I did download the Solutions database companion to Northwind and I did learn how they make a report based on a dynamic cross-tab query. Kind of complex, but nice to know...

One of my tables is surgical operations - a resident participates in each operation but has one of three roles - surgeon, first assistant, or teaching assistant. I use a cross-tab query to give each resident a summary of their experience to date - for each operation, how many they have done as...

works great That did the trick.

If anyone uses some form of Access Interface on their Palm, what program are you using and what do you find are its advantages and disadvantages?

I have an update query that I use to calculate a particular value that is inserted into a table (Yes, I know I shouldn't do it this way but honestly there is no other way...I posted a prior question under the reports forum on calculating a value in a report, if you are interested exactly why I...

Finally All I needed was: If Err.Number = 3022 Then .... It works great. Thanks for all your help.

Best advice I've had You are absolutely right. I am in the process of changing the dbase, doing the error trapping the right way and not allowing duplicates in the MRnum field. Thanks for pointing out what should have been my approach all along. -Nelson

Needs tweaking This method is indeed very fast. However, it only really is valid, algorithmically speaking, if you are inserting a new record. When tabing through fields in records that are already there, when you leave the [MR#] field, you set off the duplicate alarm, because it already has...

So far it works Thanks for the help - so far it works - I haven't tried it on my regular version of the list but on my smaller tester version it works fine. Oh, and yes, I have been meaning to fix all the names (i.e. spaces and special characters). -Nelson

What do you mean by query Medical Record Number is an index field, but I have allowed doubles because if I don't and a user enters one, they get a most user-unfriendly error message that I want to avoid. As to using a query, do you mean I should stick some SQL into my little code that is...

Short version - DCount super slow. Why? Detailed version - I have a DBase with 1200 hospital patient records and growing. I use DCount to see if a given person's medical record number is already in the dbase to avoid duplicate entries. I think I should do it this way rather than not...

Thanks Thanks Neil, Wayne for your help, and to all on the forum whose replies I have benefited from immensely I say thanks. -Nelson