Search results

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

Hmm ok I've found the Microsoft DAO reference and now i can can get the autofill word 'database' when I SET it. Now when I try to pull out a recordset .... Set rst = dbs.OpenRecordset("SELECT * FROM tbl1") all I get is an error message TYPE MISMATCH (runtime 13) Do i need to reference...

Hi i'm has just upgraded to access 2002 and am having problems with the VBA to be presise i'm trying to implment the line DIM dbs as database or DIM dbs as dao.database for some reason access 2002 won't find database in the auto text and it doesnt like it as a type what am i doing wrong???

Hi All I have searched the forums for help on this little problem of mine and been unable to find anything that does what I want. I have a list box with about 15 fields displayed and its a nightmare trying to get all of the column widths correct. Is there any way that I can set the listbox...

Hi all Does anyone know if it is posible to grab the time on any server I am using Access 97 at work and coding a Clock in/Clock out system. The problem is when Using Dim Clockin as date Clockin = Now 'or ClockIn = Time 'or Clockin = Date the values are retuned from the system. So basicly...

ta for the info. If I were going to code this. I was thinking more of somthing like this. I dont know which would be faster, but i like the way i could reference your code within a query please excuse the tardy pseudo code ____________________________________________________ Function...