Recent content by AndyJ

Is it possible to use a macro to enable a database user to input a value on a form, click a button and have the database search a table for matching information? I know you can use the Ctrl+F (Find/Replace) function to do this - but is it possible to have it as a permanent option on a form...

This might sound like a really dumb question but.... How DO you close the database properly? I've put an exit button on the front page which activates a macro to close it down. I either use this or just click the X in the top right corner. Is there some sort of procedure that I'm unaware of??

Further to my previous post... I received the error message again, it reads as follows: "The Database needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsoft Access to...

Or rather to a specific cell in a spreadsheet? I want to add a hyperlink field in my access database which will enable the user to view data relating to a record on an Excel Spreadsheet. So far I have been able to link to the spreadsheet but not a specific place within it. Is this do-able?

Why do I keep getting an error message.... when I try to open my database? The database has been used by my colleagues for the last 3 months without any problems whatsoever until this week. When they tried to open the database this morning (and yesterday) they were greeted with an error...

The database is to be used to store information regarding the development of projects within my organisation. Basic information to be held is stuff like Project Name, Reference, Description, Impact, No. staff Affected, key dates, contact details, solution methods, costs etc. I simply requested...

Yes, there's 70 fields in one table (I know that's not very efficient but I'm only an occassional Access Dabbler with limited ability!). There are other tables too, I have created a table simply listing the 70 fields used in the main table, this is the data-source for my proposed pick-list...

I have created options on a form that allow a user to Print, Send to e-mail or Open a report in Word (printing ALL records). I have also inserted a combo-box from which the user chooses a SPECIFIC record to print (using a WHERE condition in a macro). Is there a way of allowing the user to...

I have created a database which has about 70 fields of information. I have created standard reports featuring the data that I think my customers will require. However, to enable my non-technical colleagues to be able to select which fields they would like to include in an ad-hoc report I have...