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

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

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

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

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

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

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

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

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

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]

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]

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]

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

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

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

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

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

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

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

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

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

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

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]

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

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

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

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

è 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

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

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

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

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

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

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

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

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

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

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

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

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]

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]

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

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

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

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

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

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

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

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

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