Search results

Assuming it can be done???

Can someone please tell me how I can programatically delete all relationships for one, or all, tables?

Still struggling with this, anyone got some ideas?

Mile-O-Phile, thanks for the code. But I already have some code that prints modules by looping through the modules container. The problem I'm having is looping through the forms container printing what I want and then passing the appropriate form name to print the code!

I can get the name of the forms, no problem. But am having probs with printing the code.

No-one?

I don't like the format of the documenter, I'd rather produce my own report. As for the code, I want it all printed out. What I am trying to get to is something along these lines: Formname: frmA_Name_Here Description: Some descriptive text here Code: All of the code here. I have around...

Does anyone happen to have some code that loops through all forms (open or not) and lists the form name, desription property and the code behind the form? I want this to produce some documentation. I've had a very very long week and my brain is completely addled, I've been trying to get this to...

That's the one, thanks ghudson!

Can anyone point me to some code that brings up the "Open File" & "Save File" dialogues? I believe one of the functions I once used for this was called GetFileOpen(), but I've now misplaced the code. Any help would be appreciated!

Good point, that will stop the flickering.

The reason the form is flickering is because I have written a generic function that loops through all of the controls on the form and re-sets the forecolor and mouse pointer depending on whether or not the cursor is over the control passed to the function as an argument. Here is the code...

The closest I can get is with a routine that uses On MouseMove. But this isn't very good because it makes the form flicker too much! I'm sure this can't be done anymore, but if you know different then please let me know.

Does anyone have some code that replaces the old "On Mouseover" event in AXP?

This works well for command buttons, labels etc but unless I am going blind there isn't a "Hyperlink Address" property for text boxes. The controls I am using are all text boxes. Do you know how to get round this?

Does anyone know if it is possible to change the appearance of the mousepointer to the pointing hand graphic used in hyperlinks etc? I have a form that contains numerous controls, by double clicking on these controls another form opens. This all works fine but the problem is that the users are...

David, I have all that working, but it's the bit about changing the senders address that I am stuck on, Docmd.SendObject doesn't seem to do it?

I have a function that uses SendObject to send emails to a number of different email addresses. The problem is that I want to also vary the sender email address (as I have numerous email addresses that I use). How can I get Access to send an email using a from address that I specify (can it be...

A case of making a silly mistake and then staring at it too long. Here is the answer if you're interested: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp", txtPath, False, shtName & "!" (Forgot the exclamation)

I'm pretty sure the order of the parameters is correct and that it is the syntax that is wrong. Itried changing the order anyway but it still didn't work.