Search results

Followup Hi, I've done that. But it gives a running sequence to the end of the report. My report is about 20 - 22 pages and with each page I want the detail number to start at 1 again. Theres another catch, each page has 1 - 3 groups. Suspect this needs to be done with code vs. a control...

Follow-up Hi, I've been searching for a similar answer to this problem. I'm using the =1 to show line numbers, but when it's grouped the number starts over with the first line in the next group. Is there anyway to have it continue without starting over with "1". Thanks, Bob

Hi, Two different actions all together. The Label will show a short message depending on what is happening on the form. The other timer I want to allow the user only 10 minutes to do his inputing. The reason here is so they don't walk away and leave the application open.

Hi, Is it possible to have two timers on the same form. I have a form where a label is turned On and Off by a timer event. But I would like to add another timer event to close the application after a specified period. Thanks, Bob

Hi, I've been looking and adapting your Login/Password code, and I'm making a little progress. Very impressed, it's what I've been trying to do for some time now. Would it be asking too much for you to post the other part that deals with changing, creating new users and password. Also, can...

Hi, I have a combo box on a form that I created from the wizard. The box shows two fields, the Asset Number and Description. Upon selecting the Asset/Description the associated record opens in a subform. This is good, but after the record in the subform opens the combo box now shows only...

Delete dups Open Table, then menu Tools > Office Links > Analyze it with MS Excel. Create a macro in Excel and paste the following code, go back to your worksheet and highlight the SSN data column (only the data, not the whole column or the header) and run the macro. You may have to run the...

Hi, You all have no idea how much these forums mean to me. I've been fighting creation of a db to an .mde that just wouldn't go. Ran the dubug and found four errors, code that was left over and doing nothing. Removed it and presto, an .mde file. Your suggestions above did it. THANK YOU!!

Hi, Hate to be a pest, but..... Now I get Run-time error '2501': The OpenForm action was canceled. Saying I clicked Cancel in a dialog box. :confused: :confused:

Thanks, Getting there, it now opens to a blank record, not the record I need to edit. Have the following now: Private Sub Purchase_Order_DblClick(Cancel As Integer) Dim PONum As String PONum = [PurchaseOrd] DoCmd.OpenForm "tblpurchaseorder2", acFormDS, , [PurchaseOrd] =...

Hi, I have a form with a subform in it. I want to double-click one the the fields in the subform (PurchaseOrd) and have a tblPurchaseOrder2 form open to that particular record so I can edit a value in the record. (The value in the subform that I want to edit is based on an expression from a...

Hi, I work alot with Access, Excel and SAP. Especially with reports. I've posted here and received alot of great help and deeply appreciate this forum. My question is, I am trying to get some experience, to broaden my scope (and please the boss) and get into Impromptu reports/templates to...

Hi, My IT Group is telling me that it is possible to install both Access 97 and Access 2002 on the same computer. I say no. Who's right. I have Office XP on a LapTop I'm using for a special project and I've created a db in Access 2000, but I saw later, that it would let me create in Access...

Hi, I've been searching high and low and can not find the Image/Pic file used in the "Command button" - "Picture" property. I would like to use an image elsewhere and thought it would be easy just to copy / paste the image. But cannot locate the folder where they reside. Anyone know what...

Wayne, Currently I'm very happy that I got the app to where it's at now. The only drawback is it opens a Notes session if not open already. But is very clean and quick if a Notes is already open on the user's desktop. What I would like to accomplish is for it to pull info from the Notes db...

Wayne, Since you mentioned it, I'm also working on a Notes app, interested?

Hi, I agree. However it was a good learning experience. Don't regret that part. After all that work and time, especially from Wayne, I wound up coping the fonts to the users desktop. Less than a minutes work. But I do appreciate Wayne's time, but again it was a learning experience...

This will be the last, also found but very confusing: Call fontAdd("MSGothic", "MSGothic") Private Function fontAdd(vsFontName As String, vsFileName As String) As Boolean Dim sTmp As String, sSysPath As String Dim lResult As Long Const COPY_TO_FONTS_FOLDER = False #If Win32 Then sTmp =...

Wayne, Found this bit on a site: you can use AddFontResource()/RemoveFontResource() to add/remove fonts to the system font table for displaying it. To make the font installation permanent, the program should add the font name and filename to the registry by writing both of these values to...

Wayne, Well, it was a long night and a longer day. Getting message "Added 1 fonts" Seems to be doing something. Now will have to test at work and see if a machine I know that does not have the font will display the new font. I'm sure 'Thanks' is not sufficient. Just wish I could shake...