|
More site info...
|
|
Forum profile page for Tables on http://www.access-programmers.co.uk.
This report page is the aggregated overview from a single forum: Tables, located on the Message Board at http://www.access-programmers.co.uk.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Tables" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Tables:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
55
|
144
|
383
|
|
Post:
|
239
|
597
|
1,537
|
|
|
Tables Posting activity graph:
|
Top authors during last week:
user's latest post:
Index Message
Published (2009-11-06 07:15:00)
Thanks Gemma. Good answers.
user's latest post:
Date or Text field? - Page 2 -...
Published (2009-11-06 03:48:00)
Quote: Originally Posted by Brianwarnock Careful of your bloodpressure Namliam. Nothing wrong with my bp... but thank you for the concern Quote: Originally Posted by Brianwarnock Your posts implied that he should have a real date in his data, I say he does not need one,.... I asked how it was to be run but did not get an answer. And this is the problem now a days with many people. 1) Not answering questions (in full) 2) Not listening to...
user's latest post:
Calculation Column
Published (2009-11-05 13:25:00)
You can however do: Code: SELECT IIf([col2]=0,0,[col1]/[col2]) AS Calculation FROM Table1;
user's latest post:
S.O.S:Export Table to Text with...
Published (2009-11-06 06:58:00)
you may find it hard getting the delimited data via a report. A report is designed to look like printed report - not a csv. the thing is that exporting a csv produces a csv, either with or without a header row. Having additional data in the csv file just stops it being a csv. you could either add todays date into an extra column in the query, or save the date in the file name the same thing with the footer. the row count is obvious from the...
user's latest post:
Date or Text field? - Page 2 -...
Published (2009-11-06 03:54:00)
Quote: Originally Posted by namliam And this is the problem now a days with many people. 1) Not answering questions (in full) 2) Not listening to advice given 3) Oh well, it must be me Nope I think that we are all finding that more and more often, also some adopt an abrasive style, Genesis springs to mind, I just bail out but some of you younger members have more staying power. Brian
user's latest post:
Date or Text field? - Page 2 -...
Published (2009-11-05 09:10:00)
You were right Brian, got it working. But think I should add 3 instead, to take it into 4 months. Clever solution and mucho thanks.
user's latest post:
Index Message
Published (2009-11-05 19:41:00)
i think you can use the dlookup function and evaluate for existing records. that way you can customize you msgbox. still use the docmd.setwarnings false after that evaluation procedure.
user's latest post:
Insert DATA
Published (2009-11-08 00:53:00)
Change you query to an UPDATE query and indicate the fields that are to be updated with the values in the query.
user's latest post:
Filenames as fields.
Published (2009-11-07 20:46:00)
Yes, Access forms can be set up that way. So can Excel forms.
|
|
|
|
Latest active threads on Tables::
Started 1 week, 1 day ago (2009-11-02 14:22:00)
by boblarson
The junction table would have
ClientsService - Autonumber (PK)
clientID - Long Integer (FK)
ServiceID - Long Integer (FK)
And normally (in this case, based on your description) you would have the Client table be the basis of the main form and then the subform would be the junction table and you the Master/Child links would be on clientID and you would set serviceID by using a combo ...
Started 1 month ago (2009-10-08 07:25:00)
by Mr. B
Robert,
Use the "Linked Table Manager" to specify the new location of your linked tables.
Started 3 days, 1 hour ago (2009-11-07 15:49:00)
by georgedwilkinson
Quote:
Originally Posted by akedm
I want to basically make a spreadsheet
If you want a spreadsheet, I recommend Excel. You will just be hobbling Access if you come in to it with a spreadsheet mentality, and Excel is very excellent at working with spreadsheets.
Quote:
...
Started 2 days, 3 hours ago (2009-11-08 13:51:00)
by ChrisO
I would guess 500,000 would max out around 750 million bytes.
But if itÂ’s important to know for sure then I would be inclined to create a loop of 500,000 and append three 256 character strings in each record to the table.
Alternatively, run the loop till you get near 2 gig (or crash) and see how many records you get.
Started 2 days, 5 hours ago (2009-11-08 11:35:00)
by lagbolt
Your HoursWorked table needs a new unique index on the Date and EmployeeID fields. Find the index button for the table in design view, create a name, add the fields, set the Unique property to 'Yes'.
The impact of this is that the table will not allow the duplicate entry.
Cheers,
Started 2 days, 10 hours ago (2009-11-08 06:24:00)
by Fifty2One
probably a good way to have it would be a table for the demographics and a second one for this particular survey and a third for the Error, Remediation and Closure - they will probably after the fact ask for the initiation date for the Error and Remediation as well as the Closure date.
In all three tables you would need a uniquifier so you can link the tables together - patient number or ...
Started 2 days, 16 hours ago (2009-11-08 00:38:00)
by vvasudev Registered User
I have 2 Tables
- TABLE1(12 fields that are EMPTY)
-TABLE2(2 FIELDS that are filled)
I want to insert the Data in TABLE1 to column numbers 2 and 3 of Table 1 PLEASE advICE!!
Started 2 days, 20 hours ago (2009-11-07 20:34:00)
by georgedwilkinson
Use a primary key that has nothing to do with anything (preferably autonumber). Put a Unique Index on the 2 fields you were referring to.
Better yet, normalize. A "ring" is a discrete thing I take it that is in no way associated to a bird in its natural environment. As such, you should be able to use it as a FK to multiple breeding records.
Started 4 days, 3 hours ago (2009-11-06 13:30:00)
by John Big Booty
Firstly Welcome to the forum.
assuming your data is correctly Normalised you should be able to do what you want using a query.
Started 5 days, 8 hours ago (2009-11-05 08:27:00)
by Atomic Shrimp
Do the tables include an identifier by which you can ascertain which product was sold and when that specific product broke? (something like a transaction number, or in the case of multiple line transactions, a transaction number plus item ID?)
You need some way of identifying which breakage event corresponds with the item from which purchase event.
|
|
Hot threads for last week on Tables::
Started 5 days, 12 hours ago (2009-11-05 04:40:00)
by namliam
If the text is english, you can "simply" use CDate to convert the month/text to a real date then search on that...
Started 4 days, 21 hours ago (2009-11-05 19:11:00)
by genesis
can you tell what is that error.
If what I am thinking is the same with my problem before, you can use docmd.setwarnings false before your codes starts. that will prevent the error message from popping up.
Started 5 days, 16 hours ago (2009-11-05 00:34:00)
by georgedwilkinson
Yeah, it is bad design. It shows that the human race has not evolved enough to be able to anticipate the consequences of their actions.
Started 5 days, 15 hours ago (2009-11-05 01:14:00)
by namliam
both are valid and both have positives negatives.
Personaly I am a strong believer of the meaningless hidden autonumber key on all tables, INCLUDING the Order table.
Furthermore I dont particularly see a use for the OrderLines table, what data would be stored there that is particular to the line but not the article/detail?? I would probably skip that table all together...
Started 2 days, 16 hours ago (2009-11-08 00:38:00)
by vvasudev Registered User
I have 2 Tables
- TABLE1(12 fields that are EMPTY)
-TABLE2(2 FIELDS that are filled)
I want to insert the Data in TABLE1 to column numbers 2 and 3 of Table 1 PLEASE advICE!!
Started 4 days, 21 hours ago (2009-11-05 19:24:00)
by John Big Booty
Sorry I'm not quite sure what you are looking for the thread title says Dont' want Access to put 0 for Default Value then you go on to say you don't want Access to always leave the field blank
In short you can put any value you like in the default value setting at table level.
Started 5 days, 16 hours ago (2009-11-05 00:51:00)
by georgedwilkinson
This feature of all DBMSs is critical. Especially if you get into reporting databases.
Just remember, the more indexes you have, the longer inserts will take. As long as you don't go crazy, it shouldn't be a problem.
In your example, many DBMSs would not use the firstName field of the index because you didn't compare the MiddleName. The keys are used in order that they're placed in the ...
Started 1 week ago (2009-11-03 11:51:00)
by boblarson
The answer is YOU DON'T DO THIS. At least not until Access 2010 comes out and you buy it and then have DATA MACROS and/or Calculated Fields to maintain this. There is no way currently to have a table make a change to data within the table based on data in another column. Access doesn't have "triggers" like SQL Server. And so the normalization answer says you should not be storing data that is...
Started 1 week, 1 day ago (2009-11-02 08:54:00)
by Brianwarnock
Quote:
Also need to make sure that if queue name is not found on weekly file than need to leave this blank or with a 0.
This sentence makes no sense to me.
Brian
Started 5 days, 16 hours ago (2009-11-05 00:34:00)
by genesis
i think its the field types there. for example there is no smallint field type in access. I think you should familiarize yourself first with table field types.
|
|
Size: 602 bytes
