Search results for query: *

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

I am dysfunctional today, Not sure if this makes a difference but the Listbox is based on a Union query that combines 4 tables which have about 25% of the fields in common, hence the "opening of the forms in selectcase portion. Would this mean another select case for the : FilterInfo =...

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

Hi Miners74, It did "filter" 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 (...

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

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