Search results for query: *

Not sure if i explained myself enough i have an activex sidebar and what i want to do is click a button in there to open a URL for instance i have a Statusbar and on click of a button i have the code StatusBar.panels(3) = "Reports" this sets one of the panels to say Reports i also...

Ok for some reason i cant get my head around this i want to be able to click a button and in VBA i want that button to open a URL whatever i try doesnt seem to work any help would be appreciated. Andy

Thanks Fubear Just what i needed Andy

Its ok i have achieved the goal by referencing back to the list box me.email DoCmd.SendObject acReport, "ReportName", "SnapshotFormat(*.snp)", Me.Email, "", "", "Email Header", "Email Message", True, "" This opens my outlook...

Ok here is my problem I have a form with a list box on with "Name" & "Email Address" behind the list box when i double click the name up comes a report that is to be sent to that person but i would like the report to be generated attached to an email and sent automatically...

Thanks Jebry Sorted in the end Andy

Cant get that code to work it highlights the following strCurrentControl = Screen.ActiveControl.Name any thing else i can do Thanks Andy

OK i have done the above and like i say that works well for the form but now i would like to do it individually ie when a text box/ combo box on got focus i can put in i.e Private Sub Postcode_GotFocus() Postcode.BackColor = 13434879 End Sub Private Sub Postcode_LostFocus()...

Thanks everyone worked a dream DaltonVB & KUZZ Andy

Just wondering how do you set the backcolour of a text box on the Got Focus event pls could you post the code if possible. Regards Andy

OK a question that may have been asked b4 I am trying to create a class rergister using access just wondering if anyone has done something like this b4 as i am stumped on where to even start on this one. Any help or samples would be greatly appreciated Thanks in advance Andy

Not sure about the relationships but i wouldnt think so, but like i say im not sure perhaps someone else could verify that. You could disable the database window as long as your users dont have the knowledge to bypass it with the shift key. Security is one of those issues we could talk about all...

Try re-linking all the tables in the Front End again, it should then ask you for a passowrd which you can then put in and it should save it. The problem you then have is that if they can get to the database windown in your database then they can still see the tables. Hope that helps Andy

As far as i am aware after such a problem i have had this before and the database seems to be ok afterwards. If you are still not sure try sucking all the tables from your backend into a new database and renaming it. This has also worked for me in the past when i have encountered corruption or...

Have you tried opening up Access itself then File/Open/Navigate to where your database is highlight it/hold down the shift key and then open it keeping the shift key down. Is it just not opening or are you getting an error? Hope that helps Andy

Just a simple idea you can automatically compact the database everytime you close it. You probably already know that but just in case you dont click tools/options/General Tab/Compact On Close. Like i say you probably knew that but just in case Andy

Thanks KenReay Havent got it to work yet, for some reason and i cant see why within the code as everything seems as it should be im sure with a little time on it i will sus why.It seems to be just what i need. Thanks Andy

The situation is as follows I have a report generating delivery notes, one large report totaling maybee 300 pages. My problem is that i need to number the pages for each individual Delivery address ie maybee there are a total of 300 pages for 100 different addresses so each one might have 3...

Sorry never saw that yep if you cant make an mde then most probably need to compile. Thanks James Andy

The easiest way is to look in the directory where the database is stored, if the database is open there will be an ldb file in the directory. The file will have the same name as your database but(.ldb) make sure that you dont have the database open yourself. Hope this helps Andy