Search results

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...

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...

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...

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...

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 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...

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...

Hi everyone, I have a problem relating to a combo box. I have got a form based on a table called 'Notes', whose primary key is 'NoteID'. What happens is, the database has numerous cases whicah can each have notes based on it, so the 'Notes' table also has a 'CaseID' field which can then be...

Hi everyone, I have a problem which I assume will have an annoyingly simple solution. I have a combo box that is populated by an SQL statement, which works ok. What I want to happen is when I open the form that the combo box is on, I would like it to autoselect the first item in the combo box...

Hi everyone, I am doing some work on my company's database and it is an MS access front end with an SQL back end. I have just had some new fields added to a table, and when I try and update the new fields through the form to which the table is attached, I get a 'Write Conflict' error message...

Hi everyone, I am creating a query that shows a list of all invoices raised in the last month which shows the date on which they were raised along with the amounts. Each invoices has it's own ID, but there may have been more than one invoice raised to send to the same company for different...

Hi everyone, I am looking for some help with a particular problem. I have a report based on a query and at the moment it is ordered by a particular column. What I want to be able to happen is that the user chooses what they want the query (and subsequently) the report to be ordered by before...

Hi, I was wondering if anyone can help me. I am running a parameterised query on which a report is based. The report shows all invoices raised for a particular amount, which the user specifies before the report is run. What I would like is that if they wanted to show all invoices raised...

Hi everyone, I am doing some work on my company's database. It is a MS Access 2003 front-end with an SQL back-end. Recently, I have asked the database administrator to add some new fields to an existing table and two of them are yes/no fields. When I have tried to update these fields, it...

Hi again, I have got 4 separate listboxes on a report and dependant on the content of the report, I wish to display a message box to inform the user of data inaccuracies that are appearing on the report. Basically, when the report is loaded, it runs a query and fills the listboxes if certain...