Urgent Required Field Advice Needed
Jul 1, 2005
I'm looking for advice on the best method to accomplish the following from the esteemed members of this Forum (You all have provided excellent advice in the past to this Access Dummy, with my thanks), (I've also searched the forums without result):
I would like to make several fields "required" fields on my form, easy enough, in that I set the Required property on the table to "Yes".
What I would like to happen on the form is that when a user tabs out of a required field, a message box pops up that says "This is a required field" and/or when they click any of the following command buttons I've created, "Save Record", "New Record" or "Close Form", that a message box pop up and list the required fields that they missed.
Any ideas, with code, macros, or other solutions would be greatly appreciated, keeping in mind that I'm just not that swift to start with.
Many Thanks,
Photoguy
View Replies
ADVERTISEMENT
Oct 3, 2005
Hi,
I hope someone can help me, I have a database compiled from different sources which means that information in fields that need to be linked are written differently, meaning that I can't just simply make a relationship between them.
The two tables I would like to link are,
Table 1 has the fields OCCUPATION and AMOUNT and contains over 740,000 records.
Table 2 has the fields COMPANY_NAME and TICKER and has 500 records.
I need to find a way for all COMPANY_NAME fields in table 2 to be cross-referenced with the OCCUPATION field, so if COMPANY_NAME is part of the string in the OCCUPATION field then the TICKER (of that company) can be attached to the record in table 1 (specifically to AMOUNT).
The problem is that the OCCUPATION field is not written in a standard form and can include either only the occupation, only the company name, or both in either order.
I can make a seperate query for each company by using as criteria "like "*[COMPANY_NAME]*", but then I would have to do this 500 times!!! Is there a way to automate this?
The final purpose is to link the AMOUNT to TICKER so as to find the sum of all the amount associated with a company.
I really hope you can help, I have little programming knowledge and it will save me the time of making 500 seperate queries. The final use is for my thesis studying private contributions in the american elections.
Thanks in advance (I hope),
Onur
View 1 Replies
View Related
Feb 25, 2015
I have a form that I have opening in Filter by Form mode. It WAS working flawlessly, at least it was opening in that mode. It IS still requiring me to click on Toggle Fields once data is entered into controls to filter by, but that's another issue (I wrote a recent comment, but haven't gotten any response). Something different is happening suddenly that wasn't happening before. This form is a copy of a form needed to enter data.
Both forms read from a table which has several required fields. Suddenly, when I open the form to find records in ANY mode it's making me enter something into these required fields, even though I'm not searching/filtering by them. The message comes up "You must enter a value in the [Specific Required Field name here] Field." What did I do to make this start happening? How do I stop it? I DO want something to need to be entered in the required fields when new records are being entered and when things are being changed. However, I don't want it to be required during search processes.
View 12 Replies
View Related
Mar 28, 2007
Hi All
Im after some help with a query im building.
I have a table called QuizResults which has 10 Yes/No fields. The table also has a field called Site.
Each site will take a quiz and the problem I am having is with the statistics side of things.
What I need is a query that will work out the percentage correct for each site. All the data is stored in this 1 table. There are no relational fields as they are not required. I have tried a few different ways but each method I use involves me making many many queries to work this out.
To summarise I need 10 percentage correct fields, broken down by site.
Please can anyone help?
Many Thanks
Dazstarr
View 5 Replies
View Related
Jun 4, 2006
Hello gentlemen,
My main form contains a Entry_No (Text – Not duplicate) field. I used following code in the same form in a command button’s OnClick event to increment integer value of Entry_No to “Issue-1”, Issue-2”, “Issue-3” & so on.
Dim strmax As String
strmax = DMax("[Entry_No]", "T_Drug_Receiv_Head")
Me!Entry_No = "Issue-" & Right(strmax, _
Len(strmax) - _
InStr(1, strmax, "-")) + 1
No problem with above code. It works fine.
The record source of the main form initially was based on query which I removed later. I placed following code to display only the last record while form opens (on Open event). This is a try due to very large table and I don’t want my form / query to load all 90,000 records into the memory at one time that takes time.
I placed a unbound text box (TxtMaxt) to disiplay Entry_No field of last record of the table which is ok.
Txtmax = DMax("[Entry_No]", "T_Drug_Receiv_Head") ‘ This is OK.
Dim NSSQL As String
NSSQL = "Select * from T_Drug_Receiv_Head where [Entry_No] = Txtmax"
Me.Form.RecordSource = NSSQL
Me.Refresh
When I open the form, it asks me ‘Enter parameter value’ for ‘Issue’. When enter something then dialog closes and form appears with blank record except showing displaying Entry_No field of last record of the table in the Txtmax unbound text box.
When I removes code from on open event and selects query that was set before as record set, it works.
Where might have gone wrong?
With kind regards,
Ashfaque
View 12 Replies
View Related
Apr 13, 2006
I am about to create a system where I want to use MS Access for data and MS Outlook for email,contact management etc. I have a dilemma (what do I use for storing the contacts)? I know I can use Access and use VBA to send emails etc but I also want the user to be able use Outlook directly to send emails etc as normal using that contacts (Outlook) list.
Using Office XP at the moment btw.
I would appreciate comments as to the best way forward before I start.
Thanks in advance.
View 2 Replies
View Related
Jul 21, 2006
Hopefully someone can assist me. For an advanced user, this will probably take only few minutes.
We have conducted a survey online and now need to analyse the data. As the online questionaire is about 25 pages long and about 20 Managers were asked to fill out. Each manager had to describe the different positions they maintain for example, Business Analyst, Business Consultant, Postion description ..... Now the results are trickling in, its pretty tedious to go through each response one by one and compare how many common job functions there are....
It has been suggested to build a dB in MSAccess with the "questions" that were asked and upload all the responses from the online questionaire to the dB. The online questionaire & responses from each individual has been converted to excel flat files.
Can some one assist me in building the dB with the ability to upload the excel flat files one by one.
The point of this exercise is so that the analysis of the result process is not cumbersome.
Hopefully I am making sense?
View 1 Replies
View Related
Jan 29, 2006
Hi,
I'm currently putting together a database for a medical NGO in Cambodia (http://www.medicorps.com/updates/cambodia.html) and am looking for some advice. The simple database is for logging client referral cases by Cambodian doctors to a team of international doctors. I haven't used access in 10 months and despite programming in access for 5 years progress is very slow. At the moment I'm designing the input and search forms. I was thinking that a more logical approach would be to convert the forms to access data pages and put the database online. I haven't used data access pages but from what i know their fairly limited?
The goal would be the ability to log/search the data with auto updated pull downlist based on the actual data. Ultimately I want the data compiled and emailed to a email list from withing the website. The trouble is I have no idea how to do it.
Thanks in advance for your help.
View 5 Replies
View Related
Mar 15, 2006
I have received a Access97 database which has a date field filled with numbers.
The date of birth field is in the format : 19970131
And the date of birth field is a text field.
The software requires the date to be in dd/mm/yyyy order and also to be a date/time field.
When I try to change the text to date/time, Access deletes all dates of birth.
I am not sure how to solve this as I am very new to databases.
Can someone please help me soon?
View 5 Replies
View Related
Sep 27, 2005
Hi all,
This is my first post here and was just hoping for a bit of advice, what it is my dad wants me to create a small database for him and was hoping for some advice on how to tackle it. What he wants is listed below. I have some ideas but the most confusing aspect I found was how to update a persons age from the computers date.Heres what he wants and hope you can give me some advice. Thanks in advance John
Fields (free text unless otherwise stated) for people;
First name
Surname
Age
Further Education level - drop down menu for "GCSE/A level ,HNC/HND, Degree, MSc, PhD"
Degree held? - drop down menu "yes" or "no"
Chartered engineer - drop down "yes" or "no"
Professional Quals - free field for these
Skill base 1 - drop down for " Manager - Operations, Production, Maintenance, Engineering; Engineer - Mechanical, Instrument, E&I, Electrical, Rotating Equip, Process, Asset Integrity, Inspection, QA/QC; Superintendant/Supervisor - as above; and any others (think of all KPO Ops parented people)
Skill base 2 - as above
Skill base 3 - as above
Professional ladder job title
Grade - drop down menu BG3,BG4. BG5
Hay points
Date of birth
Age - can this be generated from entry above and current date?
Current Assignment job title
Current Assignment start date
Current Assignment Asset
Current Assignmnet end date
Current Assignment location (eg Cairo, Idku etc)
Currnet Assignment type - drop down menu rotation 14/14, rotation 28/28, expat
Next assignment options
Comments
Then set of data fields for posts
Post job title
Post type - drop down rotation menu as above
Likely Start date
Location
Asset
Sponsor in Asset
People Reports
People - All data
People - Listed by current job end date
People - Listed by skills (if Mechanical in any of three fields above, list him), will be repeats of names in list (as have more than 1 skill but thats OK)
People - List of those with degrees
People - List of those chartered
People - Listed by current job end date
People - Listed by current job end date
People - Listed by current job end date
Job Reports
View 14 Replies
View Related
Mar 11, 2006
I built a DB for work (Access2000) which is on the network and is for inputting maintenance request. Nothing complicated about it and at any time there would probably only be 3-4 users logged on at a time, and then probably only for a few minutes each. This DB got corrupted yesterday and I had to recover from teh backup. I compact and repair manually on a weekly basis(usually). My question is would it be less likely to get corrupted if I split the DB? Would it help to set up an automated complact & repair to run overnight?
Thanks
RussG
View 3 Replies
View Related
Apr 16, 2006
Hi
Im currently building a database which holds customer delivery options, quantities, unit and delivery price and so on.
It has all been going fine until now...!
I am trying to setup the billing aspect. My main headache is that each customer could have a delivery every day, of different quantities. Now there will be times when this customer goes on holiday and of course doesnt need to have anything delivered - my only problem is getting the billing to adjust accordingly.
I have my SubForm which contains:
UnitName
UnitPrice
Mon
Tues
Wed
Thursday
Fri
Sat
Sun
DeliveryCost
TotalCost
at the moment in the main form the holiday period is put in and i convert this then into a number of days value - this is then subtracted from the total of units (count of Mon to Sun) x UnitPrice + Delivery.
My problem is that if a customer has 2 days off which are Mon and Tues, how do i get it to only remove the mon and tues values from the unit amount - instead of just removing a figure assuming that they have only 1 per day - wihch in most cases they don't.
Can i somehow assign the day values to each day field in the subform and get the correct days from the holiday or something!
i dont know its just breaking me down!!!:mad:
Any help greatly appreciated
View 3 Replies
View Related
Jan 1, 2007
I have a database that has one aspect that is highly dependent on certain payroll information. For example:
When a pilot begins entering his flight for the day at the bottom of the entry form it tells him the payroll dates are from x to x and you have worked X number of days in this pay period.
This part I have gotten down quite nicely using a payperiod table. Problem is that I must enter that information manually and it is time consuming to do that for the whole year. Point of fact I only put the first day of the pay period in this table. Our pay periods are every two weeks.
I also generate a report for payroll based on these pay periods.
My question/advice is a new way of going about this pay period deal without having to enter it in manually every year.
We have these wonderful computers but I feel I am doing too much work but just don't see a different method around it.
A bit wordy but I wanted to be clear. Any advice in a new direction?
View 13 Replies
View Related
Aug 3, 2007
Hi all,:)
I'm looking for some advice: the problem is that I've got 13 sections in which people are working, and administrative assistants that are taking care of 1 or more of these same sections.
In addition to the usual security, there is also a requirement to make the AA's only output their own sections reports.
The way I see it there are two ways to ensure this:
1) put in a field in the users table that would indicate which sections the AA was responsible for ie
userID 1
respFor 56,34,45
userID 2
respFor 41,3
userID 3
respFor 42
... etc respFor would have to be a text field with a delimiter between each sectionID
sectID 41
sectName AAA
sectID 42
sectName BBB
2) have a separate table that will form a "union" between user and section tables ie User&Section
userID 1
sectID 56
userID 1
sectID 34
userID 1
sectID 45
userID 2
sectID 41
userID 2
sectID 3
userID 3
sectID 42
Now for my question: Can you advise me on which way is best for this circumstance? or perhaps you've got another way to go? Have you got an example ?
Your advice please...
TIA
View 1 Replies
View Related
Jan 16, 2007
Greetings! I am setting up a database in Access 2003 for a Seniors Program. Through this db I need to set up forms where they can add information on individual members, denote which programs they participate in/pay dues for, etc.
Any advice you all could give would be greatly appreciated.
EDITED TO ADD: I'm basically a newb when it comes to Access...I can do the basics, but need to go beyond what I know to do this project...
View 2 Replies
View Related
Jun 19, 2006
A record in a table linked to various others has recently been corrupted in my database. When i try to delete the record an error message appears telling me that the 'Search key was not found in any record' and the record will not be deleted. This corrupted record is causing me serious problems and i need rid of it by the end of the day.
Any suggestions would be greatly appreciated.
View 3 Replies
View Related
Jul 5, 2006
HI,
I am having a problem with all of my comment fields showing up as Japanese and I need to get some reports printed...
Does anyone know how or why this would or could happen?
I have checked the tables but they are normal. When you query the tables is when the comments start to mess up.
Thank you.
Your help is really appreciated!
View 7 Replies
View Related
Nov 7, 2006
Hi,
I'm importing data of a query to excel from access; however, all fields that have combobox for input display numbers instead of text.
Any help will be very much appreciated.
B
View 4 Replies
View Related
Nov 14, 2007
Hello, I'm new to the board and I need an urgent problem fixed. Ok, I have a query that contains the type of TRAINING REQUIRED FOR EACH POSITION/PERSON IN A COMPANY . It has:-
1. Clock no. (uniqe for each employee)
2. Job Title
3. Position effective date
4. Training code
5. Description of training code
6. Retrain requirements ( number of days that are needed after initial training to reach retraining date, this varies from 0 to 365 days depending on the code)
7. Status of employee (whether active or inactive, the criteria for this is active)
8. Due date for completed training
I have another query which shows the TRAINING RECEIVED FOR EACH EMPLOYEE. IT has:-
1. Clock no.
2. Job title
3.Last names (employee)
4. First name
5. Status of employee
6. Training code
7. Date of training received
QUESTION IS HOW DO I CREATE I GUESS ANOTHER QUERY THAT WILL TELL ME WHAT REQUIRED TRAINING CODES THAT EACH EMPLOYEE HAS NOT RECEIVED? I BASICALLY NEED TO KNOW IF EVERY EMPLOYEE HAS BEEN TRAINED CORRECTLY ACCORDING TO THEIR POSITION OR NOT.
View 14 Replies
View Related
Dec 25, 2007
I need to make a database for a association and collect the Business information and Personal information the following information is needed
For business
Business name
Corporation Name
Address
city
state
Zip Code
County
Phone
fax
then
Type
alcahol yes/no
tobacco yes/no
EIn number
STI Number
Sale tax Number
Personal
Name
Address
city
state
zip
phone
cell
email
*some things one owner might have more than one store.
i can make the form and everything just need help with relationships and that quiries that sort of stuff.
I am attaching a access 2007 file which i use.
View 6 Replies
View Related
Apr 12, 2007
hi i am making a database for a company, in which i have the feild "joining date" and the feild "paymant method" which can either be yearly or half yearly
im looking for a quiery that will work out who need to pay when and also i need it to bring them up two weeks before due payment..... im then going to mailmerge them.. which i am not 100% sure how to do. :eek:
any help is highly appreciated :rolleyes:
View 5 Replies
View Related
Mar 23, 2006
Hi,
I was wondering if anyone might be able to help me here. how do i stop the combobox to print multiple duplicate records?
for example,
in the combobox dropdown, there are records as follows
01
02
03
04
05
05
05
06
07
How do i ensure that it only displays the unique records only without printing 05 three times?
Your help is greatly appreciated.
Thank you very much
View 5 Replies
View Related
Apr 28, 2006
Hi. I am creating a website for my employees. I have created a table, query and a form in microsoft access containing a lot of different fields, including employee ID and password. I have also created a form in Dreamweaver. How do i link the database to the form and how do i create a code that will log in the employee if his password and username are correct, into a new page and if the info is wrong, to another page. PLEASE HELP. This is very very urgent!
View 4 Replies
View Related
Mar 26, 2008
All,
I am new to access and despite reading what seems to be a mountain of stuff I'm a bit stuck. Can somebody point me in the right direction to achieve the following.
This is a simplified version of my problem, but it is the principle I'm after.
I have a query, the results of which look like
FIRSTNAME SECONDNAME ITEM ITEMSIZE
There are multiple results with the same firstname and secondname but different item info. e.g.
Bill Smith Shoes 10
Bill Smith Shirt 16
I need to be able to produce some output - table/report/query (to be export to excel) where there is only one record per (FIRSTNAME SECONDNAME) of the form
FIRSTNAME SECONDNAME ITEM1 ITEMSIZE1 ITEM2 ITEMSIZE2...ITEMn ITEMSIZEn
e.g
Bill Smith Shoes 10 Shirt 16
Fred Jones Hat 12 Jacket 48 Shirt 16
Can this be done without resorting to VB code? I'm no programmer.
Thanks
Chris
View 5 Replies
View Related
Feb 27, 2008
Hi,
I wonder if someone could help me, i have started to create a database which will be uses for a gardening service company.
I have created the customer database table and form which him quite impressed with the say ive never done it before.
I also followed a tutorial from the net which was based around a video rental shop, ive put in in the transdetail and masterquery forms also as said in the tutorials as it will basically need a databse for the customers, then i will need to create invoices from services we do for the customers i:e lawn cut etc.
this is where im stuck really, i have tried variuos things but it doesnt seem to be tying into what i want it to do, i think ive tried to overcomplicate it. If anyone could give me any advise on what i need to do to create this very simple database i would really be grateful.
so customers
service and products
then invoices
thanks
Kazza
View 1 Replies
View Related
Sep 25, 2006
Hi all,
Big problems on access 2003.
When opening my live db, the message
"The Visual Basic for applications project in the database is corrupt."
I've had a quick search but can't find a solution.
This db has always been access 2003 (Not converted from prior file version).
I can't even import into a blank db as the same error occurs.
HELP!
View 2 Replies
View Related