|
More site info...
New Users | Forum profile
|
|
Forum profile page for New Users on http://www.officefrustration.com.
This report page is the aggregated overview from a single forum: New Users, located on the Message Board at http://www.officefrustration.com.
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 "New Users" on the Message Board at http://www.officefrustration.com 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 New Users:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
66
|
235
|
627
|
|
Post:
|
179
|
650
|
1,794
|
|
|
New Users Posting activity graph:
|
Top authors during last week:
user's latest post:
Access Tutorial
Published (2009-11-29 00:30:00)
On Sat, 28 Nov 2009 15:23:01 -0800, a_ryan1972 wrote: Hi, I am new to access and was wondering if you can point me in the direction of a tutorial that will help me create my database. This is what I am trying to do: On the left side, I would like a list of all of the clients in the database. If I click on one of those clients, I would like to open up a form with that client's information. On the right side of the list, I would like to...
KenSheridan via AccessMonster.com
12
user's latest post:
Duplicate data
Published (2009-11-29 19:05:00)
Mike: You need to build and execute an SQL statement to insert the rows from the OrderDetails for the other. Start with the command button on the frmOrder form and in its Click event procedure open an unbound dialogue form which contains a combo box to select the other order. Then having inserted the rows via the dialogue form, requery the subform control on the frmOrder form. So the button's code will be like this: ' open select...
user's latest post:
Date calculation in a Query
Published (2009-11-27 17:02:00)
Add the expression as a calculated field in the query Field: Removal: DateAdd("d",63-Weekday(FirstContact,7),FirstContact) Criteria: = #2009-11-27# Then you can apply criteria against the calculated field. Another option would be to determine the date range of FirstContact that you are interested in and apply criteria against firstcontact. That would probably be something like the following if you were trying to get the...
user's latest post:
Table Names not showing in...
Published (2009-11-29 22:57:00)
Well, that's not a problem I've ever seen (which might be useful to know?) Are you double-clicking the folders? Do they have a cross on them, which changes to a minus when you double-click? Has it been working before? Which version of Access? Have you tried detect-and-repair from the Help menu (or in A2007, Access Options/Resources? Sorry I don't have anything more definite... Phil, London "Dorsai" wrote in...
user's latest post:
Calculations, Queries and making...
Published (2009-11-24 22:22:00)
Remove the WHERE statement -- SELECT [OBS Main].[OBS ID], [OBS Main].[# Safe], [OBS Main].[# Unsafe], ((# Safe]-[# Unsafe])/[# Safe]) AS [PC Safe Results] FROM [OBS Main]; Do not store the calculation results, just calculate it each time it is needed. -- Build a little, test a little. "Carla" wrote: Here is the SQL from the query. SELECT [OBS Main].[OBS ID], [OBS Main].[# Safe], [OBS Main].[# Unsafe], [OBS Main].[PC Safe]...
KARL DEWEY external usenet poster
6
user's latest post:
Calculations, Queries and making...
Published (2009-11-25 22:22:00)
Remove the WHERE statement -- SELECT [OBS Main].[OBS ID], [OBS Main].[# Safe], [OBS Main].[# Unsafe], ((# Safe]-[# Unsafe])/[# Safe]) AS [PC Safe Results] FROM [OBS Main]; Do not store the calculation results, just calculate it each time it is needed. -- Build a little, test a little. "Carla" wrote: Here is the SQL from the query. SELECT [OBS Main].[OBS ID], [OBS Main].[# Safe], [OBS Main].[# Unsafe], [OBS Main].[PC Safe]...
John W. Vinson external usenet...
6
user's latest post:
Access Tutorial
Published (2009-11-29 00:30:00)
On Sat, 28 Nov 2009 15:23:01 -0800, a_ryan1972 wrote: Hi, I am new to access and was wondering if you can point me in the direction of a tutorial that will help me create my database. This is what I am trying to do: On the left side, I would like a list of all of the clients in the database. If I click on one of those clients, I would like to open up a form with that client's information. On the right side of the list, I would like to...
AccessVandal via AccessMonster.com
5
user's latest post:
Access 2000-2007 conversion - VB...
Published (2009-11-26 10:24:00)
Typo: Sorry, recordsetclone does not work with nomatch. if rs.EOF then 'change it to rs.EOF msgbox "No record matching FindFirst" else Me.Bookmark = rs.Bookmark end if Booleanboy wrote: snip.. Or like this..... Dim rs as DAO.Recordset Set rs = Me.RecordsetClone ' Find the record that matches the control. With rs .FindFirst "[ID] = " & Me![Combo206] 'Assuming number datatype if .EOF...
user's latest post:
open database to input data
Published (2009-11-20 18:20:00)
Thank you both very much! Worked like a charm! "John Spencer" wrote: ==Open the database in design mode ==Select Tools: Startup ==Set Display Form/Page to the form you want to display when the database opens. In Access 2007 (More steps - same result) == Open the database in design mode == Click on the Office button == Click the Access Options button at the bottom of the window == Click Current Database == Set Display Form to...
user's latest post:
Autonumber
Published (2009-11-23 06:38:00)
Thank you John. After reading your reply I see no reason to use autonumbers. I will just use my own numbers as a key field, and with a little programing I can keep them sequential if I want or need to. I am using 2007. How does access keep track of record numbers and will they change if I sort on different fields? -- Thank you, Jack "John W. Vinson" wrote: On Sun, 22 Nov 2009 18:01:01 -0800, Jack wrote: I designed a database...
|
|
|
|
Latest active threads on New Users::
Started 1 day, 1 hour ago (2009-11-29 22:57:00)
by Philip Herlihy[_3_]
Well, that's not a problem I've ever seen (which might be useful to know?)
Are you double-clicking the folders? Do they have a cross on them, which
changes to a minus when you double-click? Has it been working before?
Which version of Access? Have you tried detect-and-repair from the Help
menu (or in A2007, Access Options/Resources?
Sorry I don't have anything more definite......
Started 10 hours, 58 minutes ago (2009-11-30 13:34:00)
by Philip Herlihy[_3_]
There are some really smart folk here who could probably tell you right off
what's wrong, but I'm too lazy to figure it all out without using the tools
provided. I do wonder what the line ending .NewData is supposed to do, and
why one line setting the ControlSource begins with Forms! and one doesn't,
but I could figure all that out using the tools.
That's the main thing I think ...
Started 20 hours, 45 minutes ago (2009-11-30 03:47:00)
by Crystal (strive4peace)[_2_]
Hi Trevor,
use a different database for the scheduler task ...
link to all your tables, put your report in there and
anything else it needs
create an AutoExec macro that opens the report (which will
automatically print unless you specify otherwise) and then
exits Access
Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com
free video tutorials...
Started 3 days, 20 hours ago (2009-11-27 04:13:00)
by Ed Robichaud
Hard to tell what you're trying to do here, but only 1 table should have the
fields description and quantity. Look at the inventory template that ships
with Access. There you'll find tables and relationships that you can modify
for your own use. Typically, there is:
Product table
ItemID
Item Description
ProducerID
etc.
Producer table
ProducerID
...
Started 4 days, 12 hours ago (2009-11-26 12:30:00)
by Philip Herlihy[_3_]
Access 2003 doesn't have the "attachment" data type that was introduced in
Access 2007, but I understand (watch for corrections!) that you can use an
OLE Object type to store pictures. However, either way I'd leave the
pictures where they are and use a Hyperlink data type, so the database
merely stores their location. Might also be worth looking up "Hyperlink
Base" in Help - this ...
Started 1 day, 8 hours ago (2009-11-29 16:32:00)
by Mike Revis[_3_] external usenet poster
Hi Group,
Win xp, Access 2007
This is an estimating form for an electrical contractor.
We have the db set up with a main form for entering info like contractor
name, estimate control number, job location etc.
The main form has a continuous subform for entering the parts needed for a
particular project.
frmOrder. sfrmOrderDetails.
What happens sometimes is that there will be a ...
Started 3 days, 18 hours ago (2009-11-27 06:26:00)
by John W. Vinson
On Thu, 26 Nov 2009 17:04:01 -0800, awsmitty
wrote:
First, let me stress the question posed in the subject line ... is the
following task even possible? I am not asking you guys to do this for me,
but I do need some help!
I am a dispatcher in a men's homeless shelter. I, along with three others,
take in donations over the phone, for example, Joe Citizen @ 1234 Park Ave,
My ...
Started 1 week, 1 day ago (2009-11-22 13:50:00)
by Philip Herlihy[_3_]
Have a look at the Access video tutorials available from Lynda.com. I've no
connection, other than as a contented user. Try these free samples:
http://www.lynda.com/home/Player.aspx?lpk4=31001 (A2007)
http://www.lynda.com/home/Player.aspx?lpk4=13150 (A2003)
Subscription is annual or monthly.
Phil, London
"marbet" wrote in message
...
Hi there
Anyone wants to get ...
Started 2 days ago (2009-11-29 00:23:00)
by a_ryan1972 external usenet poster
Hi, I am new to access and was wondering if you can point me in the direction
of a tutorial that will help me create my database.
This is what I am trying to do:
On the left side, I would like a list of all of the clients in the database.
If I click on one of those clients, I would like to open up a form with that
client's information.
On the right side of the list, I would like ...
Started 6 days, 4 hours ago (2009-11-24 19:55:00)
by KARL DEWEY
Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post. Post some sample records
also.
--
Build a little, test a little.
" Carla" wrote:
hello,
I am trying to create a very simple database (I'm pretty new to Access). In
my main table it have a field call % Safe which is to show the results a
...
|
|
Hot threads for last week on New Users::
Started 6 days, 4 hours ago (2009-11-24 19:55:00)
by KARL DEWEY
Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post. Post some sample records
also.
--
Build a little, test a little.
" Carla" wrote:
hello,
I am trying to create a very simple database (I'm pretty new to Access). In
my main table it have a field call % Safe which is to show the results a
...
Started 3 days, 18 hours ago (2009-11-27 06:26:00)
by John W. Vinson
On Thu, 26 Nov 2009 17:04:01 -0800, awsmitty
wrote:
First, let me stress the question posed in the subject line ... is the
following task even possible? I am not asking you guys to do this for me,
but I do need some help!
I am a dispatcher in a men's homeless shelter. I, along with three others,
take in donations over the phone, for example, Joe Citizen @ 1234 Park Ave,
My ...
Started 1 week ago (2009-11-23 18:05:00)
by John W. Vinson
On Mon, 23 Nov 2009 06:33:06 -0800, swlaw
wrote:
I have put together my database using 26 tables and I would like for an
expert to review my relationships. The entire relationship model is centered
on the project number. Basically, all the tables need to link to a specific
project number.
Would someone be willing to review the database and provide your expert
advice?
I can send...
Started 6 days, 6 hours ago (2009-11-24 17:48:00)
by KARL DEWEY
Can you explain a little more what you are trying to do?
--
Build a little, test a little.
"sundy" wrote:
how can 1 make a combination of 6 digits out of 40 numbers (1-40)
Started 4 days, 12 hours ago (2009-11-26 12:30:00)
by Philip Herlihy[_3_]
Access 2003 doesn't have the "attachment" data type that was introduced in
Access 2007, but I understand (watch for corrections!) that you can use an
OLE Object type to store pictures. However, either way I'd leave the
pictures where they are and use a Hyperlink data type, so the database
merely stores their location. Might also be worth looking up "Hyperlink
Base" in Help - this ...
Started 1 week, 4 days ago (2009-11-19 19:53:00)
by Jerry Whittle
Go to the Database Tools tab. Click on the Set Database Password. Don't give
him the password.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Nikki" wrote:
Hi,
I created the database by using Microsoft access 2007-Iâm a new user of this
software. I also save this database in my desktop. One of my employees will...
Started 1 week ago (2009-11-23 03:55:00)
by John W. Vinson
On Sun, 22 Nov 2009 18:01:01 -0800, Jack
wrote:
I designed a database and enter some test records. On some of the tables I
decided I would be better to have an autonumber. I deleted the records in
the table and did away with the relationships. Changed the field to an
autonumber. When I entered the first record it started the autonumber at 3.
If I deleted that record it starts ...
Started 6 days, 5 hours ago (2009-11-24 19:32:00)
by John W. Vinson
On Wed, 25 Nov 2009 04:52:02 -0800, Bob Mansell
wrote:
However, I also require them in a diferent form for the yearbook.
i.e. Players shown in single line with Team ID and Name.
Can anyone tell me (in simple language) whether/how this can be achieved
using the info in the first query please,
You'll need a little VBA code to do this: it's hard to do it directly with a
query....
Started 1 day, 8 hours ago (2009-11-29 16:32:00)
by Mike Revis[_3_] external usenet poster
Hi Group,
Win xp, Access 2007
This is an estimating form for an electrical contractor.
We have the db set up with a main form for entering info like contractor
name, estimate control number, job location etc.
The main form has a continuous subform for entering the parts needed for a
particular project.
frmOrder. sfrmOrderDetails.
What happens sometimes is that there will be a ...
Started 4 days, 23 hours ago (2009-11-26 01:16:00)
by John W. Vinson
On Wed, 25 Nov 2009 15:39:01 -0800, David K.
wrote:
I've seen responses to my and other people problems and I've noticed that the
gurus will sometimes recommend creating a form based on a query.
Can someone explain why that would be more beneficial or prudent rather than
creating a form directly from a table? Or, maybe I misunderstood and it
doesn't really matter. Either way, I...
|
|
Size: 887 bytes
