Psuedo Code - Microsoft Access / VBA

Blue Bell Trading - Customer Services

Hi,

I would be very grateful if somebody could point me in the right direction.
I need access to perform the following operations when I click a command
button...(I am using yes/no fields for TRUE and FALSE) If you could give me
the first 2 lines I could probobly work the rest out myself....Many Thanks!

All records that have the PROCESSED field as FALSE will be set to TRUE
All records that have the NEWORDER field as TRUE will have their OLD field
set to TRUE
All records that have the OLD field set to TRUE will have their NEWORDER
field set as FALSE
All records that have the OLD field set as FALSE will have their NEWORDER
field set as TRUE

--
Kind Regards,
Customer Services
Blue Bell Trading

Nov 13 '05 #1

Subscribe Post Reply

1505

Randy Harris

"Blue Bell Trading - Customer Services" <bl*************@blueyonder.co.uk>
wrote in message news:4v********************@fe2.news.blueyonder.co .uk...

Hi,

I would be very grateful if somebody could point me in the right direction. I need access to perform the following operations when I click a command
button...(I am using yes/no fields for TRUE and FALSE) If you could give me the first 2 lines I could probobly work the rest out myself....Many Thanks!
All records that have the PROCESSED field as FALSE will be set to TRUE
All records that have the NEWORDER field as TRUE will have their OLD field
set to TRUE
All records that have the OLD field set to TRUE will have their NEWORDER
field set as FALSE
All records that have the OLD field set as FALSE will have their NEWORDER
field set as TRUE

--
Kind Regards,
Customer Services
Blue Bell Trading

If I'm interpreting the requirements correctly from your post, this update
query will do what you want.

UPDATE t SET t.Processed = True, t.NewOrder = Not [Old], t.Old =
IIf([neworder],True,[Old]);

HTH,
Randy

Nov 13 '05 #2

Blue Bell Trading - Customer Services

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:Bg*******************@newssvr19.news.prodigy. com...

"Blue Bell Trading - Customer Services" <bl*************@blueyonder.co.uk>
wrote in message news:4v********************@fe2.news.blueyonder.co .uk...
Hi,

I would be very grateful if somebody could point me in the right

direction.
I need access to perform the following operations when I click a command
button...(I am using yes/no fields for TRUE and FALSE) If you could give

me
the first 2 lines I could probobly work the rest out myself....Many

Thanks!

All records that have the PROCESSED field as FALSE will be set to TRUE
All records that have the NEWORDER field as TRUE will have their OLD
field
set to TRUE
All records that have the OLD field set to TRUE will have their NEWORDER
field set as FALSE
All records that have the OLD field set as FALSE will have their NEWORDER
field set as TRUE

--
Kind Regards,
Customer Services
Blue Bell Trading

If I'm interpreting the requirements correctly from your post, this update
query will do what you want.

UPDATE t SET t.Processed = True, t.NewOrder = Not [Old], t.Old =
IIf([neworder],True,[Old]);

HTH,
Randy

Hi Randy,

Thats worked great thanks.

--
Kind Regards,
Customer Services
Blue Bell Trading

Nov 13 '05 #3

Similar topics

OO in PHP

by: Mudge | last post by:

Please, someone, tell me why OO in PHP is better than procedural.

PHP

FrontController Design Pattern and Code Reuse

by: bigoxygen | last post by:

Hi. I'm using a 3 tier FrontController Design for my web application right now. The problem is that I'm finding to have to duplicate a lot of code for similar functions; for example, listing...

PHP

somewhat painful join code

by: jason | last post by:

Hello. Newbie on SQL and suffering through this. I have two tables created as such: drop table table1; go drop table table2; go

Microsoft SQL Server

Strange behaviour of simple code

by: Dario de Judicibus | last post by:

I'm getting crazy. Look at this code: #include <string.h> #include <stdio.h> #include <iostream.h> using namespace std ; char ini_code = {0xFF, 0xFE} ; char line_sep = {0x20, 0x28} ;

C / C++

using list

by: gigal | last post by:

For some "new" created objects of class A with pointers, how to put them into a list, list<class A> l? p1 = new A(); p2 = new A(); P3 = new A(); .... Thank you very much!

C / C++

109

Top warning signs of bad code?

by: Andrew Thompson | last post by:

It seems most people get there JS off web sites, which is entirely logical. But it is also a great pity since most of that code is of such poor quality. I was looking through the JS FAQ for any...

Javascript

Dealing with ties in ranking code

by: ED | last post by:

I currently have vba code that ranks employees based on their average job time ordered by their region, zone, and job code. I currently have vba code that will cycle through a query and ranks each...

Microsoft Access / VBA

Article : Code Access Security Part - 1 (.Net FrameWork Tools Series)

by: Namratha Shah \(Nasha\) | last post by:

Hey Guys, Today we are going to look at Code Access Security. Code access security is a feature of .NET that manages code depending on its trust level. If the CLS trusts the code enough to...

.NET Framework

Eval code and AppDomains

by: Joe Fallon | last post by:

I have some complex logic which is fairly simply to build up into a string. I needed a way to Eval this string and return a Boolean result. This code works fine to achieve that goal. My...

ASP.NET

What's the difference/advantages between code behind and code inside?

by: Alan Silver | last post by:

Hello, Newbie here, so please forgive what is probably a basic question ... I see a lot of discussion about "code behind", which if I have understood correctly, means that the script code goes...

ASP.NET

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp