Search results for query: *

Hello, again! We may have hope! I am refering to the Palm Installation CD. Of course, mine is at home, but when I reran the installation is when I received the option to use Outlook or to use Palm Desktop for contacts. It then loaded Chapura Mirror on my desktop (which syncs outlook) instead...

Good morning, illini! Yes this can be done. Open your report in design view and make sure you have selected states as a field for sorting and grouping. Choose to have a "Group Footer". Right click on the bar that says something like "State Footer" (you don't have to have...

I'm sorry to hear that. I purchased a Palm m130 about 8 months ago. I orginally set it to sync to palm's contact database. About 4 months ago, using the cd to install the snyc files on my desktop, I reloaded the files and went for outlook. It has been working just fine. What cd's came with...

I have only one other idea and that would be your ODBC path. I believe you are missing the provider. For example (and this truly works on my machine)...

Oops. One other error, remove the strDbl at the end of the ODBC: strSQL = "INSERT INTO cliente (t_cuno, t_nama, t_net) " strSQL = strSQL & "SELECT ttccom010200.t_cuno " strSQL = strSQL & "ttccom010200.t_nama " strSQL = strSQL & "ttccom010200.t_net &quot...

Good catch! You are absolutely correct. You need to select the specific fields: strSQL = "INSERT INTO cliente (t_cuno, t_nama, t_net) " strSQL = strSQL & "SELECT ttccom010200.t_cuno " strSQL = strSQL & "ttccom010200.t_nama " strSQL = strSQL &...

Yes. As you were loading cd that came with your palm, it gave an option as to whether to snyc to outlook or to palm's database. Just run through the installation again and select the outlook option.

I would have felt much better if this had worked! Just so you know, I'm using this format to pull data from PervasiveSQL into access. It took me several tries to get this to work in my environment. I haven't tried this with informix. After that disclaimer, perhaps try: strSQL = "INSERT...

Hi Diogo - I've done something similar. But for it to work, the ADO connection needs to be to the database containing the table that will be receiving the data. I haven't checked the following code so you would need to adjust to your DSNs and database locations, but your end result should...

Sorry if this is appallingly simple... I've got a SSTAB with 20 tabs down the side, one level deep. I would like the text on the tab to display horizontally. The problem is that even with the tabs appropriately sized, the text aligns to the bottom of the tab. Can it have a top alignment so...

I've only done a couple of small trials using HanDbase. (The access add-in was an additional cost) It worked adequately for my test.

Oops... Forgot to include the line: cnAccess.execute strSQL (Sorry!)

Greetings! I've done something similar, but not exactly the same. I have data that crosses multiple platforms (Oracle, PervasiveSQL, Access). In one case, using a connection object to an access database (so I could insert the data into a static table), I used: dim strdbl as string dim strSQL...

As a follow up for any who may be having a similar problem: there is alot to read regarding 'mutating tables'! Please take the time to research! And, as sem indicated, it needs to be a row level trigger. Here is the solution I'm using (I still have PLENTY of coding to do, so this may still...

Sem - Thanks for your time and help! You deserve a star!

sem Thanks! You probably guessed this is my first attempt at a trigger. Your answer was absolutely correct. Can I trouble you with an additional question? (If the answer is 'no' please stop reading now!) The record that fires the trigger contains a field called session_id. I would like to...

I have composed this trigger: CREATE OR REPLACE TRIGGER JobCost after update [clock_out] ON CIM_TIMECLOCK BEGIN INSERT INTO FORJOBCOST SELECT CIM_FOLDER11.JOB_NUMBER, CIM_FOLDER11.OP_NO, CIM_FOLDER11.MACHINE, CIM_FOLDER11.QTY_GOOD, CIM_FOLDER11.QTY_SCRAP, CIM_TIMECLOCK.OPERATOR...

I have data that needs to be pulled from oracle, modified, and pushed into PervasiveSQL. I would like to fire a trigger in oracle when an employee clocks out. I need data from that and 2 other tables in oracle. I would like to insert that into a table in Access. Being my first trigger, I'm...

I have captured data from PervasiveSQL, modified it (so I have the 'ET' of 'Extract, transform, and load). (Well, I actually load it into a table in access for safe keeping). At any rate, where I need this data is to update and insert a table in Oracle. Here is what it looks like: Dim...

We are on PFW 4.8. On test environment was a full copy of all our data on a stand-alone machine. We have only tested their software against 4.8, but the manual includes discussions of 4.6 and 5.0. So far we have been very pleased with the results and will go against live data in a few weeks...