Hello Everyone! I'm wondering if someone could help me out with this problem. We have a database in Access for our library. We also have it linked...

anolith

06-14-2004 12:33 AM
Pieter Linden

It's probably best to ask this by way of an example. Let's say you have a database about a college campus. For each building you've got information...

Greg Boettcher

06-12-2004 09:56 PM
Greg Boettcher

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in column B always...

06-12-2004 03:56 AM

I use MS ACCESS front end back end design. Multiple computers. There is a form that uses a table for calculation purposes. When ever the table is...

Enterprise

06-10-2004 06:35 PM
Enterprise

Hello, I have an db that uses a popup form for entering orders from an inventory item. The popup form uses three subforms to show the progress of...

Albert

06-10-2004 02:27 PM
Albert

I have a database which has a start date field based on this date I would like to have a query create a column name based on the year of that date...

willie

06-09-2004 06:40 PM
willie

i have three columns hrs_due, hrstaken, and totalhrsneeded i need the default value of hrs_due to = totalhrsneeded - hrstaken the data type of all is...

06-09-2004 04:15 AM
Philippe Ducarme

Here is my question: I got the same file on 2 various directories (C:\xxx & a USB support) If I use a macro in an excel spreadsheet, each time I open...

jlcollet

06-07-2004 03:58 PM
jlcollet

Hi I am new to creating and designing Pages in Access and have been caught on a very simple problem. I have inserted an animated gif into the Page...

Bruno

06-05-2004 01:40 AM
Bruno

Hi, i've got a word-template based on which i make a word-document throught automatisation from within my access vba-module. So far, no...

Mr. T.

06-04-2004 04:33 AM
Mr. T.

I have one main form which contain three subforms overflapping each other. Depending on a data field (X) on the main form, when X=1 then...

sean

06-04-2004 12:10 AM
sean

Hi, I have a extended combo box(mybox) that gets its values from a Table. Is there anyway to assign for the on click event procedure the zero based...

Enterprise

06-03-2004 04:47 PM
Gary Floam

We have a VisualBasic application for our field personnel that stores data in an MS-Access database. When they come out of the field...

moose

06-03-2004 04:41 PM
Gary Floam

I'm working in Microsoft Access 2002. I have two tables (Order and Customer) that are related by a field called CustomerNum. I'm trying to changed...

Harry

06-03-2004 09:19 AM
Walker

Hello: I apologize as I am not a computer expert at all, but I have a problem and was hoping for some help from knowledgeable people. We have a...

btrix

06-02-2004 06:16 PM
Stephan Bren

I'm in the middle of building a database in access 2002 for a client of mine. I just wanted to know what my choices were to make this database...

InDeSkize

06-02-2004 02:13 PM
InDeSkize

I have a database that generates surveys to send to employees annually. I've set up a progress log for the user, such that when the survey...

Johnny Meredith

06-02-2004 11:18 AM
Johnny Meredith

What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check...

Ernest

06-02-2004 11:16 AM
Ernest

Hi, I'm creating a small database and i'm having one problem. I can't import files into my form using a scanner. For example I have a form called...

Peter

06-02-2004 09:33 AM
Peter

question: I have sermon illustrations that I need to query quickly, and my paper filing system is not working. could I be able to scan a document...

M & C Milinovich

06-02-2004 09:12 AM
Peter

My problem. I have the task of creating a database where the user is going to have the ability to simply upload spreadsheets from another database...

Dave Sanchez

06-02-2004 12:16 AM
Dave Sanchez

Hello all - Whenever I use the Chart Wizard in Access, the final chart does not display my data, but example data that Access has stored in one...

heket789

05-31-2004 12:41 AM
Jeremy B. Shapiro

In a main form, I want to open a subform at one condition and open a different subform at another condition, How to it? I'm using...

Rich

05-31-2004 12:32 AM
Jeremy B. Shapiro

Sam, Check into efax (www.efax.com) You can send an email to their efax servers via email and it'll create a fax and send it from there. Very easy...

Jeremy B. Shapiro

05-30-2004 03:30 PM
Ira Solomon

OK, here's the sitch : we have an access control system at work that registers ever entry/exit of every employee. I recently made some queries in...

Melissa Kay Beeline

05-30-2004 01:42 PM
Jeremy B. Shapiro

does anyone know what is the maximum number of fields that can be updated at once in access 2000 i am updating approx. 150 at once and keep getting...

05-30-2004 01:35 PM
Jeremy B. Shapiro

Can someone help! I want to insert a feild on a Access 2000 database form where you insert Date of Birth in another feild I want in to automaticly...

Dave PNNZ

05-30-2004 01:16 PM
Jeremy B. Shapiro

I have been recently looking at various off the shelf stock / inventory programs for use in a small transport and warehousing Company , but found...

J.HUNTER

05-30-2004 12:44 PM
J.HUNTER

I have found reference to this problem in Knowledgebase but cannot understand solution. I cannot get help details displayed. e.g. In module -...

ML

05-30-2004 10:06 AM
ML

Hi, I'm running a query in VBA and it doesn't work when I try to clear the value in Flag_Reason. When I use this: sqlstr = "UPDATE...

John Shaw

05-28-2004 07:20 PM
John Shaw

I have a table with a single record that contains checkboxes. They are checked off if certain events have occured. In my query, I want to base...

rc

05-28-2004 02:29 PM
rc

I'm a novice in access 2000 and I have a problem when I try to start a wizard include in the program i.e. when I start, the program give me the...

pierre

05-28-2004 09:37 AM
pierre

I have a Microsoft Access 2000 (9.0.4402 SR-1) database that I am attempting to launch from a hyperlink using Internet Explorer...

Bill Thom

05-27-2004 11:51 AM
Bill Thom

I am attempting to create a form (Access 2000). When I use the tools wizard to insert a command button onto the form (such as a record navigation...

Gus

05-27-2004 08:03 AM
David Thomas

hi, I am making a stock control database in access. I have created a table that shows the stock. But i want to compare it with the minimun stock...

matx

05-27-2004 07:53 AM
David Thomas

I have been fighting with this and looking around the net for hours now. I have added a combo box to a form. Row Source Type - Table/Query Row...

Mark

05-27-2004 03:24 AM
Andrew Backer

Hello - I am having trouble figuring out how to code a calculated field in a query to determine a turn time on a process. I have the start time and...

Phil Doughty

05-26-2004 03:38 PM
Phil Doughty

Having an odd little problem with one of my forms. I have a button on my form, which is in 'repeating form' mode. When I use an event procedure for...

Andrew Backer

05-26-2004 12:34 AM
Andrew Backer

I've tried IsNull() and IsEmpty() on an uninitialized ADODB.Recordset, but they both return False. VBA, at least under Access 2000, doesn't like the...

MyndPhlyp

05-25-2004 03:25 PM
MyndPhlyp

Hey Everyone, I have a fairly simple, but for me advanced question. Here's the story. I have a calculated text box in a form that is supposed to...

InDeSkize

05-24-2004 10:33 AM
InDeSkize

Hi all, How can I add a row in a subform from code? I have a form named "papers" containing textboxes txt_papers_id,...

rrk

05-24-2004 01:55 AM
rrk

To all Guru's I have the below listed query in access, it works fine, but I need to display the same results by months. SELECT SurveyResults.Q2,...

Brvsra

05-22-2004 08:10 PM
Brvsra

"Anita Mossey" <amossey (AT) dupagehealth (DOT) org> wrote "Retrieve passwords?" Could you clarify? It is possible to hack passwords, as clearly...

Larry Linson

05-21-2004 10:04 PM
Larry Linson

I have a medium sized access database. I use the auto-number as the primary key in all my tables. Recently, one of my tables has been producing...

Trollina

05-20-2004 02:10 PM
Trollina

In access 97 I could Dim As Database. Access 2002 doesn't have that option : ( What do I do instead?

gn

05-20-2004 10:36 AM
MikeB

can someone help me, how do you convert ms access to sql server...?

quartz

05-20-2004 09:28 AM
Ira Solomon

As the most Access-savvy person in my office, I have been handed the task of proposing a nationwide expansion of a project that I have developed in...

user451@anon.com

05-20-2004 01:45 AM
Michael

how to convert ms access to sql server?

quartz

05-20-2004 12:56 AM
quartz

Hi there everyone again, My question is that in a database that I have inherited , there is a line of code: db.Execute "Drop Table ",...

Michael

05-18-2004 11:28 PM
Michael

I have a database that runs the usual front end/backend configuration with a user base of about 15 people. I have just started working for the...

Michael

05-18-2004 06:57 PM
Michael