Kasghost
Last Activity: Jun 8 '09, 05:24 PM
Joined: Feb 16 '07
Location:
-
Problem writing data to a file
I'm working on a group project for school. When I tried to combine all the peices together I was no longer able to save data to files correctly. The program works by reading 4 txt files into structure controlled arrays, but when I add a new record to the file I get a blank entry in the indexed location of the last record that was read from the file, if there were 11 records the blank would appear as the 11th record in the file, if there were 15 records... -
Did this when I converted from 2000 to 2007 format and was able to get an update query to run so that i could weed out some data that I don't need. I'm guessing that I will need to run compact after the delete finishes. Hopefully this will bring it down to a managable size. -
Ok i've run into another snag with this. I was given another table and need to run a query against the table and the last query. The issue I have is that with just the 3 tables the DB is about 1.30GB. I have tried using the queries to create tables in both this DB and another but in both instances I hit the 2GB limit before the tables are created. I have also tried modifying the SQL to try and account for the third table but keep getting syntax errors...Leave a comment:
-
Thanks guys works like a charm.Leave a comment:
-
It started off that way and I was getting mismatch data type when running the query so I changed it to text.Leave a comment:
-
Just figured out what the problem is. Kind of. The field [machine name] has 5 characters that I am taking out. The problem is in the field [office_gl_dep_i d] I have some records with 4 characters and some with 5. It looks like all of the id's with 4 characters in [office_gl_dep_i d] start with a 0 when coming from [machine name]. Would there be some way to drop the 0 from these?
Here are a few examples of the records.
...Leave a comment:
-
Thanks for the help. When I run the query I just get a blank sheet, though I do have all the fields that I was hoping for.
Here is the code from the SQL statement that you suggested with the names of the actual sheets and fields that I ran it on.
...Code:SELECT S1.*, T2.* FROM (SELECT Left([machine name],5) AS Stub, * FROM sheet1) AS S1Leave a comment:
-
Trouble splitting data in text field
Rarely do I play with access so please keep it simple if possible.
What I have are 2 tables. In table1 I have two fields, both are text. Field1 lists application names (Access, Excel, IE 7, ect). Field2 lists computer names (12345-ws-00). What I need is to either return just the first 5 digits in another field or in another table. Table 2 has 6 fields but uses the 5 digits I need from Table1 as the primary key and I need to end up... -
Thanks for the quick responses. As for re-reading the assignment, it wouldn't be much help as it is very open ended. And this class does not have lectures, two students and the teacher, and other than the project work I have done we have not covered anything in Access yet. I'm relying on my limited skills from my first Access class. The premis is to create an online computer store where customers can purchase computers based on selected components,...Leave a comment:
-
Write calculated value to a table
It seems like this should have been easy to do but a solution is just eluding me. Here is my situation, I am working on an Access DB for a class project, my instructor wanted me to create a form based on a table. In this table I have two fields, Computer_Price and Total_Price. These are calculated off of data from multiple tables that are used for lookups and contain the pricing for the individual components. The problem I have is that I can get... -
Having problems with forms
I started working on my first Access Dbase about a week ago, Thanks NeoPa for the initial help. Now I am trying to create a form. What I would like to do is have one form that I can fill out. The table the form is going to has 3 fields Office ID, Phone Number (Primary Key), and Purpose. I would like to be able to have the form so I can put the Office ID in 1 time and then fill in the Phone Number and Purpose for the different numbers in that office.... -
Thanks for the help but I think I found the simple solution I needed. I am just going to setup a few workstations with Office on them and have my techs remote in and fill out a spreadsheet for each office and then I can import those into the DB. Has worked so far in my test run.Leave a comment:
-
My experiance with Access is vert limitd at best. I took 1 5 week basic class and in it we created a few very simple DB's. What I am trying to accomplish is to create an asset list of all the equipment in each office. What I have done so far is create a DB with 6 tables. In each table I singled out 1 field that is unique to that table as my primary key and included an Office ID field which is the primary key in my first table. But now the problem...Leave a comment:
-
I read the Normalisation and Table Structures Guide and I understand where I started to go astray with this. Was just hopping someone knew an easier way to set it up for the data collection aspect. Thanks for the advice.Leave a comment:
-
Problem with Multiple entries
I am trying to create a DB in Access 2007 where the values in certain fields requires multiple entries.
I would like to send this DB out as an HTML to my techs and have them fill the information in.
The problem I am having is that I am having to create too many tables. I would really like to have no more then 3 or 4 tables.
I've been able to setup most of the tables so that each value has only 1 entry...
No activity results to display
Leave a comment: