Search results

if all you're returning is a single value, why not just use the DLookup() function as the textbox value?

have your button also run a SQL Insert statement (DoCmd.RunSQL) that is composed of a string that is built using the values from the text boxes.

What you are describing could easily be perfomed by Access, however, as you mentioned, it does sound complex, especially if you are just a beginner. What you would need is an understanding of the concepts of Relational Databases - understanding primary keys and the different kinds of...

If you want to avoid VBA and you are using a report that is bound to a query, you could add a parameter query field to the SQL string of the query. eg. SELECT MyField1, MyField2,[Please enter your notes here:] AS notes FROM MyTable; Then, you can add the notes field from in the report design...

you haven't really described your problem. what is happening when you try select top 1 and what happens when you try DESC. what are the data sources of the subreports? are the subreports linked to the main report, or are they just embedded?

as far as exporting to pdf, you have a number of options how to do that. the easiest way, i think, is to install a pdf printer (ie PDF Creator or Adobe Acrobat) and set that as the default printer for the reports. Then, all you have to do is create a procedure which has 4 docmd.openreport...

the OnFormat event occurs when Access begins the formatting of that header - ie. when the report is being drawn up. You need to program the onFormat event prior to running the report, but the conditions will apply on the fly.

i don't fully understand your question, but each of the Header sections have OnFormat events that allow you to put in any kind of conditional formatting.

if you have a text box in the group named MyTextBox, you would create a text box in the group footer with =Sum(MyTextBox)

Anyone can :D - as long as you know how to either join the queries to make it one, or to use subreports to bind to the respective queries.

since you consider yourself 'numpty' when it comes to programming, i would offer you this option with less programming. I would presume you would create some kind of form that would allow you to create a command button on it that would say 'email reports'. The idea would be to put all your...

sorry, i wasn't being literal, the red text was just commenting what i was doing. The following is the easiest explanation, although you could go anywhere online to get much more in depth. iif(statement here must evaluate to true or false, value if true, value if false) with an IIf()...

in what format, and using what client, were you hoping to use to email the reports? Also, where do you keep a list of email addresses and supplier id's

the dynamics of an iif statement are that you need to provide logical statements, as many as you want, that ultimately result in a boolean (true/false) value. while what you wrote sounded logical in english, the computer can't understand what you mean since you are not passing full logical...

just use minute([MyTimeField]) to return the integer value of the minutes and use it in expression of the conditional formatting If Expression Is minute([MyTimeField])>10 ...

Solution is simple. Take a look at the first text box you have, you named it Borrower#1. This means, when you reference in the second txtBox Borrower#1, you are referencing the text box on your report, not the data field Borrower#1. You probably dragged the field onto the report and access...

the easiest way to explain without any programming would be to create separate queries for each of your desired filtering options, for example SELECT * FROM YourDataSource WHERE NOT [Complete] If you build a report on this data, you will only get not complete. Same with the other reports...

pm me i'll give you my email address i'm curious to see this too.

don't know if this is the best method, but it's always worked for me. Also, if you have a lot of controls in the page footer it can be a pain. Assuming you have a single text box in the page footer, use an iif statement to sayiif([page]<>[pages],"YOUR TEXT HERE",null) why would you want to add...

When a report is exported to excel, i'm pretty sure all access is doing is exporting the query/queries bound to the report/subreport to an excel spreadsheet. Just for the heck of it, try to export the query instead of the report and see if you get the same error. If you do, most likely there's a...