Search results

  1. D

    Change database default

    Hello I was wondering if there is a way to change the default database folder with the registry. I know that I can change it by going to Tools, Options, General Tab. But the problem is that when they set-up Microsoft access everyone used to have a personnal folder under there name, what...
  2. D

    Criteria in Query

    Hello, I created a query that has 4 fields, one of the fields name is "code" the data possible in code a are numbers 1,2,3,4,5 and I want the fields to show the following data. if the code is equal to 1 then "assigned" if the code is equal to 2 then "pause" if the code is equal to 3 then...
  3. D

    DateDiff

    Hello I am trying to calculate the Time difference between two fields that I have in my report. Therefore in my control source I added the following calculations. =DateDiff("n", [HrsFin], [HrsDebut]) But I keep on getting syntax errors, that I am missing comma etc......... Does anyone know...
  4. D

    Send report by e-mail

    Thank you I will try that
  5. D

    Send report by e-mail

    Hello, I created a form that has send button that I need to send the current record to the report and then it send it to a specific user by e-mail. I created this code in my Send Button *********************************** Dim strDocName As String Dim strWhere As String strDocName =...
  6. D

    How to Hide the Ask a Question Box in AccessXP

    Hello, I created a program, in accessXP and I would like to hide the "How to Hide the Ask a Question Box" but I need to code this in my code, therefore I don't have to manually remove it from everyone PC, since it is a multi-user database. Those anyone know how to do this with coding. These...
  7. D

    Use Microsoft Word to edit e-mail messages

    I create a little template in word, which has pop up forms and then the last form you have the choice to send the document automatically to a specific recipient by outlook, but the problem is that when the program opens outlook, by default everyone has the "Use Microsoft Word to edit e-mail...
  8. D

    Remove option in Outlook with VBA Code

    I create a little template in word, and when the template is open, you have to fill up the pop up forms, on one of the forms you have the choice to send the document to a particuliar person in outlook. Since I got upgrade to office 2002, my document is not able to open outlook without bugging...
  9. D

    Remove restore option from menu bar

    Hello, I am working with AccessXP and created a customized menu bar using a macro. But the problem is thta when my forms are maximized I have the option to click on the Restore from the menu bar that is place on the top right hand side of the screen, and I also have the choice to enter a...
  10. D

    HIde Office assistant

    thks
  11. D

    HIde Office assistant

    Does anyone know how I can hide the Office Assistant. My db is in AccessXP and it is a multiuser application. I want to make sure that no matter who is logged into my program, is not able to see the Office Assistant. I tried the following code on my Open Form event but it didn't work...
  12. D

    Store data in string

    Hello I have tried the Form_load and also Form _Current but it still gives a Null...I don't see why cause I do see the number in the textbox..... Anymore suggestions
  13. D

    Store data in string

    I have a form that when you click on the cmd button it will transfer the value of the text box to the other form. This is the code I used.... Forms![PCV_Dispatch_form]![txtCodeSupervisor].Value = Me![txtCodeSupervisor].Value When I look at the PCV_Dispatch_form I see that the value was...
  14. D

    Locking a databse in AccessXP

    Hello I was wondering if anyone can help me. I have a little program that I did in Access 97 that locks all the database.... But since I got upgrade to Access XP, I converted the program , but it does lock the databse, but then at the bottom of my screen, on the toolbar I can still have...
  15. D

    Color in Continuous Form

    I have a continuous form that I would like the row to appear in diffrent colors depending on the conditions. I have 12 different conditions and I am using Access 2002, therefore if I use the conditional formatting I am only allowed to have 3 conditions. I was able to do this in Access 97 by...
  16. D

    Problems converting from ACC97 to ACC2002

    Allo Mario, Merci beaucoup pour ton aide......Est ce que vous avez un address e-mail, je vais le sauver. La mienne et dinafederici@yahoo.com
  17. D

    Problems converting from ACC97 to ACC2002

    Hey Mario, Thanks for your suggestion, but I work for the govn't therefore by law, we have no choice to have all our PC in French...... Thanks again
  18. D

    Changing color in countinuous form

    Hello I create a db in access97 and it has a continuous form that the background changes colors depending on what the condition is. It works fine in Access97 but when I convert it to Access XP, well it doesn't display the colors..... Maybe I should mention , I have 12 textbox that are all...
  19. D

    MsgBox in Access XP

    Hello I create a program in Access 97 but when I convert it to AccessXP. All my custome messages, don't go on seperate lines. For example... chMsg = MsgBox("Vous devez inscrire votre nom d'utilisateur et mot de passe pour connecter au programme.@ " _ & "@Appuyez " _ &...
  20. D

    Converting Acc97 to AccXP---HELP

    Oui, j'ai tous verifié, j'ai fiate une recherche sur formulaires...
Top Bottom