Search results

I do like these discussions on here. Thanks for that little code snippet vbaInet, Exactly what I was looking for. And yes, this is mainly for my own edifiaction. Being a self taught VBA'er I have picked up a few bad habits so just trying to iron them out. Thanks again!

Thanks for the suggestions both of you, will look in to the controls table. I'm assuming this is a table detailing the names of the controls , List of userlevels then simple yes/no fields to say whether that userlevel can see them? Another idea I had was Subforms in each tab. Would this be...

@CBrighton, No real reason that I couldn't use a command button. Same as I could use the after update event of the search box to do it. I just like to make things difficult for myself! :D VbaInet, will look in to WithEvents. Even if I don't use it this time, it's always worth learning new things.

When you say 'not working', do you mean it causes and error? or just doesn't update the record?

!? I've looked in to creating classes but didn't get very far. Is there a good source for 'how to' on this?

I'm looking to use just 1 form to run my entire DB. Certain areas of the DB are only available to certain users so for ease of programming I thought using a tab for each userlevel then all their individual options inside their tab. I think SubForms would be the way to go here?

Hi, I'm trying to put a Tab control inside a page on another Tab Control but it won't work. Is there a way around this without using a subform inside the page?

I think the form afterupdate fires just before the form closes or updates. In VB you can use a private function and add HANDLES txt_search, frm_sf.... but I can't find anything like that in Access

Try using me.controls(ctl.name) instead.

Hi Elvin_08 It looks like an UPDATE statement is required. If you have your PC names in a Combo or Listbox then in the AfterUpdate event you need to put something like: CurrentDb.Execute ("UPDATE [PC_Unit] SET [Availability] = 'Not Available' WHERE [PCname] = '" & me.comboPC & "';")...

Thanks VbaInet, (again!) I've taken your advice and put it in to a function which is called on the afterupdate of all the controls. Private Function DoSearch() Dim SQL As String Dim WhereStatement As String Select Case Me.frm_SF ' Option frame to select which field to look in...

Hi CherryBomb, When you link to the second form, you can use the docmd.openform and pass arguments to it. DoCmd.OpenForm "Rates" , AcNormal,,"[Supplier_ID] = " & me.Supplier_Id [Supplier_ID] is the ID on the 'Rates' Form me.Supplier_Id is the ID on the first form. Does that help at all? Rich

All I can think of would be to have several 'progress boxes' relating to each item then maybe an extra one which will be an overall progress.

Thanks everyone. Finally figured it out by adding extra fields to the query which were the iif statements. Finished SQL is pretty complex. Thank MS for the Query Builder! SELECT tbl_Address.[Customer Ref], tbl_Address.Surname, tbl_Address.[Post code], tbl_Telephone.[Contact number]...

Thanks Brian, I think that your code would return all values either like or exact match to [name] I was looking for the user to be able to choose whether it should be an exact match or not. ps. I'm not going to use [name] in the query, it'll be more like [txt_Search]

Hi All, Normally I would do this in VBA, but I'm intrigued as to whether I can do it in a query. I'm building an advanced search for my DB and the user can select many option: 1) What field to search in 2) Whether to search the entire field, or Any part of the field 3) Whether to search all...

Hi Speakers, When you're looping through the recordset you're assigning the date and time to T each time it passes through. I'm assuming that me.todaysdate is a control on your form. So maybe adding a docmd.gotorecord , , acnext inside the loop might work for you. Rich

Hi ErinL, I've attached a sample file with a progressbar control. Any questions just ask. Rich.

Hi Toni, You joined the right forum. The guys on here are great. Any problems, just post it! Rich

Can't believe I missed that post! That would have saved me a headache!