Querys With Subforms
Sep 7, 2006
Hi guys
The question i am looking for help with is.....
i have a database with a form(form1) and a subform(sub1), when i query this it will only desplay information that has all boxes filled in. i want it so that if there is info in form 1 but no info in sub1 i will still display the info from form 1. At the moment it just ignores the whole thing and does not give certain records from form 1.
any ideas?
James
View Replies
ADVERTISEMENT
Sep 24, 2007
I have created a cbo box that I am using to selects locations (citys) in a field. I have used "Distinct" to elimate the duplicates but I also want to elimate three locations. They are Verdun, Lasalle, and Montreal. In my query I have tried the following statement in the Critera location. Not "Verdun" Or "Lasalle" Or "Montreal". The query returns the following statement: <>"Verdun" Or "Lasalle" Or "Montreal" this statement does take out the first location "Verdun" but the two others still remain in the field. How do I solve this problem?
View 3 Replies
View Related
Aug 2, 2006
I have a form which has a subform on it and this performs a query and displays a list of courses only done by a particualr provider which changes when you change the record i now have buttons beside each course and want to be able to get it to open up another form and then display dates for that particualr course and whos attending whats the easiest and best way to do this as im really stuck and need to get this finished.
View 4 Replies
View Related
Dec 7, 2005
Hello All,
I'm only fairly basic when it comes to Access, and I need some help with a query. Im running Access 2003 on XP Pro, and my current database is in a one to many relationship with Staff and Activities. A part of the Activites field involves the expenses of that particular activity. I have a field in my Activities table saying total expenses. The expense formats are in currency (including total). When I go to make a query, I'm using the following critera for the TotalExpenses field. "FoodExpenses"+"OtherExpenses". However, when I go to run the query, it tells me that there is a data type mismatch in the criteron expression. I changed the field formats to text and it will run. Can access 2003 support currency based querys and if so how? It would be really handy to know.
View 5 Replies
View Related
Jun 19, 2006
I have to do a query that uses as condition a row from a switchbord.... Is that possible?? Can u help. (I created my switch bord with the Access tool).
Thanks.:cool:
View 2 Replies
View Related
Apr 24, 2007
Hey, I have a database and a login panel and I need to stop some users from using ctrl + c in query's or through out the database. The way I have set the db up is if a user logs in correct then they get directed to the appropriate switchboard. I have already disable all toolbars therefore disabling right click and on my forms I have vba to stop ctrl + c but can't figure out how to do it on queries, I have tried search and searching Google but if I have missed a post please include a link, any help would be appreciated THANKS :)
View 3 Replies
View Related
Nov 2, 2007
Is there a tool that converts Access querys (jet syntax) to sql views and procedures (sql server syntx)?
Thanks
View 3 Replies
View Related
Feb 4, 2008
Hi, I have done a search before posting but cannot find what I am looking for.
At work I use a database to record incidents (work that I do). I have written a query for incidents for 2007 and 2008 and I can do a line graph for each year showing the monthly incidents by doing Insert, Form, Chart Wizard
What I am trying to do is a line graph for 2007 and 2008 together to compare performance but i can only ever choose one query for my graph, either 2007 or 2008.
Is there a way I can get both years on one graph so as i can compare performance.
Any help/guidance appreciated.
View 9 Replies
View Related
Jun 2, 2005
Hello,
I have about 1500 records in a table. We use a form to search through the records to find info on certain accounts. We now want to only search through accounts that are current, so I made a query to see only current accounts. I switched the search form from going off data right from the table to the new current date query. Now when you load the form it says "running query" and the application stops responding. The query seems to load up quick in raw format.. how come the application freezes when searching using the query instead??
thanks,
Matt
View 1 Replies
View Related
Mar 6, 2006
i'm struggling here
i have a simple cross tab query. i'd like to put a parameter value as criteria. lets say i hard code the criteria with 2006 it works fine. but when i reference it to the value in a form e.g forms!frm_navmaster!txtyeardate then i start having problems. i don't know to start. i've tried using the expression and where values in design view....uuggghhh.
any ideas are appreciated
View 3 Replies
View Related
Jan 15, 2008
Hi to all
I have a .mdb Files. If i doubleclick this file the database opened but i can't see the tables and Querys. It's a program that start automatically.
I can only see the source code if i enter Alt + F11.
What i must do for see the Querys and the Tables?
regards
cobra
View 4 Replies
View Related
Jun 21, 2005
We have a tbldepartments. At this point (has been a few years)...many dept. have merged or changed names. We want to 'change' the names of some and delete or add others.
Ok on the delete/add.
However, in many of our queries, we have the dept. name/number hardcoded in. And trust me, there are tons and tons of them...this is a big database.
Short of going through each query, is there a way to 'search/replace' either in each query or in all? To update these easily?
suggestions?
View 2 Replies
View Related
Feb 4, 2006
I forum could someone tell me:
I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.
When I try to link them it says you cannot link items on an unbound form.
regards in advance
Peter:eek:
View 1 Replies
View Related
Jun 28, 2007
I have a form with 5 subforms in it.
I am using recordsets to step through a table that contains a field with the names of the subforms.
Depending on the code, I want to make visible or hide the subform for that particular record.
ie Table has 5 records with a field called subForm. the values are as follows:
Record1: Field1: Value="Yes" Field2: Value="subForm1"
Record2: Field1: Value="Yes" Field2: Value="subForm2"
Record3: Field1: Value="Yes" Field2: Value="subForm3"
Record4: Field1: Value="No" Field2: Value="subForm4"
Record5: Field1: Value="Yes" Field2: Value="subForm5"
When I step through the table if the code finds "No" in Field1 then id makes the subform referred to in Field2 invisible and if it finds a "Yes" it makes it visible.
Can anyone help me with this?
View 2 Replies
View Related
Dec 13, 2005
Does anyone know how to have a datasheet view in a subform fill the top of the main form?
I want to be able to see the records in a datasheet view and when the record in the datasheet view is selected it prefills the top of a form ?
View 1 Replies
View Related
Feb 18, 2005
This is a question from yesterday that a member had helped me out with.
I have additional questions while I am waiting for response from him. If anyone of you can help, I would really appreciate it.
1. How can I make a form that gathers information from multiple tables?
2. Lets say it is possible, how does this info get saved to these multiple tables when the user clicks on the next record button on the record navigator.
Thanks for the assistance!
View 2 Replies
View Related
Aug 12, 2005
is it possible to have more then 2 subforms?
Lynda
View 1 Replies
View Related
Sep 18, 2005
Heya --
So if I haven't scared everyone away with the post's title, maybe someone out there can help me. I need it.
I have a many-to-many relationship with the following tables:
Companies
CompaniesProjects
Projects
I also have a query with the following:
CompaniesProjects.CompanyId
CompaniesProjects.ProjectId
Projects.*
Pretty straightforward. Now, I have a form to view Companies, inside of which is a subform listing Projects associated with the Company using the above query.
The issue that is stumping is that I would love to be able to add a new project from the subform. I thought it would be pretty easy, but I'm totally dry. I guess I need to grab the CompanyId from the parent form, and assign it to the new record before I can add any more data to the new record. But I have no idea how to do this, or even if it is the right thing to do.
Any help would be _greatly_ appreciated. I've been slamming my head against a wall with this for two weeks.
-Lucas
View 2 Replies
View Related
Nov 29, 2005
Hi,
I have 3 tables : Products, Description and ProductDescription. Products can have more then 1 description, Descriptions can be used by more then 1 product, that is why the third tabel ProductDescription exists (normalizing..:) ). The Productdescription table has 3 fields: id, productid, descriptionid.
I want a form in which you choose a product, then you see all the descriptions along with it. In this same form I want to be able to add a description, e.g. by pushing a button NEW. After that user enters description form etc. After returning to the mainform, a new record must be automatically added to the ProductDescription table and ofcourse a new record has been added to the Description table. I thought I would use subforms to realize this but it isn't working..:( . I have tried so many things that I dont know anymore what to do, i am totally confused. I know how to program in VB and ACCESS, but for now i don't see it anymore. Can someone please help me with this?
I just need to know how to start, what to use as subform and what as masterform, which links between fields, etc
nelleh:rolleyes:
View 2 Replies
View Related
Jan 17, 2005
Just a quicky.
I am trying to design a form with three subforms.
I keep getting tblXXX not in recordset.
Is there perhaps something wrong with my relationships?
Thanks,
Brian.
Zimbabwe.
View 3 Replies
View Related
Nov 22, 2006
Hello,
I hope someone could come up with a solution. I have a form and 2 subforms. The form contains the person id, address and phone number. The subform1 contains a list of skills that person has which is derived from a query. I have to be able to delete any of the skills that person has. I am not sure how to delete the skills but I know when I type a skill, it automatically adds (can grow = yes). In subform2, the skills that the person DOES NOT have are listed derived from another query again. We should be able to click on any of those skills so that it will be an addition in subform1. I do not know how to do this.
Thank you for anyone who comes up with the solutions.
View 1 Replies
View Related
Oct 17, 2007
I am designing a student registration system in MSAccess. It consists of tables such as Applicant,Courses,Department,Qualification,Employe r details..the applicant has to choose only 3 courses. i have already designed all the tables and relationships. I need to create an application form which allows the user to imput the personal, qualification and employment details of the applicant. i have used tabs for this part. now i have to create a form where the user input the 3 choices of the applicant. i have used a subform in my application form. my problem is how do i restrict the user to input only 3 courses and how do i link the subform with the main?how do i make sure that when i select 3 courses, it is linked to that specific applicant?
View 8 Replies
View Related
Nov 22, 2005
Hi there.
I have a form with two sub forms on it. The form loads with a reference number that I pass to a function that in turn requeries the first sub form. The function call is in the on load event of the main form.
This part works fine.
The second sub form uses a similar requery function to the first one. The only difference is that the query for the second sub form is based on a reference number from the selected record in the first sub form.
If I put the function call for the second sub form in the on click of the first one all is well and the second sub form displays all records with a matching reference number.
The problem is that when the main form loads the first sub form will display the correct data but the second remains blank or displays the wrong data.
I know this is happening because the first sub form has not loaded fully and so the second sub form cannot get the reference number. I just can’t find a way to make the second sub form display the correct data when the main form loads.
I have tried calling the requery function for the second sub form from most of the events on the main form and many of the events on the first sub form but to no avail.
I also tried putting a meaningless sub form at the bottom of the main form and putting the requery function for the second sub form in the on load event but that was no good either. This surprised me as until that point I was assuming that access was loading the sub forms sequentially from top to bottom.
Can anyone tell me how I might determine the point at which the first sub form has been loaded so that I can get access to the reference numbers needed for the second sub form query. I would prefer not to use a timer for this as there is no way to determine the maximum time it will take access to load the rest of the data but at present it looks like the only option left.
Any comments would be much appreciated and sorry for the lengthy explanation.
View 6 Replies
View Related
Aug 2, 2006
Please help !
I have been struggling to create forms with these relationships(see attached file) . I would like to create a subform of the product list and the form must have Title TitleID and Artist and Artist ID ...these also need to populate the Product list table... oh how do I get around this ! What am I doing wrong
View 7 Replies
View Related
Feb 11, 2008
Hi, I have a main form with a subform inside it. The subform contains two records but only one is shown during form view, is there any way to show both records at the same time?
I am using continuous forms view for my subforms as i have to.
View 3 Replies
View Related
Feb 10, 2005
First I'm an average access user, but don't know much about VB. I've created a subform with a querydef that works fine standalone, but as soon as I move my subform onto my main form the the querydef no longer runs.
Am I missing something simple?
View 3 Replies
View Related