Search results

  1. C

    Probably a Simple One

    In my form I've got a bound object frame with images in each of them. I've got it set to zoom so that it makes it the size of the frame....my only question is how do i get the pictures to center themselves in the frame. Not a big deal but i want it to be perfect...(perfectionism?) naw... Lol...
  2. C

    Shaded in Field

    We are sending out "member information" and would like the field area to shade yellow if there is no information in it. How would I go about doing it. I've tried the conditionaly formatting but I don't know how to tell if that if it is empty to shade yellow. THanks -Jerad
  3. C

    Embedding Pictures

    What is the simplest/quickest way of adding pictures to a form? I have a member database and I want to create another table that has the member number and then their picture. So in the form it displays all of their information plus the picture that goes with their id number. :) Thanks I know how...
  4. C

    Sort of a POS

    I'm currently trying to make a basic POS System (Point-of-Sale) for the restaurant I'm working at. I would like to be able to click on lets say a button that says. "Vegetable Soup". I want there to be a window on the right side of the screen that says Vegetable Soup. The purpose is that I can...
  5. C

    WordPerfect Notebook and Access

    Does anyone have a clue on how to convert a *.nb file into excel or access so I can make a database with it in Access. It's a WordPerfect Notebook file and Excel can't seem to convert it properly. Neither does Access...any help would be tremedous. Thanks -Jerad
  6. C

    Having a log in type deal.

    Ok, maybe this is difficult maybe it's a piece of cake. What I idealy want is: Have a switchboard with a couple of choices. View Info, Edit Info, Exit Ok with the View Info button I want the searches to come up and only be able to view it...almost as it was locked... Now the Edit Info button I...
  7. C

    changing the date

    This is probably a simple fix. OK I have Office XP One of my fields is Sale Date: well i want to type the date like 10/10/03 and i want it to show 10/10/2003. Instead it turns it into 10/10/1903...wow that's an old sale. There's probably a simple fix but i just can't figure it out. I've tried...
  8. C

    Mail Merge or Report

    Hello again! I'm trying to make a roster book with "Member Information" and I was wondering if a Mail Merge in Word would be better or if doing a Report in Access. The reason I ask is the way the report is showing is giving me on page for each record, but I want (if it's possible) if three...
  9. C

    Query Filter

    Ok, what I would like is on my query. I have Lease and Insurance on my customers. Basically what I want is a list of the customers who doesn't have a Yes, Yes (yes insurance, yes lease) but I also don't want it to show me the N/A for they are "Not Applicable" lol. Thanks, CodeCracker0291:)
  10. C

    Pop-Up Box

    Basically I would like a button to open a pop up box so I can type info in it. I want it to look like a seperate form but the info is still held in the main form...If I worded that confusing.. Let me explain. I have "SBS" as my table. It has all my cells with info like name, purchase date,etc...
  11. C

    Taking Info from One Table to Another

    Ideally, what I would like done is that I have Customer Status and basically I want if their status is Deceased or so I would like them to be taken out of the main table and placed in a seperate table. I probably would have to have a relationship or something. Please let me know. Thanks...
  12. C

    A Couple of Questions, Could Be Tricky

    Ok I have a few questions about forms and what not. We are trying to record data from our customers..blah blah...Ok What we want is to keep records of the posititions our customers have held. Ex. If John Doe was a governer in 1987 and then in 1989 he changed to secretary or something. Well we...
  13. C

    Forms with Reports

    I basically have a Form that you enter investment info in and then I have a print report command button on the form. Well now if I enter in more than one record in my form and i go to print it or prieview it it brings up all the reports. How can i make it only make a report and print it only of...
  14. C

    Matching

    I have a problem. I've made a form that holds information about a person and I have different buttons to take you to other forms to enter more info about the same person. Even though I made a table with all the info on it when I enter info first and then click the button to go to another form it...
  15. C

    Open if not "Check"

    I'm trying to make a combo box in my form and i have all the payment methods like Cash, Check, etc. well i want if I select Check another text box appears so i can put in Check Number. I don't want the box to be there unless Check is selected.
  16. C

    Find

    Yes, I want to make a macro for a swithboard named "Add info to an exsiting Customer". I want the macro to open a box or something so the user can type in a persons last name and then it searches the record to find that persons record, so the user can add the items they've purchased. Thank You.
  17. C

    Find

    Yes, I want to make a macro for that will allow the user to input a persons last name and then the macro searches the form to find that persons record. I'm making it for a switchboard but I want it as a macro and then the switchboard will run the macro. Thank You.
  18. C

    Table in Form

    Basically, what I want is to put a table in a form and have the table become blank when I go to enter a new record. My only problem is that When I last tried it, I could enter everything and then go to a new record but when I went back it had deleted everything off the table.
  19. C

    Forms Subforms Confusing

    Ok...I've been working on this and I even have a book on Access but I'm alittle clueless. I'm trying to set up a form so that I can put in my customers name, phone, address, etc. and then under that I want a table so I can put what they bought. But I have an inventory as a table. I've tried...
Back
Top Bottom