Recent content by homer2002

Wow, its been a long time. I just searched to find out how to make an MDE programatically... and the first thing I find is my own question from years ago. Deja Vu

Hi Does anyone know how to print a word document with links to excel... but with the links highlighted (the same as Tools/Options/View/Field Shading/Always does for on screen highlighting, but for printing) TIA homer

...and if you think thats strange and if you think thats stange... i just made a copy of tblBugFixingLog to play with the #Errors ..... and............ the #ERROR Lines just turned themselfs into normal records..... that contain the data that should have gone into tblSQLRecord

Hi all This is an ongoing problem I have had for 4 weeks now. I have made a a system thats acts like a clock In/clock out Out system. the structure is somthing like this ID Username tblDailyLog TimeIn MorningBreakOut MorningBreakOut LunchOut LunchIn AfternoonOut AfternoonIn TimeOut All...

Hi cheers for the info.... but to be fair, I did look & found that code..and it didnt work The problem is, everybody just closes the form if there are no records which is the exact opposite of what I need. I need the form to stay open, set the recordsource to nothing and still display the...

Hi all. quick question Is it possible to compile a .MDB to .MDE using VBA? if so, which is the easiest way? Thanks Homer

Nice, one. I was hoping not to have to make the table again, and cheers for the insight into record locking. I guess i'll have to go over my code ensure i'm locking everything right. Cheers again. Homer

Hi I have a muli-user database that's been creating the odd strange record for me two records that have been created have all the fields data as #ERROR or #DELETED no matter what I do with these records I can't get rid of them or find out where they came from. Can any help me just delete...

Hi i've searched for a simple solution for this andI apologise if this has already been coverered... but I found this little snippet of code to change the default printer, print a report and then change back the default printer.. It looked somthing like this...

Hi All A quick question. Is it possible/Easy to wipe out the standard menu for right clicking a listbox and replacing it with a custom menu. I would like to make some custom functions for adding and deleting records using list box contol instead of having a huge amount of buttons all across...

Nice one, cheers You hit the nail on the head. Dunno how I missed that... :-)

i'm trying to go through a multi select list box with 5 columns.... .... then in Pseudo Code(ish)..... ______________________________________________________ FOR EACH SELECTED ITEM IN THE MULTISELECT LISTBOX MSGBOX "Column 1 = " & listbox.Column(1) MSGBOX "Column 2 = " &...

Hi, i'm having a bit of trouble interegating a multicolumn, multiselect listbox I'm trying to get the bound field and another column from all the selected items.... Everything is ok, but I can't see how to reference a row & column (instead of just the row and the bound column being...

Ok i'm sure this one must be an old skool problem... but I'm using Access 97. If I try to open a form with "Additions disabled" ... and there are no records in the recordsource ... then the form just displays NOTHING.. ABSOLUTLY NOTHING Is there a tried and tested method of opening forms...

Since you are a bit secretive about your code: dim dbs as dao.database dim rst as dao.recordset set dbs=curentdb set rst=dbs.openrecordset("select * from tbl1") or substitute the two last with set rst=currentdb.openrecordset("select * from tbl1") - guessing the recordset wasn't explicitly...