Search results

Hi Andy, I’m sorry I am sure its me, but when I go into the application icon in set up, and delete the path leaving it as: myicon.ico, when I press OK, I get an error message ‘The application is unable to set the application icon to the file ‘myicon.ico’. Make sure the file is a valid Icon...

Hi Andy, I’ve tried what you recommended and it does writes the icon file to the directory specified by the client, however it leaves the path in the icon start up as the default that I set. e.g. C:\RM2000\MyIcon.Ico, so Access cannot see it and reverts to the default icon. Regards Eddie

Hi All, With applications sent out to clients using the set-up created by the packing wizard, I find that when the end user decides not to use the default folder, that the application icon I provide gets lost, the program icon reverts to the Microsoft default Access icon. I’ve tried putting...

Hi Andy Many thanks for your advice, it is now copying the file into the correct place. Regards Eddie

Hi All, I've got a minor problem! I have been using the packaging wizard to create a set up program to install a database onto my client's machines. Generally this works well, however on a couple of occasions recently the clients have phoned me to say that the application does not work because...

Many thanks for your help with this, it is now doing exactly what what I want it do, that is the grade is being changed when the score is edited. Again many thanks for your help. Regards Eddie;)

Hi All, I apologise if what I am asking cannot be done. I want to show a range from 1 to 1500 on a table with the minimum and maximum on each record running consecutively. Eg: Table 1 Minimum Maximum Record 1 1 149 Record 2 150 249 Record 3 250 349 etc. As the range in each record and...

Hi Mailman, Thanks for the help, I'm just about to try it the way you have suggested. Regards Eddie

Hi All, Whilst I agree that it is undesirable and more often than not unnecessary to store a calculated value, there are times when it is required. In the case I described in my question, the reason is that although the figures making up the sub-set will change I require the original total of...

Hi All, I need to run the following query in a form: DoCmd.RunSQL "UPDATE Positions SET Positions.PercTot = " & _ "DSum(""[PercTime]"",""OccDet"",""[PosRef] = " & _ "Forms![FhPosnD]![PosRef] "")" & _ "WHERE Positions.PosRef =[Forms]![FhPosnD]![PosRef];" Whilst this query works perfectly it...

Hi Chann, Many thanks I am really grateful for the advice. The reason I needed the advice was that the end users tend to retain old copies of the front end when I send them an update and occasionally one of these old front ends get copied back in error when the computer has a problem or it gets...

Hi Chenn, Thanks for the advice, is it possible to stop the application from opening if the front end number is not the same as the the back end number? Regards Eddie

Hi All, Can anyone help with the following problem? I have a database, which consists of a Data.mdb and a front-end.mdb that I regularly update. The problem is when work is done by a third party on the end users computers either the data or the end-user part of the database gets changed. If...

Hi Jeremie, Thanks for your help. Regards Eddie :)

Hi All, Can anyone tell me how to open a Microsoft Publisher document by code from inside an Access 2000 application? Regards Eddie

Hi All, I use Word to mail merge direct from Access 2000 in the following way: I export a query as a text file with the first record as the name of the fields, I then create and save a word document merging the fields from the text file. The user can then select the records in access and...

Hi All, I left the following message on the 5 May, without success, can anyone suggest who I can contact to get an answer? Regards Eddie Previous Message "I have a major, major problem that I hope someone can provide an answer. I have an Access 2000 system where the tables are loaded onto...

Hi All, I have a major, major problem that I hope someone can provide an answer. I have an Access 2000 system where the tables are loaded onto a Novell 5.1 network with the front end loaded onto 5 computers each attaching to the tables. As the records contained in the tables have grown so the...

Hi All, Eventually I've soughted the problem out, I'd stuppidly forgotten that there was an additional function. My appologies Regards Eddie

Hi All, I'm still having difficulty in XP merging from a query, the code I've used which is identical to what I've used in Access 97 is as follows: Private Sub BtnMailMerge_Click() On Error GoTo Err_BtnMailMerge_Click Dim Filename As String FrmLtrStr =...