Search results

Good Evening Paul, Thanks for your quick response. The original code I had was replacing the reference to the msgbox. Call Form ("eDNA Legal Notice.", vbinformation). With no success I tried DoCmd.OpenForm ["eDNA Legal Notice"] I feel rather stupid now, as I was getting the code for you I...

Good Evening pr2, I am now embedding this logon page into my database and I need it to open a form "eDNA Legal Notice" instead of displaying the msgbox "login success do whatever you want from here" Could you please provide me some guidance on getting this working as I have tried renaming the...

Thanks Paul This is now working exactly how I needed it to work. Cheers Andrew

G'day Paul, I have attached some screen shots of what I have with the popup. When I click the command button (circled in red) the pop up appears. I can type in any number I want and the report is generated. Is there anyway of changing the text in the popup? or have I gone about this all...

Thanks Paul this has worked a treat. When I push the command button on the form a pop up box appears and allows me to enter any parameter I want and the associated report is generated. How to I change the wording in the pop up box from "Forms!FormName.TextBoxName" to "Enter Performance...

Thanks Paul, I already have a query going for this table. How do I "point to the form" in the criteria? I currently have a <20 in the criteria field for a report I run, this is the field I want to be able to put any figure in and have that data displayed in a report. Cheers

Good Evening, I am very new to access and I am wondering is there a way that I can have a popup box appear when I ask to produce a report and I can type in a parameter of my choice and it will produce a report based around that parameter? I have a table that is directly linked to an excel...

Perfect Paul thank you very much. I will have a bit of a play around now with naming convention, and see if I can have it automatically tally the log on numbers to each person. Appreciate you assistance in getting this sorted out. Cheers Andrew

Thanks Paul. The 12 months will expire from their initial first log in, and your sample database is exactly what I was looking for in that aspect. Is there a way to add a counter to this so I can see how many times a user has logged onto the database? I need this for my company so as to...

Thanks PR2. I have a form that is uses as a log in page for the database. There is a table attached to that form in which user names and passwords are added to allow people to log on to the database. What I am after is a way to log how many times a users has logged onto the database. So each...

Thanks for the response Billmeye. I have entered the Me!TimeEntered=now() in a field on the Table associated with the log in form and the =Datediff in a text box on the main form used for tracking usage and I get a #Name? error on the form. Please help

Good Evening All, 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...

Thanks pr2, I need the counter as way of monitoring usage of the database by user. With having the password automatically expire after 365 this will allow the administrator of the database to clean up users that don't reactivate their account. So I really need both. Regards

Good Evening All, I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database. Is there a way I can add a counter to see how many times...

Thank you very much, put the <20 in the criteria box under the MGT Margin Query field query and generated the report.

Thanks Paul, Yes it is a numeric field. Sorry, I am very new to access, where would I put this parameter in the query?

Good Morning All, I have an excel spread sheet that is linked into access 2003 via a table. This spread sheet is updated by personnel in another location and I have to run a weekly report on engines stored in that table that are below a certain performance level. The column heading is MGT...

Thank you put the sort on that field and it worked. "Sorting grouping button" - Pos --Ascending ---GroupHeader, NO ---GroupFooter, NO ---GroupOn, Interval ---GroupInterval, 1 ---Keep Together, NO Thank you very much for your help.

Good Morning Everyone, I have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the...

Just wondering where I put the code? Will it be under the MGT WC Margin Column in the query? Please see attached screen shot.