|
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:
|
60
|
164
|
387
|
|
Post:
|
218
|
657
|
1,624
|
|
|
Tables Posting activity graph:
|
Top authors during last week:
user's latest post:
Matching title and gender - Page...
Published (2009-11-25 14:50:00)
Quote: Originally Posted by wiklendt yes, well, having said what i just said, i do get a 'kick' out of using "Miss" on forms that provide the option makes me feel younger! Same here
user's latest post:
Matching title and gender - Page...
Published (2009-11-25 14:14:00)
Quote: Originally Posted by wiklendt you put the code in the wrong place. the code should be in the afterupdate event of the title combo. if you think about it logically, it is the change in title that triggers the gender. now a couple of pointers: first, compact and repair your database before uploading. this drastically reduces the file size (your original file size upon unzipping was over 2mb. after, it was 356 kb) - you can even set this...
user's latest post:
Matching title and gender - Page...
Published (2009-11-25 15:36:00)
Quote: Originally Posted by boblarson Same here hmmm. Miss Bob Larson. has i nice ring to it ;P
user's latest post:
Error message when attaching images
Published (2009-11-24 12:52:00)
After looking at this, you are so right! I didn't realize the pictures were so big and making the file too large. I am compressing them down and hopefully this will work. Thank you all so much for the help! Andie
user's latest post:
Merging databases and filling...
Published (2009-11-20 22:55:00)
Join the tables on Manufacturer and Model. Update your availability based on the field in the master. Don't use special characters, especially # in your fields or table names. I would also change your availability field to a Y/N checkbox. It is easier to manage, much faster and uses less storage than entering "yes", "no". Also avoid using an empty string or Null to indicate anythiing. It is important to...
user's latest post:
My system is changing data i...
Published (2009-11-25 08:37:00)
Perhaps. you could show us what you are actually doing, what is happening etc. Even versions you're using....
user's latest post:
Preventing duplicates of two...
Published (2009-11-17 11:46:00)
bob, a sincere thanks for your time. I'll give those suggestions a go tonight. Thanks again for the help.
user's latest post:
Updating Table with Excel
Published (2009-11-20 10:58:00)
Nevermind! Figured it out. Exactly what I needed to do. Thanks Zaeed
user's latest post:
field properties, lookup, space...
Published (2009-11-20 03:54:00)
Hi David, I can't figure out where to write this Replace() function. Is it after or before SELECT, or FROM? Many thanks,
user's latest post:
Merging databases and filling...
Published (2009-11-21 14:29:00)
This will update all the excel table records to N, or (presumably) Y where the part is available. As I said earlier, it is better to make an entry (as the table supplier has) for "no" to remove the chance of Null and "" being confused. Code: UPDATE [exceltable] SET [FieldB] = [Price].[availability] FROM [exceltable] JOIN [Price] ON [exceltable].[fieldA]=[Price].[Ingram Part Number]; If you choose to convert...
|
|
|
|
Latest active threads on Tables::
Started 17 hours, 43 minutes ago (2009-11-26 16:50:00)
by John Big Booty
Here's a tip; Use the Search function on this forum, and do a search on User Level Security . Once you've had a read through the existing threads you might find that your question has already been answered, or you may find that you have additional questions, in which case we can kick things off from there.
Started 18 hours, 29 minutes ago (2009-11-26 16:04:00)
by ChrisO
Why not create a table and enter the data manually?
Field1…… Field2 (better names required)
1…………...rain
2…………...sun
.
.
.
etc
Started 2 months ago (2009-09-24 08:49:00)
by 1961templar 1961templar is offline Registered User
tbl_Employee
pkEmployee_ID (autonumber)
strTitle (4 char string) "Mr", "Mrs", "Miss" or "Ms"
strGender (1 char string) "M" or "F"
I need to ensure consistency between Title and Gender.
What is the best way to do this? Validation rule?
Thank you.
Started 1 day, 2 hours ago (2009-11-26 08:17:00)
by HiTechCoach
Hiow are you importing?
If using vba code, please post all the VBA code used for this task.
Started 1 day, 3 hours ago (2009-11-26 07:18:00)
by JohnLee
Hi,
In your events table the ChildID should be a foreign Key and not a primary key.
Foreign keys are not autonumbers.
The ChildID number [Foreign Key] in the events table should match exactly the ChildID [Primary key (Autonumber)]number in your table children.
For instance if Paul Hull has an autonumber of 1 in the children table, then in the events table in the ChildID field the...
Started 1 day, 8 hours ago (2009-11-26 01:50:00)
by namliam
Its probably smart to keep the same discussion in one thread? Reported to mods to merge it.
Started 2 days, 6 hours ago (2009-11-25 04:32:00)
by gemma-the-husky
presumably you are not storing these details as numbers, but as text - so you are getting a dictionary sort.
you could try adding another column to a query with the expression val(whateverfield), and sort on that - but this depends on you only having numeric values in the field.
Started 3 days, 14 hours ago (2009-11-23 19:47:00)
by georgedwilkinson
Why don't you just put a unique constraint on the 2 fields that make the
record unique?
Started 2 days, 3 hours ago (2009-11-25 06:44:00)
by tom1252 tom1252 is offline Registered User
I have no idea what is going on and it is only in my staff table.
If i add a new user than when i try and login it wont. I check the table and the first record has been duplicated.
I have no idea why but its changing my data how can this be stopped?
Started 2 days, 7 hours ago (2009-11-25 03:03:00)
by YNWA Registered User
Hi, I have a few forms for submitting employee payments to a database, the forms will then run a report to pull off certain payments within a certain date for a specific employee.
So I select employee, enter dates and click search. I then view report and all calculations are made based on pension etc...
I have my forms running off a query.
I it works fine if I didn't have to edit ...
|
|
Hot threads for last week on Tables::
Started 2 months ago (2009-09-24 08:49:00)
by 1961templar 1961templar is offline Registered User
tbl_Employee
pkEmployee_ID (autonumber)
strTitle (4 char string) "Mr", "Mrs", "Miss" or "Ms"
strGender (1 char string) "M" or "F"
I need to ensure consistency between Title and Gender.
What is the best way to do this? Validation rule?
Thank you.
Started 2 days, 23 hours ago (2009-11-24 10:54:00)
by HiTechCoach
How big is the database file? There is a 2 gig file size limit.
Have you compact the database lately?
Started 1 week ago (2009-11-19 16:50:00)
by Zaeed
You could link to the excel file so that access treats it like a table.. That way whenever the excel file is modified the database is also..
Started 1 week ago (2009-11-20 02:54:00)
by DCrake
You can use the Replace() function
FullName:Replace(Forename & " " & Middlename & " " & LastName," "," ")
David
Started 6 days, 11 hours ago (2009-11-20 22:55:00)
by Galaxiom
Join the tables on Manufacturer and Model. Update your availability based on the field in the master.
Don't use special characters, especially # in your fields or table names.
I would also change your availability field to a Y/N checkbox. It is easier to manage, much faster and uses less storage than entering "yes", "no".
Also avoid using an empty string or Null to indicate anythiing...
Started 2 days, 3 hours ago (2009-11-25 06:44:00)
by tom1252 tom1252 is offline Registered User
I have no idea what is going on and it is only in my staff table.
If i add a new user than when i try and login it wont. I check the table and the first record has been duplicated.
I have no idea why but its changing my data how can this be stopped?
Started 1 week, 5 days ago (2009-11-15 07:17:00)
by gemma-the-husky
not 100% sure exactly what yuo are saying
but
1. dont touch the csv - if you need to inspect it open it , and save as an excel sheet, but dont change the csv. - just import the csv into access
2. you can then add extra columns for the additional fields in yuor tables and not in the csv
3. it depends how you want to assign your ids to this table - do it manually by inspection ...
Started 3 days, 14 hours ago (2009-11-23 19:47:00)
by georgedwilkinson
Why don't you just put a unique constraint on the 2 fields that make the
record unique?
Started 6 days, 7 hours ago (2009-11-21 02:42:00)
by lse123 Registered User
how i change privilege on a db table: select , insert, delete, update ?
access 2003
Started 4 days, 17 hours ago (2009-11-22 17:33:00)
by jdraw
Quote:
Originally Posted by Louiscande
Hi there,
I have a database that has field "location".
In this field shows the following for one record:
203:4~204:7
Which mean: In location 203 a qty 3 of an item and the same item is in location 204 qty 7.
I want to break that field at the "~" and have two records with ...
|
|
Size: 495 bytes
