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 Rhinorhino 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: LucasH
  • Content: Threads
  • Order by date
  1. LucasH

    running VBA through task scheduler

    Hi guys, I am stumped on this one. Windows Server 2008, Office 2010 I have some vba code that exports a table to an Excel spreadsheet and then does some formatting (basically running Excel macro statements stored in an Access vba module). It normally runs fine but we are trying to automate...
  2. LucasH

    best way to scan directories

    Hi, Im wondering what the recommended method is to scan through a directory structure is? Currently Im using the Dir command and then looping through the results but that is taking a long time. Granted there are a lot of files. But Im wondering if I could use some of windows/dos...
  3. LucasH

    vba delete query

    Hi all, I have an application built through MS Access 2003 with linked tables to a SQL Server 2005 db. My question revolves around a delete query that is taking a very long time to process. The table in question has about 5.6 million rows. I use a vba docmd.runsql statement which goes...
  4. LucasH

    display message while processing

    Hi guys, Quick question. How do I display a form/messagebox while some calculations and functions are being done by the database? I would then close it when the calulations are completed. I know how to open and close a form, and I have set the first step of my autoexec function to open a...
  5. LucasH

    text export hash symbol

    Hi all, Im exporting a query with a column named "FILE #" and upon export, "FILE #" becomes "FILE .". Any idea why? Is there a way around this (i tried using the "'s around text but same thing happend) besides editing the text file after export? I can't change the column header name. Thanks!
  6. LucasH

    auot tab and input mask

    Hi all, I have create a form that will receive input from a scanner. i want the form to auto tab to the next control after a scan. I have read about using the auto-tab property along with the input mask, but my problem is that the data being entered is not necessarily uniform. Is there a way...
  7. LucasH

    OLE object PDF

    I insert an OLE object (both PDF and Word Doc) of my terms and conditions and the report only shows the first page of the document or pdf. Why is that?
  8. LucasH

    terms and conditions

    Hi guys, Question for you. using CR10 against my accounting system and we have a crystal report that generates a purchse order. I want to append a 3 page terms and conditions document (either word or PDF) that prints out for every po printed, could be multiple. I am wondering what section to...
  9. LucasH

    loop through fields?

    Hi, Is there a way to loop through all fields in a report section in the OnFormat event? Something like For each Field in Me.Report blah blah blah.whatever = something Next im pulling my hair out.
  10. LucasH

    invalid precision value

    Hi, I am using MS Access ODBC to interface with a Pervasive SQL 9.1 db. I normally have no problems whatsoever, but at a particual client site, I cannot edit (or append) any date records. As soon as I enter a date (or try to add a record with dates in it) I get an Invalid Precision Value (#0)...
  11. LucasH

    auto save query changes?

    Hi, Using Access 2003 and haven't seen this behavior before and it's driving me mad. When making changes to query design, upon closing, I do not get prompted to save changes, Access just autosaves whatever I change. Or when i create a new query, and attempt to close the query, I have to...
  12. LucasH

    date function

    HI I am running Pervasive SQL 9.1 and am just trying to run a a query that grabs all transactions between now and 4 months ago. This query is run as an Access pass-through query. Is there a dateadd function or something in 9.1? My attempt is the following SELECT * FROM order where docdate >...
  13. LucasH

    updating counter

    Hi all, Can someone point me in the right direction here? I am importing rows using DBI and I just want to print the number of rows inserted, updating itself after every insert. I can get it to print like this: 1 2 3 4 5 6 etc But I don't want a new line for each update, I just want to see...
    • LucasH
    • Thread
    • Replies: 1
    • Forum: Ruby
  14. LucasH

    for loop looping through labels?

    Programming question here. I have 4 labels: label1 label2 label3 label4 I want to make a for loop to assign the text property of each one. Is that possible? I was thinking something like (I know this is wrong and probably stupid but it's my first guess and not the most experience...
  15. LucasH

    page refresh question/advice

    Hi all, I have developed a web app that takes requests. The initial page lists existing requests. Upon clicking the NEW button, I have a javascript that opens a new window with a blank form. When the user clicks SAVE on the form, the db is updated and another javascript closes the window...
  16. LucasH

    export schema and stored procedures

    Question, I am trying to convert a SQL Server db to a posgreSQL db (actually I am not, I am giving it to another person) and am wondering if there is a way I can export or print the schema? Relationships, table designs, data types, etc? i know about the diagram, but I don't want to have to...
  17. LucasH

    calendar day label?

    Hi, I am thinking of creating an app for a, say, baseball team's schedule. I want the days when the team plays to show the opponent and time, etc. and if a user clicks on the data/game, directed to a report for that specific game called by the date. I just started looking at the calendar...
  18. LucasH

    call a job within a job?

    Hi, I have a several jobs created that each have several steps (DTS package, SP, etc). I want to create a "master" job that calls these sub-jobs. How do I do that? Is there syntax to call a job?
  19. LucasH

    folder structure

    Hi there, Anyone know of a way to setup a folder structure within the DTS Packages folder to organize my different packages? It's getting a little unwieldly... I use SQL Server 2000
  20. LucasH

    confirm delete

    Hi guys, I am not that good with javascript and fairly new to .NET. Can someone help me figure out how to enagle a confirm pop-up box when clicking a button on a webform (not in a datagrid). The button's click event will execute a SQL Delete command against my db, but I want a confirming box...

Part and Inventory Search

Back
Top