| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | Hello,
I work on an app developped with Access/VBA and communicating with a
SQL Server database via ODBC.
My problem is that I have to manage a big...
nartla
|
01-04-2008 03:44 AM
nartla | 6 | 650 |
|  | I'm trying to get geodata from Google or Yahoo's web service using an
Access (2000-2003) application. I have this working fine in vb.net but
have no...
Lauren Quantrell
|
01-04-2008 12:15 AM
rkc | 1 | 130 |
|  | Sorry, I know this has been done 1000 times. The problem is i need to
loop though a recordset and I dont know the field names, so they have
to be...
pmacdiddie@gmail.com
|
01-03-2008 11:07 PM
CDMAPoster@fortunejames.com | 1 | 124 |
|  | Hi
I have a database which has linked tables, none stored locally - it
has a size when compacted of nearly 200Mb
it comprises 21 queries, 26 forms...
ian.tiesdell@hotmail.co.uk
|
01-03-2008 10:15 PM
lyle fairfield | 3 | 107 |
|  | I am trying to use the Can Shrink feature in Access - I found an
earlier post that walked me through the If statement to use to clear
out the label...
Menelomie
|
01-03-2008 10:14 PM
Menelomie | 0 | 112 |
|  | Every once in a while I modify one particular form (could be anything from
adding code to tweaking properties as far as I can see) and upon loading...
Deano
|
01-03-2008 10:06 PM
lyle fairfield | 3 | 102 |
|  | On Dec 30, 3:27 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:
With a literal you can just add a decimal point and a zero...
lyle
|
01-03-2008 10:05 PM
CDMAPoster@fortunejames.com | 4 | 111 |
|  | On Dec 30, 9:17 pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:
From a Microsoft article of many years ago:
"Use Count(*) instead of...
LaSalamandra
|
01-03-2008 08:49 PM
CDMAPoster@fortunejames.com | 6 | 103 |
|  | Hi all
Is there any method to schedule Access queries to run regularly?If yes
pls mention how it is being done?
ARGroup
|
01-03-2008 08:28 PM
Albert D. Kallal | 4 | 105 |
|  | I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008....
christianlott1@yahoo.com
|
01-03-2008 06:44 PM
Tony Toews [MVP] | 1 | 103 |
|  | I am trying to run a pretty simple select query in Access 2007, and I
keep getting the error message "Reserved error (-1524); there is no
message for...
adampierce
|
01-03-2008 06:43 PM
Tony Toews [MVP] | 12 | 196 |
|  | I some times have to scan 20 to 40 databases (on a daily basis) to see
who worked on that particular file and the only way to know is to open
it and...
jbl
|
01-03-2008 06:32 PM
Tony Toews [MVP] | 8 | 102 |
|  | Access 97/2003 Windows XP (Classic Start Menu)
I just converted an mdb from A97 to A2K3 and found something that,
after Google search, doesn't...
Robert McEuen
|
01-03-2008 06:26 PM
Stuart McCall | 3 | 94 |
|  | hello,
i am trying to figure something out. the facts:
- i have an Access 2000 app that ive converted to Access 2007 (windows
Vista)
- it uses...
SpaceMarine
|
01-03-2008 06:02 PM
Tom van Stiphout | 1 | 97 |
|  | Happy New Year All!
I have 2 queries, a qry_HISTData and qry_RAWData. qry_RAWData is
automatically triggered from a subform using the "asofdate" of...
AccessGuy
|
01-03-2008 02:54 PM
Salad | 1 | 109 |
|  | On Jan 1, 5:19*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:
I did check references and it does list DAO before Activex...
Vince
|
01-03-2008 02:45 PM
Vince | 7 | 91 |
|  | I'm using Access 2003 and will have to separate databases with the
exact same tables and table structures.
I need to be able to compare the table...
Ecohouse
|
01-03-2008 02:02 PM
Rich P | 1 | 95 |
|  | Looking a the promo materials for Access 2007 MS is highlighting
interoperability between Access and Outlook's Contacts. Has anyone
played with this...
Lauren Quantrell
|
01-03-2008 11:28 AM
Lauren Quantrell | 0 | 97 |
|  | I am trying to make a query and I am stuck. There probably is a
simple solution to this so hopefully one of you can help. Here is
what I want to...
Brian
|
01-03-2008 09:37 AM
Fred Zuckerman | 7 | 105 |
|  | Happy new year !
Is it possible to import hyperlinks from Excel to Access ?
I tried and can only import the text associated with the...
p-reine
|
01-03-2008 06:55 AM
p-reine | 0 | 99 |
|  | So, I tried to copy a toolbar. I have a custom menu bar for a form. Tried to
copy it so that I could modify the copy and use it with another form....
Neil
|
01-03-2008 05:10 AM
Neil | 13 | 192 |
|  | I recently purchased the MS Access 2007. I have used MS Access 2003 for
years. I need to transfer a table in a Tab Delimited Text File format ...
destinman via AccessMonster.com
|
01-03-2008 02:08 AM
Allen Browne | 1 | 104 |
|  | Has anyone ever encountered this problem? When I open forms or
reports, everything seems to have reverted to Arial & Times (displays
and prints...
penguin732901@aol.com
|
01-02-2008 10:57 PM
Tony Toews [MVP] | 1 | 93 |
|  | hello I am trying to use the iff function in a textbox in a report
like such: =Sum(if(=,,0))
but I get an error undefined function.
Kaspa
kasparov11
|
01-02-2008 08:35 PM
Bob Quintal | 3 | 92 |
|  | Great website for IT / Database professionals like you,
http://certdream.googlepages.com
and,
http://securityrules.blogspot.com
Good luck and...
cisco exp.
|
01-02-2008 08:04 PM
Larry Linson | 2 | 107 |
|  | I'm exporting XML from Access. There is an option to not export key and
index information to a schema (XSD) file, but there's no option for the...
Christopher M.
|
01-02-2008 06:41 PM
Joseph Kesselman | 1 | 97 |
|  | I am trying to dynamically populate the module name in the error
message.
Currently I populate a variable with hardcoded text:
strModuleName =...
rlntemp-gng@yahoo.com
|
01-02-2008 12:28 PM
lyle | 1 | 92 |
|  | è possibile reperire da qualche parte un database con la lista
completa dei comuni italiani con il relativo cap?? ( e se possibile
col codice...
After
|
01-02-2008 11:59 AM
After | 0 | 148 |
|  | Hello, all!
New here, so please forgive if this has been answered before. I use
MySQL most often, and can use the commands:
show tables in ;
show...
Dan
|
01-02-2008 01:23 AM
Albert D. Kallal | 4 | 97 |
|  | Hi,
I appreciate any help I can get. I have a book on this but I still
can not get it. I am getting a syntax error on my IIF statement and I
am...
bunzmon
|
01-01-2008 08:57 PM
Steve | 3 | 96 |
|  | I use a make table query. A field in the output table is a combination
of three fields and the syntax is:
NewField: !&!&!
Fields 1 through 3 are...
zazu
|
01-01-2008 11:31 AM
Linq Adams via AccessMonster.com | 1 | 103 |
|  | I am making a database for a dress shop, which hires and sells prom
dresses. I am creating a form where the user selects the customer
using a list...
Hanny J
|
01-01-2008 10:26 AM
Hanny J | 2 | 105 |
|  | I need six teachers to provide me with a small amount of data each
week. Their IT competence varies from reasonable to barely literate
(but they're...
anthony
|
01-01-2008 06:10 AM
anthony | 3 | 110 |
|  | On Mon, 31 Dec 2007 11:51:10 +0000, efefvfv wrote:
Who ever you are, you need to keep this MI-5 CRAP!! off newsgroups that
could give a doodly...
Don Calloway
|
12-31-2007 06:15 PM
Don Calloway | 0 | 112 |
|  | In the combo box wizard there are typically 3 options, the last one
being to find a record based on the selction in the combo box.
Nevertheless,...
Tyler
|
12-31-2007 01:51 PM
Rick Brandt | 3 | 100 |
|  | I have two users, Andrew and Nancy, who each have their own computer
and can connect to a common database called "employees.mdb" which
resides on a...
Paul Brady
|
12-31-2007 12:29 PM
Paul Brady | 3 | 96 |
|  | So I have a text box with a string in it, and I want to get the value
in that text box into a table using VBA but I have no idea how to do
that....
Zachary
|
12-31-2007 10:12 AM
rael | 5 | 113 |
|  | I have a database with many subforms formated as "single forms". I am
having trouble formating the forms so they display propers (fill the
box on...
Tyler
|
12-31-2007 06:38 AM
Tyler | 0 | 102 |
|  | hello everybody,
how to export and import sdcripts in clearquest
Thanks,
lakki
lakki712@gmail.com
|
12-30-2007 10:26 PM
Linq Adams via AccessMonster.com | 1 | 108 |
|  | I'm using OleDb to connect with an Access Database. I have anywhere from
10 to over 100 records that I need to either INSERT if the PK doesn't
exist...
Terry Olsen
|
12-30-2007 08:02 PM
Tony Toews [MVP] | 11 | 169 |
|  | I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our...
chiinook
|
12-30-2007 02:25 PM
Tony Toews [MVP] | 3 | 101 |
|  | I need to create a report that shows the first six codes that apply to each
company horizontally. The codes are stored in individual records in the...
KC-Mass
|
12-30-2007 01:51 PM
KC-Mass | 6 | 105 |
|  | What sort order does the DIR function use? I can't see any options
within the function to force it to sort in a particular order. Does
the sort order...
anthony
|
12-30-2007 01:17 PM
lyle | 11 | 185 |
|  | I have a combo box on a form that I want the content to be read only. If any
changes it should be done in the table. How can I accomplish this task?...
Kissi Asiedu
|
12-30-2007 12:04 PM
Kissi Asiedu | 8 | 100 |
|  | Hello eveybody,
I'd like to know how to send line by line a report to the printer and
how to control(Select one, set up) the printer. I don't want...
CenturionX
|
12-30-2007 11:12 AM
Salad | 2 | 115 |
|  | I'm a bit perplexed about this. If I bring the form out of design mode
into view mode, then the code below (which is on the form's open
event) works...
anthony
|
12-30-2007 09:37 AM
anthony | 1 | 123 |
|  | Hi,
I have a database that lists each time stock items are purchased, who
they are purchased from and the date of that purchase.
I have a query...
J-P-W
|
12-30-2007 06:18 AM
Allen Browne | 4 | 105 |
|  | On Dec 29, 6:16 pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:
I believe so.
anthony
|
12-29-2007 05:38 PM
lyle | 8 | 111 |
|  | I quote:
"With an unbound combo in the form's header, you could provide a
------
simple interface to filter products from one category."
I've...
Thelma Lubkin
|
12-29-2007 01:09 PM
Thelma Roslyn Lubkin | 5 | 115 |
|  | Hi All,
I m Pankaj, i ve a problem in accessing data from MS-Access Table. The
error is
System.Data.OleDb.OleDbException: IErrorInfo.GetDescription...
1983.yadav@gmail.com
|
12-29-2007 10:03 AM
Tom van Stiphout | 1 | 116 |