| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Respected sir,
How to solve this problem.
saran
|
04-15-2011 07:05 AM
saran | 0 | 1 |
|  | The Microsoft Jet database engine cannot find the input table or query
'Table1'. Make sure it exists and that its name is...
saran
|
04-15-2011 06:59 AM
saran | 0 | 1 |
|  | I've just started using Access 2010 as my primary development tool. I've been using A2003 up until now. Am I missing something or is the help sadly...
Wayne
|
04-15-2011 06:44 AM
Wayne | 2 | 3 |
|  | Hi All,
I have a series of tables with two fields, LA and IndicatorValue. I
have a recordset that selects this data from one table at a time...
Laura
|
04-14-2011 03:26 PM
Bob Barrows | 4 | 5 |
|  | I have sql server 2005 linked tables with access2007, periodically
assigning a recordsource fails (see below) with
ODBC--connection to 'dbSql'...
Roger
|
04-14-2011 07:27 AM
Roger | 0 | 1 |
|  | Hi Everyone,
Just tossing this out there for consideration: Is anyone aware of an
IDE add-in that allows for the editing of procedure attributes? It...
The Frog
|
04-14-2011 05:47 AM
The Frog | 4 | 5 |
|  | hi
I have created a Crosstab query
the headers are the days of the month ie January 1-31
April 1-30
no problem with the query
however how do i show...
kevcar40
|
04-12-2011 10:55 PM
Salad | 9 | 10 |
|  | hello ;
Access 2000, sql server backend
I need to pass a value to an integer variable. The dbfield is the
rowid (the key) of the table.
The logic is...
Tony_E
|
04-12-2011 12:32 PM
Tony_E | 4 | 5 |
|  | I've found yet another case where code works perfectly well in the same db
run under Access 2002 but fails when run under Access 2010.
I have a...
Bob Darlington
|
04-12-2011 12:23 PM
Marshall Barton | 7 | 8 |
|  | Hello Sir/Madam,
This is Lalit from Aspire Software Consultancy, Bangalore India. We
are into software development and IT services. We have...
Aspire Software Consultancy
|
04-11-2011 07:18 PM
James A. Fortune | 1 | 2 |
|  | Does someone know if Office 2007 (with Access uninstalled) and Access 2010
can easily work together on one PC?
Thanks,
Martin |
04-11-2011 08:17 AM
ron paii | 4 | 5 |
|  | A good rendition of these should get the voters pumped up and their teen
fingers...
Salad
|
04-10-2011 01:37 PM
Salad | 1 | 2 |
|  | Hello all;
Access 2000 sql server backend.
I am trying to implement dynamic criteria into a query instead of hard-
coding a range. It is a date/time...
Tony_E
|
04-10-2011 09:12 AM
Douglas J Steele | 8 | 9 |
|  | I've got tblTrade which lists buys and sells for securities
(SecurityID, TradeDate, Amount, TradeType).
For any given date, we can determine whether...
(PeteCresswell)
|
04-09-2011 05:34 PM
David-W-Fenton | 2 | 3 |
|  | I've been asked to upgrade a gatehouse application. The current
application is written in Access 95. It has many little features, but
its main job is...
TC
|
04-09-2011 05:25 PM
David-W-Fenton | 12 | 13 |
|  | Does anyone know if (without depending on a reference to an auxiliary
textbox in a mainform) there is a way to establish a parent-child
relation...
Arsene@selenium.net
|
04-09-2011 10:46 AM
Arsene@selenium.net | 3 | 4 |
|  | I have a subform which I've always used in one main form. Now I would like
to use the same subform in another main form, only the subform then needs... |
04-08-2011 10:33 AM
Arsene@selenium.net | 9 | 10 |
|  | is there a way to spread/split a database over multi monitors.
I can't find anything online that specifically deals with anything
other than...
sparks
|
04-07-2011 04:18 PM
John Spencer | 3 | 4 |
|  | Hello; Access 2000 sql server 2000;
I have a sql server table linked into my access db.
One of the fields is OLE dtype in Access-binary in sql...
Tony_E
|
04-07-2011 11:10 AM
Tony_E | 7 | 8 |
|  | Hi Everyone,
I was just wondering if anyone has created wrapper classes for use in
an object heirarchy. I am thinking specifically of using...
The Frog
|
04-07-2011 03:51 AM
The Frog | 0 | 1 |
|  | I am comfortable using workgroup files in the MDB world or using an
ODBC connection.
Now what I would like to achieve is to use SQL to take of ...
saintor1@hotmail.com
|
04-06-2011 05:32 PM
saintor1@hotmail.com | 1 | 2 |
|  | I'm using Access 2010 to open an Access 2002 mdb front end linked to an
Access 2002 backend.
I have the following code in the AfterUpdate event on a...
Bob Darlington
|
04-06-2011 01:10 PM
David-W-Fenton | 6 | 7 |
|  | PW <emailaddyinsig (AT) ifIremember (DOT) com> wrote in
news:9ripo6t4ps4fruqoh7jh1cj2etqbt6hq87 (AT) 4ax (DOT) com:
MS has a path for you, and it...
PW
|
04-06-2011 01:03 PM
David-W-Fenton | 38 | 39 |
|  | I need to save a subform to MS paint.
Background. I want to be able to print transparent images (with writing on
them). I can create the transparent...
Phil
|
04-06-2011 10:00 AM
Phil | 8 | 9 |
|  | Dozens of people are successfully using a database developed in Access
2002, but usually running on 2007. A series of pre-programmed reports
are...
Nance
|
04-05-2011 04:26 PM
Nance | 2 | 3 |
|  | I have an access form where I capture a payroll code (PayrollNo). I
want to be able to click the button and have access run a stored
procedure in SQL...
Monica
|
04-05-2011 03:33 PM
Bob Barrows | 3 | 4 |
|  | I have a number of controls in the detail section of a form, each control
corresponding to an individual record in a table (Spaces). The controls...
Phil
|
04-04-2011 06:07 PM
Phil | 2 | 3 |
|  | I'm converting my hyperlink fields to standard text fields. Since the
hyperlink field stores (part of) the info twice, like... |
04-04-2011 10:53 AM | 4 | 5 |
|  | I have an Invoice form and a InvoiceDetail continuous form. It's easy
to present the header/main data and the detail data as a form/subform.
Let's...
Salad
|
04-03-2011 10:47 PM
Tony Toews | 6 | 7 |
|  | On a form I want to on load create in SQL records to be added to a
table. The records consist of todays date so that is a variant in the
sql and then...
Barry
|
04-03-2011 02:15 PM
Marshall Barton | 2 | 3 |
|  | Has anybody done this?
I'm failing miserably with the MS Access chart - notwithstanding
Bob Barrows being able to make it work. Maybe something...
(PeteCresswell)
|
04-03-2011 11:41 AM
David-W-Fenton | 1 | 2 |
|  | Using Insert | Chart, I added a chart object to my report.
Ole Class = Microsoft Graph Chart
Class = MSGraph.Chart.8
But when I try to...
(PeteCresswell)
|
04-03-2011 11:35 AM
David-W-Fenton | 7 | 8 |
|  | In a subform I have this query:
strSQL = "Delete ID_hyperlink FROM tbHyperlink " & _
"WHERE (((ID_hyperlink)=" &
!!.! & "));"
Now I want to change... |
04-03-2011 09:44 AM | 3 | 4 |
|  | I inherited this Access application, in which some fields in several
tables are supposed to contain hyperlinks pointing to PDF documents
sitting...
Arsene@selenium.net
|
04-02-2011 11:02 AM
Arsene@selenium.net | 4 | 5 |
|  | My Preventative Maintenance database has a table with Equipment and a
table with Services.
The primary Key is an auto number field in the Equipment...
Anthony
|
04-02-2011 06:57 AM
Bob Quintal | 11 | 12 |
|  | Hi,
I have a table with two columns of data: LA and VALUE. The column is
sorted by VALUE, in ascending order.
I have a recordset that counts the...
Laura
|
04-01-2011 03:23 PM
James A. Fortune | 4 | 5 |
|  | I'm opening a form like so;
strWhere = " = " & lngRpt
DoCmd.openform "frmCC_Choice", , , , , acDialog, "usercodes"
The form opens and I run this...
buckskin
|
04-01-2011 08:52 AM
Salad | 5 | 6 |
|  | I have created a form that has 120 transparent images on it. By that I mean
that each image is basically a line drawing with lettering on it. So...
Phil
|
04-01-2011 06:12 AM
Phil | 1 | 2 |
|  | Using Access 2010. Can I use a string function in an OrderBy? Here's
my code so far:
Me.OrderBy = "Left(Block,5)"
Block is a column name in my...
emanning
|
03-31-2011 10:26 PM
Access Developer | 10 | 11 |
|  | My client currently utilizes Office 2003. He is planning on upgrading
to Office 2010 Professional.
My client has some documents in Sharepoint. He...
Salad
|
03-31-2011 05:52 PM
Salad | 0 | 1 |
|  | Hello Everyone:
I am trying to create a lottery checking program in Access 2007 (just
so I can practice my rusty skills). What would be the best...
mjbaz
|
03-31-2011 12:49 PM
mjbaz | 6 | 7 |
|  | Hi all,
Using Access2007 runtime. Having problems with Transferspreadsheet.
Msg 'Could not find installable ISAM..'
I (think I) know I need to...
Arno R
|
03-31-2011 10:15 AM
Arno R | 0 | 1 |
|  | I have a client who has just installed Windows 2008 Server and uses RDP on
both LAN and remotely to run my application (Access 2002). It worked fine...
Bob Darlington
|
03-30-2011 08:13 PM
Bob Darlington | 4 | 5 |
|  | If I deploy an application to a terminal server (Windows 2008 64 bit) it
runs OK for me but if someone else opens it, the objects seem to
disappear...
Travis Crow
|
03-30-2011 12:48 PM
Jim Devenish | 8 | 9 |
|  | Until recently my clients' ancient legacy Access application has
worked fine.
However, their IT department installed Office 2010 and the legacy...
Edward
|
03-30-2011 12:19 PM
Edward | 2 | 3 |
|  | Using Access 2010. I'm attempting to split a database into a frontend/
backend. There's some coding that creates tables on the fly,...
emanning
|
03-30-2011 11:32 AM
emanning | 0 | 1 |
|  | I have a form with a text box set as a hypelink. When I type the url
into the text box everything works fine. It shows as a hyperlink and
saves as...
JackonLI
|
03-30-2011 10:07 AM
bsn | 4 | 5 |
|  | Hello;
Access 2000
We append an access table to a sql server table through a linked ODBC
connection in access. The append succeeds. One of the...
Tony_E
|
03-29-2011 04:22 PM
Tony_E | 0 | 1 |
|  | hello;
Access 2000. I am appending an access table (1 record) to a sql
server table. I get the message that it can't append the records
because of a...
Tony_E
|
03-29-2011 03:42 PM
Tony_E | 14 | 15 |
|  | Of a report's group footer I would like to set the 'New page' property while
loading the report, depending on the user's choice. The values can be... |
03-28-2011 02:34 PM | 2 | 3 |