Crazy Thing
Aug 30, 2005
I've been ask to think of some solution to this problem but i'm no way near of it. I have a txt file (ascii) with aprox. 1845000 lines.
The code is something like this:
"++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++
Date:02-12-2004Time: 11:06:24
Job Number:2542
Job Name:al
Priority:Normal
User Name:msescudeiro
Customer:
Account:1341000
Distribution:
Notes:
--------------------------------------------------------------------------------
Original Filename:C-0884_Vers_E.TIF
recycled paper
Used Area:0
Plotted Area:0
Media:paper
Used Area:4977
Plotted Area:4977
Media:film
Used Area:0
Plotted Area:0
Media:vellum
Used Area:0
Plotted Area:0
Operation Count
Mirror:0
Rotate:0
Zoom:0
Stamp:0
Fold:38
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++
I need to have a table like this:
View Replies
ADVERTISEMENT
Mar 9, 2008
Hi, im currently under going a Driving school project database. I have the following tables, Client, Instructor, Lesson and Lesson Type. However i feel like i want to go into more depth, e.g. make tables like recording sections of theory and practical tests, etc.
Currently my database with 4 tables is in 3rd normal form.. but say if i had 10 tables linking via relationship in query, what normal form is this? Is this gd practice or bad practice? :confused::confused:
This has been going through my head lately and im wanting to get take alot into consideration for my project. This might be absurd question to say in the forum but hope anyone can help me and explanation for me.:o
Thanks and much appreciated! :)
View 4 Replies
View Related
Nov 13, 2007
I make that ERD :-
http://www.imagehosting.com/out.php/i1365582_erd.PNG
is there any suggest to add or remove fields or tables ?
I attached the file.
and thanks.
View 3 Replies
View Related
Mar 25, 2005
I have a very simple (it has to be) database which holds names, address’s and telephone numbers (I told you). What I want to do is this when I come to the Town field, a drop down list is displayed with a few local town names (Peterborough, Huntingdon etc) and the respective STC code (01733, 01480 etc). When I select Peterborough in the town box the STC code 01733 is placed in the STD field automatically. I have two tables, one with the address’s (including Town and STC) field and the second one with two fields Town and STC. How do I get the two tables or forms to work together. Any help would be appreciated, many thanks.
View 1 Replies
View Related
Feb 7, 2006
have a table call 'ClinicTimeTable' there is a column call 'ClinicDate', another column called 'DrID', different row could have same 'ClinicDate' and 'DrID', so I wanna to count how many Drs in a particular day, I have following code, but it acts so werid, it onlys work for some dates! say if I put 02/02/2006 then I can get the number of DrID by observing 'count', however, if I put 01/02/2006 like below, count is 0! but there is some records with 02/02/2006 (I open the table directly in Access), how can this happening? how can it only partly works? it will make more sense if it don't work at all.
Dataset ds = new Dataset();
query = "SELECT DISTINCT DrID FROM ClinicTimeTable WHERE ClinicDate = #01/02/2006#" ;
OleDbDataAdapter myAdapter = new OleDbDataAdapter( query, oleDbConnection1 );
myAdapter.Fill ( ds );
int count = dds.Tables[0].Rows.Count;
any helps will be so appreciated! I am going mad at this problem!
by the way, i just tested that if any day in Jan 2006 is fine, say if i search 23/02/2006 or 22/02/2006 is fine... can't imagine why...
View 3 Replies
View Related
Jul 1, 2006
Moderators - please help. Apparently there's a 70 message limit on saved Private Messages (PM's). I've long since exceeded the limit, but can't find a mechanism in this forum to delete unwanted PM's Where am I going wrong here?
Best wishes - Bob
View 2 Replies
View Related
Jan 3, 2007
I have many queries that all do the same thing. The problem is that they're connected to specific controls on a form, so I have to make a new query everytime I make a new form to perform the same task as the others. This would be eliminated if there was a way to use the criteria the same way you would in code, like Me!controlname. Is there anyway possible to make these queries more universal so that they can be used by many forms?
View 1 Replies
View Related
May 6, 2005
I have a form, with some controls, a subform and some command buttons. In the OnKeyDown Event of the subform, i put the following:
If Me.NewRecord And Keycode = 9 Then
Me.Parent.cmdAddSong.SetFocus
End If
However, as soon as i hit the tab key when i am in the new record of the continuous sub form, rather than it moves to cmdAddSong, the focus is set to the control after it (cmdDeleteSong). Similarly, if i try to set the focus, to the cmdDeleteSong, after i hit the tab key, the focus will move to a next control (cmdAddAlbums).
Any ideas why does the focus does not go to the control i specified in the Me.Parent.Control, but it goes to Me.Parent.Control + 1 ?
Thank You
View 5 Replies
View Related
Aug 11, 2005
gosh, I can't believe I forgot simple thing. when I'm opening a form in Access it automatically goes to new/blank form, I'm try to make it go to first record instead and can't remember how I didin't before.
Thx for help
View 2 Replies
View Related
Feb 11, 2005
This is a lot like my last post, but not exactly...
I have a table with some really strange fields. They all have 4-8 digits, and those digits stand for the date--but not for simple mmddyy. This is much more complicated than that. Each 4 or 2-digit number set stands for something different.
|___START____|_____END____|
|___196303___|___199912___|
|___192603___|___199910___|
|___193101___|___199812___|
|___195606___|___200112___|
|___192801___|___1999_____|
is a sample of the numbers in the fields. Here is the way the website says to define them:
NOTE: The seventh and eighth columns of each document describe the initial and most recent coverage dates using the SICI standard, which defines standard month codes for seasonal and quarterly issues. (A full list of the month codes used for seasonal and quarterly issues appears below.) Dates may appear as a year (1989), a year and month (197601), or a year, month, and day (19331229). Sometimes the format for initial and most recent coverage dates may differ due to changes in publication frequency over the history of the journal. For example, coverage may start with an annual issue (1898) but finish with a monthly issue (199912) or coverage may start with a monthly issue (193002) but finish with a supplemental issue containing no corresponding month (1972).
Month Codes Used in JSTOR Delimited Lists
01=January02=February03=March04=April05=May06=June07=July08=August09=September10=October11=November12=December20=Winter (when it appears at the beginning of a year)21=Spring22=Summer23=Fall24=Winter (when it appears at the end of a year)25=Early Spring26=Late Spring27=Early Fall28=Late Fall29=Early Summer30=Late Summer31=1st quarter32=2nd quarter33=3rd quarter34=4th quarterSo, if it's a 6 digit number, that's going to be 4 for the year, and 2 for one of the codes above.
If it's an 8 digit number, it's going to be 4 for the year, 2 for the month, and 2 for the day.
If it's a 4 digit number, it's just 4 for the year.
There are 665 of these, and I'll need to update them each time I download a new version of the file. So.... can anyone help me? If I could get the numbers into separate cells (at least temporarily), I could do a find and replace and add my final results back together in one cell when it's finished. I would want something that would put the first 4 digits into a cell, then the first 2 digits of what's left into a cell, and then the last two digits of what's left into another cell. I don't mind running 3 different queries.
Thanks,
Siena
View 4 Replies
View Related
Apr 14, 2008
I've been using Access 2002 since approx 2003 now. I won't upgrade as I've used 2007 and don't like the new interface.
I'm competent with it and regularly build locally used databases or databases for websites.
About 2 months ago my copy starting pissing me off. Everytime I click on any of the "create" links, it plays an alert sound. Anytime I click on an already created query/table/report etc it plays an alert sound. The only other time it happens is if I click on the button in the toolbar in windows to open a previously minimised window.
There seems to be no option to turn this off or on anywhere, so I'm completely stumped. It's not critical but it's bloody annoying. Anyone else had this and figure it out or anyone simply know how to stop it doing it?
I could obviously turn the speakers off but I like to listen to music whilst I work, and shouldn't have to either!
Thanks in advance
PS - My "Provide feedback with sounds" option is set to OFF
View 2 Replies
View Related
Aug 24, 2006
Hey all, I've been banging my head all day trying to find a method and have nothing. Perhaps someone could guide me towards the right path... Here's a generic simplification of what I have:
ID# - Friend
1 - Fred
1 - George
2 - Fred
3 - Bill
3 - Ray
3 - Scott
Here's what I'm hoping to end up with:
ID# - Friends
1 - Fred, George
2 - Fred
3 - Bill, Ray, Scott
or even this would get me there:
ID# - Friend1 - Friend2 - Friend3
1 - Fred - George
2 - Fred
3 - Bill - Ray - Scott
I'm dealing with thousands of id#'s and thousands of possible friend's names.
Any help out there? If I need to explain myself better, just ask and i'll write some more...
thanx for any help you can offer...
Jim
P.S. I'm only a lite-weight in programming. I've been trying with a thousand different query methods so far using temporary tables and anything else I could possibly imagine...
View 3 Replies
View Related
Mar 23, 2005
i wanted to be able to send an email with attachement for this i created an outlook object and i filled in all the parameters and it creates the message successfully with the attachement and everything, but when i press send instead of sending the email to the recpient it puts it in the sent items without sending it, unless i opened my outlook and looked into the sent emails box then it sends it, i dont know if i can do something in order for the email to be sent automatically because i dont know if the problem is the code or it s a sort of security thing for outlook
if anyone has an idea.......................
thanks
View 4 Replies
View Related
Feb 17, 2006
I am redesigning an old database. There is a form that has an unbound combo box field that gets its values from a query. Basically, someone will choose a value from the combobox and a subform will display all records for that value.
Here is my dilemma...
In the old database, if I typed an N in that combo box, it would immediately go to the "N"s in the combo. However, in the new database...nothing happens when you start to type in the combo box. You either have to type the whole thing in or actually use the dropdown button. I have checked every setting imagineable...and I can't find how to get it to autofill based on the letters entered. It is driving me nuts!!!
HELP!!
View 5 Replies
View Related
Mar 3, 2007
Hi,
I'm trying to build a mdb which holds customer details, which insurance they have, who sold them this and which Insurance company provided this.
The relations I have to make are driving me nuts !
When I try to enter a new customer in a Form, there is a advisor added, the package the customer wants is added. But this shouldn't happen for the advisor and the package allready exists !
Who can help me with the proper relations ?
Attached is screendump of the current relations.
Thanks a lot !
View 8 Replies
View Related
Nov 14, 2007
I posted this in the wrong thread yesterday
I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct code in the format field:
"Not Completed "[Red];" Completed "[Green]
This worked for different field before I created the split form but now I cannot get the new field to display anything but check boxes regardless of what code I use. It won't even let me use the default yes/no, true/false or on/off options.
I've been studying this for about 2 weeks and I've figured out quite a bit but this one thing is really iritating me....
Help
Any comments would be appreciated
John
View 3 Replies
View Related
Oct 18, 2006
Hehe... and since me and my girlfriend just broke up, that seems applicaple both in the dbase and the real world ;)
I have one Access Database. For now containing three Tables:
KlantNAW (customer adress data) with one primary key, Klantnummer (clientnumber) which is an Autonumber Data Type, Long Int, Increment, Indexed: Yes (No dupes).
CaseDateTimeInfoTable with one primary key, Casenumber which is an Autonumber type, Long Int, Incremental, Indexed: Yes (No dupes).
Within this table I have included the Klantnummer field from KlantNAW as a Number, Indexed: Yes (dupes OK).
CaseTechInfoTable with no primary keys but with both the KlantNummer field and the CaseNumber field included. Both have a direct relationship to the tables in which those two values are created. Both values are now of type Number, both are Indexed, but Klantnummer is set to Duplicates OK and Casenumber is set to No Duplicates. I don't know if it might be wiser to just not index those values in this table, since they are already indexed in the tables in which they are created, if someone could tell me which is better in this case, please do.
I have created a one-to-many relationship (well actually, access seems to decide whether it becomes a one-to-many or one-to-one relationship) between KlantNAW.Klantnummer and CaseDateTimeInfoTable.Klantnummer with Join Type 1 and I've created a Join Type 1, one-to-many relationship between KlantNAW.Klantnummer and CaseTechInfoTable.Klantnummer.
There is only one extra relationship left, which is a one-to-one, Join Type 1 CaseDateTimeInfoTable.CaseNumber with CaseTechInfoTable.CaseNumber.
So ehrm.... a recap:
KlantNAW.Klantnummer (P-key) with CaseDateTimeInfoTable.Klantnummer
KlantNAW.Klantnummer (P-key) with CaseTechInfoTable.Klantnummer
CaseDateTimeInfoTable.CaseNumber (P-key) with CaseTechInfoTable.Casenumber
If I leave it like that the dbase works perfectly except for the fact that when I delete a customer the related case date/time info and the case tech info don't delete with the client account accordingly.
So, I thought I'd "Enforce Referential Integrity" and "Cascade Delete Related Records". I do not know if it would be wise to also enable "Cascade Update Related Fields". Could someone please tell me if that would be wise to do or not? And maybe even why... I have some beginner and more advanced books but can't be sure, probably because of lack of experience (or maybe lack of brains ;) ).
Anyway, back to the problem: when I make all the relationships to Enforce Rererential Integrity and I add a customer through a form (KlantNAW_InvoerForm) and click the "Create new case for this customer" button, the form I use for entering the case date info pops up nicely, but when I try to close that form I get an Error stating: "You cannot add or change a record because a related record is required in table "KlantNAW"". So, I click ok, then get a messagebox stating I can't save the record at this time. Do I want to close anyway? .... well, ok. Let's do that. And now the strange thing is that after that, when I do absolutely nothing other than pressing the create new case button again, enter the date/time info into the form and close it again, no errors or messages come up. Wel... that should happen the first time around right? What's wrong?
Now... I'm really lost. I'm new at this. I made some tables, queries and forms, set all options for all values, that which I didn't understand mostly tried solving or finding out on my own but now I'm hitting a brick wall.
If you guys and gals could help me out I would really be very grateful for that.
EDIT: I even tried making it more simple by removing all relationships and creating just one new one between KlantNAW.KlantNummer and CaseDateTimeInfoTable.Klantnummer (type 1, enforce referential integrity and cascade deleted records) but still, the same problem arises.
EDIT2: made sure it was not a form thing by just putting in data in the table data views directly. Same thing occurs.
View 14 Replies
View Related
Nov 13, 2007
I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct code in the format field:
"Not Completed "[Red];" Completed "[Green]
This worked for different field before I created the split form but now I cannot get the new field to display anything but check boxes regardless of what code I use. It won't even let me use the default yes/no, true/false or on/off options.
I've been studying this for about 2 weeks and I've figured out quite a bit but this one thing is really iritating me....:eek:
Help
Any comments would be appreciated
John
View 3 Replies
View Related
Jul 19, 2005
I am trying to create a chart on a Form. In Excel I have no problems arranging my data. This is my first try for charts in Access. I have a table. I created a query summing two fields of this table:
Total Workers
Total Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[ClockNbr]<>'*'")
Total Workers = 120
Total Verified
Verified Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[StaPrimary]=True")
Total Verified = 43
So far so good. That is the correct information. What I want in a Chart is two bars side by side. One bar at 120 and the other bar at 43. I have tried everything and cannot get this to work. I am getting confused on the Axis, Data, & Series. I think I need another Field somehow. The totals I would call Monthly Totals
Could someone please help me get this thing started. I have wasted a week and feel like I have learned nothing except how to count in the Query.
After this I would like to be able to show a percentage of those verified. I have 120 workers and 43 are verified. That would be approx 35%. Anyway I am assuming that there is a solution and that I am just floundering for nothing. Thanks in advance.
View 8 Replies
View Related
Aug 9, 2005
I am biulding a database with quite a few subforms but now I have a wierd problem.
I am building a form that displays upcoming IT courses. so I have sumbforms for word, excel, outlook... you get the picture.
All the subforms work well except the outlook subform. When I create the subform with a wizard. When I go into form view mode to check, the form displays Outlook courses. When I save the form, the outlook subform then changes itself to Excel!
When I open the excel form and the outlook forms independently (not as subforms) the work fine and the data sources (queries are correct)
I've tried deleting the subform over and over again but everytime I hit the save button, The outlook form reverts to Excel.
I've gone as far as checking if there is any code behind the main form that makes this happen, but nothing.
Can anyone heelp>? this is driving me crazy! :confused:
View 2 Replies
View Related
Jul 14, 2006
I am pretty sure that this is crazy! I have attatched a word document (the quickest way for me to show and explain at the same time) that shows in a print screen picture what I want done with this form. There is colored text explaining. Any questions feel free to ask. I am pretty sure that this is ridiculously tough and am not sure that it is even possible with access. Please help, and may the gods give tons of wealth to whomever can solve my problems.
View 1 Replies
View Related
Jul 14, 2006
I am looking at a database where the Primary Key is a composite of the customer's First & Last name. Obviously a huge problem! The funny thing is, the table was set up to with an Autonumber CustomerID, so all customers have this information already.
Here's the question: there is a one to many relationship with an orders table, how can I change the primary key from the composite key it uses now, to the autonumber field and not mess up the relationships?
Thanks for help in advance.
View 5 Replies
View Related
Apr 14, 2006
Greetings,
I searched on IMPORT, but didn't see anything like the problem I have.
I have a large Excel file formatted thus;
COLUMN A COLUMN B COLUMN C
1 Full Name
2 Full address
3 City State Zip
4 Phone SSN Sex
Alas, as you can see, the first four rows contain information on one person, then Column B contains just their SSN on Row 4, and so forth.
Row 5 begins the cycle again. This goes on for 160 people.
Is there a way to get the employee information contained in Column A in a 'nomalized' format, such as Full Name in Col A, Full Address in Col B, and so on?
Unfortunately, it's illegal here to whack the person who provided this data to me.
Thanks in advance !!
View 3 Replies
View Related
Jan 14, 2008
Hi All,
I have a table with starts with an autonumber as a primary key.
Recently it has been giving out crazy high and sometimes negative numbers when a new record is created
Dose any know what might cause this?
p.s. I've tried compacting and repairing the DB
- E|fmAn
View 5 Replies
View Related
Apr 15, 2006
Sorry for cross-posting. I posted this in the Tables forum, but have had no replies in over 12 hours.
I searched on IMPORT (72 threads), but didn't see anything like the problem I have.
I have a large Excel file formatted thus;
COLUMN A
1 Full Name
2 Full address
3 City State Zip
Columns B and on have other information for the employee in Column A.
I need to get the employee information in Col A into a tabular form, such as (A) Employee Name, (B) Address, (C) City, (D) State, (E) ZIP
If this could be done with the data in Column A, I believe I could join the employee info currently in Col A to the remainder of the data.
I've also looked at the Excel forum with no luck.
Suggestions would be appreciated !!
View 1 Replies
View Related
May 27, 2006
I have a subform with textboxes for data entry.
I want the last data entered to stay displayed in the textboxes after the form is closed.
When the form is re-opened the textboxes display a row af data several rows down.
How do you link the textboxes to the feilds of the subform the new data is always at the top row.
Example:
Form textboxes data Entry:
Apples Oranges Pears grapes
Click command button to save:
Subform displays
Apples Oranges Pears grapes
Grapes Kiwi Tangerines Corn
Beans Lettuce Okra Rice
Close form Text boxes still display Apples Oranges Pears Grapes
Open form back up
Text Boxes Display
Grapes Kiwi Tangerines Corn
Subform Displays:
Apples Oranges Pears grapes
Grapes Kiwi Tangerines Corn
Beans Lettuce Okra Rice
How Can I make this work Right?
If anyone knows how to do this please Help.
If it must be done in code please provide an example.
I need to get this worked out this weekend.
Thanks for all the help
You guys are great!:D
Charles
View 4 Replies
View Related
