Search results

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?

The problem is that I need it to open on the 1st record, I guess I could move forward 1 record then back again - would that work?

Hi, I have a form and I have turned the record selectors off. Due to this I have created 2 buttons that allow the user to go back and forward though the records. This is working fine. I have now put in a caption that says "Record 1 of 35" using "me.caption =" code. I put this in the on...

The "English" that the German tribles came up bares no resemblance to the English that the Brits spread around the world but I take your point.

Thats very much, I will get back to you tomorrow monring when I implament this at work. UK time that is. Thanks again.

Yeah, I will need the month and the year. My table has, for instance, "01/05/2011" but I only want the user to be able to see "May 2011". If I have the "01" at the start of each month the users that I work for will be confused (that happens easily :p ). I am still learing a I go with Access...