General :: Stop Tab Control With VBA
Jan 17, 2014
I'm trying to stop a couple fields from being able to tab to based on other field value in a form. I have the following code but this didnt work.
Code:
Private Sub Step42_GotFocus()
If Me.Step42.Locked = True Then
Me.step43.SetFocus
End If
End Sub
I then tried this. but it still allowed the tab stops. How can I stop it?
Code:
Me.Step42.Locked = True
Me.dat18.Locked = True
Me.dat19.Locked = True
Me.dat20.Locked = True
Me.Step42.TabStop = False
Me.dat18.TabStop = False
Me.dat19.TabStop = False
Me.dat20.TabStop = False
View Replies
ADVERTISEMENT
Dec 3, 2012
I have one Form & Table. I am making customer list, But i dont want a duplicate name, so how i control or stop duplicate name when i do entry.
View 1 Replies
View Related
Mar 25, 2013
On my form my Tab stops at a "New Record" button. After the "Enter key" can I make the cursor go to the first field in the form?
View 7 Replies
View Related
Apr 11, 2013
The charity that I work at has many volunteers.
When they enter data they use the tab key for movement to each field.
Can I have the Tab Key STOP on the current record and not proceed to a new record?
View 2 Replies
View Related
Jul 3, 2013
I have an excel file, and am trying to import it, and once when I have imported it, am checking for a condition with While Not rs.EOF, it works fine for the purpose of looping, but it does not stop when the records are over., it is additionaly printing 19 null statements, where I beleive it, should not be.
View 9 Replies
View Related
Feb 28, 2014
I have included some code to disable the access PassKey (holding shift down as you open the database so that the database window appears). It is password protected and it works pretty well for normal users.
However, I have realised that even in this restricted mode you can go to File-Options-Current database and enable Access Keys. This then lets you open the database window by pressing F12.
My question is, is there a way to absolutely stop anyone from ever viewing the database window at all? All my code is password protected, but I still don't want an ICT person fiddling with my tables and queries!
View 4 Replies
View Related
Mar 7, 2015
Is it possible to stop anyone from going into design view ( even right clicking the mouse ) .
View 3 Replies
View Related
Feb 14, 2013
I have an Access 2010 db on a shared network drive. All users accessing the db are running Windows 7 OS and have a licensed corporate version of Access 2010. The advanced options "Shared", "Edited record" and "Open dabases by using record-level locking" are turned on. Additionally, the locking time limits are set to their default levels. If a user selects the save icon after making additions or updates, the following waring message appears:
Costar Job Database can't save design changes or save to a new database object because another user has the file open. To save you design changes or to save to a new object, you must have exclusive access to the file.Since I developed the db, I am the only one that makes design or object changes. I know that users don't need to select the save icon to update the db, but I don't want them to "freak out" if they select save and see the message.
Is there any way to prevent the message from being displayed?
View 6 Replies
View Related
Sep 5, 2012
I am using SendObject to send Outlook email messages from my application. On my development system, I get two Outlook warning messages each time I send an email. A user tested this on the live system today and said they got no Outlook warning messages.
Is this something that I can set? To not give Outlook warning messages?
View 1 Replies
View Related
Oct 14, 2013
I have a database that is saved as an accdr so it can be compiled for distribution as an exe..I have just found the accdr the exe installed and renamed to accrb and was then able to open it and view all the tables, forms etc.Obviously I cant stop someone renaming but if there was a way to stop the forms, tables etc opening.
View 8 Replies
View Related
Mar 6, 2014
I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.
I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.
View 2 Replies
View Related
Feb 24, 2013
I have a form with a 'tab control' on it
Tabs 2-9 have a subform on them
Each form/subform writes to a seperate table
The form is the main table
When a record is created with by the form an autonumber Id is generated
I want to pass this ID to each of the subforms so that the tables can all link
Form-1 Table-1 AutonumberID
Subform-1 Table-2 AutonumberID from table-1 (can be new field in table)
Subform-2 Table-3 AutonumberID from table-1 (can be new field in table)
For all subforms and tables
View 2 Replies
View Related
Jan 21, 2013
I have a form for testing purposes only it is named "Navigation Form". It has a tab called WorkingInitial. Within WorkingInitial I have a form called QueryTester. With a list box called List0.
Basically I want to click on the tab and the query to automaically filter based on the criteria I create. I dont want to have to create a bunch of forms with each seperte query. I want VBA to modify the Query.
This is what i have an I have no clue why it doesnt work or what I am missing.
Code:
Private Sub WorkingInitial_Click()
Dim strSQL As String
List0 = strSQL
strSQL = "SELECT * FROM [Table1 Query].[My.StatusInitial] WHERE StatusInitial = 'Working';"
End Sub
View 5 Replies
View Related
Feb 5, 2014
I I have a SpouseID field in my Contacts table to link spouses.When a spouse is selected in one contact's record, I want to be able to automatically update the other contact's SpouseID control.I have created a calculated control called txtSpouseID that uses DLookup to find the ContactID for the other spouse:
=Nz(DLookUp("[ContactID]","tblContacts","[Spouse] =" & [ContactID]))
And I have entered this code into the form's OnCurrent event:
Code:
If Not IsNull(Me.txtSpouseID) Then
Me.Spouse = Me.txtSpouseID
End If
However, this obviously only works if the user navigates to the spouses record. If s/he doesn't then the value does not get entered into the table.
View 2 Replies
View Related
Sep 26, 2014
I have a 2 unbound text boxes.1 populates the id number from a table.I want the other to display the first name where this id occurs. I am currently putting this in the control source of the seconded textbox
This is what I have
=dlookup("[FirstName]","[tblUser]","[ID]='[Textbox1]")
View 1 Replies
View Related
Apr 15, 2014
Code:
Private Sub CommandButton3_Click()
Dim rngCell As Range
Dim i As Long
Application.ScreenUpdating = False
'Coverage code
i = Range("J" & Rows.Count).End(xlUp).Row
[Code] ....
Why doesn't access like the underlined (For control variable already in use).
View 3 Replies
View Related
Oct 23, 2012
I have completed the split and have deployed the backend to SharePoint. The front end is sat on my (and others) machines with linked tables to the SharePoint lists. This is all fine and works well.
Although this database is deployed, I am constantly working on a local copy of the database in design I.e. Tables being updated with fields and relationships and new tables being added. The reason for this is that work wanted something workable putting out there now and that I just continue its development in the background.
What is the best way to update the tables on SharePoint bearing in mind that users are putting new data on there? I don't want to lose what they are updating and then I need to redploy the 'new' backend to SharePoint again (no doubt in the same location) as that's where the front end is looking for it.how I can manage this version control of the backend without losing data.
View 3 Replies
View Related
Jan 5, 2013
I have a combobox containing the "Field Names" of a table called "Main" Also, I have a report called xyz which only has one field.
All I want, whatever field name user selects in the combo, report displays the results of selected field name only.
example
Main Table has three fields (Fie1, Fie2 and Fie3) The combo box lists the names of all three fields (Fie1 to Fie3) Report has a textbox in the detailed section.
I want user to select the field name from combo click button to generate the report (lets say if user selected Fie2) and want textbox to list all the records of Fie2
i tried [Forms]![Fm1]! [cm1] but it is listing the field names not the values in the field...
View 1 Replies
View Related
Oct 10, 2012
I would like to be able to put an if expression in the default control of a tx box.
I would like to say
if txtA = 0 then [Forms]![frmNewAppointment]![OrderTime] else [Forms]![frmAppointmentTreatmentItems]![TextA]+[Forms]![frmNewAppointment]![OrderTime]
Is it possible and am i close to doing it mysel?
View 3 Replies
View Related
Apr 1, 2014
So I ave a tab Control with 5 tabs. When I hover or move across each tab name it auto opens that page, so I don't have to click to open. How do I get the VBA for this?
View 1 Replies
View Related
Jul 24, 2014
So I have a Tab control. Each tab is assigned to a specific user (which is controlled through another form). So If I assigned Page1 to Smith then Page1 caption reads Smith. Within each page is a list box that is filtered based on what name is in the caption. This works perfectly. My problem is I have another list box that is not within the tab control. I wan this to be filtered based on what tab is active. Both list boxes are bound to a query.
View 4 Replies
View Related
Aug 2, 2012
I have a tab control with 11 pages (departments). Each page have 3 subforms (country, channel, product). Each page can have multiple countries, channels and products.
Example:
Marketing: Country A, Country B and Country C
Country A: Channel A and Channel B
Channel A: Product A, Product B and Product C
So a combination can be:
Marketing in Country A in Channel A with Product A.
I enter several informations (sales, dates, comments etc) on each subform. The subforms are linked (master/child). I store the different primary keys in hidden textboxes.
When I navigate between the pages, the selection resets due to a necessary requery. How can I keep the selection?
View 2 Replies
View Related
Aug 3, 2012
My question is in Access 2010 I am currently in the property sheet at a combo list i just added to a form to be more precise with the data the user will look for. My question is I know I have to be in Control source in order for the combo box to select the data that I entered from the table. When i click the arrow the drop list is empty and then when I click the elipses (three dots) it takes me into expression builder, so i am confused on what I should do to select the field I want the combo box to focus on.
View 2 Replies
View Related
Sep 10, 2013
I have a CheckBox and a Field Date.
The latter has two conditions: If it is >=now() to be the font is RED and if <=Now() that the font is GREEN
Now, what I need is that pressing the CheckBox, ignore both conditions and that the font color is set GRAY
View 3 Replies
View Related
Apr 6, 2013
Is it possible in access 2010 to create a table "Kits" with 4 columns: kit, lot, expire_date, in_use.
Then in a form use that table as a control source for dropdown box? However, if in the table in_use is "No" then that row is not a choice?
View 3 Replies
View Related
Oct 10, 2012
i have a list box with 6 columns. in column 6 there is a time field. on selecting this list box i want to set the value of a combo box to the time field.
so in the control source i put
[Forms]![frmAppointmentTreatmentItems]![comboTreatmentDuration]![Column](5)
This has no effect. I am not sure if i have done this correctly. but the combo box has manual values in it. the reason i want to have values in it is so if the treatment is 45 minutes at default. But i want to change it to 30 minutes just for a single occasion then i thought that this would be the way to do it.
View 11 Replies
View Related