Search results

  1. P

    creating a field "String" from multiple records

    I have a database (Cnpr 2003.mdb) and inside a table "Table1" and a field in that table "Email_Addr". I have a list of names and email addresses. i am trying to create a field that merges all of the records "email addresses" into 1 string separated by a ";". (so i can email via outlook to a...
  2. P

    Duplicate data

    I have a form named "frmvehicles" in that form is a field "vin". it is 17 digits long, and auto tabs to next field. I want something that will tell me if the 17 digit vin number has been IN My system before, and if so pull up a form Called FrmHistory. I need the system to ask "Would you like...
  3. P

    Opening a form in "NEW" data mode as opposed to showing existing records

    How do i force a form to open in INPUT mode as opposed to opening showing existing records?
  4. P

    Forms resize themselves

    I am using access 2007 to update an old db. The records are still 2003. When i open up a few of the forms, they open maximized, which is not what i want. I have resized them, changed fit to screen to no, changed autosize to yes, made them thin border not resizable... nothing works. Some of my...
  5. P

    viewing form in datasheet format vs single form format

    I have an 2003 db that i am using 2007 to update (have not converted records yet.) on my switchboard, i have a button for a form that was created in datasheet view. I have changed the properties to NOT allow any other view. If i open the form from the navigation I view it correctly in datasheet...
  6. P

    Entering data to form with NOT ON LIST and cascading combo boxes

    I have a 2007 Access DB, which i am developing and want to then import data from an existing db. i have a form [frmvehicles] that adds new cars, when a new Model [one not prev on list] is entered, the form will as you if you want to add it, then add it to the tblmakemodel, and go on to next...
  7. P

    convert a yes no field to excel in order to import to new access table

    I am trying to export a table to excel from access 2003 db [but using 2007]-- a lot of the fields are ck boxes on the form, or yes/no fields. WHen I export them, they become true false. this is a prob though when i try to import them into a new db, says wrong data type.....its a query in the...
  8. P

    copying contents of one field to another [duplicating]

    I have an old data base, with 98k records, and am designing a new front end. I have had to add one field. now i have 98k of records that are missing this one field. if i import, it doesnt append to fill in that field, and i cant copy one column and paste to other like i thought i could. (think i...
  9. P

    copying contents of one field to another [duplicating]

    I have an old data base, with 98k records, and am designing a new front end. I have had to add one field. now i have 98k of records that are missing this one field. if i import, it doesnt append to fill in that field, and i cant copy one column and paste to other like i thought i could. (think i...
  10. P

    Problem with relationships between 2 tables/ queries

    I am trying to set up a vehicle inv file [access 2003 db but using access 2007]--the tblvehicles includes info about a particular car, the tblequip which is linked by an equipid decribes detailed equipment about that car. My problem is that somehow i must have the relationships screwy... when i...
  11. P

    file sharing lock count exeeded, increase maxlocksperfile registry

    I am trying to take an old, sad out of shape datea base, with about 98k records, [on access 2003] and clean it up using table analyzer. I keep getting this error "file sharing lock count exeeded, increase maxlocksperfile registry". I found the instructions to do this, and changed the registry...
  12. P

    If command to produce different colored font upon certain criteria?

    Is there a command or code that will produce different color font if the field contains certain criteria? For instance, if the AgentID field contains the words anywhere in there "NEED AGT" then the form will display that field writing in red? to stand out? I tried to play with some commands but...
  13. P

    Converting an Access 2007 Data base to earlier version

    I am creating a new data base in access 2007, just getting finished. I want to maybe coordinate that and use for antoehr company we have , but would need to convert it to access 2003 format. The program says you can do this, but when i try i get an error that its opened by another user [user...
  14. P

    Setting up to show only last 4 digits on ss# OR credit card field / using input mask?

    I have a form that gathers employee social security numbers. I am using access 2007. Is there a way to [after info typed in] only display the last for digits of the SS#? so 444-44-4444 would show as ***-**-4444? I have done a search but not finding anything. I could have sworn i saw this...
  15. P

    Populating a field after adding a record to combo box when notonlist

    I am using Access 2007, and have some cascading combo boxes, that i would like to populate one of the fields after i add a new record. if you look at my form [frmvehicles] i have a cascading combo box for MAKE and MODEL. When you select a vehicle make, the combo box for models [cbomodel] only...
  16. P

    Displaying data from data base on web site

    I am using access 2007. and Expression Web2. I was trying to get an inventory list to display live on my website, and created an .aspx page to do that. works fine in preview mode, but couldnt get it work once published. after 2 weeks of pulling my hair out, i didnt figure out how to do it only...
  17. P

    Pop up form to enter new info when item is not on list

    I am using access 2007. I need some help. I have a vehicle input screen, that has a combo box for the dealer the car belongs too. When the dealer i am inputting [dealerno] is not on list, i want a pop up box to come up [frmdealerpopup] asking if i want to enter the dealer. The "YES" generates...
  18. P

    adding a look up field based on info i enter

    In my database, there is a form frmvehicles. i would like the zip code field to populate based on teh DealerNo i select [in other words, when i select a dealer/ that dealer is linked to my forms, and would like the dealer's zip code to automatically populate. i have been playing with this for a...
  19. P

    Adding a command button to link 2 forms/tables

    I am trying to update an older access (2002/2003) database to 2007. I have a Form [availableInventory2007] that i enter vehicle info into. I then want a button that will open a seperate screen [Equip2007] and allow me to ck boxes for the equipment for THAT particular vehicle. My form...
  20. P

    Updating a field using combo boxes and command button

    I have a database in Access 2007. ON my form [frmvehicles] i have a combo box field for cboMAKE, once selected will allow the user to use another combo box cboModel. if an item is not available on the cbomodel, i have a button [add model] that will allow a user to open a subform...
Back
Top Bottom