Search results for query: *

Some years ago using Access 2007 I built a database and when it was finished I hid the Navigation tools (form, queries etc) and the ribbon bar. Having re-established the link between the frontend database and data after repairing the machine due to virus problems I need to hide the ribbon so...

Some time ago I built a database with the front end providing forms queries and tables etc and a second database with the data. We had a Virus problem with the network and this was fixed but at the expense of losing the connection between the two databases. We got error messages “not a valid...

I have a workbook that allows me to calculate the balances needed to fund my mother's care home fees. In basic terms there is a worksheet that shows her income for different sources and her expenses. Her income is usually uplifted by inflation each April. My problem is that if I change the...

I am using Excel 2010. I have a column with dates and I want the dates (or the background cell color)to change based on whether the date is greater than today, less than today or today. I have had a feeble attempt at changing the color using this formula...

I am trying to develop a questionnaire on a web page that returns an email from the respondent back to me. I have a basic structure that seems ok but when I load it via ftp onto my site I get this error message: Parse error: syntax error, unexpected $end in...

In cell (say A40) I have a calculated figure of Fee plus VAT. This has to be taken away from an income figure but accululates each month. So for example the figure in January is say £126. What I want is in February this to be the January figure plus the same again in February and then in March...

Hopefully this is a fairly simple question. I have a page that shows a table that derives its data from an MySQL db. I want to be able to vary the column widths individually but I am have trouble getting the right syntax. Can anyone show me how to change the width say of the column Event? The...

I want to update (or add a new record) to a table in a form. I have managed to do this for a page that updates events but some reason my code in the new members page does not work. I have clearly got something wrong with this code but I simply can't see where. The code should add a new member's...

I have a page on my web site where the user can update members details. The SQL I am using is this: mysql_query("UPDATE tblMembers SET...

I have a page on my web site where the user can update members details. The SQL I am using is this: mysql_query("UPDATE tblMembers SET...

I have a page on my site where the user can add a new record to a table in a database by using a fairly standard form. To ensure data consisitency I want the user to be able to select standard responses in certain fileds. For example one field is called "eventtype". This filed determines whether...

I have just installed Office 2010 with Access 2010. I used to be able to change the cursor to a hand using the OnMouseMove property by using this code: Call MouseCursor(32649) This does no longer seem to work. Has anyone got a solution please?

I am using the 2010 beta version of access. I want to allow a user of Access 2007 to use this database but when I load it onto their machine I get an unrecognisable file format message even though it is supposed to be 2007 format. Any suggestions why this happens or how I can overcome it.

I used to be able to set up a text box that allowed the user to view each file or record as a loop search was called. I suppose a bit like when using a registry cleaner it shows each entry as it searches and checks. Can anyone point me to a tutorial that shows this or can advise how I can do it...

I have a main form that contains data from a table called tbl_Interim_Certificate that has a primary key field called Job_Reference. The subform is based on a table called tblFinalCertificate. The foreign key for this table from tbl_Interim_Certificate is also Job_Reference. What I want is that...

I have a standard search form with a sub form that is in datasheet view on load/open. I want this datasheet to be blank before the user enters a selection in the various search text boxes of the main form. However, I don't believe this is possible with a datasheet view. The next best thing would...

I am using MS Access 2010 which I suspect works in a similar way to the 2007 version. In the older versions of Access it was easy to ensure the GUI size of forms was as wanted. In the the newer versions I seem to have a lot of spare space to the right of the form and however hard I try to change...

I have a form with a combo box that looks up a table field Job_Reference. This Job_Reference will be the foreign key in another table. I want to ensure that the user selects an existing job_reference record from the combo box (which then populates the field for the foreign key i another table)...

On my form the User needs to input a new Job_Reference (typically something like SMI09_1) where the SMI is the client code, 09 the year and the _1 the reference number for that year. As the user can't necessariy know the clients last reference number I want the form to show a message if a...

My form is based on a table where fields are required to be filled. If the user moves on to another record the default MS error message box is shown. What I would like is a friendlier message box that showed the field name that needs to be filled and also an instruction that is the user does not...