Recent content by RXX00

I have a form and the record source is a table. I want the user to input a value into a blank textbox, I then need VBA to use that value to filter a field on the form. Any ideas?

Shameless bump. Anyone???

Hi, I have created a DB with 2 main forms, one is for a manager and another is for a user. I want to have 2 hyperlinks, if you click 1 it opens the user form but if you click the other it opens the manager form. Is it possible to hyperlink to actual forms rather than just the DB itself...

Hi, Is it possible to tell access to go to certain tab on a tab control when you click a specific object? Thanks RXX00

2003 - celtic Uefa Cup final 2008 - RANGERS Uefa Cup final 2011 - West Ham Relegated

Hi, Is it possible to reference a value in a list box? I have a listbox with 4 columns in it. I want to reference the value in column 3 but I cant work out how to do this. If I was referencing a combo box I would simply put "me.combo_box.value" but when there is multiple values in a listbox...

Was sad to see the hammers go down, was wanting Blackpool and Birmingham to stay up as well, must be a lucky charm. :D The best teams comes from Scotland anyway.

Yes, I have the network log in for each user in the user data table. I will give this a go. Thanks EDIT - What is the Nz part of your code?

Is there as easy way to do this. I have a list of users most are labled "Users" but a few are labled "Admin" and I only want the users labled "Admin" to access 1 specific form. Any ideas?

This worked great. Thanks :)

Sorry for being vague, so busy today and things wont work. :( When the user is going through the records and gets to the last one, it takes them forward and displays an empty record, I want it to not go forward a record if the next one is empty.

Happy Birthday.

Hi, Any help would be a life saver. Why is this caption record counter not working? Me.Caption = "Record " & (Me.RecordsetClone.AbsolutePosition + 2) & " of " & Me.RecordsetClone.RecordCount and how can I stop my code from clicking onto the next record when I have this on click of my...

I know this is a simple and prob stupid question, but what is the difference between a subform name and a subform control? :confused:

Having trouble requerying a sub form Parent - [F_TL_SUMMARY] Child - [F_TL_SUMMARY_DETAIL] My code - Forms![F_TL_SUMMARY]![F_TL_SUMMARY_DETAIL].Requery Donesnt work. Advice?