Click here to Skip to main content
15,914,165 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: search between two dates Pin
waner michaud4-Nov-10 7:37
waner michaud4-Nov-10 7:37 
GeneralRe: search between two dates Pin
Luc Pattyn4-Nov-10 8:04
sitebuilderLuc Pattyn4-Nov-10 8:04 
QuestionA stranger question about Selectsinglenode method Pin
sanyexian2-Nov-10 23:42
sanyexian2-Nov-10 23:42 
QuestionZipping files Pin
crain19812-Nov-10 6:11
crain19812-Nov-10 6:11 
AnswerRe: Zipping files Pin
Dr.Walt Fair, PE2-Nov-10 7:24
professionalDr.Walt Fair, PE2-Nov-10 7:24 
AnswerRe: Zipping files Pin
Eddy Vluggen2-Nov-10 9:26
professionalEddy Vluggen2-Nov-10 9:26 
AnswerRe: Zipping files Pin
AspDotNetDev2-Nov-10 15:11
protectorAspDotNetDev2-Nov-10 15:11 
AnswerRe: Zipping files Pin
DaveAuld3-Nov-10 3:13
professionalDaveAuld3-Nov-10 3:13 
AnswerRe: Zipping files - Use SharpZip Pin
98z2811-Nov-10 7:04
98z2811-Nov-10 7:04 
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 

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.