How Do I Query A Form To Do The Next Step

Jul 26, 2006

I have a switchboard and when I click a certain button ...
it opens a prompt popup.

In the popup you enter the required "item" and you hit enter or "ok"

It then does a search for the specified "item" and brings up
that information.
At that time I would like to have a calculator
pop up for the user to use.
(newb) How in laymans terms do I get this to work ?

In my "forms" Design View I have:
Switchboard and Calculator

In my "Queries" I have query 1

In the tables section I have :
Sheet one (this is were the query is getting its search info from.
Switchboard items

Is there something I can add to my query to get it to open the calculator form ? Or is there some other way without using additional buttons to do this.

View Replies

Form Step By Step

Aug 25, 2005

hi.

in my db i have used in one scenario two separate forms to fill in one record in a respective table.

the user fills out the details in the first form for record 1, presses NEXT, and fills out the remaining details in the second form for record 1.

every time form 1 will be opened, it will need to be at the end of the records (to add a new one of course) so i have used this code in my form 1 open event DoCmd.GoToRecord , , acNewRec

this is fine. however, i have a dilema. when i place that code in form2 also, it skips one further place to the next record(record 2).. and if i dont put any code in form 2, it will always display the record that has just been added previously..

so basically what i need is something to tell form 2 to carry on adding details into the same record that form1 was just on..

how can this be done?

View 4 Replies View Related

Step Ladder Query Help

Jan 22, 2006

View 1 Replies View Related

Compiling Multi Step Query Into Single Query

Dec 8, 2011

I'm new to access, and have discovered its easy to write large queries by breaking them up into smaller queries and having each subsequent query reference the one before it. My problem now is that I want to combine these queries into a single query, so as to make it easier for anyone who comes after me to edit/understand what was done. I can't seem to find a good explanation of how to do this, but it seems like there should be a way.

View 1 Replies View Related

I Am Stuck At A Step

Jul 14, 2006

I have a form that i use to make labels.

I want the user to be able to specify in the form the numbers of labels to print.

After reading access for dummies and other manuals, google and calling my local IT guys, I've exhausted all examples I was given.

CAN/ WILL ANYONE HELP ME?

View 1 Replies View Related

Next Step In The Autofill

Jul 5, 2005

OK, the syntax below works awesomely in a form. The SSN number is pulled from the main table and dropped into a bunch of text boxes. The only text box that is bound is called [sub#] and is stored in the supervisors table, 6 sub's per supervisor and the supervisors SSN is a child of the main table (tried to keep redundant data to a minimum). Now I need to know if there is any way to perform a similar trick in either a query or report using the [sub#](SSN equal to that of a main table entry) field to call up the record from the main table or from a query to use in a report?

Example of working syntax from form...
Private Sub Combo48_AfterUpdate()
Rank1 = Combo48.Column(4)
Sub1 = Combo48.Column(0)
Last1 = Combo48.Column(1)
Rank1 = Combo48.Column(4)
First1 = Combo48.Column(2)
MI1 = Combo48.Column(3)
EPR1 = Combo48.Column(5)
Rating1 = Combo48.Column(6)
Next1 = Combo48.Column(7)
End Sub

View 3 Replies View Related

Step Into Event Procedure

Apr 17, 2006

Can you step into an Event Procedure line by line in Access? I toggled the Breakpoint at the End Sub of the Event Procedure, clicked in the middle of the sub, and pressed F8. Nothing! I do this all the time in Excel.

View 2 Replies View Related

Sub Works Only In Step Mode

May 12, 2005

It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D

I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If Not IsNull(Me.txtNumber) Then
Me.txtNumber = Me.txtNumber + 1
End If
The weird thing is, sub B runs just fine if I run the sub B in step mode. If I set a break point and use F8 to step through the code line-by-line, it runs just fine. If I take out the breakpoint, the code no longer works.

Anybody have any ideas? I'm running Access XP Sp2 on Windows XP SP1. Thanks.

View 3 Replies View Related

Step Back Through Previous Find Results

Jul 23, 2006

Hi
I have a set of membership records which have data input via a simple form. When looking for a particular record I use the standard Find menu item on the whole record set from the Form view, and move through the results using the Find Next button. Is there a way to move back through the records when I have got to the end of the results. eg. there may be numerous members with a surname Smith and I can move the the Smith records by using Find and Find Next but if I have moved past the record that I want is there a way of stepping back through the records?
Apologies if this is a really obvious question

View 4 Replies View Related

I Have The Correct Coding,still An Error In Connection.what Is The Next Step Fr There

Sep 14, 2005

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(" coordinatordbTC.mdb")& ";PASSWORD=123456")
================================================== ===================================

I have been trying solve this problem for a few days.
however, the best i can come into is the above code, however , the following error still approached me.

================================================== ===================================
Microsoft JET Database Engine error '80040e4d'

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

================================================== ====================================

Kindly , someone can help me in this coding . Thank you very much

View 1 Replies View Related

Query In Forms Question (printing A Single Selected Query Record From A Form?)

Oct 19, 2004

What is the best way to impliment a query in a form so that the user can view the query records, and have the option to print or save the selected record using command buttons?

I tried subforms but I could not get the command buttons to work in the subform after it went into the form, it wanted to print the entire form instead of the selected record from the subform.

So in a nutshell I have 3-4 queries that are built, and I want to have them show up on my form in a format that the user can scroll through the results and select a single record of the results and then print or save that individual record from the form, if such a thing is possible.

Thanks in advance

Todd

View 1 Replies View Related

Forms :: Update Form / Query Without Updating Underlying Tables To Query

Jul 23, 2015

I have a form which will be used as the basis to print a label.

It is bound to a query and when I open the form I pass over a 'where' condition to return 1 record. I then use the query to produce a report/label.

What I want to do is to update the form/query without updating the underlying tables to the query.

View 14 Replies View Related

General :: Enter Value In A Form / Run Query And Display Result On Form

Jun 15, 2013

Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return the value of count function in to anther text box?

View 5 Replies View Related

Forms :: Using ID Value Passed To Form From Previous Form In Query

Aug 17, 2014

I have a big table, EquipmentDetails and separately I have job plans.Job plans can have many pieces of equipment. I store the relationship in EquipmentDetails_JobPlanDetails, but am feeling frustrated as I can't seem to get Access to build the SQL query from this in the way I want.

I am generating a List Box in a form which is populated from a query.The query calls on a table which lists ItemID from EquipmentDetails and JobID and in the current form (where the list box is) I want to pick up and display the ItemIDs associated with that JobID. The current JobID reaches my form correctly (I've proven this by displaying it in a text box) from the previous form.

The problem I have is that I can't seem to get the SQL query to only get ItemIDs that are linked to the current JobID. No matter what I try, it either gets all of the ones in that table, or I can't compose one.What kind of SQL do I need to only grab the ones relating to the current JobID please?I've tried building it in the design view but it says that it can't do it because the outer joins are ambiguous.

View 2 Replies View Related

Query In One Form With Results Displayed In Another Form

May 13, 2005

First, I am a beginner with Access. I am a graphics designer that has been assigned to cover for a db programmer that quit!

Here is my problem:

I have a database that we use to hold customer information. There are 22 fields in each record, and we are now well over 3000 records.

Once upon a time, to find a specific customer, we would just go to the bottom of the page, and use the arrow buttons to scroll through them all. This is no longer possible as the size is too big to manually search.

What I would like to do:

Upon Access startup, display a form that has a single input field and a button titled "Search". The input field is titled [UserName], as this field is the unique key identifier for the record. When the user types in the UserName and clicks the SEARCH command button, another form appears to display JUST THAT RECORD in the easy to read form!

If this is really basic, I appologize. I have 20 years experience with commercial illustration and only 7 days experience with Access. I have purchased books, and hit the forums, but I am not a VB programmer, and my skills this area are REAL weak!

My resourse books include the following:
Wiley - Access 2003 Bible [Prague, Irwin & Reardon]
Osbourne - How to do Everything with Access 2002 [Anderson]
O'Reilly - Access Cookbook [Getz, Litwin & Baron]

Thanks in advance for any assistance.

View 1 Replies View Related

Form With A Query To Display Result In Another Form?

May 13, 2005

View 3 Replies View Related

Inserting Data From One Form To Another Using A Query In A Form

Sep 6, 2004

HI

I have a form for member details that comes from the member table and I want to
include a button on the form that will remove the member details from the member
table to a member history table and then delete the details from the member table.
When moving the record I also want to include details from another table called 'promotion',
this table is linked to the member table via the member ID (Foriegn Key).

Firstly I want to know if this is possible and if so how I would achieve this. I am having
trouble getting the SQL query to identify the current record that the form is displaying so I can
select additional information and move it into the Member History table.

Any information would be greatly appreciated.

Thanks.

View 2 Replies View Related

Query Results In Form, But What If Query Is Null?

Aug 30, 2005

I have a query that displays results in a form, but if the query is null, I want to display a different form, or just an error message that says something like "your query returned no results" (right now it will display the form with no fields)

I am a beginning Access/VBA user and have searched and browsed the forum for combinations of null/query/form, but haven't found what I need. Can anyone point me in the right direction?

Thanks for any help.

View 5 Replies View Related

Form/Sub Form Update Query?

Sep 22, 2006

:confused:
I have a form displaying individual contract information. This form is a continuous form and on each record I have a button that activates a dialog box with two text boxes to facilitate NOTES entry for the current record on the main form. When I close the dialog form - I need the NOTES text entered to be updated in the corresponding text fields on the continuous form.

I have tried the following :

1. After the dialog has closed - set the main forms Bookmark property/ Requery the form and then reset the forms Bookmark.
Problem with this solution is that occasionally I get ' Not a valid bookmark' error message.

2. In the Unload event of the dialog - I have tried Requery calls for each of the text field controls on the constinuous form prior to the dialog closing. This works fine for records that already exist in the table and the data does reflect the changes correctly. For brand new records, the updates are not reflected on the main form and the data only appears when the main (continuous) form is closed and re-opened.

Does anyone have any ideas on how to do this properly? Has someone done something similar?

Thanks
Regards
GUIDO

View 1 Replies View Related

Query A Query, Where It Is Based On A Form?

Jan 10, 2007

Hi All

I have a query that runs based on the contents of a date entered in a form (I will call that Query1).

I need to take the data from Query1, and then have Query 2 analyse the data (I want it to tell me where the Count of First Day is more than 5).

When I use the query design grid, I include the fields want from Query 1, and put the criteria in to say CountofFirstDay >=5; but when I run it, it asks for the data for the form (relating to Query 1)

What can I do? thanks!

Maria

View 1 Replies View Related

Forms :: Parameter Based Query - Filter A Form Based On Another Form

Mar 20, 2013

I have a form which uses a parameter based query to present an individual senior doctor with a list of names for of individual juniors to provide an assessment report on. When the first form opens the user enters their RespondentID.

Once senior has decided which names to comment on I have another form which has the questions to be answered which is opened by clicking a button on the first form.

How can I pass a parameter from the first form to the second so that only the records relevant to that senior doctor are displayed? The underlying table has 60 senior doctors and 20 junior doctors. The senior doctor is identified by the field RespondentID in the first form. I've tried putting a WhereClause in the FormOpen command but I still get a dialogue box asking for the parameter RespondentID when the second form is opened.

View 2 Replies View Related

Query Form

Jul 25, 2007

I have a query form which user use to search for records according to their conditions they selected from the dropdowns.

Now when there is result for the conditions specified it works fine but when there is no record it pops up message saying no record and as one hit okk it gives below error:

"Run Time error 7874 eta database cant find the object 'xxx-0725'"

this is some table gets created everytime we search something.
and if there is no result this is not created somehow and it gives error.

View 3 Replies View Related

VBA Query Used In A Form

Aug 7, 2005

I have these queries (QRY1 and QRY2) made in vba which are used to fill 2 multiboxes (ListIncluded and ListNotSelected) in a form. The left multibox (ListIncluded) shows all the people that attented to a certain class, the right box shows the ones that werent present. The table "tblPersoneel" is used to find the names of the people. Basicly I use these tables: tblPersoneel (all the people) tblTrgRegAlgemeen (general data about the lesson like date etc) and tbltrgRegDetails (details, uses TrID to relate to a record in tblTrgRegAlgemeen and PersID to link it to the ID from tblPersoneel). I use buttons to move around the people.

The following code is used:

Dim SQL1 As String

SQL1 = "SELECT [tblPersoneel].[ID], [tblPersoneel].[Achternaam] & ', ' & [tblPersoneel].[Voorletters] & ' ' & [tblPersoneel].[Tussenvoegsel] As MyName, [tblPersoneel].[Rang], [tblTrgRegDetails].[TrID], [tblPersoneel].[Regnr], [tblPersoneel].[Toegang] " & _
"FROM tblPersoneel LEFT JOIN tblTrgRegDetails " & _
"ON ([tblTrgRegDetails].[PersID]=[tblPersoneel].[ID]) " & _
"WHERE ([tblPersoneel].[Toegang] = " & Me.ListToegang & " " & _
"AND tblTrgRegDetails.[TrID] = " & Me.TrainingID & ") " & _
"ORDER BY [tblPersoneel].[Achternaam];"

Forms!frmTrgInvoer!ListCurrent.RowSource = SQL1

Dim SQL2 As String

SQL2 = "SELECT [tblPersoneel].[ID], [tblPersoneel].[Achternaam] & ', ' & [tblPersoneel].[Voorletters] & ' ' & [tblPersoneel].[Tussenvoegsel] As MyName, [tblPersoneel].[Rang], [tblPersoneel].[Regnr], [tblPersoneel].[Toegang]" & _
"FROM tblTrgRegDetails RIGHT JOIN tblPersoneel " & _
"ON [tblTrgRegDetails].[PersID]=[tblPersoneel].[ID] " & _
"WHERE [tblPersoneel].[ID] NOT IN (" & SQL1 & ") " & _
"ORDER BY [tblPersoneel].[Achternaam];"

Imo this would result in the following: at the record i am viewing in the form i have people in the box which uses SQL1 and the other people are in the right box using SQL2. Any person cant be in both (one cannot be in a lesson and not be there).

I am pretty sure this is a SQL problem and not VB and I really hope someone can help me with this.

Thanks in advance!!!

View 1 Replies View Related

Need Help With Query/Form

Nov 25, 2005

I have a form with 4 pulldown boxes. What I want to do is basically query a query? But I am having trouble. I am basically looking for an AND/OR type clause.

If I choose any of the 4 combo's or some, or all. I want all the selections made in the pulldowns to be considered in the query. I have to consider some pulldowns will have not been selected. For that matter I must consider none were selected.

Basically having trouble passing this info from the form to the query and getting the query to do anything with it. I am not talking opening the query, that can be done with a button with an event handler. I am talking actually getting the query to give me the results I asked for. Basically I can get the query to take the data in the form of "AND" or "OR" but not to consider both.

Maybe I am talking in circles but I want clear my desire. If I chose 2 pulldown boxes, and select data. The query should consider both that I chose, and since the other 2 remaining boxes have not been selected ignor those NULL values as if nothing was in the criteria.

Any help would be appreciated.

View 3 Replies View Related

Query By Form

Jan 9, 2006

I have a form that has a bunch of unbound fields on it. I have a query that is tied to the fields of the form. The purpose is the form is a filter and when you type something in it goes through the query and then creates a report. The form is not bound to anything. Is there a way to have a list box in the form that has a list of information that people can choose multiple records from the list box and have it go through the query?

View 5 Replies View Related

Query By Form - SQL? Help

Feb 13, 2006

I created a form with several combo boxes on it. When data is chosen within the combo boxes, a query/report can be run and it retrieves all of the information in accordance with the combo boxes.

The functionality that I need to build in is the option to leave any number of those combo boxes blank in order to retrieve ALL information from the field linked to that combo.

Example:

I have three combo boxes. One is named team and it lists all team names. The second combo box is priority (1-2-3-4 etc). The Last combo box is day of the week. As it stands now, I can input data into each of these boxes and my report functions fine. However, I want to be able to leave one or more of them blank and it pull back info. Such as....if I dont choose a specific team, but I choose a specific priority and a specific day of the week, it should pull back ALL teams that have that priority and day of the week.

Does this make sense?

I was given a link to a site by the name of Brinkster to include an ALL function on my combo box, but that will not work for some reason. I know what I want to do is possible, because I have incorporated it into another database of mine. However, I cant make heads or tails of my notes or how that database is setup.

Help?

need more info?

View 6 Replies View Related