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 02: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 06: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 05: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 01: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 08: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 09: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 09: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 09: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 08: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 02: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 09: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 08: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 12: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 06: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 05: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 08: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 10: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 11:01 AM
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 03: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 01:48 AM
ziggs

I have been a user of MS Office Professional for Windows 95. When I loaded it on my new P-4, 3+ Ghz computer (Win XP), all was fine except...

HankG

12-05-2004 02:10 PM
HankG

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 ACCESS DBA/ CONTRACT/ FL

Tom Gugger

12-02-2004 12:26 PM
Tom Gugger

Hi Barry, Yes, many thanks. This makes things much clearer. I am not worried about intellectual property, since this developer has both let us down...

ronwer

11-28-2004 04:16 PM
Larry Linson

I have a database with only 2000 (Spanish) words and translations and learning scores of 2 persons. The database is now 54 Mb big. I would...

Leo Kroon

11-25-2004 05:36 PM
Dodo2u

In Access XP I have a learning database for Spanisch, with only about 2,000 words (also only text, no pictures). However, the database is 54 MB. I...

Leo Kroon

11-25-2004 12:54 PM
Ira Solomon

I created a query in Access 2000 that runs perfectly. I then copied the "sql" version of the same query and set it equal the variable "sql" in...

TD

11-23-2004 09:39 PM
Ken Snell

Hi. My client has a "Request Information" form on their website that currently sends them an email with the contact information. The details of the...

Aliza Klein

11-23-2004 07:47 AM
Aliza Klein

I want to set up Access to use a barcode scan for admission to the lunchroom at the school I work at. We already have the scanners and computers. I...

Me@Home.com

11-19-2004 09:19 PM
Ira Solomon

I have created a Web 'page' in MS Access based on a database. I can view the page in IE on the same computer. When I move the files to a server to...

Bud Moore

11-15-2004 01:01 PM
Robert Crawford

Looking for a way to add 4 combo boxes to a user form that select based on the results of the previous combo box. Help ?? Please answer here in the...

me

11-11-2004 08:57 AM
Ira Solomon

Dear, Could somebody tell me how I could find the software Microsoft Access 2.0 ? I desperately need to find this. Thanks in advance for your help...

Raoul RICHARD

11-10-2004 12:12 PM
Raoul RICHARD

Is it possible when using Access security to log a user out? I have a client who would like to be able to change users without having to shut Access...

Br@dley

11-08-2004 07:49 PM
Br@dley

Hi all, In my current project, I open other forms from within my 'Parentform'. In this parentform, dates of the selected forms are queried. Each...

Kurt Blom

11-08-2004 09:37 AM
Kurt Blom

Hi... I have a access query that I need to export to a text file that is needed by another application that requires a vbCrLf at the end of each...

MikeZ

11-07-2004 07:24 AM
Ken Snell

Hello, I'm writting a database for a dog & cat kennel, I need to know how many days the pet has stayed at the kennel. I have two date fields named...

Robert

11-05-2004 06:45 PM
Ken Snell

Hia all, In a project, a recordset is openend. In the program flow, it happens that the rst is closed in other procedures. If I trie to close the...

Kurt Blom

11-04-2004 07:44 AM
Ken Snell

Hi all, I am using MS Access as an issue tracking database that auto-emails the issue on record save. I would like to bring up a dialog box to find...

John

11-03-2004 08:19 AM
Ira Solomon

Hi, I am deploying a database to Win2k and Win XP users. My problem is the reference to the CDO.DLL in C:\Program Files\Common...

John

11-02-2004 10:10 PM
John

i have a table name, desc, podate with name/desc character and podate a date field it is a table of vender names line descriptions and purchase...

ilaboo

11-02-2004 07:28 PM
ilaboo

Hello, I have a table that contains the fields Id, date, balance, name, address, city, state, zip and phone. There are multiple records per...

11-01-2004 05:48 AM
ilaboo

Hi all, The problem with the use of a scroll mouse in forms is that you browse through the records. Does someone has a solution to turn...

Kurt Blom

10-28-2004 09:39 AM
Ken Snell

Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group...

Matthew Wells

10-28-2004 09:02 AM
Matthew Wells

I have a unbound form with a tab control with four tabs in an Access 97 database. On each tab I have a sub form each form on the sub forms is...

Mark C

10-27-2004 07:32 PM
Mark C

what is wrong with expression? using access 97 select ,vendname,,lidesc, from group by , vendname, ,lidesc where (select max(,podate)

Andrew Paulsen

10-26-2004 06:05 PM
Andrew Paulsen

I have yet another problem with the infamous tab control in my Access 97 database. I have a form with a tab control with 4 tabs on each tab is a...

Mark C

10-22-2004 10:59 PM
Mark C

I have a bunch of text files I'm trying to parse. The files all have several occurrences of chr(26), which is EOF (End Of File). Each file is ~ 1meg...

Mike Turco

10-22-2004 03:26 PM
Mike Turco

Have an question, hope it makes sense. Unfortunatly I didn't write the program my company uses, but I'll try my best to explain. We load vehicle...

sean

10-20-2004 08:36 AM
Ira Solomon

i have a pull down list bound to a lookup table of students and wish to display the image of the student each time a name is selected. i'd prefer to...

sushila bakhda

10-19-2004 09:18 AM
Ira Solomon

In my Access 97 database I have a form with a tab control that has about 150 controls on it (no subforms). When I add another tab and click on it...

Mark C

10-14-2004 09:07 PM
Mark C

Hi to all, I have a somewhat interesting problem that needs solving. I have built a system to keep track items that are booked in for repairs. These...

elmo

10-14-2004 05:22 AM
elmo