Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jrs2nd

    how to create a popup "msgbox" that counts down and closes app?

    Kalin, Thanks!! worked like a charm. I appreciate the time you took to help. Jim
  2. Jrs2nd

    Setting up a form with a records "view" on it

    David I would use a list box instead of a text box to list the records and a Combo box based on a two record table (open or close) and in the On after update event of the combobox...requery the listbox(something like " Me!Listname.Requery")...In the listbox have it base on a query...
  3. Jrs2nd

    how to create a popup "msgbox" that counts down and closes app?

    I am trying to create my own msgbox to Popup and display decreasing numbers: 10 , 9, 8, 7,.....and when it reaches Zero the Application closes the following is the code I have written so far but, no joy. any help would be apreciated. (timer interval = 1000)not sure if it's right have not...
  4. Jrs2nd

    Maximize forms without top right buttons

    OOPS!!! I forgot that you need to create your own custom "menu" bar and in the start up options in the tools menu select this new custom menu bar and right click on the toolbars select customize and then deselect the access pre-built menu bar. Jim
  5. Jrs2nd

    Maximize forms without top right buttons

    ...position.) Place the following in the Form_YourSplashformname_OnOpen event: RemoveCloseButton Me.hwnd Copy the following into a NEW module: ************************************************************ Option Compare Database Option Explicit Public Const MF_BYPOSITION = &H400 Public Const...
  6. Jrs2nd

    Problem on split db trying to link to wrong backend

    Databaseguy, Thanks, Made all the difference! not sure what I was thinking!!..forest for the trees kind of thing... I guess Jim
  7. Jrs2nd

    Problem on split db trying to link to wrong backend

    I split a db and it work fine for a while had some problems with the ldb file not releasing, and one table was corruted so I copied all of it into a new db(named something diff) and rebuilt the corrupted tbl from scratch.Then I split it. it links trys to link to the old back end... I looked at...
  8. Jrs2nd

    How to "open'' frm hidden if listbox is Null/close if not show frm?

    Hey Joe!!! Thank you very much, it's working perfectly, I also like the added msgbox for "no matches", will let them know it it's working....I appreciate the time you used to help me. Jim
  9. Jrs2nd

    How to "open'' frm hidden if listbox is Null/close if not show frm?

    ...Date], [90DAYDUPLICATES].ActionNumber, [90DAYDUPLICATES].[Ex-Date], [90DAYDUPLICATES].[Expiration Date], [90DAYDUPLICATES].Status, * FROM 90DAYDUPLICATES WHERE ((([90DAYDUPLICATES].AssetID)=[Forms]![frmSprvsr]![txtAssetID]) AND (([90DAYDUPLICATES].[Input Date]) Between Date()-90 And Date()))...
  10. Jrs2nd

    How to "open'' frm hidden if listbox is Null/close if not show frm?

    Hey Joe, I, not being the fastest chip in the computer, didn't know that was possible.. it would be amore elegant way of achieving my goal. How would I go about doing that?? If you could steer me in the right direction, I would appreciated it. Thanks, Jim
  11. Jrs2nd

    How to "open'' frm hidden if listbox is Null/close if not show frm?

    Hi, I have a form(Popup/modal) that I wish to use more like a MsgBox. It's based on a Query that takes the Value of a textbox and searches the records input over the last 90 days for matches. I presently have this set up as a CmdButton and it opens properly and displays the matches( if any)...
  12. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    Thanks again, Know how Admins are..... study in paranoia Jim
  13. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    PS. Braindead2, you should join the service/forums.. costs nothing and I could vote your tip as very helpful(to me at least!) just a thought.. :o) Jim
  14. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    Hey Braindead2!!!!! the following code that you recommended(with the two additions in red} worked perfectly!!! no need to apologize... if any one should, it should be me for not explaining myself clearly enough!! your code is soo ooo much more elegant than the maze like mess I came up with...
  15. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    ...AlphaNumeric ID# for selecting which form to open sRec = List35.Value sRec = Mid$(sRec, 1, 1) 'Str = "Like" & Chr(34) & sRec & "*" & Chr(34)'for Miners74 suggested method Select Case sRec 'Select the right form Case "A" ' ' tells which record should be...
  16. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    ...As String sRec = List35.Value sRec = Mid$(sRec, 1, 1) ' this will give you the 'D','G' or 'F' Str = "Like" & Chr(34) & sRec & "*" & Chr(34) FilterInfo = "(PCADomestic.[RecordNumber])" & Str Case "D" DoCmd.OpenForm "frmPCADomestic", ...
  17. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    braindead2, Thank you for responding. unfortunately sRec only gives the 1st character in an alphanumeric id number.. ie "G"0001 or "A"01571. but I like your idea, any way to incorporate it with my 1st response to Miners74 suggestion? it may be something simple but being...
  18. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    ...the form, however the record did not display I have a textbox that contains the following code: ='Record ' & [CurrentRecord] & ' of ' & Count(*) which shows me the number of the record "out of" the 'filtered(or not)" recordset. when ( after DblClicking on the record in the...
  19. Jrs2nd

    How to select Rec from listbox on Frm1 & open Frm2 diplaying the Rec

    If you were not able to understand my shorthand: How to have a record selected from a listbox on one form open another form displaying the selected record? I presently have the following code, (in the onDblClick event of the ListBox)which does open the correct form properly. ( there are 4...
  20. Jrs2nd

    How to open diff forms depending on selection in a listbox?

    Hey NickJar2 and Aivars, Thank you very much for the Quick responses and helpful replys!!! NickJar2, your code was perfect down to the .Value ! I finished off the cases and added the error handling and it's smooth sailing!! Aivar, That code is extremely useful!!! I have used it for a Master...

Part and Inventory Search

Back
Top