|
More site info...
|
|
Forum profile page for General on http://www.access-programmers.co.uk.
This report page is the aggregated overview from a single forum: General, 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 "General" 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 General:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
154
|
495
|
1,496
|
|
Post:
|
650
|
2,037
|
5,813
|
|
|
General Posting activity graph:
|
Top authors during last week:
user's latest post:
To Create or Not to Create...
Published (2009-11-08 22:40:00)
only when I create query that needs relationship I create relationship between tables. I do not establish Referential Integrity.
user's latest post:
Windows vista to windows 7...
Published (2009-11-09 14:01:00)
Quote: Originally Posted by Vassago I also agree. Windows 7 is by far a huge improvement over not only Vista, but XP. It actually runs faster on my laptop than XP every did. Hey and Vassago, welcome back to the ranks of the mods.
user's latest post:
Empty Listboxes in distributed...
Published (2009-11-05 07:25:00)
Have you checked for missing references in the front end yet. Are they all the same O/S with the same SP? David
user's latest post:
Switchboard issue
Published (2009-11-07 09:56:00)
Hi All, Could anybody tell me please why a switchboard created in Access 2007 produces an error message, something like "Error: Var("Switchboard")" in both Access 2000 AND 2003, despite saving the database in the relevant compatible file format? There is nothing at all complicated about the switchboard, and it was just created using the switchboard manager and the drop-down menus therein. In other words no...
user's latest post:
Re: How to talk to a programmer
Published (2009-11-09 05:21:00)
its like anything - say fixing a car if you ask a mechanic what to do, and ignore his recommendations - you cant expect him to help later on when you get in a fix. and if you ask silly stuff, he probably wont bother trying to help in the first place.
user's latest post:
datediff() - Page 2 - Access...
Published (2009-11-03 07:43:00)
because X is a result of doing the datediff(expr) function on a record in a report. the datediff() changes in every record. My results are 0-24 across all records, I am just trying to populate a text box with a number on a report.
user's latest post:
Normalization? What does this mean?
Published (2009-11-09 13:10:00)
Quote: Originally Posted by georgedwilkinson The purpose of normalization is to remove data anomalies. Examples are helpful in understanding normalization. A good site for data modelers is the data administrator's network (www.tdan.com) . There are articles and examples. George, your link doesn't work... I will try typing the address in manually.. *sigh*
user's latest post:
How to talk to a programmer -...
Published (2009-11-06 03:52:00)
Quote: Originally Posted by Brianwarnock but you can never legislate against syntax errors Yes Syntax errors well they will happen and do happen. Yet there is a tool Debug.print which somehow magicaly doesnt seem to work?? This shows you the sql then you can track down the error. So ... barring giving him the exact position of the exact line of the exact part of the sql where he is missing a space.... Barring copying the sql and physicaly...
user's latest post:
Stock control system
Published (2009-11-08 19:14:00)
First off welcome to the forum. You could do worse than have a browse through the Sample DB Section of the forum. Here's one stock control DB I found there may well be others. You could also have a trawl through this site it may have something.
|
|
|
|
Latest active threads on General::
Started 1 day, 5 hours ago (2009-11-10 10:19:00)
by AJordan Registered User
I have had a similar issue with Access 2007, however, I went with the
theory that the computer was old/not updated with the latest windows
updates. I did realize that if I hit refresh (F5) the graph would show on
that computer.
Started 1 day, 5 hours ago (2009-11-10 10:40:00)
by hardhitter06 Registered User
It's a Notepad document with text seperated by commas which respresent different fields. Editing this document is not possible (it comes from another source).
Started 1 day, 6 hours ago (2009-11-10 09:17:00)
by hockeygoalie29 Registered User
Quote:
Originally Posted by boblarson
Why do you need the linked table manager available when the nav pane is locked? It does this by the way because in the linking process you are viewing the tables that are there.
In the navigation pane, I have hidden the queries and macros to keep users from modifying them. In ...
Started 3 weeks, 6 days ago (2009-10-15 09:48:00)
by Scooterbug
I'm assuming that all the tracking numbers are the same number of digits. You can use the following code:
Code:
dim sMyNumber as text
sMyNumber = mid(me.TrackingNumber,17,12)
This will tell access to go the 17th number and grab the next 12.
Started 2 days, 23 hours ago (2009-11-08 16:34:00)
by John Big Booty
Is this a DB that you wrote and have now forgotten the Pass Word?
Started 1 day, 8 hours ago (2009-11-10 07:01:00)
by Banana split with a cherry atop.
Thanks for the clarification.
Did you create the groups then add the users to the group afterward?
Started 1 day, 10 hours ago (2009-11-10 05:42:00)
by sistemalan Registered User
You fear correctly.
I will read up on how to split databse into front end / back end.
Cheers
Started 1 day, 12 hours ago (2009-11-10 03:12:00)
by lisamariab Registered User
"Remember 1 student can pay one fees per term and this term will repeat each year. The types of fees can be sourced in the payments table and how they paid come from the methods table. "
Thanks for yr fast reply
Can u explain more what i have to do make the term repeat each year? This will mean creating new records right? But do i have to create each term for each student manually (there ...
Started 2 days, 16 hours ago (2009-11-08 23:00:00)
by orna
Look at Hartman's grate sample at
http://www.access-programmers.co.uk/...d.php?t=153 459
|
|
Hot threads for last week on General::
Started 1 month, 3 weeks ago (2009-09-18 23:47:00)
by Atomic Shrimp
+1
I would add:
Don't get shirty and defensive when we ask for details of your existing application/code/data
or if we ask for an explanation of what you're trying to do in a real-world context.
We're not the slightest bit interested in stealing your idea, or data - it's just impossible to help you unless you properly explain what it is you're trying to do.
Started 1 week, 1 day ago (2009-11-03 03:43:00)
by DCrake
You code is wrong
There are three things you need to provide
1 the time value you want to see (days, months, years, etc)
2 the lower date
3 the upper date
Example
Elapsed = DateDiff("d",Date(),[DOB])
This shows the differenc ein days between the date of birht and today.
Form more help type in DateDiff and press F1.
David
Started 1 week, 1 day ago (2009-11-02 19:56:00)
by pbaldy
An append query adds new records, an update query modifies existing
records.
Started 6 days, 6 hours ago (2009-11-05 09:26:00)
by music_al
Your post is a bit unclear, but if you are asking how to increment a value in a textbox by one each time a button is clicked, then on the click event of your button you need something like...
YourTextBox.Value = YourTextBox.Value + 1
Started 1 week, 2 days ago (2009-11-02 09:33:00)
by boblarson
My suggestion -
Visual C#.NET
Started 3 days, 17 hours ago (2009-11-07 22:09:00)
by HiTechCoach
I use multiple back ends a lot. I have for years without any issues. I even have back end in different formats. Some table in an Access database and some table in an SQL server.
With multiple back ends, you can not enforce RI between table in different back ends. You have to write your own code to enforce it.
I am really curious:
What was the reason not to have multiple back ends?
Started 1 week, 1 day ago (2009-11-02 20:43:00)
by datAdrenaline
I think you will need to give us more to go on, like what is your intent ... I know you want two db's to be same, but to what degree ... for example, do you want them as close to real time as possible? ... Which one is the master? ...
Also, do take note that Replication is file format dependant, not Access version dependant. In other words, if your file format is an .MDB, then you can still...
Started 6 days, 14 hours ago (2009-11-05 01:30:00)
by AstroDonut Registered User
I un-tick the 'Display Database Window' option on the startup dialog box, close the database and re-open it, everything is fine until I open a form in maximised state, after this the database window is visible for everybody to see!!!
Have I missed something???
Please help
Started 2 days, 5 hours ago (2009-11-09 10:21:00)
by Rick Stanich King and Supreme Ruler
I read this line a lot in posts and I dont fully understand it.
Quote:
The first problem I see is that maybe you have a normalization issue.
I'm as normal as they come, unless you ask my mom, she says I'm an alien.
What does this mean to databases?
Started 6 days, 3 hours ago (2009-11-05 12:30:00)
by Scooterbug
You want to make sure that the database is split up into a front end (Has
the forms, queries, reports) and a back end (Stores the tables). You link
the tables from the back end to the front end. You also want to make sure
that EACH user has their OWN copy of the front end on their local drive.
This will prevent corruption and not bring down everybody if the front end
experiences issues.
|
|
Size: 227 bytes
