dbTalk Databases Forums  

Sponsored Links


comp.databases.ms-access comp.databases.ms-access


Discuss in the comp.databases.ms-access forum.



Post New Thread
Threads in Forum : comp.databases.ms-access Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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] Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
0 1
Respected sir, How to solve this problem.
saran
04-15-2011 07:05 AM
saran Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
9 10
Post New Thread

Display Options
Showing threads 451 to 500 of 40771
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.