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?

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

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...

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?

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...

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?

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...

Any posters follow football (real football where you actually use your feet :D ). Any fans of any UK teams on here?

Hi, I have a table with 12 records in it that are the months of the year. I have put them in as - 01/01/11 02/01/11 ect ect I have a combo box that has that table as its row source but I only want the user to be able to select the month. I could have put Jan, Feb, Mar, ect in the table as...

Hi, 1st post on this site, been googling quite a lot of access questions and time after time this site came up so thought I better get myself on here. Just got a new job in MI and I know Excel like the back of my hand but I am having to learn as I go with Access. Anyway just thought I would...