I have a copy of the .mdb file on my own machine along with office 2k7, approximating the same environment and I have determined that the property will change as it should after stepping it. Truly bizzare.

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?

At the urging of my employer, I have begun shopping for certifications. I know I shouldn't need to be pushed to look for a certification, but its also good to be nudged out of complacency. I want something that is relevant to what I do, as well as something that helps me grow. I do primarily VB.NET 2005 development and support as well as some VB6, ASP, SQL and Javascript. Right now I've spied two certification possibilities that might work: Microsoft Certified Professional Developer Microsoft Certified Technology Specialist I am pretty sure I am missing out on something that might work better, but other things I've found focus on technologies and such that I don't use or most likely won't use. So, what do you think I should be looking at in terms of certifications?

Hello, I am in the process of trying to fix this bug that has cropped up in some code I am maintaining. The issue is this: The application runs through some data from an excel spreadsheet and when it is finished, it formats and saves the spreadsheet before closing it out. This works, but heres the thing, when a spreadsheet is run through the app the first time, the columns are formatted correctly as Currency, but when the same spreadsheet is run again, the columns formatted as Currency are now formatted as Accounting for some reason even though the lines of code doing the formatting clearly state Currency like this: objExcelSheet.Columns(eSheetLocations.AMT).Style = "Currency" This is proving to be one heck of a noodle scratcher, as I have no clue why it is doing this. I had originally considered a workaround by trying to get the current style by having a variable set to it, but the variable returns Nothing when I step through. The reason I need this to stay Currency is because zero-dollar amounts need to be seen as "$0.00" and not "-" as this confuses the end users. Any help and advice is welcome, thanks in advance.

Hello, I'm in the process of converting an application from VB6 to VB.NET. So far things have been going very smoothly, however I've come across an error I'm not sure how to get around. It happens on a line with a function that takes an object as its argument and returns a short. Basically what's supposed to happen is that if the result is not -1 then the app is supposed to close out due to it timing out if a button isn't clicked in time. So far, after stepping through, the aforementioned function seems to run without error, but when the app tries to compare the result against a constant (-1), then the error occurs. The error is this: Error Code 61837 Error Source is something I'm not sure how to duplicate with a keyboard, looks like 8 to the first power and a capital A with a tilde over it. Error message is "Unable to write read-only property" Here's the line in question: If util_Pause(myObject.Property, 200) <> CONST_MINUSONE Then Thanks in advance [EDIT] Okay, I fixed the issue, though any advice for the future would be welcome. I just set an object variable equal to what I was originally throwing into the function and just threw that in as the argument. That fixed the issue.

modified on Friday, March 20, 2009 8:57 AM

Okay, thanks, I managed to find the SDK for the printer and I see how it works. It seems like I only need what I need to print, then run it through the proper subroutines on its way to the printer.

Recently I've been tasked with needing to add the ability to and existing VB6 application print to a certain type of printer: http://global.dymo.com/enUS/Products/LabelWriter\_400\_Turbo.html Now, I am aware that I would need the specific driver for this printer, but however I am curious if this particular printer requires anything different for me to actually add it's functionality to the application I'm supporting. This isn't time critical, so no one is in a hurry. So I'm posting this as I'm looking stuff up to help answer my question. Thanks in advance.

Today I began work for a small, yet rapidly growing company, and my first task before the equipment I need to do any of programming duties gets here is to clear up a bunch of things for both my employer and myself to ensure that we do everything we need and want to do for now and in the future. Forgive me if what I am asking is all over the place, but I have to start somewhere. Question 1: While we do plan to migrate to the .NET platform in the future, I am going to be working on a bunch of legacy software coded in VB6 and C++. So essentially what I'm asking is, would I need an older version of Visual Studio to work on these apps, or can I use the newest Visual Studio to work on these. Does this sort of backward compatibility exist? Question 2: I have no experience programming for the PALM OS, so essentially, what would I need to do to get started on learning how to code for the PALM OS? What sort of tools and resources would I need? Question 3: Eventually, I will also be coding for Windows Mobile, can I also use the latest Visual Studio to code for that? Or would I need some other tool or plug-in or package to code for it? Question 4: While I am sure I'll be able to find this on the Microsoft website, how is it possible for my new employer to become Microsoft Development partners? Thanks in advance, if you need anything cleared up, don't hesitate to ask, as it will help me as well.

Marvelous! I was planning to use an array, but this works as well. Thank you, I'll be sure to save this so I can study later. However, when compiled, it delivers an error saying: "The Modifier 'static' is not valid for this term." After a bit of research, I found that my version of VS is too old to have static as a modifier for the class, as I am using 2003 still. Anyhoo, thanks for eveything.

Thanks so far. The string reversal part is all taken care of, my problem is having to dynamically replace all number with their word equivalents, here's what I have so far: public string Reverse(string x) { int i; char[] charArray = new char[x.Length]; int len = x.Length - 1; for ( i = 0; i <= len; i++) if(char.IsNumber(x,i)) { switch(i) { case'0': x.Replace("0","zero"); break; } } charArray[i] = x[len-i]; return new string(charArray); } I have something of an idea of what needs to be done, problem is, I can't seem to use that if statement without breaking the program. I keep getting an "index was outside the bounds of the array error" for both letters and numbers. I simply don't understand what I'm doing wrong, never had to do something like this before.

Lookup? As in a select case statement? so far after taking your advice I have the following: public string Reverse(string x) { char[] charArray = new char[x.Length]; int len = x.Length - 1; for (int i = 0; i <= len; i++) if(char.IsNumber()) { } charArray[i] = x[len-i]; return new string(charArray); } I suppose my next dilemma is trying to figure out what goes into that if statement, I believe my best bet is some sort of select case statement, though the last time I tried that resulted in error. And I'm still trying to figure out what to about the IsNumber(), or rather what I need to put between those parenthesis.

Hello, I'm currently in the midst of taking an assessment test, and I need some help with something. essentially, what I need to do, is dynamically reverse a string as it is entered into a text box, and while it is being reversed, replace every number entered (1,2,3) with it's word equivalent (one,two,three). Now I have the string reversal part nailed with the following function: public string Reverse(string x) { char[] charArray = new char[x.Length]; int len = x.Length - 1; for (int i = 0; i <= len; i++) charArray[i] = x[len-i]; return new string(charArray); } My main problem is I am not very sure how to dynamically change the numbers to words as the entered string is being reversed. I am considering using some code along the lines of this: public string numCheck(string x) { string[] numbers = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" }; string[] words = { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine" }; string strReplaced = ""; int i; for(i=0; i9) { strReplaced = x.Replace(numbers[i], words[i]); x = x.Replace(ch); } return x; } However, I do not know how to properly insert this into the rest of my program to get the desired result, or even if this is the best way to do it. Thank you in advance.

I don't have the money for a license of VS 2005 unless I can find it for free someplace. Otherwise I can just save for it, I got 2003 on my machine but I don't believe it has an IDS but it's been awhile since I've tried doing ASP.NET on my machine. Oh well, thanks for your input, I appreciate it. :)

Sadly, yes I do have XP home and not pro, however, would it be possible to obtain IIS from an XP Pro disc? If not, then I guess that's a good reason to upgrade. I'll see what I can do.

Being out of school, I'm looking for ways to keep my skills sharp and I need to find a way to practice my skills with ASP.NET at home. I know I can get Visual Web Developer for free from Microsoft, but I believe I'd need IIS to be able to write my own ASP.NET apps. Essentially, my question is, is there a free/trial copy of IIS that I can use for my home system?

The companies I've been applying to over the past two months have been of varying sizes that run the gamut from big to small, usually staffing compnies like Robert Half International, Volt, TekSystems, and the like. Looks like very few companies actually go directly to potential employees, preferring to "try them out" through a staffing company for a few months before hiring them. So, when it comes to getting an interview with the technical people, its usually the staffing companies acting on their behalf. Back to the subject of the tests, a lot of the questions I missed were mainly on subject matter I've simple either never had to deal with in school, never even heard of, or simply forgotten about to a certain extent. The content was extremely similar to the exams I took in school, covering what the company believed the person should know. I understand what you say about how the questions may not actually be relevant to what needs to be done, though.

Hello, I've been a subscriber to the Code Project newsletter and an occasional lurker on these forums for the past few months and this is my first message here. I had recently graduated with a Bachelor's degree in Software Engineering Technology from ITT Tech about two months ago and am currently on the hunt for entry level developer work, of which I've had little luck in finding it seems. Anyhoo, sometimes I'll be called in by either a prospective employer or a staffing company for an assessment test or an aptitude test to get an idea of what I know and so far the results I've seen have been mixed. The first time was an online aptitude test which I did fairly well on, but the second time was for a staffing company and the results were what I would consider to be the lower end of the spectrum whereas the average score was 10-20 points higher than mine. I'm going in again tomorrow for an interview and another set of tests with another company, and frankly, I'm nervous and a bit scared. Is it normal for an entry level person to score reasonably low on tests like this? I find it to be pretty humiliating that stuff like this makes me look like my education didn't provide what I needed to know or that I'm simply not cut out for something I haven't even been able to get my foot in the door for just two months out of school. What are your thoughts on assessment and aptitude tests like this?