I have a startup splash screen with a "OK" button, similar to Nortwind database. The OK button works as far as opening my switchboard page. But how do I get the Splash screen to close after I click the OK button? So I can see my switchboard page.
View RepliesQuick question.
I have a continuous form in Access 2003 listing products for return for a customers. I am in the process of creating a completion form which will just have the product number, model number and then a command button called complete.
What I'm doing is have it so when the person clicks the button it adds a value to a field saying Complete. OK. But, what I then want it to do is for any record thats associated with this customer where the field = complete to have the command button gray out.
Is this possible? I know I can conditional format a text box to do this but can't see a way to do it with a command button? Any ideas?
I have though of layering a transparent button and having a textbox behind this with complete in and having this change colour but not sure if thats the best way?
Every Page has its on data source based on query, and they aren't related to Parent form or to each other. I want to set few buttons on every Page which would filter records in predefined way.Ex: one page has calculated field named [Za platiti]. It has numeric values form 0 up. I want to set one button to filter only records where field [Za platiti] is greater then 0, and other butt to filter only records where [Za platiti] is = 0. Other filters based on combo box I use regularly.
View 6 Replies View RelatedI use a Frm1 which updates my Tbl1. By clicking on this Bt1 of the Frm1 the record is duplicated on purpose having enabled and disabled fields. While Frm1 shows the duplicated record (so it is open) I can change it and save it as needed. However the Frm1 loads having an enabled Cbo1 which normally allows the regular user to pick any value A,B,C or D.
What I would like to have is a line code under the Bt1 click event able to set the value "D" on the duplicated record only. I can not write it under the load form event because I need value "D" set on the combo only when I click the Bt1. Regular user still should be able to select between A,B,C or D when he loads the Frm1 to input a new record.
I tried Me.cbo1="D", also tried Me.cbo1.column(1)="D" under the Bt1 click event and both of them failed. What have I done wrong? How can I get it done?
I have a program that has a "GC" Button that I click on which takes me to a General Contractor Form. It works perfectly unless the Firm has an apostrophe in it's name. For example "D'Agostino". (refer to attached DAgostino1.jpg). When I click on the GC button, I get the attached Syntax error, (Syntax on DAgostiono.jpg).
The third attachment (GC Firm Button Code.jpg) shows the VBC for this button.
how to fix this error?
I am working on a web database with a form which is bound to an underlying web table where the submissions occur.My challenge is that the fields on the form get submitted to the table even before the submit button is clicked regardless of whether the form was completely filled.
My request is that I want the form to only submit to the submission table only when the submit button is clicked.When I searched on the net, the only solutions I got are VBA written code but my web database cannot use VBA code.
VBA code:
Option Compare Database
Option Explicit
Private blnGood As Boolean
Private Sub cmdSave_Click()
blnGood = True
Call DoCmd.RunCommand(acCmdSaveRecord)
blnGood = False
End Sub
[code]....
I have a form that is loaded through a hyperlink from another form. On this form I have placed a command button which closes the form (DoCmd.Close) I have also used the full syntax including form name and no save prompt. When i close this form using the command button I get a request for two paramter values that are used in queries in this form (I don't want this to happen) when I click the close button on the control box "X" this doesn't happen also it doesn't happen if I use file close. This problem only occurs on some of the slower machines in my workplace, any suggestions would be greatly appreciated. The is one combo box on the form in question which is set to run a macro after update, this macro requeries the 52 list boxes on the form.
View 4 Replies View RelatedI am building a database to track employees. I have a form to input the personal information and want to close this form and open a new form to input the employee's training information. I have a cmd button to open the Training form for the individual, however I can not make it close the employee input form.
Can someone help with this?
i am abit confused.. i have a save button on my form.. this is where field validation occurs and where the closeForm statement is (at the end). I need to keep the form's "X" button enabled.. how would i go about doing this exactly.. can i keep what i currently have (in the cmdSave_click event) and in the form_close event i can maybe have if me.dirty then... call my cmdSave_click event?.. Else.. closeform. Is this the right way to go about it??.. if so.. will my formClose statement (in my cmdSave_click event) be alright?
Thanks in advance!
I have a form which I want to disable the close button. On the properties of the form I set Close Button option to 'NO'. When I open the form the form close button is disable, but as soon as I maximse this screen, the close button becomes enabled again. Any Ideas as to why this is happening and how I can disable this button comlpetely on this form?
View 2 Replies View RelatedI am tying to create a cmd btn called "Report" that when clicked opens a form [quick report] in dialog window. I have that done easy enough. But what I want is if that form [quick report] is open, and you click the same button "Report" for it to then close the form.
View 3 Replies View RelatedHi,
Anyone know in microsoft access 97 is it possible to remove the close button (top right hand corner) when a form is maximised?
Thanks.
I have to write a code in a form so that if nobody is doing any activity for 5 minutes then after 5 minutes automatically press Close button named BtnClose in that form.
View 5 Replies View RelatedI am at my Login Screen, I want it to return to the Login Screen if you select "NO" and Close the DB if "YES"
Here is my current code:
Private Sub Form_Close()
If MsgBox("Would you like to EXIT the Database?", vbYesNo, "Quiting Database") = vbYes Then
Application.Quit
Else
???
End If
End Sub
Can I make a button, say "command01" deactive by clicking it.
i.e.
OnClick of command01 => command01.enabled=false
is this possible?
Question:
I have a make-table query which is runned when clicking on a button in a form.
Of course after clicking the button the following notifications appear:
1) You are about to run a make-table query that will modify the data in your table (yes, no help)
2) (if the table exists) The Existing Table <<tablename>> will be delted before you run the query (yes, no)
3) your are about to paste 1 row(s) into a new table (yes, no)
How can i make it possible that on forehand all three questions are "yes", so that the user does not see these questions, but the table is filled with the relevant information and can be used?
Thanks in advance for your answers/reactions/help
I am new with ms Access. I am using 2013 version and stuck with "pretty" easy task.
When I create the form, the values are inserted/updated constatly as I leave the input components. However I would like to insert/update the record only when I click the button. How to do that?
Is there a way to create a new record by clicking a command button but to show the same text boxes shown in the attachment in the next record.
View 1 Replies View Relatedhey all, I am trying to load a print wizard after clicking on a command button. I am trying to use my filtered data to select specific fields to print. On the fly kind of report. I need to have the ability to use my filtered data to create a specific report. Any ideas?? Thanks
View 7 Replies View RelatedI have the below VBA in a from for it to filter the records below based on the criteria:
Private Sub Search_Click()
Dim strWhere As String
strWhere = IIf(Len(Me.AssignedTo & "") <> 0, "([AssignedTo] Like ""*" & Me.AssignedTo & "*"") AND", "") & _
IIf(Len(Me.OpenedBy & "") <> 0, "([OpenedBy] Like ""*" & Me.OpenedBy & "*"") AND", "") & _
IIf(Len(Me.Status & "") <> 0, "([Status] Like ""*" & Me.Status & "*"") AND", "") & _
[Code] ....
When I click the search button nothing happens, is there something wrong with my code??
i have close button on my form made thru the command button. But it does not show an error message when the form closes if information has not been entered in the reqired fields. it does not save the field though. how can i get the error messages to be shown before the form closes asking the suer to enter the missing data. thanks
View 2 Replies View RelatedI have created a Media Contact Database and have a few issues that I believe are probably related to something I have done wrong. I am kind of a novice and I can't see my error and was hoping some one could look at my DB and see where I have gone wrong
1. on Company info form have added a dropdown box to select media type and it fills in on table a number instead of the actual word Eg. "Radio"
2.on contacts form when I save a new record it says "Microsoft jet database engine cannot find a record in the table 'media types' with key matching fields 'mediatype ID'
3.Also on contacts table when I select from dropdown box "Company Name" it works but if I try to change again it errors and won't let me change unless I close form and go back into record.
4. I am trying to create a report on company info with contacts related to this company as there can be many contacts to one company. but when i create a query including both table I only get company info if there is a contact associated with it. Sometimes there will be no contacts associated with company.
I will attach database so you can look at. I have worked many hours on this and it seems when I get one thing working another goes wrong. I know it seems a lot but I think its small issues that I just can't see. Any help would mean the world.
Thanks Rickilynn (ricki.kleinfelder@gov.ab.ca)
The database that I currently work with has the option chosen to compact and repair on close so that if I am not present when there is trouble the users can close the db and the problem is usually corrected. I currently have a close button on the Main switchboard that closes the db. Is there a way to make a button or another way that will close the db that will by pass the compact and repair choice? I know that I can use task manager, but that usually creates db1, db2 and so on.
Thanks,
Hello,
Is there a way I can disable the access close button, located at the top right of the screen?
Thanks.
I use a close button to close a form. There is list box in this Form. If the list box is empty, then simly close the form. However, if there are projects in the list box, I want to give a warning. If the user say YES, then everything in the listbox will be deleted and the form will be closed. If user say NO, tehn the form will not be closed. They then can use anotehr button to save teh projects.
I wrote the follwing code. The delete portion itself works. But it seesm comfused with msgbox. Could you pelase help me correct this code? Thank you very much for your help.
lbDestination -- list box name
Private Sub Close_Click()
On Error GoTo Err_Close_Click
If IsNull(Me.lbDestination) Then
DoCmd.Close
Exit Sub
End If
If MsgBox("You have unsaved initiatives. Are you sure you want to close?", vbQuestion + vbYesNo + vbDefaultButton2, _
"Delete?") = vbYes Then
Dim rsDestination As DAO.Recordset
Set rsDestination = CurrentDb.OpenRecordset("tbInit", dbOpenDynaset)
rsDestination.MoveFirst
Do While Not rsDestination.EOF
rsDestination.Edit
rsDestination.Delete
rsDestination.MoveNext
Loop
Me.lbDestination.Requery
End If
Exit_Close_Click:
Exit Sub
Err_Close_Click:
Resume Exit_Close_Click
End Sub
Hi Guys,
I have a database that uses a switchboard with a close button that runs several instructions before it exits. The problem is that some users have access to the database window and I need to prevent them from closing the database by hitting the X in the upper right.
Anyone know how to do this?