Search results

  1. J

    Filtering of Report on Calculated Controls

    Hi sjaresh, If you type > or < 100 in your creteria this will work I am sure of it. However if you want to make this an option and only apply this criteria when a user chooses so. Than just ask me and i develope the code for you so you can use it. Kind regards, Justin van der Raaf Pictures2life
  2. J

    How to open forms full screen

    If anybody is interested i have a code wich makes all the acces bars disapear and open your form even above the windows xpor vista bar
  3. J

    chooise list

    Alright this is the situation, 1 have one table which holds the data of the contact person. the second table holds data about magazines. In this table you can find the price and the name of the magazine. In the tird table ( because if i would like them now it would be a many on may realation )...
  4. J

    linked ID fields in multiple forms change when passed to the table! help please

    Your thinking way to hard, it damages your brains. You have to go back to the basics and then think logic the answere you seek is less complicated than you discribe on this point. Good luck
  5. J

    Filtering of Report on Calculated Controls

    Answer\ When you make a report based on a query, you can there insert a criteria. From iff functions to simple codes as < and >. I Hope this answers the questions you have Good Luck
  6. J

    Background Pictures

    Answer: You can just add any bitmap file that you like. You don't need any program for it. When you found the bitmap you where looking for. Go to design vieuw and open your form, than rightclick -> properties and than choose your bitmap of bg color. Note: Set te picture to linked not to...
  7. J

    Combining 3 fields space problem

    Hi, Im combining 3 fiels with the following code. Newfield: [Field1] & " " & [Field2] & " "[Field3]. So after eacht field a space is placed but when field 2 had no data there are 2 spaces between field 1 and 2. How do i solve this You can react in euther english or dutch Tank you in advance
  8. J

    Restricting display of information

    I absolutly agree with this solution. I made this code so the admin can login and the users have no acces to things they should not have acces to. Private Sub Loginbutton_Click() If (Me.Txtfieldinform1 = "Username") And (Me.Txtfieldinform2 = "Password") Then DoCmd.Close...
  9. J

    My Users Keep Accidentally Closing Access - Need Ideas

    Imade my database comletly with VB and photoshop this is ideal. I made my own menubalk with a close button of my own when clicking on this button a new screen appears. Asking if i want to close yes or no. It's as easy as that. explaining this further is gonna take time so if you really want...
  10. J

    small question probly simple

    Is it also possible to change te name in the taskbar because when you start acces i now have my own logo but after that i see Microsift Acces i dont want that
  11. J

    small question probly simple

    does anybody know how to change the picture of the database to somethng else. Now you see that pictyue of 3 forms I want to set something of my own.please assist
  12. J

    Format Dollar data in Access 2000/03

    he was tryinh to use a code which is folloish becayse acces already has a $ format of it's own. just chooste it at mask i believe. ;)
  13. J

    help needed please assist

    I want to make a sort of loging form for my database s when you enter admin into a text field and a corret password into teh other field and the pressing the login button a form is beiing openend and when incorrect a message is displayed. can anyone help me
  14. J

    please assist help needed

    Thaks but the code you made did't work as i wanted but tanx anyway. i worked the whole day to figure it out and it's quit simple exually here is the code as it should be als default information heb ik een clock Private Sub Form_Timer() Me!Ilabel.Caption = Format(Now, "ddd hh:mm:ss") End Sub...
  15. J

    show text at focus

    the solution tanks for the help but that wasn't what i meant. i worked the whole day to figure it out and it's quit simple exually als default information heb ik een cloc Private Sub Form_Timer() Me!Ilabel.Caption = Format(Now, "ddd hh:mm:ss") End Sub TIMERINTERVAL MUST BE SET TO 1000...
  16. J

    Simple Formula Problem

    you need to use a som qeury in that query you can set the field witch needs to be devided in one of the field and put the code there. And than you co back to teh from and select the field from the query and TADA
  17. J

    please assist help needed

    I made a database for models witch uses a controller. open the picture ballow to understand my problem better. The problem i have is that i want when focus is on one of the bleu balls a small discription come in the box show in the picture. i tried usig a label and a caption code but this...
  18. J

    Simple Solution Needed Please

    solution the solution is very very easy the db is made on a other pc and when it was made only that pc had admn rights. so al you have to do is make a nother copy with different name and then you pc will thik it's a new file and sets your name as aditor and you will automatically have l rights...
  19. J

    show text at focus

    Please help me if anyone knows a salution
  20. J

    show text at focus

    I need some help with my DB This is my database cotroller the next and back button work fine. the trouble i have is with the bleu balls when you focus on one of the balls a text must come to the text field. i used a label and an caption code but i dont get it to work i still need to click for...
Back
Top Bottom