Search results for query: *

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

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!

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.

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?

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

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

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?

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.

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

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

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.

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

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

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.

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?

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?

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

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

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

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