Search results for query: *

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...

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.

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?

The form properties is ordered by tblAddresses.ADDR#.

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?

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»)

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...

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...

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.

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...

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...

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

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.

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.

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...

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?

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

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.

Thanks, I'll check out the website.

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