Very Confusing & HUGE Challenege..need Help.

Nov 8, 2005

One of our key customers (GE) has demanded that we begin to submit our estimates in their transmission 160 character format.

Basically it it a txt file that looks like this all on one line.
1ABCDWXYZ0502EST TEST123456T050208654321C 00010851803098518031 000000E 0000000000000D CAR SHOPPED AS CLEAN-PROCEED WITH

Only a couple of those characters are in my database and will change. Other than that items will continously be the same. The items that are optional and we don't have not only have to be blank but have to have spaces there instead...not 0's.

How do I set up a query to kick all of this out? I tried something like:

GEString:2UPRR YYMM00&""&WorkOrderID yada, yada, yada

but it didn't work....any ideas? I also need the YYMM to be the current year/month and I have to pull the decimals out of the estimated billing costs.

Is there a better way to do this? As you can imagine...typing 5+ pages of this for each job would be a NIGHTMARE!

View Replies


ADVERTISEMENT

Confusing

May 12, 2005

Ok this may seem very confusing as alot of things need to happen for what I am trying to do

I am doing an inventory database that contains all order, client, purchasing, and inventory information.

I have a table that has all of the different products we sell (also includes which of the following tables are needed) I also have separate usage tables storing how many of each part (given a partnumber) for each of the products.

Now this is where the complecation comes in .When I create an order I want to 1. add a record to my order table (containing ordernumber, client number, product purchased) 2. using the product table, find out which usuage tables need to be looked at, go into those usage tables, get the number of each part that is needed for the product and store the value into an allocation table

I have had this on my mind for the past 2 weeks that I have know I will have to do this at some point. I am getting to the point where I cannot do anything else without this being done. I need help something bad.

If you feel you know how to do this and think you need more information, email me at cgow1@cogeco.ca

View 1 Replies View Related

ER-D Really Confusing! Please Help!

May 1, 2007

Hello, Im creating a database for a charity just to get some experience and im stuck on something - my table structure.

I know you might find it a bit difficult because you dont know the background info but i need the database to be able to let customers and members make bookings. Ive thought of putting both customers and members in one table but i dont want it to get complicated and messy, although i will do that if there is no other way.

The ER-D is attached.
17309

Is there a solution to my dilemma?
Ant...

View 2 Replies View Related

Confusing Use Of Validation

Feb 7, 2005

Hi everyone,
basically what i need to able to do is set a validation rule that allows me to enter a value that is between 5 and 10 kgs but (and here comes the confusin bit is also rounded to the nearest 5kg. I tired using the[ like "?.?0" or "?.?5" ] command but have so far been unsucessful. Also i really like oranges.

View 5 Replies View Related

Schools DB Confusing Problem

Oct 6, 2007

I am trying to redesign an older DB for a school,
to meet the new needs that emerged.
I am totally confused due to the complexity of the problem. I've already searched in this forum and in Google but most articles are for simpler DBs.
Well to get to the point.

School has Students,
Students attend to Classes (many to many)
Students are assigned Lessons (many to many)
and coming to the confusing part
a Lesson in specific Class may be teached from two different Professors
(e.g. the 1st may teach the theory and the other the excersizes).
So another many to many Class-Professor and another Class-Professor-Lesson and so on?

After throwing away many sheets of paper I come up with a schema which seems a little bit strange but seems to going to work for my case.
I figure out that I could have a unique junction table storing all these info, and that's no other than the Schedule table.
So I'm thinking of having the following relationship schema:

Students
StundeID
Name
etc.

Lessons
LessonID
Title

Classes
ClassID
Title

Professors
ProfessorID
Name
etc.

Schedule
ScheduleID (maybe a combination of all others)
ProfessorID,join with Ptofessors
ClassID, join with Classes
LessonID, join with Lessons
Day
Time

Schedule_Students
tableID
ScheduleID,join with Schedule
StudentID, join with Students


What is your oppinion about? Can you see any problems which may emerge from such a design?
Thanks in advance

View 8 Replies View Related

Confusing Query-type Help

Aug 11, 2005

This is a bit confusing, so I'll try to explain it well.

Two tables. One has a list of metals. The other has a list of submetals, and what basic type of metal it is. It's grabbing the second column from the first table. Makes sense, right?

Now, I have another table, with links to both of those fields. What I want it to do is when it picks the metal type, to filter the subgroup to only the types it has associated with it to the basic metal type. Not sure if that makes sense. I'll supply an example.

Table 1
Aluminum
Brass
Copper

Table 2
Subgroup Basic group
License Plate Aluminum
Iron Aluminum Aluminum
Yellow Brass Brass
Copper Wire Copper

Now, if in Table 3, they choose Aluminum from the drop down box for basic metal, I want the dropdown box for the subgroup to have only License plate, and Iron Aluminum. For Brass, only Yellow Brass, and the same for copper.

Any ideas on how to implement this?

View 3 Replies View Related

Query Results From Iif Statment Confusing

Jun 1, 2006

I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0.

I've tried using in the query under the 'table' field (for selecting a specific group of people seated at a particular table)

Iif([Forms]![TablePlannerFrm]![TableSel]=0,>0,[Forms]![TablePlannerFrm]![TableSel])

Which I thought would evaluate a true/false with the two results coming from the two options, so if the Table selected on the unbound form was set to 0 then it would set the criteria to >0 (everything table 1 and up), or if anything else was selected other than 0, it would use the number from the unbound form from the TableSel field.

I'm getting blank results from both positive and negative results. I assume that I'm not using the Iif statement correctly, or that there is another way of approaching the problem that my headache is blocking :)

Thanks everyone

View 1 Replies View Related

Huge Database

Jun 21, 2007

Hi,
I have a huge databse with a form, showing record info. If I use a search button to search the databse it takes ages to find the record.
The quickest way is to find the record by hand, find the record number, copy that, and paste it into the form and hit enter.

Does anyone have any ideas how i can speed thing change over up.

Thanks
Alex

View 3 Replies View Related

My Access File Just Became Huge

Mar 7, 2006

I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?

View 9 Replies View Related

Huge Jumps In AutoNumber

Nov 20, 2007

I inherited a database from someone else which has about 9000 records.

When sorted, one can see that the AutoNumbering starts at about 72K...then after a while there is a jump to about 134K...then after some more records the AutoNumber suddenly goes up to about 396K.

Does anyone know the most likely reason(s) that the numbering is like this?

Thanks in advance.

View 3 Replies View Related

Huge Problem With Form

Oct 4, 2004

I have a form that contains a field for file box numbers, and a field for two different box numbers. I have a check box set up for the data entry person to check when the box if full of files. I need the the box numbers to increment by 1 for the two different box colors when the check box is = yes. Can this be done?

View 4 Replies View Related

Huge Problem(s) Please Help!!!!! Asap

Nov 28, 2004

i've just delivered my program to my client and there are 2 MAJOR bugs.

bug 1: the first time program is opened, everything works fine. it goes to the switchboard, etc., everything's cool. however, if he closes the program (i think he closed it using the red X) and tries to get back in, only one item on the switchboard shows up from that point on. the thing is, this problem DOESN'T HAPPEN ON MY COMPUTER so i have no way of even attempting to figure this out. the way i have my program set up is i have an interface and a BE and an .mdw file all in the same folder. i've created a shortcut that uses a workgroup switcher so that he can open the program and use it w/the .mdw file.

i have no idea what could possibly be causing this to happen. i would think that the switchboard would open correctly every time.

bug 2: this one does happen on my computer.

setup: i have frmCustomers (outer form) with sfrmJobs (subform) with a subform inside of that named sfrmFinances. Everything in frmCustomers works fine, and everything in sfrmJobs works fine. The primary key (JobID) in sfrmJobs is entered manually. After the JobID is entered, sfrmFinances is accessible. sfrmFinances' control source is qryFinances, which has a few fields from tblJobs (control source for sfrmJobs). frmCustomers is linked to sfrmJobs by CustomerID and sfrmJobs is linked to sfrmFinances by JobID.

problem: a new customer is entered in frmCustomers. a job number is entered for the new job in sfrmJobs (JobID). the user then attempts to update a field (any field, but for example, ContractPrice) and a window pops up and says, "Field cannot be updated". you click ok and it pops up again, at least 10x in a row. then it finally lets you enter data, but when you try to save the record, it pops up with another window that says,

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

excuse me?? how could there possibly be duplicate data??? the funny thing is tho, when the user closes the form, and then opens it back up and tries to enter financial data w/the same customer, it allows it.

???????

The first bug is more important than the second one, but any advice or ideas on either are EXTREMELY appreciated. thank you very much in advance.

-Jason

View 1 Replies View Related

HUGE Problem With Access...

Jan 16, 2005

I try to get an ASP file work with Access database and I get this error:

Microsoft OLE DB Provider for ODBC Drivers- Error '80004005'
Specified driver could not be loaded due to system error 126 (Microsoft Access Driver (*.mdb)).

I tried everything and nothing - and the configuration of this driver doesn't work...
How do I fix this driver??

View 13 Replies View Related

Huge MDB (Need To Create Installer Or Updater)

Jul 2, 2007

Hi all,I'm in a bit of a dilemma here. We currently have an mdb which includes a form and 4 tables. The entire mdb is around 800 megs. What we used to do is distribute this mdb to users in completely different locations on a CD, but now it has become to large for a cd to hold. Our manager wants us to figure out a way to distribute this mdb using only 1 cd, without zipping it. How would i go about doing that? Is there currently an installer, that can download the database from our ftp site and then insert the tables, or is there any other easier way i can get this done? P.s. The database will likely get larger and larger every yearThanks in advance

View 14 Replies View Related

Questions Before Undertaking A Huge Project.

Feb 22, 2008

Here is the scenario:

I have a bunch of people with laptops who go on reviews throughout the state and leave reports on site with the facilities they review. They go out in multiple person teams and work together on reviews. Currently, each person types out their own citations in MS Word on their own computer, saves them to a flash drive and then the facilitator compiles them all together and prints out a report. Then the facilitator comes back to the office, provides their support staff a copy of the report, and then the support staff finalizes it and sends out a letter.

Unfortunately, none of our laptops have Internet capability out in the field.

My idea is to have a multi-user split main database that is stored at our main office. This is for the support staff to store all of the reports. Then I propose to have a local copy of the database (much smaller) on each of the laptops.

Here are my questions:
Lets say that 3 people are out on review together. They each have their entry form on their own computer. The form will be sending information to a few different tables. How can they easily export out their results so that the facilitator could easily import them into their database on their computer.

If all of that were to work somehow, how could the facilitator easily export out the review information tables so that the support staff could import them into the main database.

One of the many stumbling blocks I see relates to Primary keys. The main database will have a main table with a PK of 2008.100 for example. While out on review the reviewers will not be able to use the naming conventions of the main database PK. They might use something like the City name and date (Pensacola02222008). Could that PK be automatically switched into the other format upon import?

Let me know ya'lls thoughts. I have been trying to get my head around this for a few days and have not been able to come up with a feasible solution.

Thanks in advance.

View 10 Replies View Related

Upsizing Creates Huge MSSQL

Feb 1, 2005

I am upgrading a .mdb to MSSQL. The .mdb is 17MB, but the resulting MSSQL is 72MB. Tried using both the Access Upsizing Wizard and Enterprise Manager DTS. I have done this a number of times before, but never ran into this problem. Any ideas what coule be going on, and how to fix it?

View 1 Replies View Related

Huge Database - Access Freezing Problem....

Feb 19, 2005

Guys, my database have 7 fields and 690 thousands of lines.

When I resort, for exampe by date field, the database on my P4-3.2 with 1gb memory, on Access 2003 with XPpro freezes and does not respond at all!!!

On my old P3-866 512mb with Win2k it was working! After 3 minutes the computer was getting back.... But now.... I waited for 20 minutes. The access doesnt load not a CPU, and no IO readswrites are done - it simply stops responding.

What can we do with it? Why the perfomance is SO LOW?!

View 5 Replies View Related

Embedded Pics Create Huge File Size

Jun 27, 2006

I'd read a few places that embedding pics wasnt the greatest of ideas, but I thought that 1 JPG embedded onto 2 forms would be ok and would prevent the pic from being deleted or moved. (Theyre always screwing with the server here.) But it's making my DB huge.

No pics embedded
Size: 808kB

1 Pic Embedded into 2 forms
Pic Size: 156k JPG
DB Size: 135 MB

Is this normal? I could understand a 156k pic adding somewhere around 156k to my DB, but 134 megs? Anyone have any insight?

View 4 Replies View Related

Huge Report With Visits Per Customer - Get Information Of Last Visit

Dec 2, 2013

We have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

How to handle this in MS access 2010?

View 2 Replies View Related

Queries :: Huge Report With Visits Per Customer - Grab Information Of Last Visit?

Dec 2, 2013

we have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

how to handle this in MS access 2010?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved