Hi,
Pls i am having some problems storing the logged in username in a variable. I am creating my own login page (not using the security in Access). I have a login page and another form for changing password. Pls how do i carry forward the logged in username so the right record can be updated? I tried using CurrentUser() but it keeps giving me 'admin'.
Kindly help. Thanks in advance.
Hi all,
I've had a quick search but couldn't find the answer to this.
Is there a way that when a user launches the application via my workgroup file, the default login name is always null?
Currently it retains the last users' login name.
Thanks
Kempes
Hi Freinds,
After viewing all the threads i got some useful information but just wanted some help as i am not a programmer but can understand logics. There are 2 issues i want to resolve
1. First query is i have a login form and in a table there is username password. Now issue is based on the username person should be able to view things. There would be 6 differrent departments. So i would have six users and 1 id only for viewing. These six users should be able to see there own records either assigned to them or create new query and assign to any other 5 users. Now option is either I create six replicated forms and based on the user login i open user form or switch board. Can there be any option where in a table i store the activities they can do and whereever these guys go the code check in table and enable or disable the view of items for other guys. Users would be accessing forms, reports and they would have option of entering cusotmer information and querying and changing information. The user which has option of viewing reports will only have option of seeing some customized reports.
2. Second query is that these six users would be addressing issues to each other regarding cusotmer issue. In this every response of the case should be stored in a table. i.e. like for customer x user1 said abc on 10th then user2 said cbf on 11th. so this would have history of case what was happeining in the matter.
I dont know how to go about this and if there is a easy solution. I dont want to use access security cause then all the six users would have security file.
Would apreciate your help and till now whatever responses i have seen in other forms they were quite helpful and did help me lot in understanding access.
Thanks to all who would be visiting this thread and taking pain in answering the query.
Take care
Ankur
I would like to implement a login form to my DB.
I have a table db-users with three fields: empID; empName; empPassword
I have a form with an unbound combo box: cmbdbUserName
And I have a text box: txtPassword where the user will type in their password.
cmdDBLogin is the button I want to add the VBA code to on click.
Code that will compare the inputs of the two objects listed above to the data in the table fields listed above that?
Hello
Can anyone help?
Im in the process of making an access database with a login form. I used VB code to validate the login which was bound to a logon button after the user puts in a username and password.
This worked fine - but I now need to do the same for a data access page.
Can anyone tell me how to do this please?
Many Thanks
Daz
Here're something I want to achieve in my database (Access 2010):-
1. To create a login page
- The table “tblUsers” has been created.
- The login page will be popped up once the database is opened.
- The user1 will be set to be an administrator who has the right to edit the info and the structure of the database. (User1’s password: 1234)
- The user2 will be set to be an end user who will be responsible to create a quotation request through the form “frmQuotationAllinOne”. (User2’s password: 5678)
- The user3 will be set to be a supervisor who will be responsible to approve/reject/give comments to the quotation request. (User3’s password: 2468)
2. Welcome note
- Once the login procedure is done, the Welcome note will be popped up.
- Under On Load event, I have keyed in the event procedure. It worked sometimes and sometimes not. It seems that the Access database is not performing consistently and stably.
hi,
I linked a table (front to back) yesterday. I had a user enter information into this table. It's a login table. The login screen of the asp page is not able to find the record, even though I can see it in both tables. I am not sure what's wrong, since both tables show the same information. Does anybody have any ideas?
thanks in advance.
I have made a basic form and use it a log on screen. This requires the user to in put a user name and a password before gaining access to the main database.
The background to the form is a table where the users details are entered including the i enter the user name and password.
Is there any way to add a counter that is only visible in the table, so I can report on the different users.
i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)
i just need a code that checks what the users level is and then open home lvl#
(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...
Hi
I run a small domestic house cleaning company in the UK. We are currently franchising our concept throughout the UK. I have a requirement for 2 databases, one for my clients & one for cleaners.
Would anyone be interested in creating something like this for me? One of the most frustrating things about databases on the market is that they do not come with a functionality to key in a letter code so that you can easily send letters/e-mails to the people in the database.
If anyone is interested please email me at csinclair@easynet.co.uk (put Access World in the subject box) I will then supply you with screen shots of the type of database I'm looking for.
Thanks
Chris124
I had some work done on my Database a few weeks ago and it works great.
I just got an email from the guy who did the work and he wants me to pay him more money....he said he forgot to bill me for 6 hours.
I told him I didn't think that was fair and wasn't really willing to pay for more hours....he then said he never sent the "non-expiry" versions of the databases.....he also said I have 15 days left until they expire.
Considering I done additional work on them I was wondering if this is possible?
Bruce
P.S. I hate being taken advantage of.....he was really good to work with but now he's trying to rob me.
Hello,
Does anyone know of an off the shelf application I can purchase to allow users access to my Access database over the web? I have select data I want to allow my customers access to dynamically via the web.
I am familiar with ASP however I am not at a level to develop something from the ground up.
I have access to a Windows Server, an established database and a great desire to get this done.
My vision is to have a daily upload of my back-end (for the sake of current data)to the web server for access via the ASP front end or whatever the case may be.
I am sure to all who read this you understand what I am looking for.
I will definitely entertain hiring someone to work with me on this project if need be. Best case scenario is someone has already done the work and I can just buy it...
Thanks.
Fen How
I have a ms access application in Front End and linked tables to sql server 2008 r2 in back end.. every time I open my application the linked tables ask to me for the user and password of the sql server user of the odbc conection. I want to connect to my sql database without login every time the user open the application, I know that can be possible if I start session from vba code...
View 2 Replies View RelatedI have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.
Is this even possible to accomplish?
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
View 3 Replies View RelatedI have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.??
(Actually I would also like any State that continues to a next page to not just have the state name but something like
" Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska
Ancorage
Prudo Bay
California
Whittier
Anaheim
Colorado
------------------------Page Break ---------------------------------
Denver
Pueblo
Colorado Springs
Deleware
Dover
-------------------------------------------------------------------------------------------
Thanks !
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
Hi All,
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
How can I stop the page refresh itself?
Thanks and Happy New Year!!
I have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies View RelatedI have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies View RelatedI occasionally run across this term. If the members of this group have a clear boundary between themselves and members of other groups, then please tell me the names of the other groups. If what members of those groups work on is not intuitively obvious, than will you give me a super brief description of what those group do? Thanks so much.
Regarding the term I asked about (and the others presumably), is this term relevent today? Does it have a precise meaning that a professional should clearly understand. Thanks if you can help.
I am trying to create an invoice report. I want to add all the costs from the detail section in my footer. I have accomplished this in either the Report footer and/or the page footer, but the problem is that the report footer doesn't go to the bottom of the page, and the page footer doesn't go to just the last page. I have tested a bunch of suggestions that don't seem to work.
1. Print page footer with Report header = NO - only works if your report is two pages or more.
2. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
Me.[TextBoxName].Visible = True
Else
Me.[TextBoxName].Visible = False
End If
End Sub
The Page functions worked, but it did not change the results from page to page. If it was a two page report, then the if statement is false and the text box was not visible on page 1, but it also was not visible on page 2.
to automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.
So right now my form looks like below
CAD#
Person name
Charge
Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"
Officer name date page # of #
Thanks in advance.
Matt
Hi All
I have added the Allen Browne Calendar 2k control to my form.
My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.
What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.
Any suggestions please?
Many thanks
Tee :(
I've used the following code on the footer on print procedure:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
Me.PageFooterSection.Visible = (Me.[Page] = 1)
End Sub
This works fine when you view it in print preview, but the footer don't show up at all when you actually print it.The reports default view itself is set print preview.
I have made a report on my query. The page setup is all around merging 0.2" and page size A4
When i view this report in preview it looks all my data whatever i want in a page but after every page it will generate a blank page.
I have included my report.