Search results

I tried this and it worked a treat! Thanks for all of your help.

Thanks for your replies guys I will try it tomorrow. I did try and use the val function but I tried: TotalMems: Val([Act]+[Def]+[Pen]+Val[Trans]+[Dec]) which didn't work. Thanks again. Gareth.

Hi everyone, It's been a long while since I posted on here, I hope you are all well. Basically, my problem (which I think should be relatively easy to solve) is this: I have a query which selects values from multiple tables. This part works ok. However, here are some of the columns that...

Hi everyone, I have, what I hope, is a very simple query. Basically, I have a form containing a couple of combo boxes both of which store data ok. However, when I change to a different record, one of the combo boxes displays the data correctly, however one of them doesn't. The only way...

Hi, I have got a report that I want to export to a spreadsheet and I am currently using the following code to do so: DoCmd.OutputTo acOutputReport, "reportname", acFormatXLS However, in the report header there are two text boxes, one underneath the other, but when I export it to excel it...

Hi everyone, On a report that I am running, the user enters some parameters before the report is displayed, and dependant on their answers (y/n), content on one of the pages will/will not need to be displayed. I have a text box that stores their parameter input so is there some way that I...

Thanks for your response. The box is set to visible as it displays when previewing it from design view. I only have an event on the 'on print' of the detail section that the box is displayed in. The event determines the content of the box dependant on parameters that have been inputted by...

Hi everyone, I am running a report in Access 2003 to produce company standard letters. When the report is in design view and I click preview, it works fine but when I try to run it from the relevant form on the database, one of the text boxes doesn't show up and I don't know why. Any ideas...

Hi everyone, I am aware that this has been asked before but I currently have a report which is being used to produce standard letters. What I want to happen is for the text boxes that are being used to form the body of the letter to be justified but I cannot get this to happen. I have...

That sounds like a plan.. Do you mean create a separate database altogether and put the data into there or to just add another table onto the front end? How would you go about that? Thanks for your quick response I'm surprised you managed to read all of my waffling on in that time.

Hi everyone, I have a situation regarding comboboxes.. Please note that the information isn't stored in a table as it is a company database and I cannot get a new table added onto the back end at the moment so my method is to add the fields into the 'row source' property. I have a form...

Hi everyone, I am producing a report in Access 2003 and in the header, the back colour is grey and I want to put a checkbox in the header but it comes up as white and I cannot make it transparent to fit in with the back colour. Is there anyway to do this, perhaps vbcode in the 'on print' even...

Thanks for your reply. I have done a similar thing but using IsNull will that work or should I change it to IsDate?

Hi everyone, I have a report that is based on a query. Some of the fields in the queries are dates (i.e. 'date1' and 'date2') , and on the report I want to do a datediff to show how many days there are between 'date1' and 'date2' and for this value to be placed into a text box on the report...

It is an SQL back end but it is set up as a text field in there as well because when I go into the table in design view it says that I cannot modify the properties as it is a linked table so it is obviously getting the settings from SQL. I am using Access 2003. I am assuming it is something...

Hi everyone, I am using a table that stores data and one of the fields is just a text field with a maximum length of 10. However, when I store the data in the field, if I only enter 5 letters in it, it stores the 5 letter word correctly but followed by some spaces (I assume 5 spaces but I may...

Hi and thanks for your replies. As I don't want the rest of the form to allow edits, I have the combobox allowing edits when it gets focus and not allowing edits when it loses focus. I have an afterupdate event that finds the relevant selected record to bring up the details but other than that...

Hi everyone, I am hoping this is a simple one. I have a combo box with a list of customers and when I choose one it brings up their record on screen. It is an editable combobox i.e. when I click in it, if I want the customer Steve Smith for example, instead of having to scroll down the list...

I could have done but it was a separate issue on a form so I thought I would start a new thread.

Hi, I posted a message before relating to a combo box on a form I have that I want to be able to edit fields stored in a table called 'Notes'. There can be numerous notes stored for each case. When the form loads it brings up a combo box showing all of the notes that have been made for a...