Search results

ive tried that but it didnt work............... i must be doing sumat wrong.... is it possible that you can implement it in my database? it would be a great help!

Can someone please look at my database and sort out my search form for me............ it might b sumat simple.................... the search textbox works (it succesfully searches for the provider or site) from the listbox.... BUT the subform underneath the listbox doesnt...

is there another way? i dont particulary like the wizard way................ because the listbox is already created and is linked to a search textbox....... ive got an empty form underneath it, which i would like to populate by clicking on the record in the listbox?? any1 got some code?

yes........ and show it below the listbox in the same form

Hi, how can i populate some empty fields/comboboxes by clicking a record in the listbox? the details are stored in my table..................?? thanks

Hi, I have a database that contains details of different sites. The details include site address, connection details, Line details(telephone provider etc) and DSL details.................. There are several sites............ Basically i want to have a search option(possibly in a form) that...

thanks for ur reply....... everything in my database works............ apart from the way the report pops up!?? i want it to come above all windows (including the form window from which i opened the report)????? :confused: :confused:

thanks for that....... how do i stop it from adding an empty form? becoz if i click the add button even if the forms empty, it brings up the message sayin Are you sure you want to add...... etc etc.......... if i click yes, then its adds an empty form!

can someone please modify the following code to add a warning message to an add button.................this add button allows to add details filled in a form... Private Sub addrec_Click() Dim strSQL As String DoCmd.SetWarnings False strSQL = "INSERT INTO tab_main ([username]...

Hi, im struggling to bring a report above a form. there is a combobox in the form, from where i select a username and bring his details up in a report(Report2)............. ive got the following code for the OnOpen event: Call DoCmd.SelectObject(ObjectType:=acReport, ObjectName:=Me.Name)...

cheers gemma

hi, a simple 1, ive got two columns in my combobox .... userID and name. i want to hide the userID column and just show the name column? how do i do that? the userID is the first column(to the left)

Barry ur the Man............... ive got it working, using the example you gave me!!!!!! cheers mate :D :D :D

Thanks peep, Barry thats a good example..cheers bud... will give it a go

im not getting nowhere (i still appreciate what ur help).......... what shal i do?

ive changed the forms popup to YES.... and it works but............. after this when i try to open a report(from the popup form) it hides behind the popup form....... i have to close down the popup form to view the report!!! my database is crazy .......................... arghhhhhh:mad:

i used the followig code: DoCmd.OpenForm "reportform", acNormal, , , , acDialog because i want the form window (from which i want to open the report from) comes above every other window??? Using Mic codes: DoCmd.OpenForm "reportform", acNormal corrects everything but doesnt open as a...

any1????? my database is annoyin me!!:mad:

hi, has any1 got any examples i can look at for the following: A delete button that deletes the item selected in the combobox i need it urgently???????please or even any code!!!!

do u have any examples or so that i can look at? it would be appreciated thanks