Click here to Skip to main content
15,891,423 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionVB.Net - Print Queue Pin
directred31-Oct-10 6:41
directred31-Oct-10 6:41 
AnswerRe: VB.Net - Print Queue Pin
Ray Cassick31-Oct-10 7:04
Ray Cassick31-Oct-10 7:04 
GeneralRe: VB.Net - Print Queue Pin
directred31-Oct-10 9:31
directred31-Oct-10 9:31 
GeneralRe: VB.Net - Print Queue Pin
Ray Cassick2-Nov-10 14:42
Ray Cassick2-Nov-10 14:42 
QuestionAdding a password to a file. Pin
crain198130-Oct-10 14:50
crain198130-Oct-10 14:50 
AnswerRe: Adding a password to a file. Pin
DaveAuld30-Oct-10 15:42
professionalDaveAuld30-Oct-10 15:42 
AnswerRe: Adding a password to a file. Pin
Dave Kreskowiak30-Oct-10 16:30
mveDave Kreskowiak30-Oct-10 16:30 
QuestionMS Access 2k7 VBA problem, property will not change Pin
BREdwards29-Oct-10 5:12
BREdwards29-Oct-10 5:12 
I have a user for whom a VBA application in MS Access ceased to work properly after upgrading to office 2k7. I stepped through the VB code and this is what I am seeing in the Form_Current sub:

Consider the following If Statement:

If Nz(Me!PID) = 0 Then
    Me.Attachments.Form.RecordSource = "Select attach from attachments where pid = " & Me!IssID & " AND [ISSUE_ONLY]=1;"
    Text114.Visible = False
    Label119.Visible = False
    Text128.Visible = False
    Label129.Visible = False
Else
    Me.Attachments.Form.RecordSource = "Select attach from attachments where pid = " & Me!PID & " AND [ISSUE_ONLY]=0;"
    Text114.Visible = True
    Label119.Visible = True
    Text128.Visible = True
    Label129.Visible = True
End If
Me.Attachments.Form.Requery
Me.Attachments.Form.AllowDeletions = False


The Me.Attachments.Form.RecordSource property, normally should change after being explicity set like that, but on this user's machine, it isn't. The propery is remaining "attachments" returning the entire table instead of what is specified in the query. This only seems to be happening for this user so far so I don't think it is a code issue. The .mdb file itself is not read-only and is up to date as far as I can tell. The Trust center settings also appear to be correct as well, allowing macros to be run. No errors are thrown when the code attempts to change the recordsource property, only that nothing happens and the property remains unchanged.

Any ideas?
AnswerRe: MS Access 2k7 VBA problem, property will not change Pin
ChandraRam30-Oct-10 7:32
ChandraRam30-Oct-10 7:32 
GeneralRe: MS Access 2k7 VBA problem, property will not change Pin
BREdwards30-Oct-10 8:45
BREdwards30-Oct-10 8:45 
QuestionCrystal Report Formula Pin
Nikhil Bhivgade28-Oct-10 23:38
professionalNikhil Bhivgade28-Oct-10 23:38 
AnswerRe: Crystal Report Formula Repost Pin
Richard MacCutchan29-Oct-10 1:40
mveRichard MacCutchan29-Oct-10 1:40 
AnswerRe: Crystal Report Formula Pin
ChandraRam29-Oct-10 2:31
ChandraRam29-Oct-10 2:31 
GeneralRe: Crystal Report Formula Pin
Nikhil Bhivgade29-Oct-10 23:07
professionalNikhil Bhivgade29-Oct-10 23:07 
GeneralRe: Crystal Report Formula Pin
ChandraRam30-Oct-10 7:25
ChandraRam30-Oct-10 7:25 
GeneralRe: Crystal Report Formula Pin
bigbadben17-Nov-10 23:38
bigbadben17-Nov-10 23:38 
Questionhow to use cookies in visual basic Pin
srianraja28-Oct-10 21:03
srianraja28-Oct-10 21:03 
AnswerRe: how to use cookies in visual basic Pin
thatraja28-Oct-10 22:43
professionalthatraja28-Oct-10 22:43 
AnswerRe: how to use cookies in visual basic Pin
Rajesh Anuhya28-Oct-10 23:19
professionalRajesh Anuhya28-Oct-10 23:19 
AnswerRe: how to use cookies in visual basic Pin
Dave Kreskowiak29-Oct-10 3:20
mveDave Kreskowiak29-Oct-10 3:20 
AnswerRe: how to use cookies in visual basic Pin
bigbadben17-Nov-10 23:52
bigbadben17-Nov-10 23:52 
QuestionobjReader.peek() concept Pin
swathi658928-Oct-10 20:37
swathi658928-Oct-10 20:37 
AnswerRe: objReader.peek() concept Pin
riced28-Oct-10 23:45
riced28-Oct-10 23:45 
GeneralRe: objReader.peek() concept Pin
swathi658929-Oct-10 2:38
swathi658929-Oct-10 2:38 
AnswerRe: objReader.peek() concept Pin
Luc Pattyn29-Oct-10 2:46
sitebuilderLuc Pattyn29-Oct-10 2:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.