Search results

Hi Thanks for the reply. How do I see who is logged into the application, to see the currentuser I have just created a form with unbound control with the source being =currentuser(), which shows admin. Thanks

Hi Dcrake I just downloaded the DB and taken a more detailed look. It does as some good features, especially the who is logged in and date etc...... so I would like to adapt this and see if it would work within our db.... but first 1. I have logged in as Delilah with password Del and it is...

Ok Jonanthan when you can of course, its appreciated and enjoy your Holiday Thanks

HI thanks DCrake for your reply and link. I took a look at this but found it a little to complex for my limited knowledge and would find it har to implement into our DB. Jonathan - I think what you have is more or less what I am after. If it logs the current user into another table I can...

Hi jonathan Yes I would like whoever is logged in to be the user =currentuser() When we create a Quote report, I want the current user and their job title to display on the front cover and need this to happen as automatic as possible. So using login's is the only way I can think of. So...

Hi Thanks for the reply. That is something I am after except the databse needs to know who is logged in. I logged in as Graham so the assumption is I am logged in as Graham. If I add a text box and set the Contol Source =currentuser it comes back with the Admin username and not Graham as...

Hi All Does anyone have any ideas on this at all I have tried using the access 2010 manage user and passwords and I cant get this working. I use the Wizard but then when I go into the database it just shows as Admin as current user and does not even list the users I have so I am totally...

Hi All Does anyone have any ideas on this at all I ahve tried using the access 2010 manage user and passwords and I can get this working. I use the Wizard but then when I go into the databse it just shows as Admin as current user and does not even list the users I have so I am totally lost...

Hi Just to let you all know I finally solved this issue..... What I did was go into the report and then go into the record Source and then highlight the criteria section for Quoteid. I then right mouse clicked and went to build, and drilled through to the formquote and selected IDquote I...

Hi Yes I have tried using the OLE object insert with a balnk report. It says it does not recognise the file type, it is a PDF. If I convert the PDF to Word it does it no problem. Its PDf it doesnt seem to like Any ideas????

Hi Prley Yes seems simple once you have worked it out..... Have not got the hyperlink problem sorted as yet, but still hoping for a result and if I do I will post it on here... Thanks

First impressions I am running into problems... there is far to much coding. I have for example changed the user name to look at my table, that works but as soon as i click login i then get a whole host of debug problems. Any ideas please....

Hi Thanks for the reply. Yes I have but and found one by yourself I believe, which I am now trying to ut into my DB. I will no doubt run into problems, still very raw with more advanced things presently :p Thanks

Hi I have a table with user id, username and position of users. I want the users (abit like the Northwind Db) to have this screen when they log in (a form which as the user name drop down list and button for Login) When they log in with their user name then I want that to be the...

Hi The field idquote is an integer. Thanks

Hi Ted I dont know what you mean using brackets.. this is my exact code in the Open event of the report.................... Private Sub Report_Open(Cancel As Integer) Me.Filter = "idquote.value = " & Ingidquote Me.FilterOn = True End Sub When i run the report from the Quote form I...

Hi Ted I now have thiscode in the open event Private Sub Report_Open(Cancel As Integer) Me.Filter = "idquote.value = " & lngidquote Me.FilterOn = True End Sub However when i try and run the report now from the quote form I am getitng this message Run time error 3075 Extra ) in...

Hi Ted Sorrry dont quite follow.... I ahve added this to the report Private Sub Report_Open(Cancel As Integer) Me.Filter = "idquote = " & idquote Me.FilterOn = True End Sub But I am getting a debug error message on the Line Me.Filter = "idquote = " & idquote The field for the...

Hi Thanks for the replies, Ted not wuite what I am loking for but thanks. Ok this is where i ahve got to If I preview the report I use this code and it brings just the one report with the correct quote information. StDocName = "quotedem" DoCmd.OpenReport Combo38.Column(2), acPreview...

Hi I am using A2010 and I now have the report working thanks with the DoCmd as below and it attaches the correct PDF report.... (just to work out how to grab the correct email address now... DoCmd.SendObject acSendReport, Combo38.Column(2), acFormatPDF,Me.EmailTO, "type = '" &...