Recent content by Jrs2nd

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

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

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

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

I can not remember who steered me to the following code, ( I would have liked to give them the credit due)but it works great for me. remember to include the DoCmd.Maximize in your OnActivate event.(I found that if you switch back and forth between opened forms, it sometimes does not...

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

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

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

Joe thanks, for replying, Here the Query you requested. SELECT [90DAYDUPLICATES].RecordNumber, [90DAYDUPLICATES].AssetID, [90DAYDUPLICATES].AssetDescription, [90DAYDUPLICATES].[Action Type], [90DAYDUPLICATES].[Input Date], [90DAYDUPLICATES].ActionNumber, [90DAYDUPLICATES].[Ex-Date]...

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

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

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

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

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

Hey Braindead2, Once again thank you for taking the time to look at this for me!! I added the recordset info so the Findinfo would use the correct table for its corresponding form. However I must have something coded in the Form Module that is preventing the selected record from displaying...