Search results

I understand the market is jammed with project software - I'm not trying to recreate or reinvent the wheel in that respect but I would like to create the chart in an Access form as all the data i need sits in a relational db and it would suite the database to create a simple chart to illustrate...

Hello Everyone Is there a way of creating a gantt chart in an Access 2007 form- either through Macros or VBA. I prefer not to use Third-Party software if possible. Thanks for any Insight on the matter

I am trying to create a validation form txtSystem txtLine txtEquipment txtAsset txtModel txtSerial These fields are always visible. For each bit of equipment I have to answer these questions broken into four groups. Group 1 - IQ (Installation Qualification Equipment Identification has 3...

I have a couple of questions regarding database/form design. I have a table that has 212 fields (majority of these are simple yes/no tick boxes) - is that number of fields in a table to store data ok or could it be a problem? (eventually I will break these down when I need to run query's or...

I don't know the ALT-Code - if I found out - how would I place that in my Combo Box?

Hi Any Help on this would be great. I'm using Access 2007 How do you get the üsymbol in a combo box. I want to have a drop down combo box, with - Not Applicable, X, andü

Hi. Does anyone know where i might be able to find information or sample databases of a functional database that controls/tracks documents. I want to look at how it might keep track of documents when revision numbers change or keeps track when documents are due by date to be reviewed etc...

I Pbaldy. If I set the visible property of each tickbox to No - will the VB code still make the tickbox visible - even if after the visible property is set to No? Thanks Once Again

Thanks Pbaldy for the quick post. When I open my form how do I make the tickboxes "PreApproval", "InterimApproval", "PostApproval" hidden in the first place. So that when I use the code you've given me - to make "PreApproval" visible only? Thanks again for your help. SpiritedAway

Hi - Need some help figuring this out - I'm using Access 2007 I have 3 ticks boxes, "PreApproval", "InterimApproval" & "PostApproval". When I open the form called "ProjectControl" I would like these 3 ticks boxes to be invisibile. Only when I type in a date in my "ProjectStartDate" field do...

Is there a straightforward way of creating more than 3 conditions using conditional formatting in an Access 2007 form. I am scoring a document. On my form there are 4 dropdrop boxes each with a score between 1-4. As I score, I'd like the "final score" field to add up the total and if the score...

I have a record in a form that has 3 fields, [name], [Line], & [asset number] and a series of check boxes. Is there a way of hitting an "add new record" button that will open a new record with the current values in the [name], [Line], & [asset number] of the record i clicked from but leaving all...

If you go onto Microsoft's website and download their contacts template - they have a filtered search query which searchs across the whole form in all fields without the need to click in specific field or use wildcard tags. Just download it, look at the filter macro, familarise yourself with it...

Guys I came across this bit of code that works a treat! Private Sub CallObject_BeforeUpdate(Cancel As Integer) If CallObject.Text = "" Then MergeBttn.Enabled = False Else MergeBttn.Enabled = True End If End Sub Does what exactly it says on the tin. Thanks everyone for their help - it is...

I have had a rethink - what I have is a combo box, if it is empty then user cannot use the Mail Merge Button, no matter how many times they click on the button if the combo box (which is called "selectobject") is empty then the button simply will not do anything. It's inactive. The button can...

Hi Mattkorguk The only versions of Access on my machine is 2007 - it all started to happen once I had compacted my database. Since then it has affected my ability to use the spacebar when writing code, it drags the word back and joins it to the proceeding word. I'm now using a back-up copy...

I have a mail merge button on my form that will merge the data in my fields into specific places bookmarked on my word template. If the user hits the mail merge button without having filled out all the fields i want to have a message box pop up telling them that they have to fill in the fields...

Thanks for posting a reply lagbolt At present a simple piece of code such as If IsNull([LastName]) Then AddyLineVar = [Company] SalutationVar = "Sir or Madam" end up looking like IfIsNull([LastName])Then AddyLineVar=[Company] SalutationVar="SirorMadam" If it is as you say, is there...

:mad: Following good database practise I recently compacted my database - the next day I went into my database to write some VBA code and it will not allow me to add any spaces between words, whenever i hit the spacebar and try to write some code it joins the word up to the last word. Does...