| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I want to query data from a table and add an extra row to the
results. This is what I have so far:
SELECT ResidentID, LastName & ', ' & FirstName &...
emanning
|
05-05-2011 04:23 PM
David-W-Fenton  | 11 | 12 |
| | | Hi,
I have a subform that I use in multiple places. It's data comes from
an uneditable outside source (A sharepoint list with custom
controls.) ...
jonceramic
|
05-05-2011 03:41 PM
jonceramic | 4 | 5 |
| | | In an Access form, I need to hide part of a SSN in certain conditions, and
show the whole thing in others. In other words,...
Neil
|
05-05-2011 02:22 PM
Access Developer | 6 | 7 |
| | | I have a combo box that filters another combobox on a form after i do
a requery. The issue is that i don't want my form to return to record
one when...
koturtle
|
05-05-2011 11:54 AM
jonceramic | 3 | 4 |
| | | I am using Access/VBA to consume a web services proxy which was
generated via .NET using a WSDL file and wsdl.exe and VBC.exe. The
result is a dll...
BobAlston
|
05-05-2011 10:10 AM
BobAlston | 0 | 1 |
 | | How to set a starting number of the ID (which is set to autonumber and
primary key)? It is by default 1 but I want to start with 4000.
Bart
AA Arens
|
05-05-2011 09:10 AM
imb | 15 | 16 |
| | | When this is run it works great.
UNTIL they start it and have a word document open.
it runs but the output is not there.
I understand that and only...
sparks
|
05-04-2011 06:16 PM
Albert D. Kallal | 1 | 2 |
| | | My computer was recently upgraded to Access 2007. The one feature I
can't seem to find in this newer version is how to view the creation
date and...
Coll
|
05-04-2011 05:36 PM
Salad | 1 | 2 |
| | | I am creating an order database which includes my customer's credit
card numbers, exp. date and security code. Is there way to encrypt the
text field...
John
|
05-03-2011 04:15 AM
The Frog | 2 | 3 |
| | | I used WSDL.exe to generate a proxy class to generate a web service
client. I then compiled it into a DLL.
The soap message required uses to...
Bob Alston
|
05-03-2011 03:42 AM
The Frog | 5 | 6 |
| | | Folks:
I recently converted a 13+ year old database app from Access 97 to Access 2003.
The conversion was swift and completely uneventful. There...
greyhawk
|
05-02-2011 12:44 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 9 | 10 |
| | | Got a table "tblTrancheHeldStatus":
TrancheID
StatusDate
StatusTimeStamp
Contains one record for each day a Tranche was held.
If we own a Tranche...
(PeteCresswell)
|
05-02-2011 12:13 PM
John Spencer | 1 | 2 |
| | | All I need is to put a button on the Access form to open a document in
Word2010.
I could do it in Access2003 but this new Access has no way to do...
Peter Jason
|
05-02-2011 04:00 AM
Jim Devenish | 2 | 3 |
| | | I need to import a CSV file through a url directly into Access 2007. I
can import into Excel then import the excel file into Access, but
can't figure...
JackonLI
|
05-01-2011 07:31 PM
PW | 4 | 5 |
| | | Hello All,
I have been tasked with creating an access application for scheduling
a fairly complex set of requirements. Staff, trainees,...
flymo
|
05-01-2011 07:11 PM
flymo | 9 | 10 |
| | | "Access Developer" <accdevel (AT) gmail (DOT) com> wrote in
news:919ejfF18aU1 (AT) mid (DOT) individual.net:
But that's no longer true from A2007...
buckskin
|
05-01-2011 06:45 PM
Access Developer | 11 | 12 |
| | | Hi All,
Using AccessXP does anyone have vba code that they would share that
would take a AnyName.PDF file and using WinZip zip it with encryption
to...
bobh
|
04-29-2011 02:49 PM
bobh | 6 | 7 |
| | | Using Access 2010 in Windows XP or Windows 7, the scroll bar in the nav
pane, it refuses to stop where I leave it.
I've raised this before and read...
Bob Darlington
|
04-28-2011 07:34 PM
Bob Darlington | 0 | 1 |
| | | I just finished finally getting www.pocketSOAP.com to work with my VBA
client program to access a web service. What is unique about my
requirements,...
BobAlston
|
04-28-2011 06:54 PM
BobAlston | 0 | 1 |
| | | Hello;
MSAccess 2000, MSsql Server 2000
I have an append query. When I run it, it might run once succesfully.
If I run it again (with new test...
Tony_E
|
04-28-2011 12:47 PM
Tony_E | 2 | 3 |
| | | Moving Focus From Option Group:
I have a form with two option groups on, which generate separate reports. When I click on one of the options within...
bezz
|
04-27-2011 06:39 PM
bezz | 2 | 3 |
| | | The Combo boxes drop down with the F4 key when they're on a main form,
but not when they're on a sub form.
They dropped down in Access97 and...
Peter Jason
|
04-27-2011 01:39 PM
Access Developer | 1 | 2 |
| | | Hello:
MSAccess 2000 sql server backend.
I have an append query(in vba) that is appending to a sql server
table.
There are 3 tables in the query,...
Tony_E
|
04-27-2011 10:35 AM
Tony_E | 4 | 5 |
| | | Anyone have a checklist of possible causes of this and how to deal with
them?
bob
BobAlston
|
04-27-2011 02:27 AM
bsn | 3 | 4 |
| | | Just a quick question: does anyone use the keyword Friend anytime they
are building a class? I dont and I was just wondering if others...
The Frog
|
04-26-2011 06:27 PM
James A. Fortune | 12 | 13 |
| | | I'm thinking about using data macros (BACKEND table level) to track
changes to a table. This may be trivial, but I can't figure out how to
track...
elgin
|
04-26-2011 05:03 PM
elgin | 13 | 14 |
| | | Wsdl.exe is a microsoft utility that is command line operated and can
take as a parm a link to a WSDL file for a web service. It generates
classes...
BobAlston
|
04-26-2011 03:19 PM
BobAlston | 2 | 3 |
| | | Hi Everyone,
I am having a strange error (3001, Invalid Argument) when trying to
build a DAO.Tabledef object. I could have sworn that the code I...
The Frog
|
04-26-2011 09:34 AM
The Frog | 1 | 2 |
| | | I want to be able to open and run an Access database from within an
already running one. The OpenDatabase command simply opens it but
does not run...
Jim Devenish
|
04-25-2011 12:45 AM
David-W-Fenton | 7 | 8 |
| | | I am using Access 2003 and 2007.
I have a Form (F1) with a sub form (F2). The form and sub form are not
linked in any way. On the sub form (F2) I...
BEETHOVEN
|
04-21-2011 08:03 AM
BEETHOVEN | 4 | 5 |
| | | I have a combo box based on a table that has 4 entries, Dept1, Dept2, Dept3and Dept4. How can I limit the values that the combo box displays based...
Wayne
|
04-20-2011 02:40 PM
Wayne | 3 | 4 |
| | | See his code here
http://www.everythingaccess.com/tutorials.asp?ID=Creating-an-Audit-Trail
Anyone using it?
Can you tell me how much this slows...
BobAlston
|
04-19-2011 04:51 PM
Bill Johnson | 6 | 7 |
| | | Here is BenchmarkCategory table. Notice the BenchmarkCategoryName is
not sorted alphabetically when sorted by...
bo_dong
|
04-19-2011 04:29 PM
Salad | 1 | 2 |
| | | Does anyone know where I can get the code to print a single mailing
label using VBA? User has labels that are six per sheet, and the
particular task...
John von Colditz
|
04-19-2011 12:09 PM
Rishi Poddar | 7 | 37 |
| | | I have a query of costs for cars. The cars are given a number and a
status for current or retired. Each car has a make and model.
For each car...
nospam@thankyou.com
|
04-19-2011 10:06 AM
John Spencer | 4 | 5 |
| | | The Microsoft Jet database engine cannot find the input table or query
'Table1'. Make sure it exists and that its name is...
saran
|
04-17-2011 05:01 PM
David-W-Fenton | 2 | 3 |
| | | A few lines of code (bassaccesshider, found at
http://www.tek-tips.com/faqs.cfm?fid=2562 and elsewhere) did a
beautiful job of completely hidding...
Arsene@selenium.net
|
04-17-2011 12:11 PM
Arsene@selenium.net | 4 | 5 |
| | | Can anyone tell me if it's possible to use the WindowMode argument to
hide a window and still make changes in the window?
I have a form that i have...
fishqqq@hotmail.com
|
04-15-2011 06:11 PM
Access Developer | 7 | 8 |
| | | I need to scan all of my queries to look for a specific criteria text.
Any query with this criteria text I need to look at further and...
BobAlston
|
04-15-2011 02:42 PM
Access Developer | 5 | 6 |
| | | Fellows,
Have an application with numerous forms, each containing multiple
bound text boxes. As the user tabs from field to field down any of...
Arsene@selenium.net
|
04-15-2011 01:08 PM
Arsene@selenium.net | 8 | 9 |
| | | Hello all-
I'm trying to do a pivot table view query using DoCmd.OpenQuery "My
Query", acViewPivotTable, and when the view displays, the...
Rob
|
04-15-2011 11:24 AM
Rob | 0 | 1 |
| | | Help me to solve this error.
The Microsoft Jet database engine cannot find the input table or query
'Table1'. Make sure it exists and that its name...
saran
|
04-15-2011 10:41 AM
Bob Barrows | 1 | 2 |
| | | Help me to solve this error.
The Microsoft Jet database engine cannot find the input table or query
'Table1'. Make sure it exists and that its name...
saran
|
04-15-2011 07:09 AM
saran | 0 | 1 |
| | | 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 |
