Multi Selection Box User Submitted Values?

Sep 27, 2013

I'm currently having a problem with a multi selection box not taking user submitted values. I'm not sure if this is a limitation or just me missing something. I'll try to post enough pictures so you get the idea as uploading the entire file might not be possible. The box itself holds phase(s) with the default values being the most common. My main goal is to give the user the ability when he opens the combo box drop down to see his options, and if none of them fit his/her needs then give them the ability to input their own.

The Phase(s) default value are held in the "Multi-selection box" table

The Phase(s) information or whatever is selected while filling out the form goes to the "sub Table Information" table

The Phase(s) combo box itself is under the "Phase(s) & Effects" Form (subform) with "BSTS" being the main form

View Replies


ADVERTISEMENT

Field Values Based On User Selection In Combo

Dec 9, 2005

Hello,

I'm stuck! I want to create a form which has a combo box where you select
someone's name, and their address appears in another text box on the same form. The names and addresses are in a table called "cardholders".

I'm doing separate combos for first name, surname cos I think that's the only
way you can do it.

The fields in the table are credit_add, credit_name & credit_surname. The combos are called "cardholder name" "cardholder surname" etc. This is the code in the text box where I want the address to appear:-

=DLookUp("[credit_add]","cardholders","[credit_name] = '" & [cardholdername] & "' And [credit_surname] = " & [cardholdersurname])

Can anyone help?

Thanks.

View 3 Replies View Related

Queries :: How To Update Combo Box Values Based On User Selection

Sep 25, 2014

I have a combo box which gets its values from sql server using a query which is called "get_query_reason", which works fine. Now I want to update combo box values based on a user selection, st string. Have written the code, but does not work:

Dim qDef As QueryDef
Dim Query As String
Dim st As String
Dim rs As Recordset
st = "SOV"
Set qDef = CurrentDb.QueryDefs("get_query_reason")

[Code]....

View 3 Replies View Related

Multi-User - Can You Assign Which User Created/amended A Record?

Aug 4, 2007

Hi guys,

I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...

We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...

Best ideas anyone?

dazza61

View 6 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Multi-Option Selection Problem

Oct 7, 2005

I have a form with 12 questions for the user to select either yes or no for each of the questions. I was hoping to having Option Buttons or Check boxes for each of the questions and the user could very simply click on the questions to answer as a "Yes".

I guess my problem is that I don't know how to best setup the table to capture their selections.

Any ideas would sure be appreciated.

John

View 1 Replies View Related

Multi-Value Field Does Not Submit Selection On OK

Sep 2, 2014

I know many are opposed to multi-valued fields, but in this case it works out nicely for my purposes.. I pick a couple things from a table to put into a field in a separate table via multi-value lookup, and when I hit ok, nothing happens. Literally. Tried the enter button, tried a mess of different keyboard mashing, and nothing. URL....

Row Source:
SELECT [Cage Codes].[CageCode], [Cage Codes].[Company], [Cage Codes].[Division] FROM [Cage Codes] ORDER BY [CageCode];

View 4 Replies View Related

Forms :: Multi-selection List Box In A Form

Jun 21, 2013

I've created a database to track training courses. I'm having issues with selecting multiple trainers. I set up my table to lookup a "List" on the trainer column. I've entered 2 records into my form and it displays 6 records. See attach image.

View 3 Replies View Related

Forms :: 2 Records Added To Table After Form Is Submitted

Dec 20, 2013

I have a form that has a few combo boxes that I use as drop down lists that the user can choose from. After the form is completed, the user clicks "Submit" and the query/table is updated. However, 2 records are added instead of 1. The first record leaves the first field blank and every other field completed. The second record has every field filled out with the same info as the first. In other words, the first of the 2 records is unnecessary. How do I eliminate this from happening?

Data Entry set to "Yes"

Submit button:

Code:
Private Sub cmdSubmit_Click()
DoCmd.RunSQL "Insert Into qryEarlyPoints(empName,dateOfOccurrence,leaveEarly,early6Mins) VALUES('" & Me.txtEmpNameInf & "','" & Me.txtDateInf & "','" & Me.cmbEarlyPoints & "','" & Me.cmbArriveEarly & "')"
Application.SetOption "Confirm Action Queries", 0
Application.SetOption "Confirm Document Deletions", 0
Application.SetOption "Confirm Record Changes", 0
DoCmd.Close

cmdSubmit_Click_Exit:
Exit Sub
End Sub

View 3 Replies View Related

Multi User (1 X Rwx, 2 X R--)

Mar 2, 2007

I have read a lot about if multiple users want to share an MDB, they have to create BE and FE and split the database.

I understand having to do that if all those users want to write to the MDB simultaneously.

I have a situation where one person will do data entry (write access), and two other users will just want to view and perhaps just search the database (read).

If only one person is writing at any time, do I have to do all that splitting and FE/BE configuration?

View 2 Replies View Related

Multi User

Apr 17, 2007

I've create a form with subform that work like a charm, now they want in a multi user environment. What is the best way to achive this?

View 6 Replies View Related

Multi User Capacity

Sep 1, 2005

I plan to create a multi-user application on access 2000. There would be more than 20 users simultaneously logging in the database. The database would be kept in Server with high config. The users would work on the database (server) from their workstations. Forms/Queries/Reports ... are in the workstation (client). The database may growup to 70 MB every 3 months. The application will run on the database for 3 months which will be replaced with a new one after that period. Is it a good plan to do so on Access 2000. Am worried about the network traffic. Will the users face it as a very slow application ???

(SysConfig workstation: Win2K Pro/ 128 MB RAM/ 40GB HDD/Pentium-4)

Any suggestion is appreciated. Thanx in advance.
Prodigy.

View 2 Replies View Related

Multi User Access

Sep 5, 2005

Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.

They need to each be able to use the database when they need to and read or add data, reports etc.

I am using access 2003.

Thanks

Dave

View 14 Replies View Related

Multi-User Recommendation

Mar 10, 2006

I maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method for making this database accessible to several users at once? My main concerns are accuracy (changes commiting in the proper order) and low chance of corruption.

View 1 Replies View Related

Multi User Problem

Feb 7, 2007

Hey everyone,
I am in desperate need of your help. I have a split database that I am trying to enable multi users access to the database. I created a folder on the share drive with the front end and a folder on share (BEN) with the backend. I have changed the settings via options, advanced options, and checked that shared box however it will still not allow everyone into the database at the same time. Is there something that I am missing? Should I then right click and copy and paste the front end to local PC since the tables are split and still on the share drive???? I plan on using security in the future will this cause a problem???Thanks

View 3 Replies View Related

Multi User Environment

May 22, 2007

Hi,

I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval.

Is it possible? If so, how do I configure my access database?

Please help.

Thanks!!!

View 13 Replies View Related

Multi-User Database

Jan 29, 2008

I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options

Any help is appreciated! Thanks

View 2 Replies View Related

Multi-user Password

Mar 11, 2008

:Hi,
At the moment I'm writing a production database for work, which include parts in/out, production planning, kitting lists and other forms. What I'm after is a way that when the database opens it asks for a password and depending what it is, is what you can do. Administrator can do all, Stores can only enter parts and scheduler can only enter planning and so on.

How easy is this? :o

View 3 Replies View Related

Allow Multi-User Environment

Mar 14, 2008

1) I develop my application(Ms-Access 2k) and put into company network directory.

2) The problem here is only 1 user allow to access per time.

3) Is there any setting I miss out?

View 4 Replies View Related

Need Help On A Multi-user Database

Mar 17, 2008

Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.

I appreciate any help you can provide me on this!!

View 1 Replies View Related

Multi User Enviroment

Nov 1, 2004

Hi everyone,
can anybody help me on this. I have two PCs connected and i am trying to execute an Access file from the client PC. This appears to be possible but the problem is that i cant save any new record and Active X or OLE seems to be the problem according to the message box appeared when i execute a form. The file works normally when executed from the server.
Any ideas?
It appears that the problem comes when Vba Code is executed for example i can save records from the tables but not from the forms where VBA code is attached

View 2 Replies View Related

Multi User Problem :(

Dec 9, 2004

Hi all, question about using a table for temporary storage. When a user clicks a button after selecting critiera, a form is displayed with fields bound to a TempTable. On this form is a subform which pulls 3 peices of data from a table called QuestionsTable. As a user clicks through the subform, two fields are populated by the user and get stored in the QuestionsTable.

Once done, the user clicks a button and a SQL statement grabs the data from the main form (TempTable) and subform (QuestionsTable) and shoves it into the Archive table. A SQL statement then runs to delete the contents of the TempTable, and Delete the *modified* data in the QuestionsTable (by simply setting the 3 fields which will change to " " or Null).

Now my problem. If two users are in the same form and one clicks save, the SQL statements eraase everything... so the 2nd user will be mid process and their data will poof.

I want to assign a Session ID each time the main form is loaded. This is set via AutoNum in the TempTable. My question is, how can I copy 3 fields (Question, Comment, Result) from the QuestionsTable and insert them into the TempTable, then have the subform load the 3 fields from the temptable (so in essence, everything is loaded from TempTable).

Did that make sense? Sorry if it didn't, I'm reaching my deadline on this and have a bad cold

View 3 Replies View Related

Multi-user Form

Jan 13, 2005

I have a form "log_file" that I am going to be placing a nework. All I have done is create a new DB, create a table, and create a form. Now I want to make it so users open up the DB file and only see the form and cannot access/edit the table. Basically, It is okay if they go back and forth through the records and change those, but I don't want them to be able to edit the form either.

I'm just not sure where to go from here. If there is more info I should provide please let me know.

Thanks in advance.

View 3 Replies View Related

Multi User Diary

Mar 22, 2005

i am looking for an outlook style planner in Ms Access for a booking sytem i am trying to put together, can anyone point me in the right direction of how best to tackle this please.

I have scoured the net for samples, and have come back to the most helpful place on the net for more assistance on where to go with this...

What i am looking to do is to set up something like this..

Click here to see example picture

how hard would this be to do?

Cheers

Andy

View 3 Replies View Related

How Do I Log Out On Users On A Multi-user System?

May 27, 2005

I run a multi-user system of over 200 users. The only facility I have for advising an office-wide logout is required is the email system. However, staff either don't read their email or forget so I have to run around like a headless chicken trying to get everyone to get out/stay out of the system while I perform maintenance etc. Is there a way to enforce a logout and keep users logged out until a requested time without spending a fortune on new software?
Any advice would save me a lot of hair pulling (not mine :)).

View 2 Replies View Related

Multi-user Remote Database

Jun 22, 2005

I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.

The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved