My main form has 2 “Continuous Forms” sub forms.
The cycle of the sub forms is set to “All Records”
Is there a way to exit the first sub form and move the focus to the second sub form utilizing only the keyboard? (Like shift + tab, or any custom buttons)
I’m trying to avoid using the mouse
Thank you
I have a form with 4 tab pages. on the 2 tab page I have a subform that adds records to a table via 2 combo boxes.
I have been able to stop user from leaving a combo control blank or skipping to the next combo control, but if user clicks the Exit command button on the main form, from the 2nd combo control, it prompts that value has to be selected but the gives error:
"You cannot add or change record because a related record is required"
How can I stop this so form will close and undo the 1st combo selection and not give error?
Obviously doing something stupid here :-)
I use a form for data entry. When I hit the next arrow in the navigation button section (the default navigation buttons supplied by access), by data is saved into the relevant table.
When the I press the X on the form my data is also saved. However I'm not given the opportunity to say if I want to quit the form or save the data.
What do I need to set to get this functionality?
Thanks
Hi all, I have a textbox with an input mask for an id number, so if I begin adding numbers I get an error message if they're not in correct format- this is fine- but I want the user to be able to cancel the entry and exit the form, but when I click the cancel button I get an error message about the id format- anyone know how I can allow cancel to override this?
thanx
HI
How can exit from an "DataEntry=True" and "AllowAdditions=True" Form without add a new record to the table ??
Any help please!!!!!
Thanks
Ps: i only can do that if i press 'esc' in the 'textbox', but that doesn't suits me. the form only have a 'textbox' and a 'commandbutton'
I am developing an Access 2003 database for our shipping dept.
I have linked tables from a Sql Server 2000 Database that MakeTable queries were used to make tables then changed to Update Queries for the data.
The shipper opens a form (Call it Dock 1, Dock 2 , etc.) to scan a barcode or manually key the Batch Code in a ComboBox that is a lookup. "Enter" moves the cursor to create the next Record with the balance of the data pulled into the next 6 or 7 fields through VB Code. This data is written to a table for verification of each shipment.
My problem is that if the form is closed or the user exits Access, this form is empty when reopened but the table is intact. I need to be able to assure the form is not cleared on exit unless by request.
I have tried
"Private Sub Form_Open(Cancel As Integer)"
"docmd.gotorecord ,, aclast "
"End Sub"
in the Form, (Without the Quotes) nothing happened not data was returned but, the data was in the Table
I need all entries to be retained not just the last record
I am not a programmer but i have experience with VB6 and Access 2.0, 3.0, 97, 2002, & 2003. Any help will be appreciated and I offer my thanks in advance to all responders
Hi could someone point me in the right direction for this one,
I have a series of linked tabbed Forms. One of the Forms is mostly populated by Combo boxes which all work fine. My problem occurs when you go to add a new record and populate the form with the combo boxes but decide for some reason not to save the record but exit the form using the Close form command button or by using the close button at the top of the Form. Access seems to Save the record anyway. I have placed an Undo Cmd on the form to clear all text boxes which works fine but it does not stop a user from closing or exiting a Form by another means and stop them saving that incomplete record.
I would be grateful for any thoughts on how to solve this problem.
Thanks in advance
i want that when i press the space key on my keyboard oi will exit from the form. i searched on the interne t but i couldn't find the proper one. I don't know exactly what i have to write in vba.
View 2 Replies View RelatedI have a form and I do not want the mouse wheel to move through the records - it is a single form view and I do not want the use to use the wheel as it corrupts my calculations.
Is there any way to allow input of numbers input without the wheeldoing anything
I am sure that I am just missing something.
Thanks very miuch in anticipation
I have a parts order form (FrmORDER)with a list of parts selected stored in it. e.g Part #, Part Description, Qty, Price etc
I also have assemblies stored with the same detail that are composed of individual parts.
What I would like to do is
Open formA if I do a single click (to select a new part or assembly)
Open formB if I do a double click (to open the contents of the selected assembly in the order form
It would seem that the following series of events occurs
When the user double-clicks a control other than a command button: MouseDown → MouseUp → Click → DblClick → MouseUp
Hence I can't actually open formB with a double click unless I remove the single click event.
How can i deactivate mouse second button click on form?
Can anyone help me pleae? :)
Hi all,
Have any of you know a way (maybe in VBA modules) to deactive the use of MOUSE WHEEL while using on the MS Access form since I am creating a form for users to enter hundreds of project data into a project table.
I put certain contrainsts (force the users to enter data on several fields on the form and NOT to leave them blank).
However, the users can use the MOUSE WHEEL while on form to move to the next project WITHOUT entering those required fields?!!
By the way, each project is stored in separate record in its table. The form is a SINGLE FORM, not Continuous form.
Please help. I am looking forward to your reply.
Thanks so much,
I have a form that opens to a NEW record, all fine and grand. there are a few drop down choices, and modern users are using the scroll button to try to move up and down the list in the drop down boxes, but this action actually tries to move to the next record, causing an error as fields are blank etc (which is fine) but its confusing everyone.
the nav buttons are not shown on the form, so what can we do to stop the form trying to goto another new record?
the form is opened using a macro, where the action is OpenForm (view=form, data mode=Add and window mode=Normal) GoToRecord (record=new).....
Is there a way to prevent a user from switching records on a single page form when he rolls his/her mouse wheel. I have noticed that users accidentally scroll the wheel, and this switches them to the next record.
I need for them to remain at the current record they have chosen, or at the new record they are working on.
How to open a search form with a mouse click on Button_Search
My idea is to pop up a form where user can enter the search text and select the required name and get back to the old form with all details about the entry. This form alone is workign fine. I want to call it in a mouse click. and pass the data back to old form.
I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedI would like to update a txtbox with a simple int count of the number of times a mouse is left-clicked while on an active form. How do I do this?
View 5 Replies View RelatedDoes anyone know the code to exit from THE whole ACCESS program.
That is when I click the close button on the switchoboard, I want the system to close the whole of access program.
If my user uses the MS Access 'X' button (upper right hand of screen) to Exit the application does anyone know what methods are triggered that may let me perform some task before the application actually ends?
Thanks
I've created a new database using the standard Switchboard function. However, when I use the Exit Application command the database closes but MS Access stays open. It's a minor problem but infuriating, especially as I've never encountered this problem before and everything I try won't fix it. Any ideas?
View 5 Replies View RelatedI'm having an application which is developed in access. It's running quite well, some times when I made changes to forms or reports it hangs for a while and exits without saving, it happens sometimes not always... what could be the problem? how can I rectify this..
View 3 Replies View RelatedHiya,
I have a database which on exit runs calls the following module and backs up the database to anther folder
Public Function BackupCopy()
'This function will allow you to copy a db that is open,
'You must set a reference to the 'Microsoft Scripting Runtime' for the CopyFile piece to work!
Dim fso As FileSystemObject
Dim sSourcePath As String
Dim sSourceFile As String
Dim sBackupPath As String
Dim sBackupFile As String
sSourcePath = "C:Database"
sSourceFile = "MyDB.mdb"
sBackupPath = "C:DatabaseBackups"
sBackupFile = "BackupDB_" & Format(Date, "mmddyyyy") & "_" & Format(Time, "hhmmss") & ".mdb"
Set fso = New FileSystemObject
fso.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True
Set fso = Nothing
Beep
MsgBox "Backup was successful and saved @ " & Chr(13) & Chr(13) & sBackupPath & Chr(13) & Chr(13) & "The backup file name is " & Chr(13) & Chr(13) & sBackupFile, vbInformation, "Backup Completed"
End Function
but after backing up correctly it brings me the following error
"Run-time errror '424':
Object required
any ideas what might be going wrong
Cheers
Hi all,
How would i close access via vba after a function runs?
I know how to close a form, but id like to close the entire thing.
Thanks in advance
I have a form that automatically is shown when a user enters the database. I want to disable all exits of this form so that the user cannot exit the form before he/she exits the whole database. How do I do this?
View 2 Replies View RelatedWhat are the pro's and con's and setting the database to compress on Exit?
View 5 Replies View RelatedI have a form that has a command button on it. When the user clicks the command button I want the form that was up to be exited. I cannot find the correct syntax for this. Please help.
View 5 Replies View Related