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 Chriss Miller 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: ErikZ
  • Order by date
  1. ErikZ

    The power of PHP and MySQL

    I had no experence with PHP or MySQL. But I've taken a year's worth of database classes and come contract work with Access. In short order and some "How To" books, I built a nice little dynamic webpage. It works great and I've had no technical problems. If you are used to Access, I...
  2. ErikZ

    Formatting a string with an update query.

    Hmm, not exactly what I had in mind. But you've set me on the path. I'm using an update query, so if I modify your code to this: Left([Fullfield],Len([Fullfield])-7) It works perfectly! Thanks!
  3. ErikZ

    CGI & Access2002 -

    Um, if there's only one table, it makes perfect sense. Primary and secondary keys are for linking between tables and indentifying records. If you have one table, then all you have is a key. The code looked for the key, didn't find it, so it adds the record.
  4. ErikZ

    Formatting a string with an update query.

    I have a field where all the records in it need to be modified. The strings are of varying length, but they all end with "HTTP1.1" How do I remove the last 7 characters of a string?
  5. ErikZ

    Help with a csv file

    Sure. Before doing all of the above, create the file on the floppy, copy the string: "Meterref;Customername;Meterno;Meterseq;Multiplier;Reading;Readingtype;Readingdate" to it. Close the file. It looks like the code above appends to the file, so when it runs, it will open up the file...
  6. ErikZ

    Compact and Repair Database automatically.

    I'm not sure, but I think this is why. They handle database security within the database using the built in security features. So that anyone can open up the database, but without the correct Access permissions it won't let them view or change anything inside. But I've never had to deal with...
  7. ErikZ

    Help with a csv file

    I don't understand, you're loading an Excel file into Access so you can save it as a CSV file? Why don't you just save it directly from Excel as a CSV?
  8. ErikZ

    Compact and Repair Database automatically.

    Use Access help and do a search for: Startup command-line options You'll get a full list of switches and info on what they do.
  9. ErikZ

    Macro is too fast!

    Yeah, it would be more elegant if the conversion were in Access. However, I'm making 8$ an hour here, and they only let me work on this project 2 hours a day. After my regular 8 hour day, so much for a College education. They don't have any programmers, and they have no interest in hiring me...
  10. ErikZ

    Compact and Repair Database automatically.

    Well, our databases are very different. Mine will be emailed to each user and they will use it locally. So no permissions need to be set. When I was researching the problem, I believe I came across the problem you're talking about. It DOES make a new copy when it compresses it. I'm assuming...
  11. ErikZ

    Compact and Repair Database automatically.

    Heh, boy do I feel dumb. Found the answer in Help. FYI there is a checkbox so the database compresses on close. 1 On the Tools menu, click Options. 2 Click the General tab. 3 Select the Compact On Close check box. Hey, it's Monday.
  12. ErikZ

    Compact and Repair Database automatically.

    My database adds and deletes data frequently. As you know, this causes the size of the database to balloon up to a system halting size. This is going to be an application that I hand out to users all over the company and I don't think they know/understand the problem. I've been looking into...
  13. ErikZ

    Macro is too fast!

    Hmm. What you wrote sounds like it might work Herb. But since I had all the code for birklea's idea ready, I went with that. It works now, and it goes like this. Command button runs a macro, the macro has a bunch of basic commands in it, then it runs the DOS batch file. When that window closes...
  14. ErikZ

    technical or business

    I think Stand Alone has the most valid point. In a poor job market, they want programming GODS. At this point I believe the only way to get a job is to work though your contacts and friends.
  15. ErikZ

    Macro is too fast!

    Thanks! Hmm, I've used the code above as a guide to add a timer pause. Right now my VBA opens a DOS window and runs a DOS batch file. But as soon as that window is open, the VBA code goes to the next step. Any idea on how to get it to wait for the DOS window to close like the Macro does?
  16. ErikZ

    Macro is too fast!

    Well. Ok. If there's no way to do this in a macro, how about I convert all of the macro into code? So how do I get a 5 second pause in VBA code?
  17. ErikZ

    Macro is too fast!

    I have my Macro call a program outside of access that parses the data file. It turns the data file into something Access can easily import. However, once that application ends and Access tries to import the files, I get a "File not found." error. I've determined that it's a timing...
  18. ErikZ

    How can I export more than 1 object from a db at a time

    A lot? Why don't you just copy the whole database instead of exporting?
  19. ErikZ

    sql statements too short

    Why don't you save the SQL as a query, and the call the query by typing in the name of the query?
  20. ErikZ

    Is it possible to detect other programs?

    Interesting. I'll give it a shot when my brain doesn't feel like oatmeal. Thanks!

Part and Inventory Search

Back
Top