I use VBA in Excel and Access to manage files in my trading system generated by various 3rd party modeling packages. Originally I was just trading a single...
I know this is very easy but I cannot figure it out. Basically I just want to open a EML (Outlook Express Email) using VBA. This is what I did but no success,...
In a query on the Fields line-- Field3: [Field 1] & [Field 2] John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003...
Hi i don't know if this true but it happen to me. I use MS Access on defrant PC's in some PC's when i want get value to form from an opened form i got ERROR#....
I'm using SQL via Access on a remote server, at my web host. While making some changes, I lost my connectivity earlier, and now *nothing* works. My sites...
WAIT!!! This how I resolved it: 'Open EML Dim strEXEPath As String Dim strEMLPath As String Dim dblRet As Double strEXEPath = "C:\Windows\Command\Start.exe" ...
Guys, Just want to know if this is possible to do in Access. I want to translate the data horizontally similar to the example below ... PN MPN ... PN1...
George- I find no Start.exe on my system, so it is suspicious. If the .eml extension is registered to Outlook Express (it is on my system), you should be able...
First of all, hello everybody, I just joined today. I've got some experience using Access 97 to build a complex application for a Machine Shop I worked at for...
Vince- Despite the fact that you say you have no modules, if you used one of the control wizards, your application does have some VB code. The symptoms you ...
Thanks heaps. The module that opened got a compile error "label not found" but it was in an unused part of my "overladen" application. Anyway after the...
Hello I have a really weird situation going on with this client. This client is networked with a server. The server has the Access database shared on it. I...
Frankie, You are aiming at selective crosstab effect even though all the required ingredients for a genuine crosstab query are not available. Desired results...
Thanks John, its been resolved by adding this: "/eml:" 'Open EML Dim strOEPath As String Dim strEMLPath As String Dim dblRet As Double strOEPath = "C:\Program...
I would like to find out if anybody can help me. I have built a table with a field called "date" and I have created form using a MS DTP and bound the DTP to...
Greetings: Hoped for goal: =========== a) Would like to work my way up to creating a continous form with checkboxes. b) Initally I created an unbound checkbox,...
The key in the Work table cannot be AutoNumber data type. Try changing it to Long Integer. You might also need to write code to copy the Autonumber value...
Hi all I am hoping you can help. In Access 2002, I have created a form which carries data from a Query. In the relevant table, there is a field called 'Exit...
Hi all, I recently updated to win2k adv. Serv and office 2000. I copied an access 97 db to the server and can access it. The problem is that when I try to...
If the current date is 04/15/05, I want to set my date to 4/30/05 If the current date is 05/31/05, I want to set my date to 6/15/05. Please advice. Thanks a...
Dear all Hi, i got a problem in printing a single record from a form in a specific paper size. My paper size is 19 cm X 7 cm continuous paper, I am curently...
Yes I am using linked tables. This is a problem because the link is also wrong as per previous email. The exact text of the error: '\\Library_Server\DATA...
Shawn- No, Access won't fix linked table Connect properties on its own. You must write some startup code or use the Linked Table Manager to fix them. You can...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
