|
More site info...
Access World Forums - www.access-programmers.co.uk | Site profile
|
|
Site profile page for http://www.access-programmers.co.uk.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.access-programmers.co.uk.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.access-programmers.co.uk is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Access World Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
864
|
2,923
|
8,213
|
|
Post:
|
3,274
|
11,608
|
33,000
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Access World Forums (http://www.access-programmers.co.uk)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Access World Forums posting activity graph:
|
|
http://www.access-programmers.co.uk Alexa graph:
|
Top authors on Access World Forums during last week:
user's latest post:
Displaying movies within a form
Published (2009-11-21 20:34:00)
Quote: Originally Posted by CEH I'm lost.... Are you trying to attach something to your post and it won't let you??????? No, I think it is YOUR attachments on YOUR thread Curtis that they can't get because they were never approved by a moderator or admin.
user's latest post:
Export to CSV without text...
Published (2009-11-21 12:09:00)
You should be able to export it manually, and create a specification (Save As after the Advanced button). Then you should be able to specify that named specification as one of the arguments of TransferText.
user's latest post:
generatnig serial numbers
Published (2009-11-21 17:08:00)
Quote: Originally Posted by mehdi Thanks Adam But I for got to mention that, the Serial number has to be generated by concatenating some other filed in the same table and some random numbers. Mehdi Mehdi, I gave an answer to the question. Sometimes, but very rarely, it teaches people how to be specific. As for Bob, he's too specific for his own good. thanks for the philosophical response bob, but I'm nowhere near smart enough to...
user's latest post:
Opening Excel files from Access...
Published (2009-11-21 16:01:00)
Quote: Originally Posted by ajetrumpet I'm sorry...isn't that supposed to be Windows XP, NT, 2000, or VISTA? Might be wrong, but I was under the impression that ALL programs are accessed through windows. Doesn't a computer need an OS to operate anyway? i think it would be logical to assume the OP meant "office" 2003...
user's latest post:
Sarah Palin - Page 3 - Access...
Published (2009-11-21 12:00:00)
Quote: Originally Posted by KenHigg Yeah - Kind of like brits taking jabs at american politicians 'Stick to hockey luv' - Give me a break... we take jabs at all politicians, No scrub that , we take jabs at anything and everything that needs a good poke. Brian
user's latest post:
Help Please!!
Published (2009-11-20 22:32:00)
You're welcome! Glad we could assist.
user's latest post:
Iran: A Nuclear Power? - Page 3...
Published (2009-11-21 23:52:00)
Quote: Originally Posted by Thales750 I'm not sure they were in anger Col. I think at the time they were in self preservation. But why would you care, we had already beaten your enemy for you. Remind us again where else you've managed to win a large conflict without OUR help
user's latest post:
NetWorkHours() Not Working
Published (2009-11-21 08:38:00)
NetWorkhours = (intGrossDays - 1 - nonWorkDays) * 9 Well.... intGrossDays is 1 (intGrossDays = DateDiff("d", (dteStart), (dteEnd))) nonWorkdays is 1 (as per it is saturday) 1 - 1 - 1 = -1 * 9 = -9, makes perfect sence to me The problem is in your logic, not the code itself... It basicaly assumes that the start day is a weekday.... not a weekend... or even holiday.
user's latest post:
Re: Iran: A Nuclear Power?
Published (2009-11-21 19:30:00)
Quote: Originally Posted by Thales750 I'm not sure they were in anger Col. I think at the time they were in self preservation. But why would you care, we had already beaten your enemy for you. That art to stir him up. LOL I wanted to say that too, but I know what col is like. There is no winning with him. I don't even think it's about winning, more about stirring shit up.
user's latest post:
EDI Integration Problem
Published (2009-11-21 01:32:00)
I've worked with EDI applications in a number of contexts - both generating outgoing files and parsing incoming ones, but it sounds to me like your file is coming out of an application that translates the highly-structured raw EDI message into a flat file table - am I right?
|
|
|
Top 10 active forums on Access World Forums during last week:
|
|
Top 10 forums on Access World Forums:
Forms
- 82,966 posts
|
Modules & VBA
- 60,975 posts
|
General
- 56,458 posts
|
Queries
- 52,129 posts
|
The Watercooler
- 29,668 posts
|
Reports
- 20,520 posts
|
Tables
- 17,456 posts
|
Politics & Current Events
- 16,849 posts
|
Excel
- 5,294 posts
|
Theory and practice of database design
- 4,452 posts
|
|
|
|
|
Latest active threads on Access World Forums:
Started 4 days, 2 hours ago (2009-11-19 01:23:00)
by John Big Booty
Welcome to the forum and congratulations you have inadvertently discovered one of the evils of table level lookups .
Started 2 days, 5 hours ago (2009-11-20 21:58:00)
by HiTechCoach
Welcome to AWF!
A simple method would be to add a status field to the books table. You could then create two forms using the books table. For the issues books form, you would filter the books table in the query to only show issue books. By simpling changing the value in a field, the data move move between forms by using a filter, not by actually moving the data.
I normally would create a ...
Started 7 hours, 2 minutes ago (2009-11-22 20:28:00)
by boblarson
Just curious why you are wanting to do this instead of just setting the rowsource of the combo box at design time. I don't see any WHERE clause which would limit it based on anything so it would be fine to just set the row source and the column widths and all at design time and if you want the latest data just use this in the click event of the combo:
Me.cboDefectGroup.Requery
Started 2 days, 5 hours ago (2009-11-20 22:20:00)
by HiTechCoach
It appears that you are trying to use a "Like" for numeric data? "Like" is used for alphanumeric data (text). Where you want to match part of a string.
Numbers match ( 1 =1 ) or don't match ( 1 <> 2 ). You probably will need tot change the Like to =
Started 9 hours, 57 minutes 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 ...
Started 20 hours, 37 minutes ago (2009-11-22 06:53:00)
by stopher
Sorry but I don't understand your question. Maybe you could explain the purpose of each table. Why do you need to copy data from one table to another? This is not normally a good thing to do.
Chris
Started 7 hours, 25 minutes ago (2009-11-22 20:05:00)
by boblarson
1. You should not be STORING the Description; just the part number.
2. You can DISPLAY the description by setting the text box's control source to be:
=[YourComboBoxName].[Columns](1)
which sets it to the value of the second field in the combo (because it is zero-based).
Started 2 days, 23 hours ago (2009-11-20 04:29:00)
by Rich
Your pictures don't show in this part of the World
Started 10 hours, 58 minutes ago (2009-11-22 16:32:00)
by David Eagar
How does everyone handle different screen sizes?
Badly!
|
|
Hot threads for last week on Access World Forums:
Started 3 days, 15 hours ago (2009-11-19 11:45:00)
by Thales750
Follow up
http://www.time.com/time/world/artic...ullworld-ya hoo
All of the free world (and the not so free as well) has a dog in this fight.
Started 1 day, 22 hours ago (2009-11-21 05:29:00)
by ajetrumpet
I think Sarah Palin is an incredible flake, hands down. And how about those sexy banner ads in US metro areas? Talking about hanging yourself out to dry. She's really putting herself out there and making a fool of herself. But at least she knows how to get peoples' sleaze bag attention spans going. Sex and drugs. What else in the good ol' US of A?
Let us look forward to 15% unemployment....
Started 2 days, 19 hours ago (2009-11-20 07:34:00)
by Brianwarnock
You haven't also called the module minimum have you?
Brian
Started 3 days, 18 hours ago (2009-11-19 08:45:00)
by boblarson
Quote:
Originally Posted by christakis
Hi guys,
With your help I have reached the final stages of my database design. The database is now aprox 6MB. Around 15 users will be using it (rarely at the same time) The database is in one mdb file and stored on a shared drive. Do you think its worth splitting it into a front/back end or ...
Started 3 days, 19 hours ago (2009-11-19 08:25:00)
by boblarson
Quote:
Originally Posted by jcraw42
I have a document with the forms and design view included, but am unable to upload it due to size restrictions (419kb). The forum only allows 100kb uploads.
Did you zip the file? A Zip file can be up to 785Kb.
Started 2 days, 14 hours ago (2009-11-20 12:44:00)
by mikerea90 Registered User
Hey all,
Does anyone know how to run an update query on a specific record in a list box upon double-clicking on that record?
Thanks
Started 6 days, 17 hours ago (2009-11-16 09:54:00)
by fenhow Registered User
Hi,
I have a subform that has two cols in it.
Acres and Status
In the header of the sub-form I would like to show the following:
Total Acres where Status is = to Good to Go.
I was thinking I could put a unbound txtbox on there but am not sure of what to put as the control source.
Can anyone help me?
Thanks.
Fen How
Started 5 days, 16 hours ago (2009-11-17 11:21:00)
by wtrimble
sorry tables didn't come out so well after typing in.....just starting out
with these blogs...
Started 1 week ago (2009-11-16 00:43:00)
by Atomic Shrimp
It's meant to be: used to.
The reason use to is common is that in spoken form, the D sound often gets dropped or merged into the T sound that follows it - and people hearing this (especially kids) acquire the habit of writing it as it sounds.
Same sort of thing with 'could have' - because people tend to say it as "could've", many people mistakenly write it as 'could of '
Started 1 week ago (2009-11-16 02:05:00)
by GalaxiomAtHome
Wow that is a vast database just for invoices. You must have a lot of transactions.
Either that or your database is not storing it efficiently.
|
|
Size: 191 bytes
