Search results for query: *

Hi folks, I have several linked projects with a shared resource pool. Can anyone advise if it is possible to set the priority of one project to be higher than another at the Project level so that the higher priority project has first call on the shared resource when levelling? (I know that you...

Hi Folks, I have an Excel application that I use to draw a whole series of charts from an Access database, and these are updated weekly. This means that the number of rows imported for each query increases by one each week. Originally I used the wizards to do all the connection stuff, and so...

Hi Folks, I want to be able to distribute an Excel graphs report spreadsheet, along with a corresponding Access database, for users to install in any directory. So, I need to be able to modify the importing of the various data to Access and queries from Excel to suit the installed path, but I...

Hi folks, I searched through loads of posts about Date arithmetic etc. but can't quite find a situation like I have: I work with an old database which has separate pairs of fields, StartDate and StartTime, and EndDate End Time. I need to calculate (in minutes) the elapsed time between start...

Hi, I develop and maintain a database on our network and recently replaced the full standard menus with just a custom Report Menu to prevent users tinkering (built with the usual Access menu wizards). I have since found that the standard Access "Save As/ Export" function that I added to the...

Hi folks, I have a tested and working function that works out what the drive and path of the db application is. It is placed in the "modules" section of my database. When I try and "run" it with a RunCode command from my Autoexec macro (or any other) Access says it can't find the named...

Hi folks, I have searched the archives but think this is a new question: has anyone had this sort of problem? I have an Access 97 stock control application which conditionally e-mails various people with a report in Snapshot format (.snp file extension) as an attachment. The list of addressees...

I have a long Form which is divided into manageable screen-sized chunks using three separate tab buttons. I want one of the tab buttons to run some code when pressed, however I have found that any perfectly valid code segement (tested with another command button)refuses to run when placed in the...

Hi folks, I have a very strange "intermittent" problem with some Access 97 reports, so I'm hoping someone has seen this before. In my standard report Vba coding I have used the OnFormat and OnPrint events to control things like forced starting page number, conditional page breaks, facing page...

Hi folks, I am having great difficulty in try to create a Select query which will extract both alpha and numeric data from a Text field in a Parts database correctly. I have two tables called "old" and "new" and I need to compare one specific field called...

Hi folks, I am trying to use a hyperlink field in my database to link to external .tif files to display scanned images when selected. According to my understanding of the Access "help" details, if I don't want an absolute hyperlink address I can make a relative address by putting the...

Hi folks, I have an engineering database that I distribute periodically to customers on CD ROM. I have found from previous issues that people will tinker with things, so I need to make it "idiot proof". Is there any way to prevent the user from editing or creating new queries and...

Hi folks, I did look under FAQs, honest, but could not see anything quite like my question: I have a form with an option group of five buttons which select different reports for various records depending on which option button is selected - so far so good. I now want to grey out certain...

I am a relative newbie to using the Visual Basic underlying Forms, etc. I am trying to select different reports with a Form which displays various Parts data. In VB I have worked out how to select different reports based on the state of a data type field OK, however I want to add an unbound user...

I am a relative newbie to using the Visual Basic underlying Forms, etc. I am trying to select different reports with a Form which displays various Parts data. In VB I have worked out how to select different reports based on a the state of a data type field OK, however I want to add an unbound...