| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Reading the Value or Caption From an OPtion Group Button using Select Case??
Normally the use of the select case seems to be as below.
Select...
bezz
|
08-01-2010 03:59 PM
Salad  | 4 | 5 |
| | | is it a hidden table ?
I don't see anything under 'access options' to view hidden tables, is
there such an option
Roger
|
07-30-2010 06:22 PM
Albert D. Kallal | 4 | 5 |
| | | This probably cannot be done, but I thought I would ask anyhow. I
have a subreport in which I wish to assign the controlsource of
several controls...
Vincent
|
07-30-2010 01:14 PM
Don Leverton | 3 | 4 |
| | | Has anyone got some examples of how to use stlink criteria when using it with DoCmd.OpenReport
I used to have a good cribsheet of the syntax for...
divventknaa
|
07-30-2010 12:16 PM
Marshall Barton | 4 | 5 |
| | | in access97, this works
SELECT businessId
FROM tblBusiness
WHERE baanPostalId = null
but not in access2007, it needs to be
SELECT businessId
FROM...
Roger
|
07-30-2010 10:37 AM
Bob Barrows | 4 | 5 |
| | | I discovered that the error occurs when the Record Selector in the
continuous form has focus.
I am able to accomplish what I was looking to do,...
Greg (codepug@gmail.com)
|
07-30-2010 10:34 AM
Jon Lewis | 6 | 7 |
| | | today's is my first day with access2007, I've read and applied things
from
http://allenbrowne.com/Access2007.html
when I open an access97 mdb with...
Roger
|
07-30-2010 09:09 AM
John Spencer | 4 | 5 |
| | | Hello,
I have problem of formating numbers on the MS Access report.
For example, I would like to format:
1) 25,000,000 result ---> 25M
2) 8,200,000 ...
Orchid
|
07-30-2010 09:05 AM
John Spencer | 2 | 3 |
| | | Nice to have both pictures and captions on command buttons (Access 2010), but
is it possible to alter the position of the image. I want the image...
Phil
|
07-30-2010 07:43 AM
Phil | 7 | 8 |
| | | I added this to the ribbonXML memo field of uSysRibbons, but my QAT
doesn't reflect it
also, do I need to do anything else for the QAT to be...
Roger
|
07-29-2010 11:42 PM
Roger | 0 | 1 |
| | | I have an Access 2003 database that is used to record details of all
of our members. Table 1 is populated via a form. We also
have another Table to...
sharsy
|
07-29-2010 10:13 PM
Don Leverton | 6 | 7 |
| | | Hi,
I tried ages to ago to wrap my head around this process, but I still
need help and education - I found a workaround at the time but it's
come up...
Stinky Pete
|
07-29-2010 09:19 PM
Stinky Pete | 3 | 4 |
| | | I have a calculated field on a form with the following as its
controlsource.
=DLookUp("BupaID","Lookups_UserT","Category='Provider number'...
Owen
|
07-29-2010 06:22 PM
David W. Fenton | 12 | 13 |
| | | Hi There,
I've updated one of our a databases to run in Office 2010 x64 w/Win 7
x64.
For some reason, I am getting a Path/Access Error 75 on...
elias
|
07-29-2010 06:16 PM
David W. Fenton | 14 | 15 |
| | | Here is a code snippet that I use to populate a treeview control:
Do Until rst.NoMatch
' Extract the category name an count of related...
Steve P.
|
07-29-2010 03:46 PM
Steve P. | 1 | 2 |
| | | frmfind has a list box which is based on a query and an unbound
textbox (txtproduct)
The user enters part of a product code into txtproduct and...
BobbyDazzler
|
07-29-2010 11:40 AM
BobbyDazzler | 1 | 2 |
| | | Title:Tester Position (QA)
Location: Halifax
Duration: 5 to 6 months
*Must Have Educational Qualifications/
Skills/Experience (Basic...
Maple MRS
|
07-29-2010 09:29 AM
Maple MRS | 0 | 1 |
| | | Hi Guys,
I am working on the last phases of this wretched project I was given
(long story), and I am hoping to use the ReprtToPDF tool from...
The Frog
|
07-29-2010 07:07 AM
The Frog | 0 | 1 |
| | | Hi Everyone,
I have a fairly simple crosstab query and the results are good. I have
a need to add a roll-up row to the query where I need to...
The Frog
|
07-28-2010 05:27 PM
Karen Mills | 3 | 4 |
| | | currently I have an access97 application that opens a second access97
application using
Dim objAccess As Access.Application
On Error GoTo fErr
Set...
Roger
|
07-28-2010 03:51 PM
Douglas J. Steele | 6 | 7 |
| | | "Salad" <salad (AT) oilandvinegar (DOT) com> wrote
I am planning to do the above, but in place of doing that, I spending time
here answering...
Albert D. Kallal
|
07-28-2010 12:17 PM
Salad | 4 | 5 |
| | | If an Access app is published to the web and a person is a Sharepoint
user can that person access the database via his cell phone?
Salad
|
07-28-2010 11:06 AM
Salad | 7 | 8 |
| | | Hi Everyone,
Firstly thankyou for previous guidance on dealing with my crosstab
data, I have implemented the suggestions and it has made a...
The Frog
|
07-28-2010 05:51 AM
The Frog | 2 | 3 |
| | | In Access 2002 and 03, when you changed a name in a table, the change
automatically propogated to all queries, forms and reports. That
doesn't seem...
Tomahawk Lady
|
07-27-2010 08:05 PM
David W. Fenton | 2 | 3 |
| | | I've got a function that relinks my tables from the development server
to the production server (sql server 2005)
some of the tables / views are...
Roger
|
07-27-2010 08:01 PM
David W. Fenton | 6 | 7 |
| | | Title: Business Analyst
Location: Portland OR
Duration: 6 months
Job Description:
Business Analyst with...
Maple MRS
|
07-27-2010 02:27 PM
Maple MRS | 0 | 1 |
| | | Hi all
I have a client for whom I've created an Access database over a period
of some years.
It's now getting to the point where we're going to...
Andrew
|
07-27-2010 01:48 PM
a a r o n . k e m p f @ g m a i l . c o m | 6 | 137 |
| | | Hi (again)
The solution below worked for the problem I posted last week (shown at
the bottom of this post) , however some of the dates are...
Carl
|
07-27-2010 11:13 AM
Carl | 5 | 6 |
| | | How do I programmatically assign user-level permissions to the <New
Tables/Queries> object? I am able to assign permissions to the other
objects via...
Vincent
|
07-27-2010 11:13 AM
Vincent | 1 | 2 |
| | | Hi everyone,
I need to be able to dynamically populate a table with the dates from
a specified period range.
For example, if Start Date = July 1,...
Odd
|
07-27-2010 10:13 AM
paii, Ron | 3 | 4 |
| | | I have a couple of tables called tbl_EMPLYE (has EMPLYE_ID as
autonumber PK) and tbl_TIMESHEET (has TIMESHEET_ID as autonumber PK,
and EMPLYE_ID as...
Carl
|
07-27-2010 06:37 AM
Carl | 5 | 6 |
 | | "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote:
Depends on management. If it's local or IT management then it'd be the rocking...
(PeteCresswell)
|
07-27-2010 03:32 AM
James Avenant | 12 | 157 |
| | | I haven't used Access 2010 yet, but have used various previous versions of
sharepoint (2007 and 2003) at my last full-time regular 9 to 5...
Mark Andrews
|
07-26-2010 04:39 PM
Mark Andrews | 2 | 3 |
| | | I have an option group which opens a report dependent on the use of select case within the option
Group.
Occasionally there will be a report where...
divventknaa
|
07-26-2010 04:27 PM
divventknaa | 3 | 4 |
| | | I have an option group which opens a report dependent on the use of select case within the option
Group.
Occasionally there will be a report where...
divventknaa
|
07-26-2010 01:10 PM
David W. Fenton | 4 | 5 |
| | | Hi All,
I have an application that I need to make as 'user proof' as possible.
Current roadblock is that one of the operations it performs does...
planetthoughtful
|
07-26-2010 11:04 AM
Roger | 1 | 2 |
| | | Apologies if this has posted twice, Broadband is down and I am one of those singularly pathetic 3G
mobile BB sticks at the moment. Can retrieve...
divventknaa
|
07-26-2010 09:17 AM
John Spencer | 1 | 2 |
| | | Can one format a memo field with different font/sizes/bolding or use
HTML tags to do so in a web form?
Salad
|
07-25-2010 04:18 PM
Douglas J. Steele | 2 | 3 |
| | | Two apparently-identical subreports each containing a pie chart.
Been through the props over-and-over... and they appear tb
identical except for...
(PeteCresswell)
|
07-25-2010 04:17 PM
(PeteCresswell) | 0 | 1 |
| | | Just spent the last hour or so Googling in search of the object
model for MS Graph.Chart.8 - but to no avail.
Lots of "How-To" articles, but no...
(PeteCresswell)
|
07-25-2010 01:42 PM
(PeteCresswell) | 0 | 1 |
| | | Here is some data for a scatter graph
X Y Testname
20 30 Fred
40 50 john
30 30 bill
I I know in AK2 it was not possible to draw a scatter chart...
Phil
|
07-25-2010 01:11 PM
Phil | 0 | 1 |
| | | I am using a treeview type menu system on an Access 2010 Db. There is a close
button on the menuform which runs RunCommand acCmdExit. All works...
Phil
|
07-25-2010 05:21 AM
Phil | 10 | 11 |
| | | Hi,
I'm trying to sum two sub-queries with this code:
SELECT Count(*) AS Attivi
FROM adi
WHERE (((adi.pratica_2010) Is Not Null) And...
remigio
|
07-24-2010 02:08 AM
remigio | 4 | 5 |
| | | Hi everyone,
This may seem like a dumb question, but I'm going to ask it anyway. I
have been requested to build a report in a db I am developing,...
The Frog
|
07-23-2010 03:37 PM
David W. Fenton | 2 | 3 |
| | | I don't have A2010 yet.
In a desktop application you can store pictures in a table. Or one
could create a hyperlink to the image. Since Web apps...
Salad
|
07-23-2010 03:34 PM
David W. Fenton | 8 | 9 |
| | | hi
i have a field in a table which has bees set to 12 Characters
what i would like to do is make sure the user enter 12 characters
also the string...
kevcar40
|
07-23-2010 12:33 PM
Marshall Barton | 2 | 3 |
| | | I don't have A2010, just asking.
There's a link for a video on adding users to a published web...
Salad
|
07-22-2010 04:23 PM
Albert D. Kallal | 1 | 2 |
| | | Wondering...
I've recently started playing with Google Maps and had a thought. Does
anyone know of a way of displaying HTML within a Form (or Page)...
randomblink
|
07-22-2010 12:51 PM
David W. Fenton | 1 | 2 |
| | | I rarely use the Like operator and below is the only way I could get a
function to return true if
str is all numbers or all numbers followed by a...
Jon Lewis
|
07-22-2010 04:35 AM
Jon Lewis | 13 | 14 |
| | | Dear reader,
The following VBA instruction opens a file.
Application.FollowHyperlink X:\.............\FileName.Extension
Only in case the...
Simon van Beek
|
07-21-2010 11:59 PM
Tony Toews | 10 | 11 |
