| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | my regional options has the currency symbol as a comma (French format)
but I'd expect this
?format(1.2,"#.00")
to display 1.20, yet it displays...
Roger
|
09-20-2010 01:24 PM
Salad  | 1 | 2 |
| | | Hi,
I want to use a subroutine to print a subset of records from a table. I tried an option box using select case, as there is a field called...
bezz
|
09-20-2010 09:19 AM
John Spencer | 1 | 2 |
| | | The code below creates a unique index called MemAddID
With MyTblDef
Set MyField = .CreateField(FieldName, dbLong)
MyField.Required =...
Phil
|
09-20-2010 03:19 AM
Phil | 2 | 3 |
| | | The following code opens the control panel
Public Function ShowControlPanel() As Boolean
On Error Resume Next
Shell "rundll32...
Salad
|
09-18-2010 11:50 AM
Salad | 4 | 5 |
| | | When selecting a bunch of controls and then selecting tabular layout
each checkbox control is aligned left. I would like the check boxes to
be...
Paul H
|
09-18-2010 02:48 AM
Reginald Merritt | 1 | 65 |
| | | I got some data that has the dates as 10/24/02
But its yyyy/dd/mm
so its FEB 24, 2010 but access sees this as 10/24/2002
I tried format(, "dddd...
sparks
|
09-17-2010 04:29 PM
Salad | 2 | 3 |
| | | Hi,
I want to use a subroutine to print a subset of records from a table. I tried an option box using select case, as there is a field called...
bezz
|
09-17-2010 10:56 AM
bezz | 7 | 8 |
| | | I am writing a small app for my own benefit that dials a phone via a
modem. I have a modem so that's not an issue.
I was wondering, do people even...
Salad
|
09-17-2010 07:27 AM
Michiel Rapati-Kekkonen | 2 | 3 |
| | | This may be an easy enough fix. It may be challenging though, so if
you are up to the task, I'd love your thoughts. But those of you who
are familiar...
WhathaveIdone?
|
09-16-2010 05:04 PM
Salad | 5 | 6 |
| | | Anyone have any ideas for an efficient method/function to count the total
number of records in a subDatasheet please? I have a MainForm with...
Jon Lewis
|
09-16-2010 11:18 AM
Jon Lewis | 3 | 4 |
| | | I have an unbound checkbox on a form and I would like to limit the
records based on the checkbox. Here's the data:
Form: frmProducts
Table behind...
WhathaveIdone?
|
09-15-2010 10:50 PM
David W. Fenton | 5 | 6 |
| | | I'm using Access 2007.
I probably need a tutorial because I have tried to piece this together
from different sources. I am sure this is a simple...
eaglewingmd
|
09-15-2010 01:19 PM
Salad | 2 | 3 |
| | | Hello All
I have been fumbling around with this for several hours and would
appreciate some guidance.
I have a form based on a query that pulls the...
flymo
|
09-15-2010 10:06 AM
Albert D. Kallal | 3 | 4 |
| | | I need to change the colour on a certain field on a report. The colour
depends upon the data. Cannot see how to do it ? Anybody got any
ideas.?
Barry
|
09-12-2010 02:09 PM
Stuart McCall | 1 | 2 |
| | | I spent a lot of time with the SQL Server Migration Assistant 4.2
for Access this week, and these are some observations that might
help others:
1....
David W. Fenton
|
09-11-2010 02:37 PM
David W. Fenton | 2 | 3 |
| | | I am trying to add a Field FieldName = "MemAddID" to a table
With MyTblDef
Set MyField = .CreateField(FieldName, dbLong)
MyField.Required =...
Phil
|
09-11-2010 10:22 AM
Phil | 1 | 2 |
| | | When I run a report that has one table as its record source, I receive
"Enter Parameter Value” dialogue boxes for 13 of the fields. I...
zufie
|
09-10-2010 04:45 PM
Douglas J. Steele | 1 | 2 |
| | | I have construced a string of people's surname who live in the same house
Field name is XFirstSN
E.G.
Blackburn, Blackburn, Blackburn, Blackburn,...
Phil
|
09-10-2010 04:12 PM
Phil | 5 | 6 |
| | | I'll try to keep this simple, obviously there is a lot more to it.
I habe a table of Members
MemberID
MemSurName
MemFirstName
MemHeadOfHouseID '...
Phil
|
09-10-2010 02:03 PM
David W. Fenton | 7 | 8 |
| | | Glad to be of help guys.
I used to have a class module years ago that was very similar to this
one for comIO. I used it a lot when dealing with...
Lou O
|
09-10-2010 08:15 AM
Lou O | 4 | 5 |
| | | I successfully created a custom group and tab in Access 2007 by
adding this record to the USysRibbons...
Arch Stanton
|
09-09-2010 08:02 PM
Arch Stanton | 0 | 1 |
| | | I am learning that using Activex controls in Access is NOT a good idea!
I need to display data from several queries in a grid with both row and...
David Newman
|
09-09-2010 05:07 PM
David W. Fenton | 2 | 3 |
| | | I am running WinXP and MS office.
I have a problem with Access - When I try to do a mailing list for instance,
I get messages that the Wizards are...
ronglen
|
09-09-2010 03:25 PM
Calvary Chapel | 9 | 41 |
| | | I've used the Lebans report to pdf code for a long time in Access 2003
databases without issue. Given that the snapshot format has been
reportedly...
Wayne
|
09-09-2010 05:45 AM
Wayne | 0 | 1 |
| | | Dear reader,
In a query you have the possibility to work with a Unhide Columns form.
This form pops-up with a right mouse click on the border of...
Simon van Beek
|
09-08-2010 03:23 PM
Simon van Beek | 0 | 1 |
| | | I have a combo box that its value is used to calc another value on the
form.
works fine until someone wiped the value from the box and hits tab.
if...
sparks
|
09-08-2010 03:15 PM
Salad | 3 | 4 |
| | | Sr Developer -Data Base Analyst
Location: SFO
3+ months
7-8 Years of Exp in Oracle SQL, PL/SQL
please send your updated Resume to jobs (AT)...
Maple MRS
|
09-08-2010 02:09 PM
Maple MRS | 0 | 1 |
| | | I'm working on a project at work right now that requires me to enter
data into Access through a barcode scanner. I have the WASP barcode
software...
Joe Smith
|
09-08-2010 02:05 PM
Joe Smith | 6 | 7 |
| | | I've got a form based on a sql server table, the recordsource is
select * from table where id = foo
the form has textboxes, combo boxes - nothing...
Roger
|
09-08-2010 10:14 AM
James A. Fortune | 7 | 8 |
| | | Duration : 6+ weeks
Start : ASAP
Required skills:
Linux Redhat
please send your updated resume to jobs (AT) mapleresource (DOT) net
Maple MRS
|
09-08-2010 09:53 AM
Maple MRS | 0 | 1 |
| | | I have an XML download I want to load to Access. I can do this for most
of the sub-nodes of the xml document. However, one node has about...
Bob Alston
|
09-07-2010 11:40 PM
Banana | 3 | 4 |
| | | Duration: 6 Months
Job Description:
3 – 5 yrs of experience in projects involved in OIM development, will
be part of the Identity & Access...
Maple MRS
|
09-07-2010 01:49 PM
Maple MRS | 0 | 1 |
| | | I am using the following code to replace the toolbar on all my reports with
a custom ribbon. It adds the ribbon but will not delete the toolbar. How...
paii, Ron
|
09-07-2010 08:55 AM
paii, Ron | 11 | 12 |
| | | I use an unbound objevt frame on a form to display word docs, excel sheets
etc
One of the documents is a mail merge doc which uses a different front...
Phil
|
09-06-2010 03:47 PM
David W. Fenton | 2 | 3 |
| | | Hi All,
I have a form (A) with a subform (B).
The subform gets loaded with:
MyID = Forms!.!ID
NewQuery = "SELECT * FROM Tabel_Aanvragen WHERE =" &...
Co
|
09-06-2010 07:18 AM
Stuart McCall | 1 | 2 |
| | | I've been trying to figure out how to make a copy of a database
newly upsized to SQL Server, and asked how to do it...
David W. Fenton
|
09-05-2010 05:20 PM
David W. Fenton | 12 | 13 |
| | | Am I missing something really simple? I feel like I should be able to
find this and I haven't seen anything on it yet. I have several
unbound...
WhathaveIdone?
|
09-04-2010 09:03 PM
James A. Fortune | 4 | 5 |
| | | using access2007, I've created a pie chart based on a data table
the chart has 4 slices, and the color of each slice is auto-assigned
I used the...
Roger
|
09-04-2010 09:37 AM
Roger | 0 | 1 |
| | | I'm experiencing a problem where the AutoFE Updater takes up to a
minute to open databases on my Windows 7 home network. Is there
something wrong...
Wayne
|
09-04-2010 04:33 AM
Wayne | 8 | 9 |
| | | Sorry to repost.
I need an unbound object frame to display varios objects including Word
documents, Excel, PDFs, BMPs JPGs, DIBs, GIFs etc The word...
Phil
|
09-03-2010 02:46 PM
Phil | 2 | 3 |
| | | Sorry to repost.
I need an unbound object fram to display varios objects including Word
documents, Excel, PDFs, BMPs JPGs, DIBs, GIFs etc The word...
Phil
|
09-03-2010 10:54 AM
Phil | 0 | 1 |
| | | I'm trying to print a barcode, and it doesn't seem that Microsoft has
a standard font available, that I could find
so I downloaded a font, and stored...
Roger
|
09-02-2010 08:49 PM
Roger | 3 | 4 |
| | | ETL/SQL expert with knowledge of Clarity tool
Location Phoenix
Duration: 3 Months +
More details on Skill set Person should have knowledge of the...
Maple MRS
|
09-02-2010 06:20 PM
Maple MRS | 0 | 1 |
| | | Back in June, I submitted this post and received a lot of help, but
unfortunately, it could not be resolved as...
agiamb
|
09-02-2010 04:14 PM
Access Developer | 6 | 7 |
| | | Job Title Sr. Cognos TM1 Developer
Experience Level 6 – 9 + Yrs of IT
Location East...
Maple MRS
|
09-02-2010 01:51 PM
Maple MRS | 0 | 1 |
| | | Location: Newark, NJ
Length of Engagement: 9 months (With the option for the client to
extend to a maximum of 18 months)
Targeted Bill Rate: ...
Maple MRS
|
09-02-2010 09:49 AM
Maple MRS | 0 | 1 |
| | | My application uses ODBC connected tables to SQL Server 2008 R2 Express as
the back end, across a LAN.
One function is to import data from Excel...
agiamb
|
09-02-2010 08:13 AM
agiamb | 9 | 10 |
 | | "lyle fairfield" <lyle.fairfield (AT) gmail (DOT) com> wrote
On Aug 27, 4:45 am, Roger <lesperan... (AT) natpro (DOT) com> wrote:
To be fair, there...
Roger
|
09-01-2010 09:59 PM
David W. Fenton | 21 | 22 |
| | | viz: http://tinyurl.com/28qprwu
Note labels for Germany, Netherlands, and Norway.
I'm taking it on faith that if I can ever figure out how...
(PeteCresswell)
|
09-01-2010 03:48 PM
(PeteCresswell) | 0 | 1 |
| | | Dear reader,
I work with two forms.
A field in the master form has an After Update event with the instruction
Me.Refresh.
If this event is...
Simon van Beek
|
09-01-2010 03:15 PM
bobh | 2 | 3 |
