Search results

Hi There, I have a documentation control system that I wrote in Access many years ago for my company. It has always workd very well, with a table populated with hyperlinks to a server drive that opens the documents when the user clicks on the button in the forms views. Today I have had a user...

Hi There, I'm gettng really frustrated with a query that should be quite simple. I have a query that pulls out data from a table based on user inputs for 'start date' and 'end date'. This is done using the "between [Start Date[ and [End Date]" function in the query. This sounds simple enough...

Continuous forms and combo boxes - HELP!!!!!! Hi There, I am developing a database to capture information on a production line. I want to capture name, machine, checked by etc. I am doing this by using a continuous form with a combo box that is set by a query which looks at another filed on...

Hi There. I have a database that has been working merrily for the last few years in Access 97. I have recently converted it to Access XP and now I have some problems. The main form is just a pile of unbound boxes that get enabled or disabled based on some user choices at the menu stage. I then...

Good Morning ! I am currently developing a database for work and want the backgrounds of my menu forms to look nice and snazzy! I have previously used the background styles that come with XP as follows: C:\Program Files\Microsoft Office\Office10\Bitmaps\Styles\ACEXPDTN.GIF As you can...

I'm having a problem with my shortcut menus in a database I've just distributed to runtime users. Some forms have a custom shortcut menu for searches etc. This menu works fine on my PC as I have the full-blown Access XP version. However, on the runtime users' PC's, the shortcut menu isn't even...

I am developing a database to control the documentation system within my company. It will control the procedures and who they are issued to. I have the following code which opens a new Word file: Option Compare Database Private Sub word_button_Click() On Error GoTo Err_word_button_Click...

I am developing a database to control the documentation system within my company. It will control the procedures and who they are issued to. I would like it to hold links to all procedures within our system. Is there any way of linking to Word files from within the database, and would this have...

Hi, I have recently upgraded my PC from Access 97 to Access XP Developer (I know, a bit of a jump !!) and I am having some problems with the converted databases. Queries that use the DATE() function are now bringing up the error message 'Undefined function DATE in expression'. Can anyone tell...