Search results

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

I have had an idea, here is an example of the report: Summary of invoices for all companies between x and y dates: ABC LTD - Amount Raised £75 DEF LTD - Amount Raised £70 XYZ LTD - Amount Raised £300 Report summary: Total value of invoices raised: £445. That is a snapshot view where each entry...

I have tried doing a totals query on the amounts field but as each invoice id is unique, it isn't making the slightest bit of difference to the outcome of the query/report. Thanks for your help.

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

I figured it would be something like this involving SQL. Do you have any idea how this is done as I'm not really sure. Thank you for your reply.

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

Thank you for your response. I have tried that and it still shows up with the error message is there anything else that it could possibly be?

I'm not sure I understand what you mean. I am not launching it from a form it's just a report based on the query.

Ok, how do I go about that? I have basic knowledge of VBA but nothing more than that. Thanks again for your help.

Thanks for your reply. What if I wanted them to enter for example 300 and only show the results including 300 exactly and not 3000 because wouldn't that show 3000 or 30000 etc?

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

How do I get the items out of the list box? What would you recommend I do to have another form as a message box? What happens is, the user runs a report that is based on a parameterised query. When they run this report, they have to input a parameter which obviously defines what the query...

Is there anyway I can assign each line of a text box to a variable and add it to a messagebox that way? I can't think of any other way to do it really that I am able to do. What other options do I have when dealing with the values in my listbox? Can I copy them to a multiline text box and use...

Hi, thanks for your reply. How do I go about putting line breaks in etc? I'm not too bothered about the columns lining up really. Also, just out of curiousity what are API's? Thanks again. Gareth.

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

Exactly, I feel like banging my head against the desk! :rolleyes: I don't know why the additem feature isn't available for me already, and neither is the .rowsourcetype or anything.

Hi, 1) I am trying to fill the listbox on the activation of the report, although it doesn't really matter when it gets filled to be honst as long as it is on the report. 2) I have tried setting the listbox rowsource in design view but it doesn't work because the report is based on a particular...