Sub-Form And On Click Questions

Mar 30, 2006

Hi all, i got a problem which i hope you guys will help me on. I created several forms, the main form with command buttons that leads to other forms where users can key in their conditions for queries, i.e. parameter forms

After building the SQL string using createquerydefs

i use the code:

DoCmd.OpenQuery "Requests_open_module", acViewNormal
to open the query.

all these is assigned to a command button on click event. however when i click on the button in form view, the query result appears in a window behind the parameter form instead of on top of it.

so i tried:
DoCmd.OpenForm "weekly_open_requests_result", acFormDS, , , acFormPropertySettings, acWindowNormal

where weekly_open_requests_result is a form linked to the Requests_open_module query. And i get the same result, upon clicking, the form appears at the back instead of on top.

finally i went to the weekly_open_requests_result form and enabled popup in properties window and it worked! however...it doesnt have "File" which i need as the user upon looking at the result, needs to export it to excel.

so what is wrong here? or is there any code that i can use to make the exporting to excel automatically; i will need the form to prompt the user for a name and directory to save to.

View Replies


ADVERTISEMENT

Form Questions

Dec 21, 2004

I have a form that I am working on. I have enabled queries to be run by selecting on command buttons. All of my queries have a year field. I want the user to enter the year in a text box and then run the queries based on the selected year. I do not want any of the data in the queries to update except for the year field. I am not sure how to link the text box that I put on my form to my queries and get everything to update correctly.

If anyone could give me advise I would appreciate it.

View 1 Replies View Related

Using A Form To Score Yes/No Questions

Feb 9, 2005

I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.

View 7 Replies View Related

Continuous Form Questions

Jun 28, 2005

Hi,

On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?

Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?

Mant thanks, in advance.

Lampy

View 3 Replies View Related

Form Design Questions

Jul 25, 2005

I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea of how I could use this same format for order entry? I need to ease our sales staff into this new idea and don't really want to disturb the form they have been using forever.
Thanks for any and all suggestions,
Chad

View 5 Replies View Related

Two Questions- (two Frames And Html Form)

Apr 28, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 3 Replies View Related

Two Questions- (two Frames And Html Form)

May 4, 2005

First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.

the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.

please advice.

thanks.

View 1 Replies View Related

2 Questions About Search Boxes On A Form

May 26, 2006

Hi all..

I am using the following search function to search my database:

Private Sub cmdSearch2_Click()
Dim strLastName As String
Dim strSearch As String

'Check txtSearch for Null value or Nill Entry first.
If IsNull(Me![txtSearch2]) Or (Me![txtSearch2]) = "" Then
MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!"
Me![txtSearch2].SetFocus
Exit Sub
End If
'Performs the search using value entered into txtSearch
'and evaluates this against values in strStudentID
DoCmd.ShowAllRecords
DoCmd.GoToControl ("LastName")
DoCmd.FindRecord Me!txtSearch2
LastName.SetFocus
strLastName = LastName.Text
txtSearch2.SetFocus
strSearch = txtSearch2.Text
'If matching record found sets focus in strStudentID and shows msgbox
'and clears search control
If strLastName = strSearch Then
'MsgBox "Match Found For: " & strSearch, , "Congratulations!"
LastName.SetFocus
'txtSearch = ""
'If value not found sets focus back to txtSearch and shows msgbox
Else
MsgBox "Match Not Found For: " & strSearch & " - Please Try
Again.", _
, "Invalid Search Criterion!"
txtSearch2.SetFocus
End If
End Sub
Which i got from here: http://www.databasedev.co.uk/text_search.html

Question #1

I have my own record counter setup at the bottom of the form via this:

Private Sub Form_Current()
'Inserts current record number and total number of records
Me.txtCurrent = Me.CurrentRecord
Me.RecordsetClone.MoveLast
Me.txtTotal = Me.RecordsetClone.RecordCount
End Sub

I would like to have this show how many searchs were found. I really don't
care about how many entries at this point... but if you do a search via
lastname for "johnson" I have 15 right now.. I would like to let the end user
know their are 15 enteries with the last name "johnson"... how can I do this
if it is possible with what I have setup..

Question #2
How do I get the search lastname field to go blank after I hit the
search button??

Thanks
R~

View 14 Replies View Related

Button Face / Form Size Questions

Apr 20, 2005

1st of all let me say hi (newbie on this forum)

2nd: i started doing access about 3 weeks ago. and 90% of my knowledge goes to this forum. ur just great guys (or woman, if any here). cograts. (well to brag a bit, i made a form, subform table on it, can use checkboxes to filter data on the table (4 checkboxes), can add open a new form and add the data while the table subform is refreshed,etc... and like i said, i got it 90% from this forum). Who's da man?? YOU ARE!

3: my problems:
a) i want to either:
- change a face (pictucture) on mouseover or onclick
- use a picture for a button and change it on mouseover or onclick

b) i want to set a default size for my forms. now the problems are:
- the unists are in centimeters (or inches). i want pixels. screensize is in pixels so it's easier to adjust the form that way. i know that if i type for ex. 400px and move away it is converted to px, but is displayed in cm. any way to use px as default display units?

- the form has the size of the whole window instead of just the grid. what's the trick? (i mean if i say 400px, the grid is 400px. but if i have a gray area 200px more (design view), then when the form is opened, it will be 600px). huh?

c) can i get rid of the scrollbars if i don't need them? and they will auto appear when needed.

Thanks for the answers. And again, even if i don't get any, this forum is by far the best. (well for access anyway ;)

d) is there a "mailto" function i can run with onclick [command button]?

Bye for now
Josh

(oh you can reply here or by mail: joshlyman_slo@yahoo.com)

View 5 Replies View Related

Code Triggered From Label On Click Behaves Differently From Command Button On Click

Nov 7, 2006

Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code.
The code below however works for a command button, but not a label button.

DoCmd.OpenForm "frmdatetime"
Do While Forms!frmdatetime!OKFlag.Caption = "False"
DoEvents
Loop

When this code is run by clicking on a command button, it works fine.
If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime.
If I remove the loop with the DoEvents in it, then the problem does not occur.

Can anyone enlighten me as to why this behaviour occurs.

Thanks

Richard

View 4 Replies View Related

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Double Click Record In One Form To Open New Form?

Jan 27, 2014

I am trying to create a proposal log for my company to make things easier to track. I have made a multiple items form to list the proposals. I want to be able to double click the record to open up another form (that i have already created) that shows the information from the proposal table and the proposal details table. So.....

I want to double click the field named "Proposal Name" and have it open up to form i have called "proposals details form".

View 3 Replies View Related

Refreshing A Form On Click

Jul 27, 2005

I have a form that has a status, and a button that changes that status when clicked. This should remove the record from the current form and put it in another.

Is there anyway I can refresh the form after that button is clicked to show the record actually dissapearing instead of having to close/reopen the form?

View 2 Replies View Related

Refresh Form When Click Out Of A Specific Box?

Jun 29, 2006

I have a refresh button next to a box in my form. I would like to make it so that when someone clicks another field or out of the key box it will refresh the form automatically because that box makes other fields autopopulate and the way I have it set up thus far is that you half to refresh the form somehow to get that date to come over.

How do you like that run on!?!?! :p

Thanks for any help!

View 3 Replies View Related

Call A Button Click On Another Form

Feb 6, 2006

Hello everyone!I need to call the button_click procedure for a button on a form (button1), from another form, if you see what I mean!.Basically the user opens form1. They click a button which opens form2. Once they have finished on form2 they press the close button, which is the point where I need to call the button1_click procedure on form1.I imagine it's something like this:Call Forms![frmForm1]![button1]![Click] orCall Forms.[frmForm1].[button1_Click()]But no matter what syntax I try it just won't work! They're very basic forms, with only 2 buttons on and basic commands.Any help appreciated! Thanks

View 5 Replies View Related

Update Table From Click On Form

Jun 9, 2006

I am trying to change all the entrys in a table that contain 0's to 1's when a user clicks a check box on a form. I am using the code below but it keeps erroring can anyone help?

Table is called tblChildren_Details and the Form is called frmBatch


Private Sub Check12_Click()

Dim rsttblChildren_Details As ADODB.Recordset
Dim conDatabase As ADODB.Connection
Dim strSQL As String

Set conDatabase = CurrentDb.Connection
strSQL = "Select * from tblChildren_Details where Batch = '" & 0 & "'"

Set rsttblChildren_Details = New Recordset
rsttblChildren_Details.Open strSQL, conDatabase, adOpenDynamic, adLockOptimistic

With rsttblChildren_Details
Do While Not .EOF
!Batch = 1
.Update
Loop
End With

rsttblChildren_Details.Close
conDatabase.Close
Set rsttblChildren_Details = Nothing
Set conDatabase = Nothing


End Sub


Thanks for any help

View 8 Replies View Related

General :: Multiple Form Click?

May 13, 2015

How do you enable to click multiple form that are set to pop up , modal and the border style is dialog ... ? the scenario is like this, my main form pops up and when i click a button that shows a different form , i won't be able to click back or do anything on my main form unless i close the new form that was loaded.

1. Main form is loaded
2. i clicked a button on my main form to load a new form
3. The new form is loaded, i can't click back or do anything on my main form unless this new form is closed.

my settins on my form are :
pop up - yes
modal - yes
border style - dialog

View 3 Replies View Related

Modules & VBA :: How To Close Pop Up Form When Click Somewhere Else

Aug 3, 2013

In the main form I have a list box, when I right click on each item on list box another form "frmshortcut" (pop up) will be open in the position of mouse that shows a list box for selecting items according to below code, now I would like when select another place (except "frmshortcut"), this form automatically will be close, like what we have in shortcut list of windows. Now when right click it is opened in the location of mouse click, but problem is, it is not closed automatically when click in other places of main form.

Option Explicit Private Type POINTAPI
x As Long y As Long End Type
Private Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long
Private mp As [*clsMousePosition]

[Code] ....

View 1 Replies View Related

Prevent Right Click On Top Of Form To Close

Feb 19, 2014

I thought I had my login form really locked down by turning off all the navigation buttons including the control box and close button. I also disabled the navigation pane and allow full menus. The login Menu automatically displays when the database is opened. After I created the .accde I was still able to right click in the top area (where the name of the form is) and close the form. Actually when I right clicked I got Save, Close All, Close, and Form View. Is there something else I need to turn off?

View 2 Replies View Related

Expression On Click Error Within A Form

Feb 9, 2015

Created a form that requires daily work flow info to be entered. Tested the form accepting random typos like "%, # ! etc... Worked just fine. In production received the following long error:"The expression On Click you entered as the event property setting produced the following error: Expression may not result in the name of macro, user defined function or event procedure".

View 1 Replies View Related

Run Button Continuous Form With One Click

Aug 9, 2014

I have a continuous form with button for every record, wich has a VBA code. I want to put Button in header form, when i click it, then should run all button in continuous form. How can I do that.

View 14 Replies View Related

How To Make Click A Button On Form

Feb 21, 2014

After data is entered into text box, on the "On Enter" event, how do I make it click a button on the form?Similar to the effect of when you enter your username then password, most people just hit enter on the keyboard to auto click the login button.

View 1 Replies View Related

Set A Form To Automatically Open On Click

Aug 30, 2013

When you click on your database icon to open up your database, is there a way I could set a form to automatically open ....

View 2 Replies View Related

On Click Change Form Background Color?

Apr 30, 2006

I searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?

View 8 Replies View Related

Double Click A Record To Open In A Form

Jul 11, 2006

I have a few search forms that, when search parameters are entered, a continuous subform displays the results (summarised...not all fields show).

I want to be able to double click a field in any given record, and have it open in a form allowing editing of the record.

I know I need something in the OnDoubleClick event of the text box I want to double click, which would then open the form, but I don't know what code to use.

For the sake of argument, I want to double click on the txtSerialNumber text box to do it, as this is a unique field.

Thanks.

View 7 Replies View Related

Open A Form On Double Click From A Subform

Aug 16, 2006

I all I have looked in the forum but can't find anything that matches I have a form containing a subform called eventswich shows some events in date order, as I have too many information on the table events I could not put them all in the subform if not only the essential information, what I need is if I double click on the field "DATE" it would open the "EVENT" form and show me all the information contained in the record.At the present time I have the filed SELECT RECORD set to NO on the form properties!
Hope I have given a good explanation!!!!
Thanks
Marco

View 9 Replies View Related







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