I have a subform based on a query. I use a dropdown list to pull up records on the main form. I would like to have the subform/query requery each...

Fbradley

07-20-2004 01:44 PM
King Ron

Dear Eric. Try the following: (I have not used your field names as you will need to substitute the appropriate fields. You will need to use...

Peter Flick

07-19-2004 08:24 AM
Peter Flick

HI All, I need help trying to accomplish the following: I have three tables: tblClients, tblWork Descriptions, and tblClientWorkDescriptions. I'm...

Michael J. Savage

07-19-2004 07:59 AM
Michael J. Savage

Hi All, I am trying to embed one or more excel spreadsheet into my database. I want to do this be say, clicking a button on a form and selecting...

PJ

07-16-2004 03:18 PM
PJ

Hi I am now sitting for almost ages in front of the screen, and may be someone can help me... Here's the thing I have a table that looks like the...

Stefan

07-13-2004 12:51 PM
Ray

Hi There! I have a distributed Access 2000 app in which I show the user their data on a form and allow them to apply any sorting as they see...

hoytnancy

07-13-2004 10:38 AM
hoytnancy

Are there any utilities that will monitor the resources that Access uses while running? I am exceeding one of my resource limits.

Paul Sieloff

07-12-2004 08:45 PM
Paul Sieloff

Table accountNo PK subType subType domain is (a,b,c,d,e). Customers can have a subscription of any combination of types. I want to find all those...

Simon Long

07-12-2004 08:37 PM
Ray

I have a database application with a front-end containing links to tables in a back-end database. I like this development model because the...

Mike Easter

07-12-2004 05:13 PM
Mike Easter

OK - need some help here, newbie, haven't done this before and reaching a deadline really quickly!! Would like to do the following: In my main...

Renee

07-12-2004 12:04 PM
Renee

I have a continuous form of records (about 4000) that get selected and gets processed. Each record is processed with a call to a local Private...

Paul Sieloff

07-12-2004 10:26 AM
Paul Sieloff

I volunteered to do a small Access project for a friend based on my experience writing an appln. with Access many years ago. It has been a struggle...

Bill Hunt

07-12-2004 06:24 AM
Bill Hunt

All, I have used Excel automation many times in the past without error until now. My machine has both Access 97 and XP installed but this code is...

Mark C

07-11-2004 11:48 PM
Mark C

Hello everyone, I have a database with the following fields: Name Control # Balance Date Posted and more fields

07-11-2004 08:39 PM

Hi All, Sorry, I still need some help with this...I can't for the life of me figure out how to do this: I need to use the field InvoiceNumber (the...

Michael J. Savage

07-11-2004 11:45 AM
Michael J. Savage

OK so I'm making a database where the main entities are Models and Assignments. I've made tables for each and now I am making a form for "new...

trudy

07-10-2004 03:25 AM
Phivos Zomenis

I've used PictureBox controls with Access 2000 and Visual Basic 6.0, but I can't seem to find it in the toolbox that comes with Access 97. Does...

LongDistanceRunner

07-09-2004 04:10 PM
LongDistanceRunner

I'm sure it's simple but.... Have a mainform / subform subform defaults to form view. Want a toggle button on mainform to toggle subform from...

wdgriggs

07-09-2004 11:26 AM
wdgriggs

I have a table with a hyperlink field that I display on a form. I can click on the form field and the hyperlink activates correctly. However, if I...

Tim

07-09-2004 08:24 AM
Tim

I need to create a table by importing from a .csv file. The only problem is I need to create a primary key ID using autonumber, and this cannot be...

CefiroZ

07-08-2004 11:40 AM
Ray

In Access 2000, can anyone enlighten a beginner with how to make a date field in a table auto update evertime another field is updated? In this case...

Mike

07-08-2004 11:33 AM
Ray

Hi, I have a database with 380 records which are numbered from 0 to 380. I would like that record no. 15 should get the number 68! or 391. means...

Michael Schrading

07-07-2004 05:16 PM
Michael Schrading

Can I include the fields from multiple tables in a data base in one form? All the tables are related by a common ID field. I think I have a 1:1...

Cherri

07-06-2004 12:18 PM
Cherri

Hello, Can anyone tell me how to grab what the user types into a combo box when it's not in the list? Thanks, Mike

mharness

07-06-2004 04:46 AM
GJT

I recently purchased a new PC which came with Office 2003 installed. Since this version does not include Access, I installed my old Office 2000...

Bob Sanderson

07-05-2004 12:42 PM
Bob Sanderson

I'm stuck. I use Access 2000. I have a date field in a query. What I need done is if a Limit_Date function returns a true, I want the date field to...

Enterprise

07-04-2004 07:42 PM
Downstreamer

I'm searching for an scaled down way to print reports to .pdf format directly from a form that selects multiple reports for review or printing. It...

Terry Clites

07-04-2004 07:18 PM
Carol and Doug Hutcheson

Question. I am trying to connnect by MS Access .mdb through ODBC to a UDB / DB2 database. I installed the DB2 runtime client and fixpack. I can...

dylan

07-02-2004 05:20 PM
dylan

I havent used access for years but now have a position where I need to use it again. I am using Access from Office XP and have some old databases...

Julie Nicole

06-30-2004 06:25 PM
Julie Nicole

Hi, I am using MS Access XP version. I used to use MS Access that came with Windows 95 and was pretty good with it. That was seven years ago and...

Julie Nicole

06-30-2004 06:16 PM
Julie Nicole

I have a routine for opening a form from another form. open original form maximized use original form. The opening another form off the...

ML

06-25-2004 01:57 PM
ML

My non-profit organization works with low-income people on employment training. I collect and analyze follow-up statistics for changes in salaries,...

Ellen

06-25-2004 08:44 AM
Ellen

I have seen a number of posts on the subject but I am unable to get them to work. I have been unable to find any information on the error that I am...

Julie

06-24-2004 05:23 PM
Julie

What I have is a numeric value (600) I want to show it in Minutes and seconds. I have a timer and want it to count backwards in Minutes and...

vidajam

06-24-2004 01:08 PM
vidajam

I have an interesting dilemma. I have a table with the following records: =================================================== Box | ...

aW

06-23-2004 02:40 PM
aW

newbie question: Could someone tell me the best strategy for distributing an application with and .mdb and .mdw file so that .mdb file can only be...

codemonkey

06-23-2004 05:48 AM
codemonkey

I hope you can illuminate some error handling mysteries: I read that if a sub doesn't do it's own error handling, control propagates up the call...

kurt klingbeil

06-22-2004 05:45 PM
kurt klingbeil

I need to determine CMYK values from bitmaps. Is there a way in VB or Access to do this? The reason is that I need to determin the relative CMYK...

MS

06-22-2004 12:14 AM
MS

Hi, I am creating a new application using ms-access database. I need help in making a custom logon screen and provide access to my users. Is there a...

Gary

06-21-2004 10:40 PM
assets

Hi people, I have a small program in MS Access, It has some table linked to sybase server. The program used to run alright. When I ported it to...

VJ

06-21-2004 04:27 PM
VJ

I an trying to read a binary opened in random mode with a specified file length. The binary data may contain the following HEX string "03 0A FE...

Jeremy

06-21-2004 10:47 AM
Jeremy

I am trying to Import a simple dbase file into my Ak2 TABLES. If I do this manually, it works fine. I get a new table called DBASE with all the data...

AccessStarters

06-18-2004 02:20 PM
AccessStarters

I'm getting tired of the 6 - 9 hour delay between submission and posting of messages. Plus, the activity here seems to be way down, 2 or 3 new...

John Shaw

06-18-2004 02:01 PM
r0adh0g

Hi people, I have a small program in MS Access, It has some table linked to sybase server. The program used to run alright. When I ported it to...

VJ

06-18-2004 01:52 PM
VJ

I have built a search engine that looks at the tables of the database but not the whole database. My co-workers are not as handy with computers. I...

Santosh

06-16-2004 04:25 PM
Santosh

How can i calculate or replace a field in a table. There are 2 tables Events and members Fields in events are name date location

Johan Harms

06-15-2004 03:35 AM
Johan Harms

i am using asp and an access database and here's what i'm TRYING to do i have 3 fields in the table (hrs_taken), (date), and (hrs_needed). i also...

06-14-2004 04:55 PM

how can i make it so that when the value of one field is 15 another field in same record automatically enters todays date? thanks in advance!!

06-14-2004 03:09 PM
Andrew Backer

I have a subform that I am attempting to set a filter value for. However access claims that the subform does not have a property or method called...

yagfxgeek

06-14-2004 03:02 PM
Andrew Backer

Does anyone know how, using asp and an access database, one could display the total of the records retrieved. all of the records retrieved are #'s...

06-14-2004 02:40 PM
Andrew Backer