Sweet - that last message about connecing the clientid from contacts rather than calls appears to have solved part of my problem. Yippie!!! Hopefully it solved lots, but I am going to look into it in more detail tomorrow morning.
Thanks so much!!!
Eubanks
Okay, first of all I will admit that I never ended up trying your way in the command box in FoxPro like you had suggested. I was actually trying your code in a program that was written by someone other than myself. Basically, I just type in the SQL, and can hit different buttons to execute...
Thanks for the advice...I have been trying to work with it but without too much luck.
Do I just write these three separate select statements one after the other? I have never written more than one select statement in a SQL statement before...I am merely a rookie.
Also, I am getting this...
Okay, I have been reading over the last post about creating a view of contacts and clients using the xref table and also using a cursor to extract the latest call and temporarily store it to use it in a report. The concepts presented make sense to me, but I was wondering if anyone had any ideas...
The purpose of using the GROUP BY was to only get the last call entered...I did a GROUP BY on the contact's name because otherwise it would (originally at least) act like the same person, for instance, Bob Smith, was actually two different people and list it twice with two different calls. So...
This is very true about my GROUP BY field - what I was doing before was pulling the contact name straight from the calls table, which will certainly only pull contacts that already have calls. So what I did was grab all of the contact information, including name, from the contacts file (where...
Please Help!
I am running the latest version of Microsoft Visual FoxPro, and am having difficulties creating a SQL statement. I am trying to create a report that lists all of our contacts in the database, and includes the last call to that person, if one exists. Basically, I have a table of...
Okay, so are you talking about the run-time version of your system, or the full version. I have not had any problems yet with the run-time. It was the full version that I was having problems with. When I first had my shortcut to the full version, the Target in the shortcut was...
Does anyone out there know whether or not Visual FoxPro is compatible with Terminal Server? I have read on Microsoft's website that it has not been tested and is not guaranteed, but it didn't sound like it was totally uncompatible.
Any help would be appreciated!
Thanks!
Eubanks
Thanks for all the advice!!! I basically just wanted to make sure that VFP was a superior product, instead of just assuming that it was. With all that said, I have enough information about each application to decide which would work better for our company. If we choose VFP, then I now feel...
Completely understood about the "it depends" part. But what I hear you saying is that there is nothing particularly wrong with VFP, right? It is just not the most common database application that MS offers b/c Access is.
Also, I have a pretty good understanding of programming Access...
I was just wondering if some kind soul could give me some advice as to whether or not my company should use Access or Visual FoxPro. I know that there are several considerations that must be taken into account, but basically I wanted to know if Visual FoxPro is a good, solid application and if...
Without pasting all my code, does anyone know why this error comes up when trying to quit Word?
Run-time Error '-2147417848 (80010108)':
Automation Error
The object invoked has disconnected from its clients.
Through VBA, I am running a routine that opens a mail merge template and populates...
Thanks so much again, I have taken a giant leap forward in getting this document automation going!!! Your advice worked awesome and I couldn't have done it without knowing that you need to use a "SQLStatement" tag rather than "query".
And just for your information if you...
On another note, I was hoping to also automatically program the user to save the document whereever they would like, naming it whatever they would like, then close that document and close the original mail merge template automatically with no warnings, and then quit Word altogether. Any ideas...
Thanks alot! This worked beautifully for me. But I do have another question to see if you know the answer or not. This process is much better than what is currently happening (i.e. typing in the individual names each time), but I was wondering if there was any way that you could use a query...
Alrighty, I tried your code, and I'm running into a small problem. For one thing, it said that it couldn't open the data source...I double-checked the directory that I typed in, but it still wouldn't work. Secondly, it is opening another instance of Access, which I would not like it to do. Do...
Orion45-
Thanks for the reply, I am about to check out this code and see if I can get it to work, but I had one question for you...is the "WordMergeParam_qry" a query stored and created in access or a variable in VBA? Or does this question even make sense??
Thanks again!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.