| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I've got a linked sql server table (tblFoo) in access2007
and I'm trying to process a transaction, see below
but it fails setting rs2 with
ODBC--call...
Roger
|
03-09-2011 06:38 AM
Travis Crow  | 2 | 3 |
| | | Client would like to be able to combine once or twice yearly data from
3 copies of a database into
a master copy of a database. They prefer to use...
davjoh123@yahoo.com
|
03-08-2011 04:10 PM
ron paii | 2 | 3 |
| | | I am an experienced programmer, but I am relatively inexperienced in using
VBA. I am working on a project developed by others who no longer...
Charles Hottel
|
03-08-2011 01:02 PM
Charles Hottel | 6 | 7 |
| | | I need to create a form with up to 100 text boxes or labels. Don't care which
I use as the data will be static. I will have a table that gives the...
Phil
|
03-08-2011 04:25 AM
Phil | 2 | 3 |
| | | Is it viable to use MKdir with a table such that you can use something like folderprint to export a table of
filenames (books with author in the...
bezz
|
03-07-2011 03:35 PM
bezz | 2 | 3 |
| | | Can anyone tell me how to disable a popup box?
I created a macro that cut and pastes data automatically but now the
user gets a pop up box asking if...
fishqqq@hotmail.com
|
03-07-2011 02:50 PM
fishqqq@hotmail.com | 0 | 1 |
| | | I have a query qry2 which is based on query qry1. Both qry1 and qry2
are defined in Access. I would like to use parameters for both
queries. I...
JohnP
|
03-07-2011 02:30 AM
JohnP | 12 | 13 |
| | | Hi All,
When I am trying to export a particular query to an Excel spreadsheet
( the .xlsx type) in get the error message "Microsoft Office Access
was...
Gilgamesh
|
03-06-2011 02:05 PM
Salad | 2 | 3 |
| | | I am trying to get the fontName and FontSize for Stephen Lebans
RotateLabelVer2.OCX control
dim J as integer
' CtlSpace is the ActiveX control
For j...
Phil
|
03-06-2011 07:39 AM
Phil | 1 | 2 |
| | | I am looking for a copy of Wayne Gillespie's "creeping backup" utility
software. Anyone have a copy they would be willing to send to...
Bob Alston
|
03-05-2011 11:49 AM
Bob Alston | 0 | 1 |
| | | Access 2007
I have a subform that the user can toggle between datasheet and form view.
In form view it shows quite a nice task costing input form...
aceware
|
03-05-2011 06:24 AM
aceware | 2 | 3 |
| | | we have a directory with an access database. One of the people put a
shortcut on their desktop to the database.
Well they wanted to do work on the...
sparks
|
03-04-2011 06:40 PM
Clif McIrvin | 2 | 3 |
| | | I've got an array of values.
When I sum by referencing array entries, I get on thing but if I
sum the values, I get another thing.
It's got to be...
(PeteCresswell)
|
03-04-2011 05:33 PM
James A. Fortune | 6 | 7 |
| | | I have 20 tables with hundreds of fields that have every field set to
Required: "Yes".
Does anyone have a script I could run to set all these fields...
musicloverlch
|
03-04-2011 03:56 PM
musicloverlch | 4 | 5 |
| | | I am looking at some code written by someone else and I find it strange
looking and confusing. It looks like an assignment coded in reverse.
The...
Charles Hottel
|
03-03-2011 03:25 PM
Charles Hottel | 5 | 6 |
| | | I guess MS pulled out of Usenet. I can't seem to find a Windows 7
group (I subscribe to Forte's APN newsgroups)
Thanks,
-paulw
PW
|
03-03-2011 12:23 PM
PW | 3 | 4 |
| | | I am back again with a new problem.
I keep having problems understanding the use of apostrophes and
quotation marks in SQL and in criteria like in...
Bob B.
|
03-02-2011 01:53 PM
Bob B. | 6 | 7 |
| | | I have an access table that contains X number of records (X changes on
a weekly basis). I have a recordset that counts the number of records
in the...
Laura
|
03-02-2011 12:30 PM
Bob Barrows | 1 | 2 |
 | | Per David W. Fenton:
+1... except my tool of choice - for reasons long forgotten - has
been "Find And Replace".
--
PeteCresswell
John
|
03-02-2011 11:38 AM
(PeteCresswell) | 66 | 439 |
| | | I'm getting a message: "The expression you entered has a function name
that Microsoft Access can't find." Access help says nothing about
this...
Nance
|
03-02-2011 11:01 AM
Nance | 0 | 1 |
| | | The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in
news:a305e330-8358-48ec-906e-a802db3ed4f2 (AT) p12g2000vbo (DOT)...
The Frog
|
03-02-2011 01:30 AM
James A. Fortune | 23 | 24 |
| | | FROM http://communitybridge.codeplex.com/
I see a number of posts in the feedback forum complaining about
this. Without it, I won't contribute...
David-W-Fenton
|
03-01-2011 08:55 PM
David-W-Fenton | 0 | 1 |
| | | I have an app that is developed in Access 2003 and distributed with the
Access2007 runtime.
I am using custom filters and when records are filtered I...
Arno R
|
03-01-2011 01:13 PM
Arno R | 0 | 1 |
| | | I have a problem that is plaguing me at the moment.
I have a simple form which contains one combo box that selects a value
for the "PooledID" field...
Bob B.
|
03-01-2011 11:10 AM
Bob B. | 4 | 5 |
| | | With the statement in SQL
SELECT * FROM firstdatatable
I can use the query to pull out data from firstdatatable. Say I also...
bezz
|
02-28-2011 06:43 PM
Bob Barrows | 8 | 9 |
| | | I have a problem that is plaguing me at the moment.
I have a simple form which contains one combo box that selects a value
for the "PooledID" field...
Bob B.
|
02-28-2011 04:05 PM
Bob B. | 0 | 1 |
| | | I have converted a large Access2000 program into Access2010. By and
large it went over Ok except for twenty or so queries which had to...
elg
|
02-28-2011 10:10 AM
elg | 0 | 1 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has confirmed its place as a leader in Mobile BI, blitzing Howard
Dresner’s...
JTP PR
|
02-28-2011 03:46 AM
The Frog | 1 | 2 |
| | | Is that an accidental cross-post?
The Frog
The Frog
|
02-28-2011 03:32 AM
The Frog | 4 | 5 |
| | | I'm just trying to find out some basic info here which seems to elude me
after browing the Access website.
I know that when I bought Office 2000 Pro...
buckskin
|
02-28-2011 02:20 AM
Bob Darlington | 1 | 2 |
| | | I have an application using ULS on the back end tables and permissions
applied to user groups.
Is there any way to change a user group account on the...
Bob Darlington
|
02-28-2011 02:16 AM
Bob Darlington | 0 | 1 |
| | | Hi All
I'm in real need of some help.
I have a database which was originally created in Access 2007, as an
MDB file (my client uses A2003 and...
andrewmrichards
|
02-25-2011 08:45 PM
Malcolm | 8 | 9 |
| | | anybody a daily timesheet app they wouldn't mind sharing?
would like to enter in/out times through-out a given day, enter descrition
for a given day,...
mcnewsxp
|
02-25-2011 03:15 PM
mcnewsxp | 0 | 1 |
| | | https://mcp.microsoft.com/authenticate/validatemcp.aspx
transcript: 944364
AccessCode: helloworld
a a r o n . k e m p f @gmail.com [MCITP: DBA]
|
02-24-2011 05:26 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 41 | 42 |
| | | I have a sql server 2005 table called foo
it is an access2007 linked table
with a form using bound fields (qmsResponsibility, ncoType)
part of an...
Roger
|
02-24-2011 09:11 AM
agiamb | 5 | 6 |
| | | I have a front end Access 2000 mde linking to a back end 2000 mdb. It
is currently running happily on hundreds of client's PCs, both single
and...
Owen
|
02-24-2011 08:46 AM
The Frog | 9 | 10 |
| | | Hello;
Access 2000. I have two forms, each form has one listbox. Form1 opens
and the listbox displays all the data from a table (it is based on...
Tony_E
|
02-23-2011 04:28 PM
Tony_E | 12 | 13 |
| | | Is there a way to program the filter by form view so I can customise it?
Phil
Phil Rushton
|
02-23-2011 08:59 AM
imb | 5 | 6 |
| | | I have a sql server 2005 table called foo, it is a linked table
with a form using bound fields (qmsResponsibility, ncoType)
part of an afterUpdate...
Roger
|
02-23-2011 04:14 AM
Roger | 0 | 1 |
| | | When running an Access 2003 database in A2007, I've found that custom
shortcut menus don't show any controls of type msoControlEdit...
Wilhemina
|
02-22-2011 06:24 PM
Wilhemina | 0 | 1 |
| | | I have a split Access database with the backend located on a server
and the frontend on user desktops. Database generally has about 10
users at a...
C-Rod
|
02-22-2011 01:32 PM
Salad | 1 | 2 |
| | | I have a table Payments which has a field called "PaymentDate" with it's
caption set to "Payment Date" Here is the SQL
SELECT Payments.PaymentDate AS...
Phil
|
02-22-2011 05:15 AM
Phil | 0 | 1 |
| | | I'm using values selected in a combo box as part of a filter procedure.
To remove the filter I use Me!cmbCostTypes = Null in the double click...
Bob Darlington
|
02-21-2011 06:55 PM
Bob Darlington | 0 | 1 |
| | | Can anyone help me with a function to get the useable screen size i.e. minus
any toolbars or ribbons (if showing), minus navigator pane (if showing)...
Phil
|
02-21-2011 02:15 PM
imb | 9 | 10 |
| | | I am developing an application where there is a lot of processing and
the user may have to wait for 1-2 minutes sometimes 10 minutes for...
JohnP
|
02-20-2011 11:10 PM
Tony Toews | 12 | 13 |
| | | Is there a way to determine how many lines of code are contained within a
VBA module? Thanks.
Charles Hottel
|
02-19-2011 11:13 PM
Charles Hottel | 5 | 6 |
| | | PW has brought this to us :
you will have to have a text box on the active form with the focus when
the user scans the barcode. The contents of the...
PW
|
02-19-2011 07:34 PM
PW | 4 | 5 |
| | | I am trying to print some PDF documents via MS Access. I get a
message that says, "Acrobat failed to send a DDE command." The
documents open up one...
Jonas
|
02-18-2011 09:42 PM
Albert D. Kallal | 1 | 2 |
| | | Opening forms in a library reference to an external database, I use the for
the OnOpen Event
DoCmd.SelectObject acForm, Me.Name
DoCmd.Restore
The...
Phil
|
02-18-2011 08:13 PM
Phil | 3 | 4 |
| | | I have a client who has installed my Access 2002 application using Wise with
SageKey script installation disk onto a Windows 7 64 bit PC.
When she...
Bob Darlington
|
02-18-2011 08:08 PM
PW | 3 | 4 |
