Hi, all! I need some help. I am trying to figure out how to enable the subdatasheet in my subform. I've already told the root query to include the subdatasheet, and it works. My subform only allows datasheet view, and I've enabled the subdatasheet visible property in the subform. What am I missing? I really need it to show up. It would be SO cool if it would work. Thanks!
KellyJo
I have a continuous form with a bound subform in the footer section. Is there a way (with VBA?) to set the tab order so that it tabs down to the subform in the footer after a few controls in the main form and then back to the main form after going through the subform?
Also I have a form with a subform in datasheet view. Can I have the tab order set so that it tabs through a few fields in the datasheet view, expands the subdatasheet and allows you to tab through it, then tab back to the main datasheet?
I want users to fill out a few fields in the main form, go the subform easily, enter the data there, then go back to the main form easily and enter the rest of the data before going to the next record in the main form.
Greetings to all,
can you help me with this?
I have a main form linked with a subform ( m/child ) query and I'm trying to make this code to work but it does not and I don’t know why.
I have this code…
Me.Form![subform1]![type] = Me.Combo12
Me.Form![subform1]![DESIGN] = Me.Combo11
Me.Form![subform1]![stage] = "NEW"
Me.Form![subform1]![stagedate] = Now()
...and it works, but when I do this…
If Me.Form![subform1]![stage] <> "NEW" Then
Me.Form![subform1]![type] = Me.Combo12
Me.Form![subform1]![DESIGN] = Me.Combo11
Me.Form![subform1]![stage] = "NEW"
Me.Form![subform1]![stagedate] = Now()
End If
It does not work, can anyone tell me why the If does no work ??????
Many thanks in advance
Hello all.
I have orders being entered, some of which may be in any one of several categories for which we need additional information. I would like to be able to have either a set of checkboxes answering the question "Check the appropriate box if the order is one of the following types" ... or ... have a radio-button selection where only one can be chosen at a time. That is important... that only one be able to be chosen at a time. It is possible to have orders outside this set of choices, and no selection made at all. Once the selection is made, I'd like either the appropriate fields to show in the main form... or ... have the appropriate subform show based on the entry from the checkboxes or radio selection.
I could have
OrderEntryForm containing
checkboxes or radio selection for Type1, Type2, Type3 with the appropriate Type1fields, Type2fields, and Type3fields hidden until the right checkbox or radio button is selected.
or
OrderEntryForm containing
checkboxes or radio selection for Type1, Type2, Type3 with the appropriate subforms Type1form, Type2form, and Type3form hidden until the right checkbox or radio button is selected.
There's only one problem: I have no idea how to make this happen... nor which way of doing this is best. Any help is GREATLY appreciated.
Tom
if i do 2 at a time it wont work
but 1 at a time works, why is that?????
insert into room values ('00012','1A','B','120','00002','Sports Hall','N','0');
insert into room values ('00013','1B','B','20','00002','Changing Rooms','N','0');
Somebody please give me an answer
Hi Guys,
I basically want an SQL statement that will search all fields of a table for a certain value. At first I thought that tihs might work..
Code:SELECT * FROM tblExample WHERE *='blah';
But it doesnt :-/
So, is there any other method of doing this? I know that I could just include each individual field name, but Im lazy - and its a big table (plus I want to use a similar query on a few other tables, so I want it to be fairly generic).
this DB should transfer records from table to another table and vice versa, somehow i cannot make the other command button works. it took me a week to figure it out what is wrong with the code.
pls help me with my DB.
Somebody out there!
ill attached the DB if someone replies my request.
thanks
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
http://www.fabalou.com/Access/Reports/filterreport.asp
http://www.fgcu.edu/support/office2000/access/
http://www.access-programmers.co.uk/forums/showthread.php?t=110337
I think the code just isnt working in 97...
Ive been trying to make a form that has a report list for filtering. Everything I research and do just isnt working for me. Ive followed a video about it and visited these sites.
http://www.fabalou.com/Access/Reports/filterreport.asp
http://www.fgcu.edu/support/office2000/access/
http://www.access-programmers.co.uk/forums/showthread.php?t=110337
I think the code just isnt working in 97...
Any Ideas? Maybe I just need more help or the code needs edited!?!?!
Thanks.
I am trying to get an IIf statement to work, but I am not quite sure how I can lay it out properly so that it works.So this is what I need
(IIF(([PAON_TEXT]= "Abbey Parade" AND [SAON_TEXT] AND [SAON_START_NUM]), (THATS THE CONDITION)
[SAON_START_NUM] & " ", (THATS THE TRUE PART)
(IIf(Not IsNull([SAON_TEXT]),[SAON_TEXT] & " ","") & (IIf(Not IsNull([SAON_START_NUM]),[SAON_START_NUM],"") & IIf(Not IsNull([SAON_START_SUFFIX]),[SAON_START_SUFFIX] & " ") & IIf(Not IsNull([SAON_END_NUM])," - " & [SAON_END_NUM] & " ","") & IIf(Not IsNull([SAON_END_SUFFIX]),[SAON_END_SUFFIX] & " ","") & IIF(([PAON_TEXT]= "Abbey Parade" AND [SAON_TEXT] AND [SAON_START_NUM])," ","") & iif(NOT IsNull([PAON_START_NUM])," " & [PAON_TEXT],"")
(ALL OF THIS THE FALSE PART)
I know the syntax for the FALSE PART is wrong how can I make the whole statement to work?
The user currently manual checks the Use Part? box but would I would like to automate with an update query. I have this query that needs to be updatable but has a group by and min to get the correct results. I plan to run this query by another update query to update the table, but its currently not updatable. Is there a workaround or does anyone have another scheme to go at it. Here is my current queries.
SELECT [t_BOM Part Cross].[Customer ID], [t_BOM Part Cross].[Assembly #], [t_BOM Part Cross].[Quote #], [t_BOM Part Cross].[Line #], Min([t_BOM Part Cross].[Alt Unit 1]) AS [MinOfAlt Unit 1], [t_BOM Part Cross].[Use Part?]
FROM [t_BOM Part Cross]
GROUP BY [t_BOM Part Cross].[Customer ID], [t_BOM Part Cross].[Assembly #], [t_BOM Part Cross].[Quote #], [t_BOM Part Cross].[Line #], [t_BOM Part Cross].[Use Part?]
HAVING ((([t_BOM Part Cross].[Quote #])=[FORMS]![Parameter]![Quote #]) AND ((Min([t_BOM Part Cross].[Alt Unit 1]))>0))
ORDER BY [t_BOM Part Cross].[Customer ID], [t_BOM Part Cross].[Assembly #], [t_BOM Part Cross].[Quote #];
I have another query that I used a SUB SELECT ON THE [Alt Unit 1] but does not group the other fields to get the results but it is updatable.
SELECT [t_BOM Part Cross].[Quote #], [t_BOM Part Cross].[Line #], [t_BOM Part Cross].[Alt Unit 1], [t_BOM Part Cross].[Use Part?]
FROM [t_BOM Part Cross]
WHERE ((([t_BOM Part Cross].[Quote #])=[FORMS]![Parameter]![Quote #]) AND (([t_BOM Part Cross].[Alt Unit 1])>(SELECT MIN([Alt Unit 1])>0
FROM [t_BOM Part Cross])))
ORDER BY [t_BOM Part Cross].[Quote #], [t_BOM Part Cross].[Line #];
thanks for any help available
how I can make an Array and For Each statement work together. I normally don't use either, but it would be good so I could write less code where plausible. Here is the example I have:
Code:
Dim Named As Variant
Dim Ctl As Control
Named = Array(Me.Namee, Me.ID, Me.Title)
[code]....
I am unsure how I include the array in this statement. I have tried replacing "Me.Controls" with the array name, but I get a 424 runtime error (no object). What I am trying to accomplish is for each item in the array I want to make it not visible if it has a null value.
is it really possible to make a work flow in access? And if so, can it be done in Ms Access 2010.
View 2 Replies View RelatedHow do I make the windows default navigation work to the following:-Next record that navigates to next, but does not create a new record when at EOF. New record that creates a new record.
I've tried turning off 'Allow additions' for the form, but that turns off the 'New Record' button, so that's not right Perhaps it's me but the default way in which the navigation buttons work is strange. I would have thought the next button would only go next and wouldn't do new.
I need to make my mainform fields required before any data can be entered into subforms. Mainform and Subforms are linked with LinkMaster Child ID. This should only be applied in this form.
View 4 Replies View RelatedHi all!
I want to insert a subdatasheet into a table but I only want certain records of the subdatasheet to be viewable/accessible e.g. Record 1 of my table should be related to records 1-5 of the subdatasheet. Is this even possible? Or worth doing for that matter!
Thanks in advance! You've all been really helpful in previous crises/head-scratching moments! :D
Hello,
I'm sorry if this has been already discussed but I've been searching without result.
I have a table "A", with table "B" in it as a subdatasheet.
Now when i insert a new row into "A", i need a new copy of the table "B" to be created, meaning every row in "A" would have it's private copy of "B". Is there a way to do this? I don't insist on subdatasheet solution, i just need a new copy of B to be created and linked to any new record in A.
Any suggestions?
Is it possible to pull information out of a subdata sheet to simplify a query or report? I am currently running a query based on 2 tables, however this produces multiple instances of the same info. If possible it would be much more beneficial to collect all info from the main table but I have not been able to find any info on how to access/reference the subdatasheet. Is there a way to do this or is this much more complicated than it sounds?
View 1 Replies View RelatedI wondering if it's possible to have more than one subdatasheet for one table. My table relations are as follows:
tbl1: Offices
col1: ID (autonumber)
col2: Office (text)
tbl2: Sections
col1: ID (autonumber)
col2: Section (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
tbl3: Staff
col1: ID (autonumber)
col2: Name (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
col4: Parent_Section (number) (relation to [Sections].[ID])
As you can see the "Staff" table has two relations. One to the "Offices" table, and one to the "Sections" table. I'm trying this because this company has some employees under an office, and some employees under a section under an office. And in the end was hoping to be able to look at the "Offices" table, then expand an office to show both contacts related to that office, as well as sections related to that office.
Is this possible? Or am I beating a dead horse?
Help is much appreciated.
Liam.
Hi once again!
I am trying to see if it would be possible to realize this design:
I have a table with 20 records (equipment names) and each one of them as a unique serial number and a lot of other fields;
Somehow I need to create a subdatasheet for each one of those records! This subdatasheet will contain pin to pin connections informations (lots of records maybe 70) for the cables attached to the equipment !
Example:
TabEquipment_Names
eqp1
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp2
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp3
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
As you can understand each equipment has a proprietary cable with specific pin to pin connections so I CANNOT create a single subdatasheet for the whole TabEquipment_Names table, but I would need to specifically create a table for each record in the Equipment_Names table, isn`t that correct?
Is there any way to do this?
Thank you.
e.
I have a main table and multiple other tables that I want to link to each row of the main table.The main table "Data" consists of columns (Name, x, y) where "Name" is the primary key and all values are unique.Each of the other tables have columns (Name2, z) where the value of "Name2" is the same in each row and also corresponds to the table name.
I want to make each table a subdatasheet of "Data" where each row in "Data" shows the values in the table corresponding to its name. (i.e. where Name = Name2).Below is what I have so far, but the code doesn't work because linkchildfields and linkmasterfields need to be run from a subform.(?)
The error I am getting is 'Property Not Found' once the code reached the linkchildfields line.
Quote:
Sub STS()
Dim i As TableDef
Dim db As Database
Dim tbl As TableDef
Set db = CurrentDb()
Set tbl = db.TableDefs("Data")
[code]....
I have a table for all my members, then a table for each class (for attendance purposes) and the class tables are linked to the master via subdatasheets. I also have a form that pulls up all the details of a member and I want to show all the times they've attended class. Is it possible to add the subdata sheets to the form or would I have to add the attendance record as a subform that filters on the person?
View 1 Replies View RelatedI 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:
We are creating a simple database to maintain driver license information for faculty, staff, and students who use cars from the university’s motor pool.
To do this, I have created two tables: tblDRIVER and tblLICENSE.
The fields in tblDRIVER are:
pkfDriverIndex
strLastName
strFirstName
strInitial
strAddress1
strAddress2
strCity
strState
strZIP
datBirthDate
The fields in tblLICENSE are:
pkfUpdateIndex
fkfDriverIndex
datDateUpdated
strState
strLicNumber
datExpirationDate
ynViolations
ynActive
Information about the driver is stored in tblDRIVER and the driver’s license information is stored in tblLICENSE. Periodically, we run a report that identifies drivers whose licenses are due to expire within a certain number of days. All this works fine.
My problem is that I am trying to create a lookup form that will load from a data entry form that will permit the Motor Pool Clerk to look up a driver by name and review the licensing information (which appears as a subform).
All this sort of works- I am using a combo box (based on a query) to look up a driver’s last name (which it does) and to populate all the driver’s information on the look-up form (including license information in a subform). Currently, the combo box locates the driver (including the unique index, last, and first names), and populates the form with first and last name but the rest of the information is not displayed on the look up form. Worse still, sometimes one driver’s last name matches up with the first name of the next driver listed in the table! This seems to happen only if a look up is attempted more than once. What gives.
Thanks for the help.
I have an expression in one column of my query and It keeps returning a negative result and there are no negative numbers in the source data. Can anyone help. I just want to sum the sums the two IIf expressions, but its not working. Thanks
Other Qty: Sum(IIf([QSum]![ACCOUNT]=2 And [QSum]![ICUNIT]=95 And [QSum]![UNITS]="ITEM(S)",[QSum]![QUANT],Null)) Or Sum(IIf([QSum]![ACCOUNT]=2 And [QSum]![ICUNIT]=100 And [QSum]![UNITS]="ITEM(S)",[QSum]![QUANT],Null))
I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right.What I would like to do is make the namebar, on top of every column, a little bit higher, so the name would be split into two lines, or three. Allowing me to make the width allot smaller.Here is an example of my problem:http://213.213.137.96/~terminal/columns.jpgSo my question is, can I change the height of the column name? Or is there some trick I can use?regardsFrímann Kjerúlf
View 1 Replies View Related