Hello, Anybody kows if SQL/ACCESS has condicional expresions, bucles ....etc, like PL/SQL Thanks a lot

Jero

03-07-2005 05:50 AM
Jero

Hi, I am having issues real troubles getting a solution for the following, any help would be really appreciated:- I have a table like the following...

Richard Davies

03-07-2005 05:48 AM
Madhivanan

I have recently updated my database to include a postcode recognition function. And to perform calculations based on that recognised value. The query...

dd_bdlm@yahoo.co.uk

03-07-2005 04:34 AM
dd_bdlm@yahoo.co.uk

Good day, I am not a programer but have made quite a big access data base and want to know if it is possible to have a pop up message if there are...

Tempy

03-07-2005 12:44 AM
Tempy

Hello, 1. I received a mail from Larry but it doesn't work, I'm not a programmer. How can I simply make a field (street) begin with a capital letter...

Marc Verdonck

03-06-2005 09:29 PM
Larry Linson

I need to unpack a bunch of values (Single data type) from an OLE Object field. I think the Windows API has a CopyMemory function that could,...

deko

03-06-2005 07:20 PM
deko

Can grid lock be turned of when designing a form? Thanks, Jack

Jack

03-06-2005 06:45 PM
Ken Snell

In the control source of a textbox, is there a way to refer to a column of a combobox? For example: =.Column(2) Thanks, Jack

Jack

03-06-2005 06:08 PM
Ken Snell [MVP]

Can anyone tell me why this VBA returns a null value when the source table doesn't have one? I have a table called 'zTerms' with fields 'TermID',...

Colin Mardell

03-06-2005 04:28 PM
Douglas J. Steele

Is there a program out there that will close a access db to make it a free standing program. I friend of mine is building me a database free of...

Chuck M

03-06-2005 11:35 AM
Linda Burnside

All, I would like to implement a recursive relationship in a table with referential integrity enforced and cascade update turned on. For example, a...

MDS

03-06-2005 11:19 AM
MDS

I have a report that groups data on an Area, the report is set to force a new page for each Area within the report. Each Area will have 1 or more...

Elasho

03-06-2005 10:19 AM
fredg

Thanks for the help.

Mike

03-06-2005 09:39 AM
Jim Allensworth

I have created a database in Microsoft Access (Office XP) , created all tables etc. Went to create forms all fine using wizard, went into design...

Carl

03-06-2005 08:30 AM
Rick Brandt

I am using outlook redemption but sometimes my emails are not sent and remain in the drafts folder. Has anyone any ideas why some emails are sent but...

Dave

03-06-2005 08:11 AM
pietlinden@hotmail.com

This has to be simple, but I'm forced to admit that I'm a novice who can't figure it out. I have a listbox in a form that allows multiple...

Onion

03-06-2005 07:34 AM
Douglas J. Steele

Hi I am trying to use the server.scriptimeout for my asp code for sending the mails to my 1000 odd subscribers But after approx 150 records the...

g_sharad@yahoo.com

03-06-2005 04:14 AM
g_sharad@yahoo.com

Danny Yeadon wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Since you're grouping by the Line value in the report, I'm assuming there is a...

MGFoster

03-06-2005 03:34 AM
Danny Yeadon

easy.pc (AT) comcast (DOT) net wrote: DIfficult to find out what is Access applications I can modify there.

Olav.NET

03-06-2005 02:20 AM
Olav.NET

Hi All If I Take DateFrom from DateTo in a 31 day month I get 30 days because 31-1=30, is there a way of getting the correct answer without having to...

Patrick Fisher

03-06-2005 02:14 AM
Bob Quintal

Hi, In my Access Report ... If there is "NO" entry i.e. (no corresponding CODE) in my Data-File, then even the Master-File entry does not show up in...

Prakash

03-06-2005 01:18 AM
Prakash

Hello, I'm using an access db for a site that I want to make subscription. The subscription will be by the month and auto recurring if the member...

David

03-06-2005 12:15 AM
David

What is the syntax for the criteria in DLookup in a subform to refer to a control (MyControl) on the subform? I have tried the following and none...

Jack

03-05-2005 10:13 PM
Ken Snell

Hi all, I am trying to design a database in access 2002. I have multiple category of items such as computers which may include laptop, server,...

Burghew

03-05-2005 09:36 PM
Albert D. Kallal

I have a table with a Hyperlink in it. I would like to put it on a form where I can click on the hyperlink and it will open the web page. Is there...

Coy Howe

03-05-2005 07:10 PM
pietlinden@hotmail.com

I'd like to trap an error if a user inputs a bogus time. The input requires a short time format. If the user enters someting like 20:78, Access...

Rebecca Smith

03-05-2005 05:46 PM
Rebecca Smith

Hi, I wonder if it is possible to filter a subform in Access 2002. In other words, the selection criteria of the filter are defined by the fields of...

Shiva

03-05-2005 04:23 PM
Shiva

I have an Access 2002 database on a diskette. When I try to open the file I get the error "The Microsoft Jeft database engine stopped the process...

Pat

03-05-2005 03:38 PM
Tony Toews

I'm generally against using compound keys, except in join tables, but I'm currently mapping out a schema where the join table has child records. The...

David W. Fenton

03-05-2005 02:35 PM
David W. Fenton

On my old Win 95 machine on the property tab of an access file the following options show. -Read only Archive Hidden System (Grayed) When a file has...

David B

03-05-2005 02:25 PM
David B

Hello all, I am using ADO.NET and trying to update the MsAccess database but unable to do so. Here is the code below that I used. Private Sub...

Vibhu

03-05-2005 01:03 PM
MGFoster

Sincere thanks to Stephen Lebans for sticking with me on this one. I have learned a great deal from this. No more questions at the moment 'cos I'm...

Brian Keanie

03-05-2005 12:54 PM
Brian Keanie

hello all, I just developed a .adp project that access to SQL Server 7 using the "application role" functionality of mssqlserver, but unfortunately I...

ansi_c

03-05-2005 12:34 PM
ansi_c

Hi -- I have a Data entry/sequencing problem. Any help appreciated. Here is the scenario: Given -- A table with the following fields and sample...

robboll

03-05-2005 12:24 PM
robboll

hello, I just developed an .adp application linked to SQL Server 7, I compiled it disabling also all the shortcuts from the tools->startup menu and...

ansi_c

03-05-2005 12:08 PM
ansi_c

Hi folks, I have a database which holds data for multiple campuses. At startup, it requires the user to identify which campus they want to...

Ray

03-05-2005 09:26 AM
pietlinden@hotmail.com

I had asked a question about the above subject a few days ago and between Stephen Lebans and Rog received the following answer. Would someone please...

Brian Keanie

03-05-2005 08:35 AM
brendan.tompkins@gmail.com

I have an option group on my form to toggle the controls' Locked property. Somehow I'm also locking the "Unlock" button, but I'm not sure why. Here's...

eliffman

03-05-2005 07:12 AM
eliffman

Allen Browne's site containing many free tips and solutions for serious and casual Access users is being relocated to another server. If you are...

Allen Browne

03-05-2005 06:03 AM
Allen Browne

I have a report based on query..which is a team list with names and their role on team ie coach, assistant and player. Report is almost what I want...

Anne M

03-05-2005 03:51 AM
Phil Stanton

I have an option group on my form that is used to toggle the form controls' Locked property. Somehow I'm also locking the "Unlock" option button (or...

eliffman

03-04-2005 10:51 PM
eliffman

Hi, I am using a text box to input a date in a form and from that date I want to show a new date in another text box which is one calendar...

John

03-04-2005 09:42 PM
Jeff Smith

I had asked a question about the above subject a few days ago and between Stephen Lebans and Rog received the following answer. Would someone please...

Brian Keanie

03-04-2005 09:07 PM
Stephen Lebans

I have an MS Access userform with 16 Check Boxes. Each of the checkboxes has a different option value, which coincides with the Check Box name (eg....

Travis.Box@gmail.com

03-04-2005 08:38 PM
PC Datasheet

Hi folks, I'm using a web page I've found as a reference to some pet project I'm working on in Access and I'm having trouble "translating" some of...

Tim Marshall

03-04-2005 08:05 PM
Tim Marshall

Hello How do I write the On Action property of a CommandBar Control to call a function that requires arguments? Ex: Function Public Sub...

GGerard

03-04-2005 06:01 PM
GGerard

This is kicking my @#$%. I have been asked to do a performance report for our vendors. I need to compare and count dates. 1. Is called which is in...

Michael Curtis

03-04-2005 05:13 PM
Douglas J. Steele

I'm running Access 97 on Windows 98. I need to make large tables and queries with approaching but not exceeding 225 fields (columns). Access is...

Proteus

03-04-2005 05:08 PM
Douglas J. Steele

I've got a routine that creates a Mail merge doc in Word. I'd like to add a title and/or header to the document. How can I do this in code? In other...

Jim

03-04-2005 04:38 PM
pietlinden@hotmail.com

Hi, Hi, please take a look at the code below, I am having a problem, because Me.Tracking Number has a space between 'tracking' and 'number', I am...

Nick J

03-04-2005 04:12 PM
fredg