Search results

Hi Bob Please find attached the db. The main tables and forms are tbl_users and the login form is called frm_login In the FormQuote I would like to see the login Fullname and Position on the screen In the report Quotecom, I would like to see the Fullname and Position shown on the from...

Hi bob Unfortunately I wont be able to get the database till Tuesday/Wednesday next week. I dont suppose you ahve an example we can work with in some way, or using the link one above. Thanks

Hi David I tried applying the example we had to the real DB but could not get it working. i took myself through this tutorial and created a similar situation. http://www.about-access-databases.co...-box-form.html and I created a login screen and it works, apart from I cannot see who is...

Hi The voss as decided he does not want the address field in a string but in a block, for example Name Address 1 Address 2 County Post code So if the county or any other field is empty how do you make it so it goes up one to coover a blank, so if I had Colins Company 1 high Street...

Hi Sorry but is there anyway you (or anyone) could help me with this. I have tried all sorts but seem to be getting into a further mess as I go along.... Thanks

Hi bob I put it in the Event procedure and it works fine. Thanks for the help

Hi Bob I have put this in the Pageheader On Format me.image8.Visible = ([Page] = 1) but I get a message saying Microsoft Acess cannot find the macro Me Any ideas please thanks

Hi We want to have the date, idquote number and page numbers at the top of every sheet of a report. However, we want it to go above our logo rather than below. So for the date etc.. to show on every page I know it as to go in the Page header If I put it above the logo in Report Header I...

Hi Bob the form for login is purely as a drop down login and then verifys password, it is called frm_login. It as a table attached called tbl_users and in there we have the username, full name, job position etc...... I am using a form called formquote to make the quoatations and it is from...

Hi I have tried this many times but still having problems. I basically want a user log in screen but then want to be able to oput the user name and job position onto a report front page. Several have tried to help me so my apologies if I seem to be going round in circles. I have used this...

Hi I found an Access database that let you point to a directory (in a form) where you graphic files were kept ad upload them all at once. I lost the file and I cannot find it on the web. So 1. Does anyone know of a sample database out there that does this.. 2. if not any ideas how I can do...

Hi David I left the username blank in the tbl-permissions and then it asked me to create a password in the login form. This works ok. In the TBL users it keeps the name Colin and on the forms we did yesterday it shows Colin, so thats good. In the table permissions it changed the name...

Hi David Could you explain how I can add a user and password into the database. I added my name into the user table and I added userid (13) into the permission table and wrote in my password. When i try and log in I get a runtime error. Could you advise please. Thanks

Hi That is excellent, I also applied it to my Form 1 just so I understood it complete and it works in that as well now. So a big thank you. My thinking now is this... To apply this to the real database, I; 1. Copy all tables , forms and code from the example DB. 2. Then I add in a Job...

Hi I cannot open 2010 on this laptop, any chance it can be saved as 2003 version. I am doing this for 2010 but wont have that machine until Tuesday. Thanks as always

Hi I have attached the database with the form. I ahve named the text box mewhoamI and added onload an event with me.whoamI=strUserName I am now getting compile errors. Is it possible you could adjust the form correctly (Form1) and then i can understand better. many thanks

Hi In the control source of the text field in From1 I have tried [StrLoginName]=Me.CboUser StrLoginName=Me.CboUser =Me.CboUser =CboUser and all of them come back with #Name? any ideas please Thanks I am definately logged in as Delilah

Hi Ok I found the code and understand that bit. I have created form1 and added a text box and in the source, what do I out in to get the name Delilah to show. I have tried =Forms!FrmLogin!CboUser but I get a name error in the box. Any ideas Thanks

The database example already as code on the afterupdate in the form Frmlogin. How do I do this in the example databse?? Thanks

Sorry forgot, also how do I make the new field Craeted by see the application user name.. And again sorry I do not understand what you mean by variables to pass the info to the reports Thanks