Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mmayo
  • Order by date
  1. mmayo

    Sync or import from Outlook to Palm M130

    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...
  2. mmayo

    Force Page Break on Report

    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...
  3. mmayo

    Sync or import from Outlook to Palm M130

    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...
  4. mmayo

    Problems in SQL

    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)...
  5. mmayo

    Problems in SQL

    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...
  6. mmayo

    Problems in SQL

    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 &...
  7. mmayo

    Sync or import from Outlook to Palm M130

    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.
  8. mmayo

    Problems in SQL

    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...
  9. mmayo

    Problems in SQL

    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...
  10. mmayo

    sstab, tabs on side, text alignment?

    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...
  11. mmayo

    downloading access file to pda

    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.
  12. mmayo

    Query 2 Databases

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

    Query 2 Databases

    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...
  14. mmayo

    Trigger for insert

    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...
  15. mmayo

    Trigger for insert

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

    Trigger for insert

    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...
  17. mmayo

    Trigger for insert

    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...
  18. mmayo

    Trigger to execute an insert

    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...
  19. mmayo

    VB, ADO, and insert into Oracle

    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...
  20. mmayo

    VALUATION REPORT

    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...

Part and Inventory Search

Back
Top