Search results

Ranman, I used your code as an example but modified slightly. The field i am looking up in the Table is UserName (its a Surname+last 4 digits of social security number = e.g Potter2345) the table is called ClientInfo and the textbox is txt3. Your script does a lookup in the table and lets the...

Sorry Doc Man, there is no domain. It will be a simple kiosk type setup for the general public to visit the career center. we have to track the number of daily visits and the towns visitors come from.

Thanks for your help Ranman and TheDBguy. Your insight helped greatly, I do simply want to append the date to a table and record the number of times a person visits. I also did run into the 'duplicating user info' issue. To get around this i did the following: I created two Tables - 1) Client...

Hi I am working on a client sign in system using a form. Table is ClientInfo Fields are: ID. UserName. BirthDate. Phone. Last4SSN. FirstName. LastName. Email. And Date. The date is set to default value ( ). For today and it automatically assigns today's date to your visit. I have a form that...

SOLVED: Thanks MajP and Ranman for your insight and ideas. the problem turned out to be with the cboBox. The sql did not include the third column but only the ID and the Service name. By adding SELECT ServiceCodes.ID, ServiceCodes.Service, ServiceCodes.ServiceAmount FROM ServiceCodes; to the...

This is quite confusing. it is a form pulling info from a couple of tables. the calculated field works partially depending on Column number. ServiceCode table ID ||Service || Amount 7 ||Job Coaching ||...

Good morning everybody. I am working on a fairly simple calculation concept that is giving me the dreaded #Type! error. at present the two tables causing the issues are ServiceCodes Billing ServicesCodes has 3 fields: AutoID ServiceCode ServiceCodeAmt - longinteger, general number (contains...

Thanks great answers. I goofed up somewhat though. taking a look at the form, it is based on a query i designed where EligibilityDate was created in the query design by inserting "EligibilityDate: [ApplicationDate]+60" so on the corresponding form if i enter in an application date, it...

Hi All, I am not a developer but someone who uses Access to streamline work tasks. current situation: if an application for services is turned in, i have 60 days to determine eligibility for our services, if deemed eligible i have another 90 days to draft a plan of support. I have all kinds of...