[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

I need help hiding a column in an Access datasheet

Posted on 2015-01-06
1
Medium Priority
?
240 Views
Last Modified: 2015-01-07
Hi Experts,
I use the code below to load an unlinked datasheet in my Access 2013 application.  I want to be able to hide the first column in the datasheet (the JobID.Column).  How can I do this?
Private Sub LoadJobVenues()
    Dim strSQL As String

    strSQL = "SELECT tblJob.JobID, tblJob.JobName, tblJob.JobtartDate,, tblJob.JobEndDate FROM tblJob WHERE (((tblJob.JobID)= " & intJobID & "));"
    
    Me.dataDisplaySubform.SourceObject = "Query.qryJobs"
    Me.dataDisplaySubform.Form.RecordSource = strSQL
    Me.dataDisplaySubform.Requery
    
    Me.dataDisplaySubform.Form.AllowEdits = False
    Me.dataDisplaySubform.Form.AllowAdditions = False
    Me.dataDisplaySubform.Form.AllowDeletions = False
End Sub

Open in new window


Thanks in advance,
mrotor
0
Comment
Question by:mainrotor
1 Comment
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 2000 total points
ID: 40535035
you need to try something like  

Me.FieldName.ColumnHidden = True


refer for more details

http://www.mrexcel.com/forum/microsoft-access/520734-hide-field-column-subform-datasheet-view.html
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question