I use a module which uses Dmax +1 i.e. searches the delivery number field for its highest value then adds one to it and updates the new record with...

David Mitchell

12-12-2006 03:21 PM
David Mitchell

One of my customers occasionally gets a corrupted record - where all the fields show #error and forms bound to the damaged table do not open (the VBA...

ian@unique-databases.co.uk

12-12-2006 02:39 PM
ian@unique-databases.co.uk

Who can indicate a Access-program to list or making iventory of DVD's and their content ?

JDW

12-12-2006 02:22 PM
'69 Camaro

The problem is (using MS Access 2003) I am unable to retrieve long strings (> 255 chars) from calculated fields through a recordset. The data takes...

Henrik

12-12-2006 01:21 PM
deluxeinformation@gmail.com

I have a form that acts like a dashboard to show summarized data. Currently, this form gets its summarized values from a total's query. When the...

BerkshireGuy

12-12-2006 11:49 AM
BerkshireGuy

I am using MS Access forms as a front end to a backend SQL Server Database. I am trying to use an ADO connection to return a Select Statement from...

ashleycvernon@gmail.com

12-12-2006 11:14 AM
Jim Devenish

Hi, I am in serious need of some help PLEASE? I have a 4 tables (April data, May data, June data and July data) with numerous fields. Each of the...

davidhumphrey70@gmail.com

12-12-2006 10:52 AM
kingston via AccessMonster.com

Hi, (sorry for my bad english) I'm using access for a complex database, and I need to create a calendar. For exemple : from the 1st of january to...

bubarnet

12-12-2006 09:30 AM
kingston via AccessMonster.com

Can somebody help me with this scenario? I want to update a date field when another field has a certain value entered. It is something like...

abprules

12-12-2006 07:57 AM
kingston via AccessMonster.com

Hi I am having trouble understanding how to attach a file or files to a record. I want to (in form view0 allow the user to attach one or more than...

calebmichaud@yahoo.com

12-12-2006 07:36 AM
calebmichaud@yahoo.com

I have a table (tblVAS) that contains a field called VAS (Value Added Servies). This field is imported from an AS/400 and the filed contains several...

starke1120@hotmail.com

12-12-2006 02:48 AM
Lyle Fairfield

UPDATE T1 SET T1.F1 = (SELECT T2.FA from T2 where T1.F2=T2.FB+1 AND T1.F3= T2.FC AND T1.F4= T2.FD

cathy

12-11-2006 10:07 PM
Lyle Fairfield

I want to use the caption property for fields in a recordset as a condition in a loop. That is, I only want to consider those fields which...

Bob Darlington

12-11-2006 09:49 PM
Bob Darlington

Thanks in advance to anyone on this... I have a central (Access 2003) database that I need to import about 10 tables from other databases (also...

Parasyke

12-11-2006 09:29 PM
barry.edmund.wright@sympatico.ca

.....as always, with support for MS Acess and other DBs. Altova Version 2007 provides numerous new features and updates, including a revolutionary...

announce@altova.com

12-11-2006 03:46 PM
Larry Linson

I've got the program working fine, it sends email when it needs to and all and it sends it with the proper subject, body and to the proper email...

ManningFan

12-11-2006 01:57 PM
Tim Marshall

I wish to supply text qualifiers to the following date time stamp function, Expr1: FormatDate(Now()) in my query, using fField1: Chr(34) & &...

jmarr02s

12-11-2006 11:23 AM
jmarr02s

"David M" <david (AT) bogus (DOT) domain.dom.invalid> wrote Result! Glad to help. Keith. www.keithwilby.com

Nick 'The Database Guy'

12-11-2006 09:40 AM
Keith Wilby

Hi can anyone help? I am importing emails from Outlook into Access using the following code:

Dean Spencer

12-11-2006 09:37 AM
Dean Spencer

I was recently given the task of entering huge amounts of data into a complex, pre-existing Access database and then using SPSS to access said data...

nicolegw@gmail.com

12-11-2006 09:22 AM
nicolegw@gmail.com

I'm starting a new project. A Personnel System. I have considered opening a single bound form to the main employee table. The user can scroll the...

ApexData@gmail.com

12-11-2006 08:58 AM
ApexData@gmail.com

Ha! Now THIS should truly be the final piece. I've recieved an email, I've sent a reply depending on the subject, but now I also want to prevent...

ManningFan

12-11-2006 08:56 AM
Rick Brandt

For all my apps in A97 and A2003, I write VBA code that constructs SQL statements for MS Jet. I'm encountering something really odd. I won't post...

Tim Marshall

12-11-2006 08:44 AM
Tim Marshall

Hi all, i would like to know how can we ensure that a user fill in each field in a form? How do we create a warning message of a sort" Please fill...

kev

12-11-2006 08:20 AM
Terry Kreft

Despite the windy weather my driveway is still relatively unobstructed with folliage, so you might ask what is my problem. I am using the tree view...

Nick 'The Database Guy'

12-11-2006 05:32 AM
Nick 'The Database Guy'

Hi folks, I have a form(frmResultsDisplay) that displays the status of an equipment. Based on the status whether "Pending" or "Approved", i want to...

kev

12-11-2006 03:53 AM
kev

How can I filter my database in Multiple way, I mean that I wana to filter st. like this: sm* *th* *er Please Help me on this matter Amir

amir

12-11-2006 01:14 AM
amir

I have a (Main) form named : Stocks_Main and a Subform in that named: Stocks_Data The Subform is a continuous form There is a field in the subform...

prakashwadhwani@gmail.com

12-11-2006 12:18 AM
Prakash

Hi All, This is similar to a question I asked earlier however this is following a more "correct" way of doing things. I have normalised and...

m.wanstall

12-10-2006 11:14 PM
tina

Hi, I am running WinXP Pro with Access 2003. I would like to have a window or an Alert Message that displays and stops processing without continuing...

Tim Hunter

12-10-2006 09:19 PM
Tim Hunter

Hi, I have a table in which for a particular record there are different dates in each column. I want to find out the latest date of all.. so for...

Rex

12-10-2006 07:03 PM
m.wanstall

Currently I am using the RegExp object to parse a large dataset in an Access table - but this table was exported from SQL Server, and the very...

Darryl Kerkeslager

12-10-2006 06:47 PM
Darryl Kerkeslager

Forgotten about that one. Had it on my old PC but rarely used it. Will download it again Thanks Phil "David W. Fenton" <XXXusenet (AT) dfenton...

Phil Stanton

12-10-2006 06:25 PM
Phil Stanton

A dump question: for project using access as front-end and RDBMS server (such as sqlsvr) as backend, do we create db in backend first before linking...

Steven

12-10-2006 05:55 PM
Larry Linson

I know you guys are heavy duty coders, while I do ad-hoc analysis, and rarely write code. And, I may be in the wrong groups because this is about an...

Wandering

12-10-2006 04:42 PM
Wandering

When my application starts 2 toolbars still remain open 1) Form View and 2) Formatting (Form/Report) Toolbar Also ... Access's default Menu-Bar...

prakashwadhwani@gmail.com

12-10-2006 12:43 PM
Prakash

I am trying to; Click on a textbox in a form called frmcalendar to open another form petalplanning (I can do that bit). However I want the form to...

keri

12-10-2006 12:34 PM
RoyVidar

Hi, I am trying to create and use a recordset (based on a table) in a module. However I do not understand recordsets (in my access books there is...

keri

12-10-2006 12:13 PM
Lyle Fairfield

I want my code to change the back colour to red (of a form field) if the name is either "admin" or "meeting" or "holiday". I tried this; If...

keri

12-10-2006 06:44 AM
Tom van Stiphout

Is there a way to set a common size for any form, when the user clicks on the middle button in the form control box the restore button for a...

rdemyan via AccessMonster.com

12-10-2006 02:55 AM
keri

I have an application (Developed in MS access with two MDB's one for FE and another for BE) distributed to user group. We have new requirements that...

KK

12-10-2006 01:13 AM
KK

Probably someone else has done this, but I figured out a flexible way to use the Leban's calendar, such that you don't have to write code in the...

DFS

12-09-2006 06:26 PM
DFS

I keep creating combo boxes over and over again without any luck. I want the combo box to look up values of which I can select them. Currently I can...

John

12-09-2006 05:18 PM
tina

Ok...I am a newbie using Access and I have this problem. I have made an application which assigns employees to computers. My main form has a...

MOC835

12-09-2006 03:30 PM
MOC835

This is the code I have; 'Populate the calendar For i = 1 To 37 If IsDate(f("date" & i)) Then myDate = Format((f("date" & i)),...

keri

12-09-2006 02:01 PM
keri

I am currently inputting codes from a product list, some codes every so often are the same, is there a way ms access can flag up if i've inputted the...

Dave

12-09-2006 10:43 AM
keri

Hi everyone, I'm using findfirst in code as below. It searches a query that shows appointment date and account name and should return the account...

keri

12-09-2006 10:13 AM
keri

Hi, I'm automating an import done manually through Get External Data I have assigned the below code to the onclick event of a command button on a...

keri

12-09-2006 09:55 AM
keri

Here I need a help. I have two tables 1) Mis_A 2) Mis_B Mis_A Mis_B Location Revenue ...

Nitin

12-09-2006 07:56 AM
Nitin

I am developing an HR package under Access 2003 for a client but do not want to give him the source code. I understand that under these...

Prakash

12-09-2006 07:27 AM
Rick Brandt