Search results for query: *

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

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

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

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

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!

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

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?

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

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.

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

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

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

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

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

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

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

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

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?

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

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