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!

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

Recent content by ken2834

  1. ken2834

    date comparison, 2038 issue

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

    Launching cmd.exe from VBA

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

    MS Access Report using multiple data sources

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

    How to save from calculated fields in a report to table

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

    I tried to make a simple change to a report in Access 2003, however I

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

    Can't save report design changes

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

    Tools menu is not visible

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

    Tools menu is not visible

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

    Can't save report design changes

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

    Can't save report design changes

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

    I tried to make a simple change to a report in Access 2003, however I

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

    Can't save report design changes

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

    Can't save report design changes

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

    Finding a lost design master

    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.

Part and Inventory Search

Back
Top