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

Can this be fixed? I have a combo box which is filled with lots of choices on a certain form. I click on the combo box and want to scroll down...

Otie

04-10-2005 04:41 PM
Ken Snell

Hi, I have a MS Access db MDE which is linked to some SQL tables on a server. Now in my company we are using a certain IP address. The same DB is...

S

04-08-2005 07:12 PM
S

I have a database linked to an Excel file and has been working fine for the last few years, now I can't create a new linked database or use linked...

A Katon

04-08-2005 12:20 AM
A Katon

hello, I just developed an .adp application linked to SQL Server 7, I compiled the application and obtained a ade project disabling also all the...

ansi_c

04-07-2005 03:58 PM
Ol!v!é

i am experimenting with forms and the add and delete buttons. currently the pirmary key is a long integer that autoincrements. i am starting off...

Steve

04-05-2005 10:33 AM
Ira Solomon

I've been posting questions here the last week, but if you don't know my situation: I have a "Print Labels" button on the subform that sends the...

ChadDiesel

04-04-2005 10:37 AM
Ira Solomon

Is there a simple answer as to why my database will not save the data that correctly appears in the AccountID textbox on a form to the table when I...

Otie

04-03-2005 03:33 PM
Otie

I am trying to create a report from a table that includes a list of dates. In the report I want to group the data as follows: FIRST SECTION: All...

jaydeeman

04-02-2005 02:50 PM
Ira Solomon

Congratulations.....I think? :-) David Hodgkins, MCSD, MCDBA, MCSE JSTAR Software Solutions 4402 Sweet Cherry Ln. Kalamazoo, MI...

David

03-31-2005 05:53 PM
David

Hello Again, I want to assign a number to each record that will be part of a shipping number. I want the number value to count up until the...

ChadDiesel

03-30-2005 09:57 PM
Ira Solomon

Hi, I've been trying to use a Sub or Function in VBA to connect to a database, make a query and return the recordset that results from the query....

lenny

03-30-2005 07:06 AM
David Hodgkins

Everyone on this group has been a great deal of help. I have another question that I could use some help with. Once again, here is a picture of my...

ChadDiesel

03-29-2005 05:21 PM
ChadDiesel

I'm new to Access and need some advice. I am trying to setup a database to print labels and reports for our shipments. I have set up a table...

ChadDiesel

03-26-2005 05:08 PM
ChadDiesel

at school we have a database, with local files in access and files central in a sql (msde) server. in the program you can login with your name and...

benny

03-25-2005 11:53 AM
Sean

Set dbsCC = OpenDatabase(Path & "\CC.mdb") Set Clients = dbsCC.OpenRecordset("Clients") At any time how can I tell how many records are in...

Oin Zea

03-25-2005 11:34 AM
Sean

Just in need of a bit of advice. I'm currently building a database to store information about different products. Currently about 350 products with...

Bex

03-21-2005 09:12 PM
Ira Solomon

I have been trying to set a recordset = to a table and thus designate the recordet's type as 1 (dbOpenTable). Everytime the code executes, the...

BennyD

03-21-2005 04:17 PM
BennyD

I have been trying to set a recordset = to a table and thus designate the recordet's type as 1 (dbOpenTable). Everytime the code executes, the...

BennyD

03-21-2005 03:29 PM
BennyD

Hi, I made a query to a table and then based a lookup filed on that query. Now when I refresh the table I do not get the relationship error -...

buck

03-19-2005 08:08 AM
buck

I'm looking for ~user-friendly access based sales quoting database. I'm using a filemaker pro dbase and though it is easy to use, I'm...

bw

03-18-2005 05:02 PM
Jesse Aviles

Hi, I am trying to figure out how to run 3 reports and attached them to one email using a macro. I can only get 1 report per email message. Help! ...

Heidikf

03-15-2005 11:20 AM
Ira Solomon

I am trying to update a memo field in a table from a form that I have created. The form is unbound, and once the user makes their changes, they have...

Andrew.Donnelly@Shell.com

03-15-2005 01:21 AM
kevindotcar@gmail.com

hi there.. I want to print a control on a report, based on the criteria of whether the value in the control is null or not... My hunch is that I...

Helen Martin

03-12-2005 04:25 PM
Ken Snell