stupid access db, can't do good stuff - Microsoft Access / VBA

Almir

This db i created has been driving me nuts. I have this one table
LOCATIONS, and in the data entry forms, the user is suppose to change
the locations of the equipment or set a location when first entered. I
set the property not to expand and limit to list, yet they somehow
edit the data there anyways. I want to prevent that. I want them to be
able to choose the options in combo box (with data from table
locations) but not edit the locations it self (the choices)...the
locked option is not going to work because it doesn't let the user to
change from location to location...it needs to be able to do that but
not edit the listing (the list it self) help anyone...

Nov 12 '05 #1

Subscribe Reply

6867

Salad

Almir wrote:

This db i created has been driving me nuts.
Its possible the db is a figment of your imagination.
I have this one table
LOCATIONS, and in the data entry forms, the user is suppose to change
the locations of the equipment or set a location when first entered. I
set the property not to expand and limit to list, yet they somehow
edit the data there anyways. I want to prevent that. I want them to be
able to choose the options in combo box (with data from table
locations) but not edit the locations it self (the choices)...the
locked option is not going to work because it doesn't let the user to
change from location to location...it needs to be able to do that but
not edit the listing (the list it self) help anyone...

Is the field they are updating a text box? Or is the field a Combo box?

If it is a combo box, you Set Limit To List to true/yes In the NotInList
event, you could enter something like
Msgbox "Select a location from the list."
Response = acdataerrcontin ue

Now if you have a textbox, in the BeforeUpdate event you could do
something like this
Dim varLoc As Variant
varLoc = Dlookup("YourLo cationTableFiel dName", _\
"LocationTableN ame","YourLocat ionTableFieldNa me = " &
Me.YourLocation TableFieldName
If IsNull(varLoc) Then
msgbox "Please don't enter new locations"
Cancel = True
Endif
Due to your frustration, you didn't cover your problem suffieciently. Let
us know if you have a combo, a text box, both text and combo, how the data
is selected in the combo...whateve r else that will help us in helping you.

Nov 12 '05 #2

Bruce Pick

My guess is that the user(s) is going to the table that provides the
list for the combo box, and changing that list. It's easy to do if
you're using a table to populate the dropdown list.

If the source is a table, can make the table hidden (right-click on the
table's name, click properties, check-yes "Hiddden"). Then make sure
the user's machine is set to not show hidden objects (Tools - Options -
View).

You also can set up an enforced relationship between such a short-list
table and the main table. Use Tools - Relationships

You can make them leave the table alone, or you can set the dropdown
list items another way. You could do it in the properties box (Row
Source Type = Value List, and Row Source is a list of items, like:
apples;peaches; bananas;pears;o ranges
Another way is to set the list values via VBA code.

Good luck!
Bruce Pick

Almir wrote:

This db i created has been driving me nuts. I have this one table
LOCATIONS, and in the data entry forms, the user is suppose to change
the locations of the equipment or set a location when first entered. I
set the property not to expand and limit to list, yet they somehow
edit the data there anyways. I want to prevent that. I want them to be
able to choose the options in combo box (with data from table
locations) but not edit the locations it self (the choices)...the
locked option is not going to work because it doesn't let the user to
change from location to location...it needs to be able to do that but
not edit the listing (the list it self) help anyone...

Nov 12 '05 #3

Rick Brandt

"Almir" <al*****@yahoo. com> wrote in message
news:72******** *************** ***@posting.goo gle.com...

This db i created has been driving me nuts. I have this one table
LOCATIONS, and in the data entry forms, the user is suppose to change
the locations of the equipment or set a location when first entered. I
set the property not to expand and limit to list, yet they somehow
edit the data there anyways. I want to prevent that. I want them to be
able to choose the options in combo box (with data from table
locations) but not edit the locations it self (the choices)...the
locked option is not going to work because it doesn't let the user to
change from location to location...it needs to be able to do that but
not edit the listing (the list it self) help anyone...

Normally one uses a different table for the list of choices than the one
being written to by the form. Is that what you're doing? In cases where a
ComboBox gets it choices by looking back at the same table it is writing to
then any time an entry is made that is not in the list then of course the
choices in the list will change, but the LimitToList property should
prevent that.

Are you allowing any other access to the data besides this one form?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #4

Brett Conway

"It's possible the db is a figment of your imagination."
--Salad
Your combo box Control Source is set to the wrong table because your
database schema is wrong, because you have no clue how to build a database,
and because you are a moron.

"Almir" <al*****@yahoo. com> wrote in message
news:72******** *************** ***@posting.goo gle.com...

This db i created has been driving me nuts. I have this one table
LOCATIONS, and in the data entry forms, the user is suppose to change
the locations of the equipment or set a location when first entered. I
set the property not to expand and limit to list, yet they somehow
edit the data there anyways. I want to prevent that. I want them to be
able to choose the options in combo box (with data from table
locations) but not edit the locations it self (the choices)...the
locked option is not going to work because it doesn't let the user to
change from location to location...it needs to be able to do that but
not edit the listing (the list it self) help anyone...

Nov 12 '05 #5

Larry Linson

"Brett Conway" <BC****@hotmail .com> wrote

Your combo box Control Source is . . .

"Brett" posted from the semi-anonymous news server "teranews" with a return
address of "hotmail", both frequently used by Don P Mellon hiding behind
aliases and impersonating others.

Nov 12 '05 #6

Similar topics

119

4642

beta2 XHTML compliance? is this necessary. OR STUPID...read UP MICROSOFT

by: rhat | last post by:

I heard that beta 2 now makes ASP.NET xhtml compliant. Can anyone shed some light on what this will change and it will break stuff as converting HTML to XHTML pages DO break things. see, http://www.alistapart.com/articles/betterliving/ I read on http://msdn.microsoft.com/netframework/default.aspx?pull=/library/en-us/dnnetdep/html/netfxcompat.asp It said they changed stuff like this

.NET Framework

3356

Orderby set by code causes stupid access 2000 behaviour

by: Dutchy | last post by:

Hi there, After spending several hours trying all I could imagine and search for in Google I gave up. In a continuous form I want to sort the choosen column by clicking the header (label) of that column. I even want to sort up and down if one clicks again on the same header. No problem so far, all works well for one column. Now I want to sort on the first choosen column ASC or DESC and additionally on a second column ASC. I use the...

Microsoft Access / VBA

2759

beta2 XHTML compliance? is this necessary. OR STUPID...read UP MICROSOFT

by: rhat | last post by:

C# / C Sharp

2437

more and more excel to access....and the inputs are really stupid

by: sparks | last post by:

We get more and more data done in excel and then they want it imported into access. The data is just stupid....values of 1 to 5 we get a lot of 0's ok that alright but 1-jan ? we get colums that are formatted for number and then half way down they are changed to text. OR the famous ok now everything in red is ---- and everything in blue is---------. WTF are these people thinking?

Microsoft Access / VBA

9576

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10568

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10074

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9138

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5516

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5647

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4292

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3813

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2988

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General