Questions About Queries
May 4, 2007I have a problem with a querie, wend im doing a querie its all well and good but wend im going to see if the thing works a message shows up "Type Mismatch in expression". What am i doing rong.
Can you help me??
ADVERTISEMENT
Delete Queries: Two Questions
Oct 3, 2005Hey guys, I got two questions about delete queries,
Question 1: Is it possible to use the delete query to delete records from two different tables? What I'm looking at is deleting a customer from a customer list, and customer records from a distribution list, which are in two different tables. If not, is there an alternative way to accomplish this....ie write two queries but use macros somehow?
Question 2: I would like to add an "Are you sure?" message-box type feature into the delete query so that the user has the ability to think and back out if neccessary. Any suggestions for accomplishing that?
Thanks,
Chris
Queries :: Multi-Field Union Query (Joining Questions And Pictures Into One Report)
Apr 5, 2013I have two tables containing (let's say for simplicity) questions and attachments (pictures). I am trying to perform a union query to join all the questions and pictures into one report, but it won't let me union the attachment because 'the multi-valued field 'TableA.Pictures' cannot be used in a union query'.
I have searched and searched for a solution (and got kind of close) but i still can't get it to work. The best I can do is union everything like below, which gives all the questions as desired, but says #Error in the pictures column:
SELECT TableA.*
FROM TableA
Union
SELECT TableB.*
FROM TableB;
(Note tables A and B have the same structure, several yes/no and open text questions as well as one attachment field. )
Two Questions: A97 & A2K
Feb 14, 20061) There are some databases here at work that I can open in BOTH A97 and A2K. I thought A2K won't open in A97, and before you can open an A97 in A2K, you have to convert? At least that's been my experience thus far. Any idea what is happening and how I can determine which version these databases are currently in?
2) With those same databases...assuming some were A97, the option to Convert them under Database Utilities is greyed out. Is this most likely a rights issue? Could it be anything else?
Thanks for the help!
Two Questions
Jul 18, 2006Hi,
Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database.
Is there any method to know which user is opening the database and in which PC (workstation) it is open.
--------------------------------------
Is there any way of adding export fuction to the toolbar using modules or macro
Questions
Sep 24, 2005Hi all,
A quick question!
Is it possible to have a table of 10 random questions and an inital form created with those questions in the form of checkboxes. When you chose random questions from that pool of questions a new brand form and table have the option to be created.
Basically, I have many external databases to research and some of the questions are the same in each database. Each database must be saved as individual tables and forms.
~Vanepps
Few Questions
Dec 16, 2004Hello,
I have few questions so please bare with me
1- i want the text box to change automatically according to date so i
tried this:
if date>text14.text then text30.text=sea else text30.text=port
but nothing happens
2-i made a form but not all the data rows in the table are in the form(there`s still some rows)
so if i delete a data that are in the form how i can automatically delete the data that
are in the other row ?
3-this may sound stupid..but is there a way to stop the access logo from apearing when
loading the database?and how to make access directly open a specified form?
Thank you very much all.
Two Questions!
Aug 1, 2006I am designing a database and have a couple of questions.
I have designed a form that I have opening at startup. How do I force this to maximize on opening?
I have set up a report based on a query. It works fine. The query requires a parameter to be entered when it is run. The parameter comes from a list (of teachers in my school). How do I set up the query so that the 'Enter Parameter' dialog box provides a drop down list of teachers from which the user selects their name?
PS I have almost no knowledge of Visual Basic!
Thanks for your help.
Steve
A Couple Of Questions
Jun 13, 2005Hi all
I am new to Access and have just designed a new database and was wondering if anyone could help with a few questions.
1/ I am setting up a Macro to send an e-mail on the change of a form. When the e-mail is generated by Access I get a message from Outlook stating that "A program is trying to automatically send e-mail..." and asks you to confirm that it is ok to go. Is there any way to bypass this check or alternatively send the e-mail from a specific e-mail address rather than the database user.
2/ I have changed the background colours on a number of my forms but the Record Selector's and Scroll Bar stay the standard Access Grey. Is there anyway to change these?
3/ I have used the User Security Wizard to setup users, groups and access but I can't seem to see a way to limit the number of simulateous logins a person can have i.e. I can log in more than once with the same user when I only want to be able to login once. Any ideas?
Any help would be greatly appreciated.
JC
2 Quick Questions
Oct 16, 2005Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following...
http://img276.imageshack.us/img276/2695/11ch1.png
is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
Database Questions
Dec 2, 2005Hey guys, bit of a novice here
Say your got a database that has many users & in which quite alot of information is added to it on a regular basis. Basically its getting slower, what could be the problems & how could you fix it???
Simple Questions
May 17, 2006Hi all, I built a system in access for my a level IT course a few years back but haven't had need to use access since. just been asked to build simple system at work and i'm forgetting some really simple things. trouble is i think i'm overcomplicating the terms and can't find anything in the help file!
basically the system is to keep track of how many hours various people have worked on various jobs.
I've got 3 tables:
Jobs - job id, location etc etc
Staff - staff id, name etc
link - job id, staff id and hours worked.
the job and staff tables have the id as the primary key, and i've set the relationship to link them to the corresponding field in the link table. which is all fine if i remember rightly?!
now what i'm trying to do is set up a form for entring the hours worked etc into the link table. we use job id numbers all the time so i have that as a drop down box. what i want is to have a drop down for employee names, which will insert the employee id into the link table- basically so we can work with names rather than numbers. for the life of me i can't remember how to do it. i know is really simple but i can't find a way to express what i want to do to search for it in the help or online!
if anybody can refresh my memory it would be much appreciated!
2 Questions.....probably Simple For Ya'll
May 22, 2006I am still learning and I have 2 questions.
First...I have a table called company rates which will be used to calculate time and materials. In the material field, I need to enter .10 for 10 percent. When I enter .10 the field changes back to zero. I have it set to long interger. Is this wrong?
Also, I am working on the form that will calculate all of this. I have a field that needs to look in a flex price field. If there is a number in the flex price than that is the labor, if not, it needs to multiply the estimated time (Text43) times the quantity, times the CurrentLaborRate contained in the CompanyRates subform. I can't seem to get it right...
=IIf([FlexPrice]>1,[FlexPrice],[Text43]*[Quantity]*[frmCompanyRates.CurrentLaborRate])
I know it is probably something simple but I can't figure it out. Can anyone help?
THANKS SO MUCH!
Some Questions About Replication
Oct 31, 2006Allrighty, some questions about replication. I have gotten the Replication Manager from the helpful IT folks here, have made the database, and it works well to synchronise between different files locally on this computer. However, ideally the other people in the department would be able to carry replicas around on their laptops, while ideally the design master and overall database tidying should sit on mine. The setup is typical intranet here - computers are invisible to one another directly, and so are their virtual My Documents drives, while shared network folders are visible to all.
Questions;
1. Since I can't see any of the other laptop drives, and the database would have to be accessible offline, I assume indirect synchronisation is the only choice, correct?
2. Does the Replication Manager need to be installed on each of the laptops that will use the database offline?
3. If yes, what's the process? Do I install RM on each laptop, then use the Create Replica function to create one locally on each? No hidden pitfalls here?
4. If yes, is it sufficient to keep RM shut all the time unless specifically wanting to synchronise? Would happen at least once a week.
5. If Replication Manager doesn't need to be installed on other laptops, how do I move replicas there? I tried moving one through copy/paste, but that broke the link to the Replication Manager.
6. (Optionally - I've seen some references to 'replica farms' - what is that?)
Very much appreciated if anyone is able to answer..
DB Design Questions
May 24, 2007I am trying to build a db for the office I work at. And I have a few questions about how I should design it.
1. My vendor number should be an autonumber, but it has a relationship to the vendor name on a report. I cant create a relationship btwn text and autonumber.
2. Right now I have 3 main tables. Vendor, builder, and job. All of this is for the marketing aspect of the business. But I want to include other aspects, like collections and payroll. Should I add columns to the jobs table, or create a new table? For example, on the jobs table, I already have job info like details on the job and who referred it to us. Should I add invoiced amount, amount collected, etc., or create a table called collections to store all of this info? Im really confused about this.
2 Newbee Questions
Jul 21, 2007Hi I'm new to the forum, and i have a question (don't we all)
I need the following, i tried some turorials but couldn't find it..
I'm creating a form, that has 2 fields that I want to relate,
let me explain a little:
the database if for a Church I work for. The church has 3 sites (3 different buildings in 3 different parts of the city)
Each site has it's own schedule of day and time.
I need to create a field that asks for the site, and depending on the site that is selected, it should display in another drop down menu the possible days and time of only that site.
I have no idea how to do this. I have created a table with the sites, days and time
How do i make one field depend on the other.
The other question is regarding a field that I want to add for the Cities of States. I want the field to remember the new ones, and add them to a drop down menu, so that if it is there it can be selected without not having to write it again, and if it isn't there yet, it can be written and then it would be added to the list....
thanks
I want to thank you in advance.
hope i can be of help soon enough:cool:
Questions On Security
Sep 11, 2007Hi there...
I've run into a problem with my db :( When I'm trying to create users for it, apparently Access won't accept them when they try to log in from different computers.
Is it a general problem with Access, or is it just me who's a noob with this?
Urgent Questions
Nov 24, 2007Hi folks
I wonder if you can help with these two questions please?
To compact and repair a FE, does each client have to be logged off or doesn't it matter?
What's the difference between make database replica and make database backup in access?
Thanks a lot,
B
Security Questions
Mar 4, 2008Hey everyone,
I've been working on a database for a while now and I believe the outline of it is complete, all that's left is the data inputting and security.
I tried to make my own security based around usernames and passwords but I was hopeless at applying MD5 encryption on the password field and working with the permissions afterwords.
I went through the user level security wizard and I set up the accounts and there's permissions to read tables, etc.. but there's no good tutorials or help files to do anything more complicated and I wouldn't know how to without reference materials.
Now.. the thing I wish to do is limit users by record, each record has a "worker" assigned to it. I want the user to log on, open the main menu form, open the client's form, then only that worker's clients would be available to go through with the forwards and back arrows, or the drop down list would be filtered.
Is this too complex to do with the user level security built into access?
Are there any alternate methods of doing so?
I can upload my database if anybody wants a better look.
- Luke.
3 Questions On Relationships
Dec 13, 2004I have a (simplified) table structure as follows
T_Problems
F_ProblemID (PK)
F_Title
F_RelatedProblems (FK to F_ProblemsID in same table)
1. Is having a FK to the PK in a one-to-many relationship in the same table allowed and desirable?
2. How would I ensure that, say, if problem ID 20 was related to problem ID 50 then ID 50 was similarly related to ID 20 or would this happen automatically?
3. Is this the 'adjacency list model'?
Somehow it just doesn't feel right!
Many thanks in advance to responders.
Design Questions
Apr 20, 2005I'm having design questions for complicated business logic. I have 4 tables, Author, Plan, Analysis, and Report. 1 or many authors can write 0, 1 or many
Plans, Analysis or Reports. And a Plan, Analysis and Report (all 3) can all have a 1 or many authors associated with it. So thats the first many-to-many. To make things worst, a Plan, Analysis, or Report can have 0, 1, or many Plan, Analysis, or Reports associated with it. In other words, a Plan be associated with a 0, 1 or many Analysis or Reports. An Analysis can be associated with 0, 1 or many Plans or Reports. A Report can be associated with 0, 1 or many Plans or Analysis. So I have 4 entities with all many-manys between them.
So by following traditional rules I would have 4 tables with 6 linking tables (author to plan, author to analysis, author to report, plan to analysis, analysis to report, plan to report). Is there a way to combine multiple linking tables into one or two linking tables shared between the 4 tables. Say one linking table between from author to plan, analysis and report and another linking table between plan, analysis and report? Any clarification would be greatly appreciated. If I had schema view like in access that would give me so much help. Thanks in advance!
New User Questions
Jul 20, 2005Hi All:
I'm brand new to this software and trying to write a simple database to keep track of departmental billings for our university copy center. I have two different manuals and yet can't seem to find the answers to very simple questions!
I am trying to create a one-to-many relationship between a table containing departmental account information and a table containing copy center orders. Following the instructions I've got available, I can only seem to create a one-to-one relationship. What am I doing wrong?
Also, I've created a form for the departmental table with a subform to enter the various employees of that department. That's working fine but the formatting on the subform looks terrrible - I'd like to make it match the background of the main form. I spent hours trying to figure this out yesterday and no luck. I get what I want in design view but it won't translate to form view no matter what I do. Any help would be greatly appreciated!
Finally, I have a question about using the form. When I begin to enter a new record, I'd like the form to go ahead and pull up the information if I put in a redundant account number. Right now if I put in an account number already in the database, the employees of that department pop up in the subform but no other information appears on the form. Will I need to write a query to make sure this happens? (Pardon me for being so clueless:rolleyes: )
Thanks ahead of time for any help you can give!
Amy
Table Questions
Nov 4, 2005Hello forum! Seems like this is the place to ask questions and get critiqued. I am starting a new project (seems right now out of my reach and knowledge, but am wanting to learn).
What I am buiding is a billing tracker for my insurance agency. What this is entails is simple policy details, whether invoice has been sent, customer paid, premium paid to company or if premium is carried on note either with agency or company, and what interest rate will be applied to that note. On premium the commission rate, commission earned, and if applicable the commission rate for sub agent and if they have been paid or not.
First of all I have a question about my tables, thus far and have read a little about normalization (sp?). What is required is 1-1 relationships should be kept to a minimal right?
So attached is a rough draft on my tables thus far...
Customers can have multiple policies (either by date,crop, or company) and each policy can have multiple details (commission rate).
I am looking for insight from someone, I can read answers all day long, but am looking for someone to say "Yeah your on track" or "why dont you try this".
The date fields, I would like to have a pop-up calendar picker. I have seen and downloaded many examples - How do I get the unbound forms to stick to my tables?
On this commission table..My thoughts are like the NorthWind example for orders sub form, my question on this how do you get the subform to start new when you want to put in a new order?
I am not looking for someone to build for me! Just give a some insight
Thanks to everyone!!
Questions About Possible Expressions
Jan 8, 2007I have a complicated question here. I am currently building a db for career development in my workplace. The main fields that i am having some issues with is the following. I have three fields labelled as the following:
1)Last Review date
2)Next review date ( i have this entered in as an auto generated date-- will add one year from the last review date)
3)Status
Now here is my question:
I want my status field to auto generate as well-- say if the last review date was in 2005 and the next review date was dec.12/06-- then the status would currently be overdue.
Is there any expression to use to auto generate the status field to say whether it is overdue or completed? or is there any easier way to do this?
Database Questions
Jul 24, 2007I am a newbie and just found your forum - hope you can help me.
I built a kindergarten software but seems to have a problem : I have children registered and I keep records of the parents, other relatives etc'.
My question : what w'd be the relations between the tables since parents can have more then 1 child and so does the other relative (each parent has his own table). Should I keep all details in 1 table (personal detail for child + professional details such as positioned in adult class etc/
Hope I'm clear.
Thanks
2 Important Questions
Nov 13, 2005Hello,
>> How can i get all the results if no input parameter is put in the query e.g. if i have A,B,C and need to get all results, only A, only B and only C?
>> How can i block 1 cell and only acess it if the last cell have a correct value?
Thanks in advance,
Kobee