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

Control Or Stop Duplicate Name Entry?

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

General :: Tab Stop To New Record?

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

General :: Tab Key Stop And Not To Open New Record

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

General :: VBA Access Code EOF Does Not Stop / When Records Are Over

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

General :: How To Stop Users From Ever Seeing Database Window

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

General :: Stop User To Go Into Design View

Mar 7, 2015

Is it possible to stop anyone from going into design view ( even right clicking the mouse ) .

View 3 Replies View Related

General :: Stop Access Warning Message

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

General :: SendObject Outlook - How To Stop Getting Warning Messages

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

General :: Stop User Renaming ACCDR To ACCDB

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

General :: Using MS Access To Control SAP?

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

General :: Tab Control - Same ID Forms And Subforms

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

General :: Navigation Control With Query?

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

General :: Set Value Of A Form Control In A Different Record

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

General :: DLookup In Control Source

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

General :: For Control Variable Already In Use Error

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

General :: Backend Version Control?

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

General :: Control Source Via Combo?

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

General :: If Expression In Default Control Of Text Box

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

General :: Tab Control Auto Opens When Hovering?

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

General :: Filtering Listbox Based On Tab Control

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

General :: Tab Control Goto Subform Record

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

General :: Control Source In Property Sheet

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

General :: CheckBox To Change Color Of A Control

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

General :: Using Table As Control Source For Dropdown Box?

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

General :: Control Source - Set Value Of A Combo Box To Time Field

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







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