Using A Form To Query/adjust Subform

Aug 21, 2004

First off, I'm really new to all this so I'm a little overwhelmed. I know what I want but may not describe it well.

I'm just trying to get a basic issue to work.

If I have 2 databases, one which has names, and another which has information - in memo form. What I'm trying to do is create a form which will allow me to bring up a persons name and have the subform query the information database for all information (events) which have this persons name listed inside.

I have tried both filters and queries and while I can get everything to work if I type in text in the queries in and/or filters if I try to use the value of the name in the main form nothing ever works...

Thanks...

View Replies


ADVERTISEMENT

Best Way To Adjust Poorly Designed Table/query

Nov 5, 2004

I'm going crazy!! Someone who didn't really understand relational database theory (not like I'm an expert, but. . .) built a DB that is much more complicated than it needs to be. That person left and I got the job. I have to work with our IT people to hopefully redesign it completely (I would without asking, but they control the SQL server and the connection to the web.) but in the meantime, I have to work with a mess.

Okay, the question--I have to print a report of which organizations used which software company.

The table fields are:

Organization
Comp1
Comp2
Comp3
Comp4

etc.

the answers are a "1" for a yes and a "0" for no in the "Comp" fields, so there is an answer in every field of a record. Essentially, it's a spreadsheet.

Off the top of my head, I know I could query each Company name with the court individually and then union query them all together. But isn't there any easier way? We're talking about 15 queries if I do it that way!

Anyway, thanks for any help you can give--this is driving me crazy (over 40 table set up in similar disarray. . . .)

View 3 Replies View Related

Tables :: Find Record Button Added To A Form To Adjust Search Function

Apr 6, 2015

Is it possible on the Find Record button added to a form to adjust the search function so it defaults to a specific box on the form? I have a form for tracking employee's and on my Find Record button I would like it to default to the Last name instead of the Record number.

View 3 Replies View Related

Adjust Margin With Vba Code?

Jan 10, 2006

I know in access 2003 i can use:

printer.leftmargin = 0

but in access 2000 there is no printer object. Is there a way of setting the margin with vba from access 2000?

View 5 Replies View Related

Modules & VBA :: How To Adjust File Attributes

Jul 9, 2013

Below is code to adjust file attributes.

Code:
Public Shared Sub Main()
Dim path As String = "c: empMyTest.txt"
' Create the file if it exists.
If File.Exists(path) = False Then
File.Create(path)

[Code] .....

View 3 Replies View Related

Queries :: Adjust Column Width To Best Fit Using VBA

Mar 20, 2013

How to adjust the column width of the fields to best fit in a Query using vba codes? Manually it can be done by selecting the Query - Click on More dropdown of the Reports section in the ribbon - Click on Column width - and select best fit as the option.I want this to happen by a vba code and not manually doing it everytime because the field length changes as it is a dynamically created Query.

View 3 Replies View Related

Make + And - Adjust Date In Field

Jun 12, 2012

I am trying to make the + - (numpad) adjust the date of the current text field. The problem I am having is I believe the input mask intercepts the keypress and my keypress event is never fired. Here is my code:

Code:
Private Sub LeaseDate_KeyDown(KeyCode As Integer, Shift As Integer)If (KeyAscii = 107) Then
LeaseDate = DateAdd("d", 1, LeaseDate)
End If
If (KeyAscii = 109) Then
LeaseDate = DateAdd("d", -1, LeaseDate)
End If
End Sub

Access makes the ding noise when I try and press + and - ...

View 4 Replies View Related

Forms :: How To Individually Adjust Width Of Controls

Jan 17, 2015

I have created a form using Create|Form.

I have now opened it in Design view and wish to adjust the width of the controls - text boxes etc but when I try to adjust one, all of the text boxes in that column are adjusted.

How do I individually adjust the widths?

View 8 Replies View Related

Reports :: How To Adjust Text For Subforms With Dynamic Heights

Jun 27, 2014

I've created an Access Report of a letter to be printed and mailed to customers. The majority of the letter is text, however there is a subform in the middle that will have a wide range of records displayed in it. This causes the subform's height to adjust from 1/2" to several inches, depending on the number of records. I need the text below the subform to start just below the last record in the subform, no matter how many records are displayed in the subform.

Access 2010

View 3 Replies View Related

Modules & VBA :: Adjust Required Field - Space Bar Character

Aug 30, 2013

How can I adjust my required field so that you cannot simply enter a space bar character to circumvent the requirement?

Here is part of the code:

If IsNull([txtRequiredReason]) Then
MsgBox "The Reason field is required"
DoCmd.GoToControl "txtRequiredReason"

Else

View 1 Replies View Related

Tables :: Transaction Table Setup To Adjust Inventory

Apr 22, 2013

I have a database that I use to put in orders for our shop and keep track of our part informations as well as paint and packing materials. Everything works good on this but I am trying to create a table for adjusting quantities on hand for packing material based on the part quantities and for adjusting paint in stock based on information given to me after the job is run.

There is already a relationship between parts and packing material as well as parts and paint. When I put an order in I would like to have it adjust out that many packing materials that are related to that part. Once a job is run I need to be able to adjust out the amount of paint used.

For the paint side of this I want it to track the paint used by order, we are trying to get a grasp on how much paint we are using for parts so it is important for me to know how much and when.

I am thinking I need a table that connects paint to orders and has quantities in it, then create a query and do the calculations from there... I do not know how to accomplish that but it sounds like it could be right...

View 1 Replies View Related

Modules & VBA :: How To Adjust A Sample Database To Suit Specific Needs

Oct 29, 2014

I would like to make some changes to the Northwind sample database.I need to have the Customers section completely removed as my company issues products to our own staff, not to external customers, so there is no Customers and shipping details needed.

View 2 Replies View Related

Reports :: Adjust Section Width To Avoid Blank Pages

Nov 18, 2014

I have set up a report in Access. However, when I look at it in print preview, I get the message that the section width is greater than the page width, and that some pages will be blank. It is obvious that the Detail Section is the issue, but I can't figure out how to reduce the section width. The detail section only contains a few text boxes that are well within the margins of the other sections.

How do I adjust the section width so there won't be any blank pages?

View 6 Replies View Related

General :: Adjust Cell Size According To Length Of Data In Datasheet

Jul 9, 2013

I have subform (Datasheet) is there some code e.g. after update, which can adjust size cell to lenght of data?

View 11 Replies View Related

Forms :: Make Frame Automatically Adjust To Image Width And Height

Aug 7, 2013

Is it possible to make it so that whatever the dimensions of the image i paste the OLE object's frame will also be the same? I'm having a problem, not necessarily a problem more like a preference, I'm inserting pictures of each individual inside a database and whomever last took these pictures didn't make sure there was a standard size So all the images are different sizes and when they're put inside the OLE frame you can see the image inside it but the frame itself also shows its white background because the image isn't the full dimensions of the frame. I was thinking if it's possible to make the frame automatically adjust to the image's width & height.

View 3 Replies View Related

Changing The Subform/query On A Form

Jan 13, 2005

Hi,

I have a form that has a query on it. It acts as a subform. I would like for this query to be able to switch depending on what employee I've got selected on the form. I've tried playing around with the sourceobject property:

Dim name As Variant

name = Forms![Time Input Form]!Employee
Forms![Time Input Form]!Table.SourceObject = name


, but it keeps telling me
"Run-time error '3011':
The Microsoft Jet database engine could not find the object
~sq_cTime Input Form~sq_cTable'. Make sure the object exists and that you spell its name and the path name correctly."

The names directing to the subform are absolutely correct though. I'm just not sure if this is the right property to use.

Anyone have any ideas? Thanks. =)

View 1 Replies View Related

Query Subform From Main Form

May 11, 2005

I have a main form with 5 fields (I'd like to be able to use any number of them) that I want to use to run a query against that is contained in a subform. What is the best way to go about this?

View 1 Replies View Related

Forms :: Query From Form To Subform?

Nov 20, 2013

I have a subform which is controlled by a query eg . Fname&" "& Lname as Name, order_number. and i have form which have combobox.

When form opens the query works fine but when i search value order_number in combo box it gives the result but with ?Name in Name column.

I know i can do this with Filter method, and rewriting the query, but i want to use it by passing the value in query of subform.

View 3 Replies View Related

Subform Query On Main Form

Dec 3, 2014

I have created a 1 to many database. One employee table with personal details and then tables reflecting costs like, flights, accommodation, visa costs etc.I then created a query(total costs) to add up the total of those tables and then a subform that I inserted in the main form that just display the total over cost.

When I click, new record, everything goes blank which is perfect for me to input a new record but the total of the 1st record( i only have one record at the moment) remains the same.

View 8 Replies View Related

Duplicates In Report / Query Due To Form And Subform

Jul 10, 2013

I have tbl_Proj, tbl_Notes, and tbl_Proj_City. They are all joined by the tbl_Proj's ID.I have a set list in tbl_City - tbl_Proj_City is 3 columns an ID for itself, tbl_City ID and tbl_Proj ID...In instances where a project covers more than one city, when I generate a report (or query) for that project I get each notes that number of times. If a project is in 3 cities I get each note 3 times.

I have a project entry form with a combobox subform for the city selection.The report is from a qry, by Proj_ID, I need to show the cities - the "key" city is the first alphabetically (also lowest via autonumber in City_ID). I would like to add that I do not know SQL. I have created this database using access commands.

I am thinking that I may be able to query the project ID for the Cities and somehow select the first alphabetically or the lowest in ID and store that somewhere? and then run a query that uses that and the notes to generate the report and then have a sub report for the other cities?

View 6 Replies View Related

Queries :: Query In Subform / How To Use A Field From Main Form

Apr 5, 2013

I have a query in my subform:

Code:
SELECT ContainsTracks.albums, ContainsTracks.tracks
FROM ContainsTracks
WHERE ContainsTracks.albums LIKE [VALUE IN TEXTBOX1 FROM MAIN FORM]

As you can see in the brackets, I would like to use the value in textbox1 on my main form in this query (so I can select only the tracks from the album that is typed in textbox1, disregarding the others).

View 1 Replies View Related

Forms :: Query Results From Main Form To Subform

Feb 19, 2015

My Form is taking its results from a parameter query, and since my subform also has the same control source (the query).

It always prompts me twice, although not a major problem it is irritating!

Is there any way that when I type the search results once the sub form takes the results from the main form?

(P.S. The form asks me for parameters even when printing and saving, is there not a way that this can be stopped too by maybe taking the results off the current page?)

View 9 Replies View Related

Forms :: Update Query From Subform On Navigation Form

Jun 17, 2013

I have a navigation form, a navigation subform, and then a subform. When I click the save button on the navigation subform, i need the data entered in two fields on the subform to save in a table. the subform is based on a query. This is what I currently have on the the button's onClick event:

Code:
Update data_tbl
Set [data_tbl].[Approved] = [Forms]![Navigationfrm]![Navigation subform].Form![Entry_subfrm].[Form]![CboAppd]
[data_tbl].[Comments] = [Forms]![Navigationfrm]![Navigation subform].Form![Entry_subfrm].[Form]![txtComments]
WHERE [data_tbl].[ID] = [Forms]![Navigationfrm]![Navigation subform].Form![Entry_subfrm].[Form]![ID]

View 3 Replies View Related

Update Subform With Query Results In Main Form

Jul 17, 2012

I created a main form containing list boxes and a subform. What I want to do is to select items in the list boxes. Then, by clicking "Search" button, the data filtered by the selected items will be shown in the subform. But the subform cannot work and show the query results. I think I miss some VBA codes.

Complaint Database_William.zip

View 1 Replies View Related

Queries :: Insert Into Query - Duplicate Records In A Subform To New Form

Jun 4, 2013

I'm trying to duplicate the records in a subform to a new form but keep getting a too few parameters error.

Code:
strSql = "INSERT INTO [OrderDetailT] ( OrderID, ProductID, Quantity, DiscountPercentage ) " & _
"SELECT " & lngID & " As NewOrderID, ProductID, Quantity, DiscountPercentage " & _
"FROM [OrderDetailT] WHERE OrderNumber = " & Me.OrderNumber & ";"

The debug.print comes out as below:

INSERT INTO [OrderDetailT] ( OrderID, ProductID, Quantity, DiscountPercentage ) SELECT 49 As NewOrderID, ProductID, Quantity, DiscountPercentage FROM [OrderDetailT] WHERE OrderT!OrderNumber = 11;

View 4 Replies View Related

Query To Return Default Set Of Values In A Subform When Main Form Opens

Apr 23, 2007

Here is my sample DBA

I'd like to solve this issue

when I open my Quotations form I'd like a set of services to be selected by default, ex: Brush and Pen. So the user only has to input the quote amount

is there anyway to have the form open with a script like:
"on open (or on load). in subform SELECT refproduct where product from tblproducts = 1 and also SELECT refproduct where product from tblproducts = 4"
Therefore when my main form opens, in the subform I have already Brush on the 1st line selected and pen on the 2nd. My user only has to type the price.

Thanks for your much appreciated help

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved