New User Button

Nov 15, 2006

Alright peeps,

Im trying to add details to a database called "tab_main". I wana add details such as phone number, name, imei no, PUK code, tariff etc etc for a mobile phone user.

Ive created an empty form with all the neccesary text fields and also a seperate form for just the New User button (the way i would like it l:) ).

I need some help and advice................

How do i click on the New User Button and show the empty form on a new window? and also on the empty form, i need an 'add button' that will allow me to add the details once the form is completed??? ANY1 GOT THE full CODE FOR THIS? OR ARE THERE ANY EXAMPLES AVAILABLE FOR ME TO VIEW????????????

Ur response will be highly appreciated.... thank you
:confused: :confused:

View Replies


ADVERTISEMENT

Forms :: How To Give User Authority On One Button

Apr 27, 2014

how to give someone authority on one button in form

View 8 Replies View Related

Unable To Edit Button For Some ID Depending On User

Aug 10, 2015

I'm making database using access 2013 web apps. Name field in the table same with username in office 365. I want to make the user can only edit the field that have their name on there.

View 1 Replies View Related

Prompt User To Enter Personal Password When Ticking Option Button

Mar 24, 2015

I have a form in which I collect approvals from two different departments. To approve an item the user selects their name from a combobox, and then tick an option box to indicate approval. The combobox is from table 'Users' and has a query as a source with the following fields, 'UserNum, First, Last, Password'. The 'approval' fields are on table 'Approvals' and are yes/no fields.

What I'd like to have happen is that the user chooses their name from the combobox and then ticks the option box for approval; when ticked I would like a messagebox to appear asking for the users password based on the name chosen in the combobox.

Is this even possible?

View 6 Replies View Related

Modules & VBA :: Word Document Load When User Click Button And Perform Email Merge

Oct 7, 2013

I have a Word 2010 document linked to an Access 2010 data source. When a user clicks a button in Access, the Word document loads and performs a email merge using the below VBA code:

Private Sub Document_Open()
With ActiveDocument.MailMerge
.Destination = wdSendToEmail
.SuppressBlankLines = True

[Code] ....

However, as the .mailsubject part is not in the loop it is only retrieving the first Return Code. I have tried to integrate in the loop to no avail. Also, how do I add static text to the Subject, I need something like "Your Return Code" + "Return Code"..

View 6 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

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

Forms :: Command Button To Unlock And Lock Fields / Edit Button?

Feb 19, 2014

I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.

SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.

I have changed the Form properties so that Data Entry and all the "Allows" are set to No...

View 9 Replies View Related

Calc User Totals Table 1 And Enter In User Records In Table 2

Oct 28, 2004

I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".

My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.

Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.

Thanks in advance.

Regards Peter

View 5 Replies View Related

Difference Between A Command Button And A 'label' Button

Aug 12, 2005

Hi, I have got a small problem and maybe someone could advise me.
I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: :


Private Sub Labelsearch_Click()
Me!itemquery.Requery
End Sub

Private Sub Labelsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.SpecialEffect = 2
Me.Labelsearch.BackColor = 255
Me.Labelsearch.ForeColor = 10092543
Me.Labelsearch.FontItalic = True
Me.Labelsearch.FontBold = True
End Sub

Private Sub Labelsearch_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.ForeColor = 255
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End Sub

Private Sub Labelsearch_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
'Come back to initial state when button release'
Me.Labelsearch.SpecialEffect = 1
Me.Labelsearch.BackColor = 16373685
Me.Labelsearch.ForeColor = 8388608
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End

If I create a command button with the wizard and assign the code :
me!itemquery.Requeryto the on_click event my form is working fine.
Why is his code is not working if I assign it to a label? :o

View 6 Replies View Related

Forms :: Second User Record Changes When First User Selects Record

Jul 31, 2014

I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.

But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.

View 1 Replies View Related

First User Allow To Read And Write / 2nd User Only Allow To Read?

Sep 2, 2014

Will like to check, i have a access database which can be open up by a few users.

How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?

View 4 Replies View Related

A User End?

Jul 26, 2005

I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.

I already searched these forums and googled for help.

View 13 Replies View Related

User Id

Nov 29, 2005

i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)

View 2 Replies View Related

User's Help

Apr 7, 2006

Can someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms and reports?

Thanks in advance for the help.

View 2 Replies View Related

Help For User

May 9, 2006

hi. i just wanted to know how to get a litle yellow box to appear saying enter text here when the user puts the cursor over a field where hey enter text on a form. thanks

View 2 Replies View Related

New User Needs Help

Aug 31, 2006

Hi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.

Tks

View 4 Replies View Related

New User (Thank You All)

Mar 17, 2007

Hi all
Well ive been using this forum for about a month now, and as an inexperianced user of Access D/B I find this forum is a wealth of information from the cream of Access programers. I have bought DVD courses of ebay in the past but has no comparison to the knowledge on this forum.
Thank you all.
Chris

View 2 Replies View Related

New User - Is This Possible??

Jun 9, 2005

Hi guys,

im a new user of Access and don't really know what im doing.

i need to make a database that will keep track of technical drawings. I need the database to be able to search for a drawing number, we might have a few of these types of equipment, so if i am adding a drawing of a different piece of the same equipment i need it to automatically generate the next number in the sequence.

This is hard to explain...

Ok, i have a load of Drawings, say they are numbered

0010-020-A-001
0020-020-A-001
0030-020-A-001

Right the first part is the type of equipment, the second is the sub-group, the thirs is the drawing type....this will all be entered by the person whois entering it into the register, the 001 at the end means it is the 001 revision of the drawing. If i have made a new revision of the drawing, say 002, i want to be able to use a form to enter the first bit of the serial number, then it will automatically tell me the next number in the sequence, and will let me fill in the other details, then i can click a button "add" or register or something and it will automatically update all the details...

....i would be so grateful if anyone knows a solution to this, or if this is even possible

thanks in advance
Cokes

View 10 Replies View Related

Welcome To User?

Oct 24, 2005

I would like to welcome the users at login on my db,
I have a table that list user details which has the following fields

tblUserDetails
UserID
UserName
Password (encrypted)
UserLevelID
FirstName
LastName
EmailAddress

What I am trying to achieve is after logging in, I would have a welcome $User$ on the splash form/switchboard

So to re-cap, I would like some kinda vba coded example that will ref [FirstName]

Thanks in advance

View 2 Replies View Related

User

Dec 28, 2006

Hi,

I want to write the code to detect that whether or not the administrator assign current user to access the database in SQL Server.

How can i detect it?

Suppose I have a database db1 in SQL Server, we assign the username to specific database. And then I linked tables from SQL Server to MS Access

When the user open the MS Access, I want the program to detect whether or not the current user has his/her name in the database from SQL Server.

How can i do that?

I just know to use is_member function, but this one is detecting user role, I want to detect whether or not administrator assign the username to the specific database from SQL Server.

Please let me know about it.
Thanks.

View 3 Replies View Related

VBA User Permissions

Aug 12, 2005

Is there a way in which to assign user permissions to vba code?
I have some command buttons which run vba code but i only want to allow certain users to use these.

View 7 Replies View Related

Yet Another Request For Help From A New User

Sep 20, 2005

Hello all. This is my first post on here after reading many of the other threads as I try - often in vain - to pick up access.

I am in the process of building a couple of databases, the main one being one that is an amalgamation of 4 other/older mdb's. All tables/queries etc were simply imported from these older defunct mdb's and then are archived off every month so they have 3months data and no more in them. The only thing is when it comes to problem solving and/or new queries, it is impossible to tell which tables/queries relate to which sections of the Db.

So my question to you is can I rename tables and queries in any way so that any queries that are using these tables are updated at the sametime, and if so how is it done? I have asked my colleague who is working with me to develope my understanding of access and he is at a loss. We are in the process of trying the old fashioned way ..... getting a book from the libarary ... but thought I'd try this new fangled internet thingy first :D .
The thought of having to trawl through around 100 tables and queries to rename or even re write the entire query/formulae is so daunting, I simply dont have that amount of time. Im using Access 97 and would greatly appreciate any help on this.
Thanx

View 2 Replies View Related

Set Up The User Login

Sep 27, 2005

I have finished the database application, and now want to make a user login for specific users to run the application (but not to change the internal desgin or data).

How can it be done ?
Do I need to split the database first before doing that ? :confused:

View 1 Replies View Related

New User Question

Oct 21, 2005

Hello,

I'm a pretty new user to Access. What little experience I have is from directly playing around with sample databases. Currently I'm helping a small non-profit organization here with data management.

My question is, are there any simple ways to create a sort of alert or scheduled notification based on the current date and some trigger criteria. Basically when a client enters the program, we input a load of data on them manually. And periodically we have to check back with them for stuff such as 6 month testing, X/hours testing, monthly checks etc.

Idealy I'd like to set up something that would start when the database is opened and alert any volunteer or staff person that soandso people need to be called to do soandso.

Macros? Reports? I have no idea where to begin.

Sorry in advance if this is one of those obvious answer questions. I find access intimidating sometimes, especially when so much information is in there thats vital to our program.

Thanks for any suggestions!

View 2 Replies View Related







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