Hi. I know there is the tool of Access to create a Master MDB with copies which can be synchronized later on. Sometimes I forget to do this.. In...

Marc Weber

09-28-2005 04:31 PM
Marc Weber

Create a query that includes all the fields in Table A. In design view, click on the query type button on the toolbar at the top of the screen...

PC Datasheet

09-26-2005 08:37 PM
PC Datasheet

I have a report with a few short fields and a then a memo field that can span from 1-3 or more pages depending on the incident. I tried using a page...

firecop1

09-22-2005 10:02 PM
Ira Solomon

Does anyone now or it's possible to read tablesnames from a database using sql?

09-12-2005 04:41 AM
Jeroen Gouma

gethrog

08-27-2005 04:19 PM
Ira Solomon

I have a "front-end/back-end" database distributed as two .MDB files: client.mdb and server.mdb. client.mdb has all the forms, queries, reports, and...

broadmana@hotmail.com

08-25-2005 05:41 PM
broadmana@hotmail.com

I have a "front-end/back-end" database distributed as two .MDB files: client.mdb and server.mdb. client.mdb has all the forms, queries, reports, and...

broadmana@Hotmail.com

08-25-2005 05:40 PM
broadmana@Hotmail.com

Monty: I would convert the back end to SQLServer. Access will do that for you. How many problems you will have with that aspect depends on how you...

Ira Solomon

08-21-2005 10:12 PM
Ira Solomon

I'm trying to display an Access 2000 report total on the same page as the list of numbers being totalled. But Access is not allowing me to do...

Richard John

08-20-2005 12:03 AM
Richard John

Afternoon everyone! I am at a loss right now and hopeful someone can help me in this news group. I have created an access db and various tables. I...

Joe Chromy, Jr

08-19-2005 05:58 PM
Ira Solomon

I wrote a database appllication that was initially used in the office by me and one person Now four of us use (maybe maximum of 3 at once) it but...

Rick Bracken

08-15-2005 08:37 AM
Ken Snell

How would i go about opening an pdf file for view from within Access?

marlin allison

08-01-2005 05:43 PM
Scott McDaniel

Good Evening, I am trying to link fields (this is probably the wrong term used). I have created database with addresses and ID# Once I enter the...

Melvin

07-27-2005 04:34 PM
Ira Solomon

I have a problem. In two cases the access database is closing completely (but leaves the .ldb file behind.). I just added a new form and now when I...

nicole

07-26-2005 06:07 PM
Ken Snell

I like using the expression builder for a lot of different things but it isn't always available when I want to use it, for example in the...

Mike Turco

07-26-2005 04:18 AM
Mike Turco

Hi All, I just finished creating my first all-inclusive MS-Access application. Ideally, I would prefer to prevent mischievous users from accessing...

Chuck Insight

07-18-2005 07:42 AM
Chuck Insight

Hello, Can someone tell me how to format a report so that the page and report headers and footers run the full width of the page but the detail...

mharness

07-13-2005 01:56 PM
mharness

I am creating a series of forms for an Access database. What I want to know is, is it possible to create an area, say a subform, that will appear...

Paul Curran

07-11-2005 10:31 PM
Ira Solomon

Hi All, I have two tables (book and reference) that share a common field, ISBN. Both tables are supposed to have matching entries. I need a query...

Chuck Insight

07-11-2005 10:27 PM
Ira Solomon

I need to test each transaction listed in a Transaction table to find out if , as of "today",at least 14 days have past since the date listed in...

Barbara Warszycki

07-02-2005 03:06 PM
Ira Solomon

I have a look-up field that is linked to a table of only 2 fields. The 2 fields are ID# and Name. When I choose from the list in the table or...

Barbara Warszycki

06-30-2005 11:28 AM
aa

Hi All, Our database will soon have several thousand records. I need to create a daily activity report that only lists what happened today. I don't...

Chuck Insight

06-27-2005 11:25 AM
Ira Solomon

Hi All, I need a create report in Landscape, but for the life of me cannot figure out how. Please Help. Thanks, Chuck

Chuck Insight

06-21-2005 09:38 AM
Ira Solomon

Hi Everyone, I have entered the following code, but it complains that my syntax is wrong. =IIf( = -1, (Sum ), (Sum * 1.06) I will really,...

Chuck Insight

06-17-2005 11:07 AM
Chuck Insight

Hi there, I recently installed a new machine for one of my users which is running XP Pro SP2 with Office 97. He has come to me this morning with a...

The Fold

06-15-2005 09:14 AM
Ira Solomon

I have been trying to link two tables of address book type field with suffix being one of the fields. Every time I try to link the two tables in...

Susan

06-12-2005 05:52 PM
Susan

I am trying to merge data with MS Word, but am getting problems. I only seem to be able to merge a single record. Can anyone help pls as this is...

Troy

06-11-2005 02:03 PM
Troy

I'm trying to do an update query on a table. I want to update only a subset of the rows, so I am joining the table against a non updateable query...

broadmana@hotmail.com

06-10-2005 12:32 AM
broadmana@hotmail.com

I have created database to allow users to track the progress of setting up systems. Part of the process allows them generate and send an...

ETorasso

06-09-2005 02:52 PM
ALESSANDRO Baraldi

Hi All, I would like to create user-specific menus for when the database first opens (including one for the Administrator) all of which hide the...

Chuck Insight

06-09-2005 08:14 AM
Ira Solomon

I'm coming from a MS-SQL Server background, and I'm accustomed to writing stored procedures that mix programming logic and SELECT statements to...

broadmana@hotmail.com

06-07-2005 12:20 AM
broadmana@hotmail.com

Hello, I'm trying to display a datasheet view of the result of a crosstab query in a subform. I can link the subform to the main form with a valid,...

mharness

06-03-2005 10:56 AM
mharness

LS I have created an MS Access dabase for staff details. In this database I build a Text Box in which I want to display the CV's of the staff in MS...

FairPlay Engineering

06-03-2005 08:51 AM
Ira Solomon

Hi, I have a small, non-fatal problem with my interface. I have main form and subform. The main form contains a list box, to which records are...

Derrick

06-02-2005 09:38 AM
Ira Solomon

I was flipping through the Data Modeling Procedures. I came across Halpian Data Modeling. Book. I want to Know if any one is using the Object...

Keen Computer Solutions

06-02-2005 03:05 AM
Keen Computer Solutions

Hello everyone, I'm having a problem with Access that I need some help with. The short version is, I want to print a list of parts and part...

ChadDiesel

06-01-2005 06:50 PM
ChadDiesel

Hi, I'm using ms access2003 (no sql backend). I have a table with 1000's of orders for difference clients (Example Below). I need to do a query...

Tim Allen

05-30-2005 12:40 PM
Tim Allen

Hi, I want to write a function in VB to copy a table from an existing database in my current database. No problem. The only catch is that I want to...

nicole

05-28-2005 07:56 AM
nicole

I am tring to add a number of years to a dob. im doing this by adding my date+years*365.26 I get a string of numbers. I then convert the number...

John Feeley

05-26-2005 09:58 PM
Bob

Hi and TIA! I have a recordset like so: COG MCC 9G D 7R E 9N (null) 1R D 1R ...

Reggie

05-17-2005 03:56 PM
Reggie

If I have a DB that I created in Access 2000 and my friend only has Access97 on her computer will she be able to somehow open the DB I...

Jim L

05-16-2005 04:22 AM
TamasToth

Good evening, I'm working on a database for a club that I'm in, and I've run into something that has me all confused. I've read through the help...

George Vaughn

05-13-2005 01:50 PM
Ira Solomon

Hi, I am getting a "undefined function "mround" in expression" message when attempting to =Mround(5,2) in Access. Yes I have installed the...

cooperfan

05-10-2005 07:39 PM
cooperfan

Hi I am using ms acces 2002 to read an xml file. I am using the DOM object in ms access - version xml 4 with service pack 2. here is the start of...

Jill

05-10-2005 03:12 AM
Joe Fawcett

I am currently working on an Outlook automation module in an Access 97 database. All is working well except now the client wants the generic...

Giganews

04-29-2005 09:39 PM
Giganews

I have an Access 2000 database which saves (exports) of copy of the main data table each time it is opened. It continually over-writes the same...

Jeff Harbin

04-26-2005 11:35 PM
Jeff Harbin

Mornin, group. Long-time usenet lurker, 1st time poster to this group. If I am in the wrong ballpark, please point me in the right direction :-) I...

kcmagg@NOSPAMcomcast.net

04-25-2005 10:49 PM
Ira Solomon

I'm using Allen Brown's code for audit tracking (http://allenbrowne.com/AppAudit.html). My aud table doesn't populate with the tracking info at all....

Bradley Burton

04-20-2005 10:54 AM
Ken Snell

I have a licensed MS Office 97 package which I have moved from PC to PC over the years and I have just bought a new machine with XP Pro on it, the...

richard

04-12-2005 02:45 AM
richard

is there a way to tell an MDIChild window to always stay on top of the other in Visual Basic 6?

Oin Zea

04-11-2005 06:25 AM
Oin Zea