Form With 3 Users

Mar 24, 2005

Hello,

Question 1:
Is it possible to use the same form, from the access database on the
server, working with 3 users on 3 different pc's?


Question 2:
How can I send data, wich is in the cells of an Excel file, to an Access
database in a table?
I have a machine that put data in an Excel-file without opening.
Because I want put the data in Access I want automatically, done by
VBA, send the data from Excel to Access without opening Excel.
Is this possible?

greetings,

mulderm

View Replies


ADVERTISEMENT

Update Excel Spreadsheet That Link To A Form While Users Having Form Opened

Sep 17, 2014

What is the best way to accomplish this? I have a database that split into the Front end and the Back end. The form that the users entering the information uses the queries from two sources. One is the a table within Access and the other is an excel spreadsheet that I link to it. How can I update /replace the Excel spreadsheet while users are using the form of the front End?

View 9 Replies View Related

Forms :: Form Already In Use Or No Permissions When Multiple Users Are Accessing A Form

Aug 11, 2015

I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to

Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO

anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?

View 6 Replies View Related

Question About: A Table Of Users Who Have Relationships To Other Users??

Feb 21, 2006

Hi,

I have a table of users somthing like this:

User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah

Users can be friends with one another and I need some way of logging this.

My 2 options (that i can see) are:

1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:

User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010

2) Making a seperate table with multiple entries for each user like so:

User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---

The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.

My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.

Thanks.

View 1 Replies View Related

How To Create Users In Form

Apr 21, 2005

hey guys,

i just needed a guide on how to create a form with different users in it.

also, is there a way in which i can create a button that will open the wizard to create a report ??

[guess wat, no deadline.... but that doesn't mean dont answer ;) ]

hope a reply soon..

thanks in advance.

View 14 Replies View Related

Multiple Users In Same Form

Jul 6, 2006

There will multiple users accessing the same database/forms at the same time. How do I ensure that all entries are saved and not overridden by each other entries?



Access 2003

View 1 Replies View Related

Password Form For Multiple Users

Jun 9, 2007

I am not sure how to do this. I am trying to do up a password form where there is a user name and a password. There will only be 5 user names, one being an admin. I seen it in the Running Microsoft Access 2000 book (it's just a reference manual) but could not figure it out.

View 1 Replies View Related

Users Entering A New Record Through A Form?

Mar 17, 2006

Hello! :rolleyes:

Just need a little extra help :(

I have set up a form for the user to fill in a new record and used a command button for it to save. This all works ok.

The problem I have is when the form is opened, a record is shown in each of the fields as opposed to a blank one. The user can still enter data but they need to delete the stuff that is already in the box.

The user then, will have to press the little star at the bottom.

I have tried going into to design view, and typing in "Unbound" but it came up with #name? ...

can anyone help me ?

Shellie x

View 4 Replies View Related

Forms :: Add Some Instructions For Users Of A Form

Jul 8, 2013

I would like to add some instructions for users of a form. Any easy way to accomplish this?

View 2 Replies View Related

Access To A Database Form For More Users At The Same Time

Nov 28, 2007

Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file!
What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help

View 1 Replies View Related

Forms :: How To Invisible Some Records Of Form For Other Users

Feb 5, 2014

I have a database that it has 2 forms. Form 1 shows list of received letters Form 2 shows list of send letters Now database has been splitted and back end is on the shared drive and front end there is on each computer and myself and other users have read/write access to the shared drive and me and other users can see all the records. .Now I would like to add something like a check box field to the forms. When I tick the check box for each record other users cannot see that record on the form.

View 1 Replies View Related

General :: Sample - Use Hidden Form To Log Users

Jul 16, 2012

I wanted to send a message to the person who created this sample database with a modification query but I don't have enough posts to do this, so my message would not send.

The below sample database called
Sample - Use Hidden Form to Log Users ,URL...

I would like to add to my database. Any way to modify the form/code so that I can log more than one form? I have 5 forms that I would like to log user in and out of but I dont know how to adapt this to do that?

View 10 Replies View Related

Forms :: Pop Up Form That Users Need To Fill Up Whenever They Need To Add New Records

Aug 13, 2014

i have a pop up form that users need to fill up whenever they need to Add New Records. everything is working fine. BUT, what should i do that in the next time the user will click the Add New Records it will not show the previous items that have been added? since it is added in the Main Form already, no need to show in the pop up Form again once they wanted to add new records. Once they are still in the pop up form, they can see the newly added items BUT once they exit the pop up form, they cant see those items anymore in that form instead it is in the Main Form already.

View 3 Replies View Related

Modules & VBA :: Login Form And Users Permissions

Mar 30, 2014

I have been searching for info with users & permission levels. I have ready a lot about ULS (User Level Security) which doesnt seem to be my answer as I do not have admin rights and I believe it is not suitable with Access 2010.

Basically I have an 2010 Access database which is used by my department as a project management tool. It has various tables, forms, queries & reports, I have created a table with user names & passwords and a login form. So when the databases opens the login form is launched & the users selects their user name & enters their password, then the main menu is shown.

Everything works really well, but as the moment there is no difference between all the users. All I want to do is to be able to make one of the Logins read only, ie if the Reviewer is logged in they can see & read every form and run every report but they can not make any edits.

View 5 Replies View Related

General :: Make Changes To A Form While Other Users Are In Database?

Jan 3, 2013

I was wondering if it was possible to be able to make changes to a form whilst others are accessing different forms.

At the moment, if i am editing the database any user trying to access the database gets a error warning them, they the database is in admin.

But if another user is in the database while i am trying to change a form / report, i am unable to save.

I no the simple way to do this would be to do changes whilst no-one is in. Its just some minor tweeks need doing during the day.

View 7 Replies View Related

Restricting Access To One Form For Individual Users?

May 12, 2012

If i split my Data base into a front and back end how would i restrict certain users only to input data on certain forms. Also how would i prevent them from accessing certain information.

View 1 Replies View Related

How To Enable Users To Use Wildcards In Their Searches On A Form

Jul 22, 2013

I have a Excel spreadsheet with an embedded query that pulls from an Access table. The users use a spreadsheet with an embedded query to search on a field called "Circuit ID", to bring up results showing the history of a given circuit id. Currently they have to enter an exact match, for example if the circuit id value is DHECHUIOY, they need to enter this exact value DHECHUIOY. They want instead to be able to enter DHEC and a wildcard character to bring back every value that begins with DHEC. There doesn't seem to be a way to do this in a spreadsheet with an embedded query.

I finally decided that it would be easier to create a form in Access

How I can create a form which allows users to search on a value using wildcard characters ? (the user enters the wildcard character).

I'm on Access 2012, Windows Vista

View 1 Replies View Related

Forms :: Form Gets Error Message With Multiple Users

May 1, 2013

I have created a profiling form for my school. Each boy can access his form using his admission number ( Adno) which is the primary key. On the form are lots of sub forms - for things like favourite authors, clubs, teams played in etc - but these don't have a primary key ( as they are automatically linked to the Adno via the main form ). Unfortunately when several boys are filling in their own forms at the same time I keep getting error messages, one says that the data can't be updated and another says that there is a primary key problem.

View 8 Replies View Related

How To Have Users Drag And Drop A Document Into A Text Box Within A Form

Jul 7, 2015

how to have users drag and drop a document into a text box within a form and have it create a hyperlink. What I need to know now, is if there is a way that when a file is dropped into the text box, it only shows the icon associated with that file, or at the very least, edit the hyperlink to only show a certain text. The files I need to see are all in a networked drive, so the hyperlink addresses can be quite long, and ultimately I'd just like the hyperlink to say "letter". Showing the icon would be a plus.

View 3 Replies View Related

Forms :: Recordset Filters From One User Affecting All Users On A Form?

Jul 10, 2013

Here is the environment:

Currently, I have 10 Users running a front end form that connect to back end data where they add to current records and eventually check that the record is complete.

I also have an "Apply Filter" button on the right hand side of the form that allows the user to apply filters to the records to show specific data that is not complete.

I am currently hearing that while the user is working, whether they apply filter or not, it seems as though all of a sudden, all of their completed work dissapears from their recordset hence not allowing them to go back to make changes to it if needed. I can only conclude that when a different user clicks apply filter, all users are affect some how... here are some examples of the code for the filter:

Code:
Select Case [cboFilterValues] ' Where the user selects a filter parameter from a dropdown
Case "All Data"
strSQL = "SELECT * " & _
"FROM [Data Table] " & _
"WHERE [Complete] = No

Then it does:

Code:
Me.RecordSource = strSQL

I am basically trying to find a way where only the user wanting to view the filter is affected... FYI, the other users arent actually seeing all the filters from the other user filter choice, they simply loose all their completed work from their form.

View 1 Replies View Related

General :: Form With Text Boxes That Are For Displaying Info To Users

Jan 10, 2014

I have done this before and can't remember how I did it and I can't fogure out how to do it. I have a form with textboxes that are for displaying info to the users. I want to lock them so that users can not click on them or high light the fields. So basically the user can only click on fields I want them to.

View 4 Replies View Related

Modules & VBA :: Ignore / Override Form Ribbon Created For Users

Jan 27, 2014

I have created a ribbon for the users on all forms, and named that ribbon on each form. While I can bypass the Main ribbon (hiding backstage and most other tabs) by holding the shift key on open, the minute I open a form I am stuck with the very limited form ribbon I've named. Is there a programmatic way I can ignore this call, either when holding the shift key or some other avenue?

View 14 Replies View Related

Modules & VBA :: Automate Access 2007 Queries With Form For Users?

Oct 18, 2013

I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change fields from code letters to words and splitting the database up into different client tables, saving the tables under date order and with different client codes.

I now need to pass this role on to colleagues, so need to make everything as straightforward as possible.

I had thought to use a Form as the user interface, with a minimum number of buttons, however I need either the system or the user to amend the date for the initial table, then to use this new table and run a series of standard queries on it, then produce the separate tables.

I don't think I can just use macros behind the buttons, because the database name is changing each time.

I assume some parts will be too tricky to automate - it will be necessary for colleagues to follow instructions instead.....

View 2 Replies View Related

Queries :: Form Setup - Allow Users To Select Parameters Using Combo Boxes

Apr 3, 2014

I'm wondering is it possible to create a multiple parameter query which will return results even if you leave some of the parameters blank ?. I'm trying to set up a Form which will allow users to select parameters using combo boxes but at the moment you need to fill them all in or you'll get no results...

View 10 Replies View Related

Mandate Users To Enter Data In Textbox Before Proceeding To Record On Form

Nov 21, 2012

Any way (VBA script, etc) to make it mandatory for a user to enter data in a textboxes in a form before proceeding to the next record on a form? I know I am able to do this in the table by selecting the value "Yes" in the Required area in the General Tab but I was wondering if there is a VBA script you can enter it in a form instead.

On attachment is an Access Database in winzip. In the __Property form, I want to make it madatory for users to enter data in the County Shapefile Gross Acres, Township, Mineral Severance Tract, and Unit name fields before proceeding to a new record. If data is not entered in these textboxes for these field, then a person will not be allowed to go to the next record.

View 7 Replies View Related

Forms :: Create A Form Which Allow Specific Users To Book A Seat At Football Match

Apr 4, 2014

I'm currently trying to create a form which allows the specific users to book a seat at a football match.

I've created all the relevant tables, but I'm struggling on how to interpret the data into them to make the form work. I am new to this sort of design, this design is currently for my university dissertation and I am struggling to get it completed in time.

I have attached my document below to show how far i have come.

View 1 Replies View Related







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