Search results

Hammer, I've had numerous issues with margins and formatting from old douments being inserted or copied in to other more recent documents. I there for set up a macro to do all the formatting to my companies style. Effectively I setup a macro to select the whole document and adjust the page...

Thanks John, I don't know that if its something I've done but your example did not work. I've attached the relevent part of my DB for you (or anyone else) to look at so you can see where I'm going wrong! Thanks Colin

The example you suggested uses a references in a field on a form, not a field in another listbox (which is where I'm struggling). How do I get the query to look at the ID field in my listbox? can I reference the field directectly using its field name or can I reference it using a column number...

I have a form where I need to select a business from first listbox then display the contacts for the business in the second listbox. I've been looking at cascading listboxes / combo boxes but everything I've found so far does not fit my requirements as its usually based around a single field...

Thanks Linq, I'll give that a try too.

That did the trick! Thanks very much.

I have a form that I want to display the data but not allow additions / deletions / Edits etc.. But also on that form is a list box that I need to have 'active' so I can select an option from the list box to carry on to a different screen or use the selection open word. My issue is that on...

Oh yes it has... I now have the following code on my 'on load' for the main form... Private Sub Form_Load() Dim JType As String JType = Me.J_Type Dim Sformtype As String Sformtype = "frm_Jobs_Jtype" & JType & "" Dim sf As SubForm Set sf = Me.frm_Jobs_DefSub sf.SourceObject =...

Thanks Trevor...

Thanks, that makes sense!

Thanks Trevor, I'm going to have a play now... Quick question - The line: Set sf = Me.frm02ClientTeam Is that the name of the current / active sub form on the main form? When the button (on main form) is clicked is loads: sf.SourceObject = "frm02ClientTeam" Sorry for being a pain...

Thanks for that Spikepl, I'll have an investigate.

Trevor, Sorry, just so I get this correct in my head (too much going on and not enough space!). Your example here when a button is clicked, in the sub form on your current form it opens a form called frm02ClientTeam and Links 'ProjectID' from the master form to the child form to pick the...

I have a job sheet created with the basic headers required, then depending of the type of job selected I want tab controls for the data they need access / complete. This is due to Some jobs needing different data entering for letter merges or creating reports etc... What / how do I control...

Bob, thanks for the pictures it explains perfectly what you have suggested. I shall try to work this in to V2 of the system.

If your using Windows 7 then you can use the backup software in windows for that purpose. You can schedule it if you wish or run ad-hoc. I know it can also be run from a command prompt so set up a batch file to autorun. Also if you take a look out there there are a lot of reasonable priced...

Sorry bob my last post mislead you slightly, its not full addresses I'm talking purely email address assigned to one contact with one postal address. i.e. I have my home email address (as my default) held in the same record in the contact table (me@home.co.uk) then I have in the additionalEmail...

Beetle & Bob, thanks for that but sadly I have it coded now and a 'pilot' scheme running with the app. I thought the easier solution would be to add a button to swap the data around. I could then look at changing it in Version 2... I'm on a dead line to get it live and it would take a long...

I was going to do that but sadly one of our contacts has 4 addresses? and quite a few with 3 addresses. This was the only flexible way I could think of covering all bases.

I have assigned to a contact an email address in a 'contact' table. I then have a table for additional email addresses (some of our contacts have home / work / other email addresses), this works fine with the default address always appears in the contact information and the additional emails...