Search results

Yeh, just a standard module. Very stange that it works for you and not for me! However, i've sorted it purely by chance by looking at the expression builder. If I use the control source: =CurrentUser() It works great! Thanks for all your help, -NS

Humm, that doesn't seem to work either. The name of the text box is txtName. Very strange!

Actually, I just tried this now and I get a Name? error. I have created a text box on my main from and set its control source to =Environ("username") I'm not a networked computer at the min (at home) if that makes a difference? My system is Windows 7 and Access 2007. Thanks, -NS

Great stuff Bob! Many thanks. -NS

Thanks for the quick reply Bob! I understand all but how to actually make this display in a form. A nudge in the right direction would be great :) -NS

Hey all, I was wondering if it's possible for Access to ..ermm...access the login name or actual username of a user on a computer. I'm basically just wanting to display a "Welcome User...." message on my splashscreeen and/or menu. Many thanks, -NS

Hi VbaInet, This old chestnut again! Can I do what I originally posted about IF the comments field is not a part of the form I want to show it on? i.e. I'd like to show the 'Staff Comments' from the Employee table on a form that doesn't contain the subform where Staff Comments actually is...

One more quick question... When creating a combo box with the wizard, it asks you if you like to store a value in a field or if Access should remember this value for later. Can anyone explain what this means? I have no idea! Thanks, -NS

Thanks SOS. I've had a quick go and it seems to be the way to go! It's very different to using Lookup fields in the table and seems a littler trickier at the min. I'll have to get my head around it and see what I can come up with :) Thanks again for your help. -NS

I see, I've read the info you linked to. Could you shed any light on what you mean by at form level? Thanks, -NS

Hey all, Just wondering if I am currently doing the correct thing. I have a problem (well, it might not be a problem) and have tried to explain below... 1) I have an Employee Table which has a Manager field. I have another table called Managers which is made up of ManagerID, ManagersName and...

Hey all, I just recently found the option in Access 2007 to allow only unique values in a query. This is quite handy but it crossed my mind that this may not be good practice and that a properly designed database shouldn't need to use this. WHat are people's thoughts/views on this? is it bad...

This is quite an interesting idea....something I might think about putting in my database :)

Ha, it seems VBA is the way forward for the trickier things! I will have a read of how to set the control source in code and fingers crossed it aint too complicated :) Cheers, -NS

The way you previously said worked!! For some reason the expression builder didnt include the main form name! However, I assumed this text field would be editable but it isnt. I am guessing this is just part of the design and there's no way to make it editable? Many thanks for all this help...

Humm, doesn't want to work for me. I have =[Forms]![qryTestsubf]![Comments] in the control source which is the correct subform and comments is the correct field within that subform. I wonder if it's something do to with the fact my subform is based on a query. Cheers, NS

Thanks for that vbaInet. It looks a little out of my league for now. I might delve into VBA at some point in the near future tho! Many thanks, -NS

Thanks vbaInet. Unfortunately I get a #Name? error in the text box. If you can provide any more info that would be awesome!! NS

Hey people, If possible I would like to display a simple txt box on a main form that changes its content depending on on what record is currently selected on a subform. For example: If I select (by select I mean click in) a record in the subform that has a related comment such as "This person...

Sorry vbaInet, I have one more question which you might be able to help with if that's ok?! Your solution worked perfectly. However I'm now thinking that it would be good to give the user a choice of filters to apply. For example I have another column named "Employee" which users may want to...