Hi all, I have a question regarding creating Left Joins. Suppose I have a database with the following tables: Person { (primary) id ...

rg1117@hotmail.com

03-11-2005 08:51 AM
rg1117@hotmail.com

I got stuck converting a claris works database from an old mac to access on a pc. I'm a C++ programmer and don't know a lot about access. This is...

jim.bello@eracent.com

03-07-2005 05:07 PM
Ira Solomon

A new website has just been launched and has some awesome prices, very competitive with Pricewatch's pricing. The site's address...

spls427@yahoo.com

03-07-2005 01:47 PM
spls427@yahoo.com

Hello, 1. I received a mail from Larry but it doesn't work, I'm not a programmer. How can I simply make a field (street) begin with a capital letter...

Marc Verdonck

03-06-2005 05:59 AM
Marc Verdonck

I'm running Access 97 on Windows 98. I need to make large tables and queries with approaching but not exceeding 225 fields (columns). Access is...

Proteus

03-04-2005 09:37 PM
Ira Solomon

I hope you understand me, I'm not speak english very good. I have a problem with SP in SQL Server 2000. This is my SP: CREATE PROCEDURE TablaPlana...

Gema

03-04-2005 08:17 AM
Gema

Hi, I'm using access 97 on windows 98. I have table with 162 fields in it. I need to withdraw this information in a (totals) query with 164 fields...

Proteus

03-01-2005 02:38 PM
Proteus

Hi I am trying to calculate the sum of several intervals over a period of months/yers Imagine a machine i stopped by fault for say 3 minutes and I...

Anders Nielsen

02-28-2005 11:02 AM
Ira Solomon

Hi.. I built this a form in my database, and for some reason, if I accidently move the scroll button on my mouse, the form starts streaming through...

Helen Martin

02-27-2005 08:41 PM
kevindotcar@gmail.com

Hi, I am real new to databases and hoping someone can help. Main-table is a huge spreadsheet that I imported into Access Site-table has a bunch of...

Steve

02-27-2005 06:10 AM
Steve

Hi and TIA! I have a simple report that my users export to excel. They like using the Main Menu / Tools / Office Links / Analyze with Excel...

Reggie

02-25-2005 01:20 AM
Reggie

Karl, Do you really want a database? I think You can use Google Desktop for index and search in your Excel files. k> Does anyone know how to do the...

Igor Shekalev

02-22-2005 09:39 AM
Igor Shekalev

Sorry for this question - I am a newbie. I currently have coded some pages to show a listing based on a particular record (i.e. UserID=). I assumed,...

magmike

02-20-2005 11:51 PM
magmike

I am new to using Access, and hope that someone will be able to help with a problem I'm having with my database: I created a skills assessment test...

Joe Ahearn

02-20-2005 03:49 PM
Ira Solomon

A few years ago, I did something very stupid. Because I didn't know how to code in a carriage return on my website, and because the memo fields...

magmike

02-18-2005 01:48 AM
magmike

There are times in my database that I might like to output some things to a PDF file instead of the the normal printer. Is there a way, via VBA, to...

Bill Agee

02-17-2005 04:13 PM
J. Clay

Good day, I have inherited a very complex Access database that has a plethora of tables, queries, forms modules and reports. Within a few tables are...

Jeff Jones

02-12-2005 05:12 PM
Ira Solomon

Hi Group, I hope this is the place where somebody can help me. I have a MS Works'97 file here and I can't get back to the originator of the file...

Leo

02-12-2005 05:08 PM
Ira Solomon

I have an Access 97 database were I am opening a recordset in a module referencing a control on a form. For some reason when the code executes I...

Giganews

02-10-2005 11:42 PM
Giganews

Using Access 2000 and have a look-up list in need of editing. CAN they be edited? Each time I try to edit, I wind up with a blank look-up list...

Marilyn

02-09-2005 09:20 PM
Ira Solomon

Greetings, I would like to open a form from within another form. I need to suspend the sub until the second form is closed. I can do this easily by...

Tony T

02-07-2005 10:21 PM
Tony T

If you living in Metro Houston and are a heavy back-end web developer with strong ACCESS & SQL SERVER conversion experience please call me at...

Steve Michaels

02-04-2005 04:48 PM
Steve Michaels

Im working on a MS ACCESS 97 database and want to use flash buttons. have managed to get a normal button to work but still have no joy with...

Ian Wilson

02-04-2005 08:15 AM
Ian Wilson

pardon my ignorance, I am new with this programming. using a .mdb file is there a way to tell Visual Basic that the .mdb file is on a ftp...

Oin Zea

02-03-2005 04:40 PM
Ottomano Nicola

I have been trying to connect to an .mdb file protected by a password created using Access 2003. I fond some information on Microsoft DAO...

Oin Zea

02-03-2005 01:57 AM
Oin Zea

Hi, I am trying to create some queries in MS Access that read from yables in PeopleSoft. I have ODBC working on the client where I am developing, I...

John Smith

01-30-2005 08:41 AM
John Smith

I have been trying to connect to an .mdb file protected by a password created using Access 2003. I fond some information on Microsof DAO...

Oin Zea

01-30-2005 02:38 AM
Oin Zea

Am using a form with a combo box listing various peoples names and want someone using this to be forced to use a name from the pull down list versus...

cover

01-29-2005 07:45 PM
cover

Greetings - I'm using an Access front end to a SQL Server (2000) database. Via several steps, I create a temp table and manipulate the data in it. ...

chris ciotti

01-29-2005 10:50 AM
chris ciotti

Hello all, I use Access to keep track of approx. 80 vehicles. I have a table of vehicles with specs. I have another of service records linked to the...

noname

01-28-2005 04:55 PM
noname

Hi All I've created a OLE object in my table to show a photo. When placed in a form, it comes up as a icon. The only settings I can find in...

Kevin C

01-28-2005 03:06 PM
Kevin C

I'm not really looking for a "how to" (although if someone would like to send directions...) In my work I sometimes OK purchase requisitions and in...

Tim K.

01-27-2005 07:09 PM
Ira Solomon

First: I have some troubles in access, some fields needs to begin with a Capital letter. Example: louiselaan need to be Louiselaan. How can I become...

Marc Verdonck

01-27-2005 06:31 PM
Ken Snell

I have a database field that represents an item description and varying length. I am using the database to import the item description into...

bu

01-27-2005 02:32 PM
Ken Snell

Hi all, i am trying to run an update query to replace the last two characters in a field to no avail. I think I am going about it wrong. I would...

Bob Bevins

01-24-2005 09:42 AM
Ken Snell

Hi, I'm trying to update a row in a table. The value in this record must be set to the sum of a column from another table. I can't seem to...

someguy

01-20-2005 10:09 AM
Ira Solomon

Altova Unveils DiffDog(tm) 2005 ------------------------------- This week, Altova added a new dedicated differencing utility to its award-winning...

Altova Announcements

01-18-2005 10:29 AM
Altova Announcements

I have both Access XP (2002) and Access 2003 on an XP Pro machine. I have discovered that "on error" does not work on this machine at the moment in...

Ira Solomon

01-18-2005 10:25 AM
Ira Solomon

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 .. One of our clients out in the greater Los Angeles, California area is in need...

Tom Gugger

01-14-2005 09:10 PM
Tom Gugger

Hi, I want to set up a print option in the menu. I want this choice to print out data which pertains to all records dated to-day and from to-day's...

Mr Ross Miller

01-14-2005 03:47 PM
Mr Ross Miller

Hi All, This is not a programming question but a question about how to establish a connection with a client with the potential of getting future...

Barry Edmund Wright

01-06-2005 10:57 AM
Barry Edmund Wright

When I open up the form to enter data it shows record 1.I must then select the >* to add a new record. Some times I forget to do this and...

Leon

01-04-2005 09:49 AM
Ira Solomon

we have accounts that are assigned a status: red, yellow, green (actually these are values 3, 2, 1) every time the status of an account changes -...

parn

01-01-2005 01:51 PM
Steve Huff

I want to use VB to add /remove/ display data table records "by hand". When I type a line like SET myDbs = CurrentDB the debugger informs me that...

Steve Laycock

12-31-2004 07:51 PM
Steve Laycock

My database records Parts of movie scenes that I want to tape (including their start and end time) By taking one from the other I can see how long...

Rick Bracken

12-27-2004 06:29 PM
Rick Bracken

I have the following lines in a macro: sql = "INSERT INTO IM (ITEM, DESC) VALUES (vitem, ndesc)" DoCmd.RunSQL sql Every time I execute the macro, I...

12-20-2004 09:09 AM
Joe Gleason

This is probably going to soound silly, but I've been trying to teach myself how to write VB macros for Access, and I've run into a brick wall. I...

12-18-2004 11:17 PM

Hi all, I have a critical problem - our client wants to be able to display reports that they've made in MS Access over a web-based interface. I...

Donald Wheeler

12-13-2004 12:01 PM
Donald Wheeler

I have a data entry form with 3 subforms. The tab order won't allow me to tab out of one subform into another field, and so on into other subforms...

Jack

12-12-2004 04:28 PM
C.P.J. de Boer

I have an Access database with 58 fields in one table. I wrote many of the field names so that they were descriptive so that others could figure it...

ziggs

12-07-2004 02:48 AM
ziggs