Search results for 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?

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

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

Hi, I'm writing a report converter. I don't have the skills/time to have Access receive a file from the mainframe, so I'm using a Tcprint program to do it. I would like Access to detect if this program is running, is this possible? Also, any pointers on receiveing files would be great. We use...

I've managed to land in a temp job that, well, could be better. Right now I'm trying to improve an aspect of it. I receive two printed reports, I compare the two, and if I find matching ID numbers, I cross them off of one report. Yeah, considering it comes from a database, I was stunned at this...

I've managed to land in a temp job that, well, could be better. Right now I'm trying to improve an aspect of it. I receive two printed reports, I compare the two, and if I find matching ID numbers, I cross them off of one report. Yeah, considering it comes from a database, I was stunned at this...

I'm normalizing an existing table. It's a list of stories and the "Author" can be placed in a new table with a link back to the list of stories. The Access is useless for this. I've managed to create a table with a list of authors using some queries, but I can't figure out how to link...

Background: I'm exporting a table to a CSV file, then uploading to my Web site, run though a PHP converter to change it to an SQL file, then load it into the MySql database. The date is the problem. If I tell Access the date format is YYYYMMDD, it displays the table correctly, but Access won't...

I've been handed a database 90% of the size is in one table. This really bothers me because there are only 700 records in it! It averages 25k per row, looking though the table most of the fields are blank. I found a field "Supervisor" that I could normalize, but it made no noticeable...

I was looking at job ads today and found something in the area that required me to have an Inet+ certification. I did a little searching and it seems to be some sort of A+ test for the Internet. I'm probably going to take the test, but my funds are limited. Can I study by taking the...

Ok, I have a working combo box, it shows the Item ID, the name and the customer. After the user selects an item, the combo box only shows the Item ID. How do I get it to show everything?

Most of my working knowledge comes from Access, so if this isn't an issue with MySQL, be kind. I plan on making a web-based story archive. I'm trying to figure out how to link the story files to the MySQL database. In Access you can link to a file outside of the database. Is this possible in...

Well, I decided to do a pet project this weekend, and I forgot to bring my Access references home from work. So this may seem simple to you guys. :-) I found a list of stories on the web, so I imported the list into Access. I want to change three things: 1) After the title, it lists the size...

Ok, I'm happy with the database right now. You select the Excel file you want to load, and everything works great after that. Except now I need to plan on user error. My database will take any excel file and load it into a new table and then try to do operations on it. How do I make sure the...

Well, I asked this question in the "Access: Reports" Forum, but no one answered. So I'll try here: Right now, my reports are opening up at default, "100%". How do I make it open to "fit"? It didn't occur to me that this would be a problem, until I watched my boss...

The user will input name, ph number and email, but when they open the form, it displays the first record. How do have it open on the last record, the blank one where you input? I want them to be able to go back and edit previous records, so starting the form in "Data Entry" mode won't...

Right now, my reports are opening up at default, "100%". How do I make it open to "fit"? It didn't occur to me that this would be a problem, until I watched my boss be COMPLETELY at a loss, trying to see the whole report.

Ok, I have a table. On this table are Services, Tasks, and Projects Projects and services are independant, but a task can be independant, or belong to a service. In this case, it's called a task, but it's really a service. I need to do a ratio of Services, Tasks and Projects, shown in a pie...

I have a table with "names" and "addresses". I have a combo box the names. When I select the name I want a query to run on the table and show me the name and address. That was the example I came up with so I understand how to do it, in reality my problem is this: In a...

Ok, So I have a form, with a combo box. I can get the query to pop up with a "After Update", but I don't know how to tell the query to search for the selection! All the FAQs I've found seem to be a lot more advanced than this, "Sending the combo results to another combo&quot...