Search results

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

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 all. quick question Is it possible to compile a .MDB to .MDE using VBA? if so, which is the easiest way? Thanks 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...

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

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

Hi Can anyone shed some light on the best way to solve this problem. I have a table (lets Call it tblMyTemporaryMadeUpTable) It has 1 text field (Lets call it MyField) I also have some data in this field like so ________________________________ MyField AABAAB BBABBA ABACCAB...

Hi all thought you might all be interested in a little sample db i put together There are 2 functions of intrest. 1. AddNewFile (Add a new file and places it into a table without any ballooning) 2. ExtractFile (extracts the file back onto a drive) Personally I use these functions for...

Hi I know its easy to catch keypresses, but how do you catch the cursor keys. Am I correct in assuming they dont give any ascii value like other keys?

Hi all. does anyone know how you can make a list box or a combo box that will allow for lists that may contain multiple lines... i.e. I have some Data.... Bound Column ListText 1 Hopefully someone Can work out 2 How to...

Hi all is there (and I know there is) a way to disable objects from being clicked on with the right mouse button? I have tried a few ways, but funnily enough they don't work I tried _______________________________________________________ Private Sub OLEInstructions_MouseDown(Button As...

Hi all I have an bound OLE Object Frame. Embeded in this frame is a Micros*ft Word document. Is there a way that I can open this document in Word using VBA code, instead of right clicking on the object frame and selecting "Document Object/Open"?

Hi All Has anyone else had trouble making a graph that allows a time line. Let me explain I have some data .... say for Example _________________________________ DateOfSomthing ValueOfSomthing 01/01/01 1 02/01/01 2 04/01/01 3...

I have a feeling this is a question for mile-o How do you create add-ins for Access 97? does anyone have any information on this at all?

Hi I'm having problems with a split database. The tables are linked using Link Tables and it is starting to run a bit slow. I thought it would be handy if you could test the speed of the network to see. Maybe somthing like a Ping where you can test how long it takes to run a set of...