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.
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.
Hi All
I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer.
I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords.
Dave
Is there a way of creating a log to capture changes in a table by users?
In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.
So, if I would be able to have a log that records all the actions taken by users, I could at least see who did what.
how to add security features into My Access database. i.e create users with permissions/login.
View 1 Replies View RelatedWhat is the best way to capture the users that modify the records in the database?
Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
View 1 Replies View RelatedWhat 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 RelatedI 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?
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.
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
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
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 RelatedHello! :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
I would like to add some instructions for users of a form. Any easy way to accomplish this?
View 2 Replies View RelatedHi, 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
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 RelatedI 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?
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 RelatedI 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.
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.
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 RelatedI 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
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 Relatedhow 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 RelatedHere 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.