Search results

  1. M

    yes/no check boxes

    How can I lock a yes/no check box to require that you only pick one or the other and not able to check both? example: new () used() you are only able to pick new or used. what do I need to do!! Thanks!!
  2. M

    Database on the Web

    How would I go about putting a database on a webpage that my company could access through the web?? How effective would this be? I am trying to network two offices that are at least 2 miles apart and I need suggestions on the most effective way to do this. Thanks!
  3. M

    Validation

    I have a form that is used for data entry and I noticed a problem with information not getting on certain reports that I need because of a validation problem, we have codes for all of our locations and within these locations we have codes for the represenative of that location and my queries and...
  4. M

    Combo Box

    I have asked this question before but I still am having trouble with it so I am sorry! I have a form with a combo box and two command buttons one that will take you to intake forms and the other to assessment information, now what I want to do is have the person pick a name from the combo box...
  5. M

    DateDiff

    I am trying to do a datediff for a query to get a age for our clients, but it is not giving me their age it is giving me a long number?? I am using datediff "y",date of birth, date(),) but it gives me something like 24975?? Does it have something to do with the century change?
  6. M

    Open form with record from combo box

    I am trying to get a form to open up to a record that I have pulled down from a combo box and the code that I used is not working can someone help!! DoCmd.OpenForm "intakeall",,,"key = '" & Me!combo11 & "'"
  7. M

    Open form to blank page for data entry

    On my switchboard I have a place for people to enter a new client and it opens a intake form but it opens it to a existing client how can I make it so it only opens to a blank form for data entry???
  8. M

    New to VBA

    I have a combo box in which you can select a client name and I have command buttons that go to forms but I want the form to go to the record of the name selected in the combo box how can I write a code for it to do that???
  9. M

    Is this possilbe??

    I have a intke table in which I have a intake form that we enter new clients on, but I also have another table which is the "master" table for all clients, now on the intake form there is only about 10 fields that need to be in the "master table" how can I make it so that these fields will...
  10. M

    Date Field

    I have a date field in a form that puts in the current date, but when you re open the form at another time it puts that date in, how do I keep it from changing the date, I want the original date that it was first created to stay in there? is this possilbe???
  11. M

    Printing Multiple Forms

    I have a form that is several pages long because of the contents I had to make really 3 different forms and then I made a button to move to the next pages but it is really one persons record on all of these pages is there a way to make it print all of the forms for that person at the same time...
  12. M

    Forms not working Correctly?!!!! Plz Help

    One of my data entry forms is not working correctly when I use the combo box the names are alphabatized and in order but when I try to use the record page forward on the botton of the form the records are out of order? In the table they are in order as well???
  13. M

    Switchboards!!! Help Please!!!

    I am trying to run a switchboard off the switchboard manager and when I go to the form that I have on the switchboard it gives me a run time error 3021 no current record, but I have 1300 some records under that form, Please help have a deadline!!!!!
  14. M

    Check Boxes

    My check boxes in my form are not "checking" in the table. One of them is a "male", "female" check box but when you check it on the form it does not appear in the table. I have them set as yes/no in the table, am I doing something wrong? Molly
  15. M

    Check Boxes in forms

    I have several check boxes in my form, but I can't get it to check it in the table, am I doing something wrong? also on my form I have several drop down boxes but they too do not show up in my table??? Can you help me please
  16. M

    Forms and subforms

    I need to make a main form for all information and I would like to make a sub form for data entry, how can I do this? I already have the main form
  17. M

    Subtraction in reports

    How can I do subtraction in my report, I have two columns one for requested hours and another for approved hours and I have totaled these columns now I would like to see the difference in hours?
  18. M

    Percentages in reports?

    How do you calculate percentages in reports?
  19. M

    Sum of a Count

    Can you do a sum of a count in a report? What I need is I have supervisors by location totaled but I need to total that total. When I do I get this huge number like 2683 but really I want to know that there is 6 supervisors for all locations
  20. M

    Legends

    Is it possible to put a legend in a report? I would need one for supervisor, they are coded now by number like 06 and I need it to tell me on the report that 06=Christina, and also the same for status, everything is coded by numbers status 1= approved, is there anyway to do this in the report?
Top Bottom