Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cheiboy

    Form data autopopulate

    Yeah, all the address fields, they're currently seperate combo boxes Address # Practice Name Address City State Zip These are fields from the tblAddress, linked by ADDR# to tblRepSiteVisit. They enter by address number, so by entering the address number, the rest of the combo boxes should...
  2. cheiboy

    Form data autopopulate

    Nope, no luck, changed all the address fields and still not keeping them together or autopopulating. I've had problems with this database since I inherited it two months ago.
  3. cheiboy

    Form data autopopulate

    If I go with the combo box, will the rest of the address fields auto populate when the address number is entered from tbladdress, if I use the dlookup function?
  4. cheiboy

    Form data autopopulate

    The form properties is ordered by tblAddresses.ADDR#.
  5. cheiboy

    Form data autopopulate

    would the dlookup function populate the other address fields afterupdate. Probably so, but would the six address fields need the dlookup in the afterupdate property as well? Oh, do I need the query for this?
  6. cheiboy

    Form data autopopulate

    Ok, I've put this on the form, in the ADDR text box, using DLookup («expr», «domain», «criteria») as a guide. Would it then look like this: DLookup ( [tblAddresses]![ADDR#] , «criteria»)
  7. cheiboy

    Form data autopopulate

    Hey guru's. I've been working with this form (S Contact Sheet)now for about two days . It's based off of a query (qryRepSiteVisits) with two tables(tblaAddresses and tblRepSiteVisits)in the query. The form will be a data entry type of form that will assign a 'visit' (auto)number for each...
  8. cheiboy

    Merging two tables

    Sure, here they are: The fields from the CONCERNS table: NewCONTROL_NO CONTROL_NO REVIEWER REFERAL_DT RESP_DEPT RESP_RECDT PRIMDOC_REVIEWER CONCRN_CD CONCRN_CAT REFERL_CD AGENCY_NAM AGENCY_ID SUB_CAT RESULT_CD ACTION_CD REPSRC_CD CLOSING_DT OCCURRENCE_CD RESPONSIBILITY_CD REFFEREDTO_CD COMMENTS...
  9. cheiboy

    Merging two tables

    There is a field for 'COMMENTS', whre they do just that, in the CONCERNS table. Is there a way I can limit them from entering another case/record for the same patient.
  10. cheiboy

    Merging two tables

    This is similar to a customer database, except that it is patient based. But since each new 'complaint' is different that the one before, and not very many are the same, It would require a new 'concern number'. Normally there is no duplication, but lately the RN's have been adding a second...
  11. cheiboy

    Merging two tables

    How difficult is it to merge two tables that are linked by a control number without mixing them up. I have two tables that make up a form and a sub form linked by a control number. I want to make one table out of them to eliminate duplicating "concern" information in the subform. This...
  12. cheiboy

    Conversion Issues

    Hey, can anyone tell me why I'm having problems getting a 97 database to work in 2000? Any suggestions most appreciated. Thanks.
  13. cheiboy

    Conversion

    I'm working on a copy so, I haven't lost any data yet, I'm just trying to get it to work in 2000. I think I'll work on the macros in 97, then take it to 2000, see how that floats. Thanks.
  14. cheiboy

    Conversion

    It's still not working, still getting the same messges. I'm getting desperate. If we upgrade to 2000, I won't be able to get this working. Any other ideas? Unless I create the macros for ALL the commands then redirect, but I'm hoping to get around that somehow.
  15. cheiboy

    Access database - Multitude of errors

    I'm also having a few issues with Access 97 going to 2000, I'm getting messages like "File not found" and "The Visual Basic for Applications project in the database is corrupt". Any ideas as to how I can get all my forms into 2000. Additional Note: the buttons on the 97...
  16. cheiboy

    Conversion

    Someone please help me. I'm trying to set up our datebase in Access 2000, and it's not going smoothly. It keeps telling me "File Not Found" then "The Visual Basic for Applications Project in the databse is corrupt". Any ideas?
  17. cheiboy

    Opening Form

    Once again, thank-you. I'll let you know how it turns out. Steve steve.bigman@hcs.maricopa.gov
  18. cheiboy

    Opening Form

    Ok, How would I incorporate our company logo and the Missions statement into this flash screen before going onto the database. Sorry about this, I'm new to all this fancy stuff.
  19. cheiboy

    Opening Form

    Thanks, I'll check out the website.
  20. cheiboy

    Opening Form

    Does anyone in here know if you can do a 'flash' presentation in Access 97 similar to a website? Thanks.

Part and Inventory Search

Back
Top