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

Yes, thanks.

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 would like to do something similar to what is discussed above. However, if I do txtBox9.value, I don't get the contents of the textbox, instead I get an error "Runtime error 2427. You entered an expression that has no value". I am trying to put the code in the report_open event. Thanks.

I don't think anyone else is in the db? I have opened exclusively and tried to save, but the same thing happens. The report says (Replicated) in the title, but the title of the db does not say this. What I think is the master db will not open, I get a message that says "The Microsoft Jet...

Well, I am learning what is significant as I go. I didn't develop this thing, I am trying to clean up someone else's mess. I would ask the guy, except he is dead. One of my problems is trying to locate the master.

Yes, I have right-clicked the menu bar and brought the Recover Design Master item up to the tool bar, but it is grayed out.

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.

Yes, It happens for all the reports I checked. I don't have a Tools option on the toolbar. This report appears to be a replica, but I can't find the master. Thanks

Yes, I am the only one in the mdb, and yes, I have a default printer designated.

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

Ok, I tried that, and still nothing happens when I try to save a report change.

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.

When I am in the replica, the tools menu options is not available. Why would this be?

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

What I mean is, if I have a table called TABLE_TEST, and I have three fields, say first_name, last_name,and phone. Can I do something like select field(3) from table_test where last_name = "Smith", and expect to retrieve the phone number? I believe I have seen this in Oracle or somewhere...

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