Recent content by jmk2z

How does one create a query in Access that uses as criteria a value inputed by the user at the time the query is run?

I'm trying to get the primary key in an Access table to autonumber in the following manner: D030001 D030002 D030003 D030004 etc. Where 03 represents the year 2003 (next year it would be 04). Is there a way to get it to do this? Note: the year part is less important than the numbering on the...

By "back end," do you mean an Access table? By "front ends," do you mean Access forms? How would I actually link the 97 form to the 2003 table?

Thank you. I believe those with XP have Access 2002. The db will be on a shared drive and that single copy will be used by the different people. I guess what I need to know is what versions of Access databases will work with Access 2002.

I have an Access 97 database that needs to be used by both NT and XP users. NT users can use it, but those with XP can not. Is there another version of Access which I can convert the db to so that both can use it?

No, I mean for the actual form. Example: <form name=&quot;form1&quot; type=&quot;&quot;...

What are the possible values for the &quot;type&quot; attribute in a form?

I'm supposed to recommend an OS for my group to use on our new machines. We are going to be using Websphere Studio Application Developer 4.0 and some Rational Tools. It's between Windows 2000 and XP. I've heard XP is &quot;buggy.&quot; Is this true? Any recommendations?

I need to defragment my Gateway running Windows 98, because the performance has become horrible. When I run the defragmenter, it says &quot;Checking drive for errors&quot; and doesn't move one from that point (I let it go for 10 hours and it still said that). I tried to run the Scandisk first...

Do you know how to call a non-VB application (a &quot;shell&quot;) from within VB and return the output (stderr or stdout) of the non-VB application to the VB application. Someone attempted to do this with the CreateProcess function and it does not work. The -V option to the mqfta.exe...

Problem solved. I had to delete a registry key. Look at this page: http://support.microsoft.com/support/kb/articles/Q283/1/73.ASP?LN=EN-US&SD=gn&FR=0&qry=%26quot%3Bcan%27t%20open%20the%20mail%20session%26quot%3B&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97 The error went away and I was able to...

How do I write a macro? Do I create a button - and then do &quot;build event&quot; and write the code myself using the sendobject command?

Outlook is open and works fine on its own. I get the error when I simply select a table, then click file-send..., so it doesn't have anything to do with any code that was written. Any other ideas? Someone mentioned something about MAPI - I'm not really sure what that is.

I'm trying to send e-mail from an Access form, but when I try, I get an error saying &quot;Microsoft Access can't open the mail session. Check your mail application to make sure that it's working properly.&quot; I am using MS Outlook. What's wrong?

There's a &quot;Microsoft Map&quot; category but no MAPI.