Search results for query: *

I am doing a comparison of dates in an if statement... matdate is a date in the format of "July 15, 2010". set matdate1 [clock scan $matdate] if {[clock seconds] < $matdate1} { #run this code... } The first problem I encountered is I have some dates that exceed 2038. I get an "unable to...

I have a VBA module that launches a DOS command console (cmd.exe) in order to login to a Unix session and then run some FTP commands to pull down a file from the Unix server. However, I would like to be able to parse the output in the console to determine if the login occurred successfully. Is...

Can I point a report to Multiple Data Sources? I am using Access 2003. The report I want to create has 2 sections. The first is basically a 8X10 table that breaks down various financial data by category. The second is sort of reference data that does not break down by category. If I go to...

I am in a replica of a database and the master is corrupt, I think. I wanted to go to Tools/Recover Design Master, however the Tools menu is not visible. All I see is File, Edit, Insert, Records, Window and Help. Why would this be the case? Thanks.

I tried to make a simple change to a report in Access 2003, however I can't save the changes. I click the X, and it asks if I want to save, I respond "Yes", then nothing happens. What do you think the problem is? Thanks. I did a DoCmd.SetWarnings True to make sure I wasn't missing any error...

I tried to make a simple change to a report in Access 2003, however I can't save the changes. I click the X, and it asks if I want to save, I respond "Yes", then nothing happens. What do you think the problem is? Thanks.

I have two problems to start: 1. I can't locate the design master for a replica I have (Access 2003). 2. For some reason, the Tools menu on my toolbar is hidded when I bring up this project, so I can get at any of the recover options. Any help would be appreciated. Thanks.

I inherited an MS Access application from a guy who dropped dead of a heart attack. I am running Access 2003, though I suspect this application was developed in Access 97. A design master is set up, however the reports only reside in the replica. All I want to do is make a minor change on...

Here's a silly question. I have a dataset open in SAS 6.1.2 and my dataset has 700 to 800 columns, not in alphabetical order. I am trying to search for a particular column name, and I think I know part of the name. The 'Find' function only enables me to search data. How can I search for a...

Is there a way I can retrieve a list of fields in a table, without having to hard code each field name?

I am writing a fairly simple VBA app in Access to retrieve a tab file from a Unix server via FTP, import the file into a table, then run a report off the table. When I try to import the table, I get the following error: The Microsoft Jet engine could not find the object...

Does anyone know of software that can be used to compare two tables? I have searched the web and I see commercially available software for comparing entire database schemas, however these seem geared toward comparing a new version of a database versus a previous version, so it will probably...

I am trying to fix an Excel macro that was coded by someone who is no longer around. When I run it, I get a "Reference is not Valid" error, I think because the sheet the code is trying to reference is hidden. I have tried to unhide the sheet, and I have been unable to. However if I loop...

I have a fairly cumbersome access query that joins 19 different values into one table. The values are pulled from several different data sources, but I think I need to get them in a single table so my report can display them. If I run the query alone, it displays the data fine. If I launch...

I am writing a small Access application that pulls in data relating to a financial trade. Each trade has two records (rows) associated with it -- there is a "pay" side and a "receive" side to the trade. I query the recordset by trade number. I wanted to simultaneous show selected fields from...