Search results

Still not working. My db is FE and BE the form I working with has sub forms which return results from criteria in the main form. I trying to have the subs and their controls unbound and set their record source via code on after update from the main forms search criteria. This works fine except...

Well Here is my Code. I call it on close of the form but it still doesn't work. Me.PollingPlacesResults.Form.RecordSource = "" Me!PollingPlacesResults!PollID.ControlSource = "" Me!PollingPlacesResults!location_line_1.ControlSource = "" Me!PollingPlacesResults!location_line_2.ControlSource = ""...

I tried that, but in the properties for the form it still shows the record source.

How to prgramaticly remove the record source for a form. and the control source for the controls.

Bump Found this autocompact

Ok I want to do auto backup using the auto compact db, I think I got from here., anyways I want to copy it but the auto compact cant because of the DB password is there a way around this like have the password in the path of the db?

V-Tools is a nice add in as well

Won't hurt if you do.

Ok Doc Last night I added extra componets from the office disk then office went nuts giving me registry errors. I can't even uninstall, It just triess to do an install. any suggestions to get office to uninstall.

That is not easy to answer without seeing your db and what you are doing with the data.

Well I'll give it a try Assuming that the isp address and phone number are separate from the type field I would have two field bound to the same source for phone/isp use an imput mask for the format of the field. over lay both fields and set the visible property to no Use an after update...

Is this the Staff/ISP phone/Isp in the same field?

lol :) I was looking for live data, don't really want to have to do imports and I really don't like connecting excell for live data. thanks though.

Can I connect to money using A97?

Something like this in the criteria for the expriy field in the query Forms!YourFormName!YourCbo

See if this helpsDate Part

It should be as simple as passing the cbo's criteria to the query. But I think we may need more info the expiry date is this a date/time field or text? do you have a seperate field for month and year for the expiry date?

Use the new menu option from the comands and you can put the functions you want in it.

The reason it affects the default bar is beacuse that is what the default bar is a built in menu.

You shouldn't need online help to do check the help files as long as they are installed on your computer.