I have some tables with many records that need to be normalized. When I use the table analyzer wizard, it appears to read and attempt to match on...

Dale

09-26-2003 02:11 PM
Dale

I know there is a colander addin for Access. However you cannot enter or post data to a date on the colander. I want to build a colander based on...

E SMITH

09-26-2003 10:49 AM
E SMITH

we have a database that contains 2500 records. one of the fiels is social security number. it crashed and was recovered, but when i try to set a...

Ken

09-26-2003 09:19 AM
Andy

Have a Table similar to the following: Col 1 Col2 Col3 Part Number Description ...

What-a-Tool

09-25-2003 08:56 PM
What-a-Tool

I am hope to get some help from all you experienced Access programmer. I am trying to help out a co-working that really need some help in getting...

RC

09-24-2003 09:10 PM
Bradley

The question is. I have a form that half the data is the same and I want it to recur. example I have different users at different locations. When...

Doc

09-24-2003 09:40 AM
janthony

Hi users, First of all, I apologise for this blanket mail. I'm from a small software company in Navi Mumbai. We've developed a new RDBMS...

Manish Bafna

09-24-2003 03:20 AM
Manish Bafna

Hello, I am trying to put together an app to capture information about documents and their relevance to a subject. I will be using access to define...

bjwhitby

09-23-2003 09:13 AM
bjwhitby

I have a .mdb that autoruns a vb program. I can't figure out how to stop the autologin from running and even when I change code in the debugger,...

Bernie Yaeger

09-21-2003 04:22 PM
Bert vd Heuvel

I have a Front End and Back End, both of which are on the network in the same directory. The Front End contains all the temp tables...

Diane

09-21-2003 08:55 AM
(Pete Cresswell)

Hi, I try to make labels with a custom size, but when I type the sizes into the fields they change e.g. if I type 7.4 cm it is changed to 740.00. I...

Jeroen Kluytmans

09-19-2003 07:04 AM
Jeroen Kluytmans

We use .snp files generated from an ADP for publishing reports. There are embedded .emf images as well as carefully formatted text within the output...

klog

09-18-2003 01:26 PM
klog

Hello, I need to pass information from one web form into two seperate tables in Micrososft access. Does anyone know how to do this? Cureently I can...

Ian

09-18-2003 05:21 AM
Ian

Honestly I can't believe I'm asking this question, since I've worked on Access for years, but I've been away from it for a bit and for some reason...

sjboyd81

09-17-2003 10:07 PM
Bradley

Hello, Something is puzzeling me for some time. In a form the filter property is set with VBA to something like: me.filter = " > #1-1-03# and <...

Ad van den Ende

09-17-2003 04:00 PM
Ad van den Ende

Hi, i am trying to select get data to go into a field when the user selects data from a dropdown. for example Table 1: Name Address Joe...

Badger

09-17-2003 09:52 AM
Badger

Hi, I have made a pivot table in Access 2002 but when I try to select for example, customers in a list my checkboxes cannot be selected...

Milan

09-17-2003 08:25 AM
Milan

Hey, I have to store all the hardware in a network in an access db... I have made some tables like servers, pc's, hubs, printers, ... But I now have...

Oswald

09-17-2003 06:27 AM
Oswald

I am trying to select a particular printer paper bin with VBA, on a networked printer/copier, and the particular paper bin I want is not covered by...

mike

09-16-2003 04:18 PM
mike

I have a database with employee hire dates. I am trying to write a program to show who's performance reviews are due the week beteen (begin date and...

Pras

09-16-2003 04:03 PM
Pras

I have a report that lists tasks that people have worked on with starting and ending times. The report looks like so: ID Task Startdate ...

Dan Leeder

09-16-2003 01:18 PM
Dan Leeder

Hi: Can anyone help me? I have a Multi-Selection List-Box on a Form. After the User selects the deisred records I want to open/edit those records...

Bruno

09-16-2003 10:22 AM
janthony

Hello Access Gurus! I am developing an application in A2K.I have a subform in which 3 fields exist.The link between the main being an ID field.The...

Rob

09-16-2003 06:58 AM
Rob

Hi All, I'm using the following query to select records in a database: SELECT (consumpties.prijs*aantallen.aantal) AS subtotaal, * FROM Leden...

Pascal Herms

09-15-2003 05:43 PM
Pascal Herms

Hi, Anyone know how to convert a daily number to a 30/360 basis. It's gets difficult when there are 31 days in a month or 28 days. It's increasing...

Diane

09-15-2003 12:18 PM
Yegnaram Iyer

Hi, I am using access as a front end and backend for an application.There are few things i need assistance: 1.I have a form with a few text fields...

mickykt

09-15-2003 12:16 PM
Yegnaram Iyer

Hi all! I am creating a Disney "Today in History" database, and so far have about 300 entries in it. Well, my Access database is great, and my...

Dan

09-15-2003 12:07 PM
Yegnaram Iyer

Hi, I would like to know how one would implement the equivalent of a stored procedure in MS Access. For example, if I delete or update few records in...

Yegnaram Iyer

09-15-2003 12:02 PM
Yegnaram Iyer

I have an access DB with two name fields, first and last, that I want to move into one field with the format "last, first". All the fields are...

Jeff

09-15-2003 08:40 AM
Ray

Hello, Does anyone know how to make Me.OpenArgs.SetFocus work? I'm trying to use it to set the focus to a command button on a menu. Thanks, Mike

mharness

09-15-2003 07:11 AM
mharness

Can anyone provide VBA code or a solution for the following: I would like to print a form by using a button on it that not only prints the form but...

Jon

09-14-2003 06:27 AM
Jon

Can someone post the Access 2000 VBA code for inserting an OLE object into a form's OLE object field. I understand that I can do it by right...

Jon

09-14-2003 02:49 AM
Jon

I have a table that is used to store configuration information,and it should have only one record in it. I would like to protect it against having...

Tim Blanchard

09-14-2003 02:33 AM
Tim Blanchard

Hi: In an ms-access form, I wrote some code on doublick of a listbox to process data, and then call a save subroutine to store updated fields to a...

KF

09-13-2003 08:16 PM
Chris

Im trying to set up a couple of tables to keep track of football stats for a pool I'm in. This is more of a learning exercise for me than an...

What-a-Tool

09-13-2003 12:07 PM
What-a-Tool

I have written a DB that will read in the meter readings from a series of machines at work and will then trend those results - just to give...

Rod

09-11-2003 09:17 PM
Rod

I was playing with the settings for start-up, and lost access to all my menu-bars and design mode. How do I get them back ? TIA for you help

user451@anon.com

09-11-2003 04:53 PM
user451@anon.com

In access2000 the tables have +'s on each record that display related data and that data will also have a + to see lower related data. I can't see...

Bill

09-11-2003 04:07 PM
Bill

I am running Windows XP, MS Access 2000, with all patches. I have a huge DB, 30 users, split front and back end, etc. I have not been having this...

VBJonC

09-11-2003 12:43 PM
VBJonC

I am using a combo box on a form to select values from a table/query. Does anyone know how to build an expression that will set the default value...

Kanook

09-10-2003 09:52 PM
Kanook

Hi, Bradley I had to switch computers the other day (the first one died and I can't get to the data). On the new one, I can't seem to set the news...

LWD

09-10-2003 08:39 PM
Bradley

I am trying to link a table to Form but how do you link a table to form that a person can enter the data for Employee Form? What should I do? Thank...

Ashley

09-10-2003 02:26 PM
r0adh0g

I want to create a database that will keep a running balance for multiple clients. How do I do this? Thanks.

John

09-10-2003 11:41 AM
John

Can anyone offer a way to convert a text field to a url? Thank you.

Tim Raisbeck

09-10-2003 11:39 AM
Tim Raisbeck

I'm struggling my way through building an Access 2k application, learing how to do each step as I get to it .... in other words I'm pretty new at...

Ragtimer

09-09-2003 04:19 PM
Ragtimer

Does anyone know if it is possible to set a property to turn off the linking feature in MS Access so that another program (i.e. MS Word) can not link...

DNK

09-08-2003 06:10 PM
Scott McDaniel

Hello Let's say...well, this isn't hypothetical, so...in MS Access, I put together a report, which was pulled from a query, which was, in turn,...

smackedass

09-08-2003 04:32 PM
janthony

I am hoping someone can help me. I am making a Access 97 app for a person and have run up against a problem to do with MS Graph. There is a table...

Jeff Blee

09-07-2003 10:08 AM
Jeff Blee

I want to do an Access database for my company. I've just moved into an area where there are about 370 clients on a regular basis. The turnover...

Morpheseus

09-06-2003 01:22 AM
Morpheseus

"Jeff Barry" <jbarry (AT) picr (DOT) man.ac.uk> wrote Try.. Me!.Requery or if calling from another form/subform Forms!MyForm!.Requery

Bradley

09-05-2003 04:52 AM
Jeff Barry