Search results

I was deliberately trying to avoid this bit :D If I told you something detailed and said you could go and write it down immediately, you would still probably get at least parts of it incorrect. If, on the other hand, I said you had to pass it verbally from person to person, for a prolonged...

No, you didn't. Kindly get your act together.:D So, to continue the analogy, how about if I do have a book and know that my dragon book was written by real people - as opposed to surreal ones? - and that they swear blind they were writing the truth? :D I have a bit of difficulty with the...

Glad to help.

Glad to help.

I think it's because you don't need the double-quotes if you don't have a filter. As long as thr right number of commas are present, a space is fine e.g. DoCmd.OpenForm pvcAirCmp1LoadCus, acFormPivotTable, , "[qryAirComprs]![fldDATE] Between [Forms]![frmHome]![AirCmpStartDate] And...

Sounds promising. What size paper does it accept (could I print 4 x 6 or 5 x 7 photos)?

Private Sub Option183_Click() DoCmd.OpenReport "Rpt_Charges03", acPreview, "", "" DoCmd.Maximize [Forms]![formname]![Option183] = False End Sub Should reset it to be clear, after opening the report.

I'm still setting up, so I was hoping to stay this side of $400 CAN.

Sorry, when I said 'working' I meant 'working for that form'. The following will set the filter and ensure that filtering is allowed, but if there is something resetting either value after this, you'll still have problems. [Forms]![form name].Form.Filter = "filter" [Forms]![form...

To transfer data you need an append, rather than an update, query. e.g. INSERT INTO Available_Reports ( Listed_Name ) SELECT AllReports.Listed_Name FROM AllReports WHERE (((AllReports.Listed_Name)=[Enter Name:])); This query just appends the values from one field of one table to one field of...

When the form opens and the filter isn't working, does the filter property look like it's set to the correct value? If so, perhaps it is being set too late? You could add a message box to the form's OnOpen event and check what it's being set to at that point.

I've just set up a business and need to buy a printer. The majority of the time, it'll be used for invoices and straightforward document printing. Occasionally, however, I'd like to be able to print colour documents or even decent quality photographs using it. All of the printers I've looked at...

Is the form's 'Allow Filters' property being reset when the form closes and reopens? Something similar happened to me and that was the cause of it.

Try DoCmd.OpenForm "pvcAirCmp1LoadCus", acFormPivotTable, "", "[qryAirComprs]![fldDATE] Between [Forms]![frmHome]![AirCmpStartDate] And [Forms]![frmHome]![AirCmpEndDate]", acNormal

In the field's OnLoseFocus or AfterUpdate event, or in the form's BeforeUpdate event, you could use the DCount() function to see if there is at least one record present. e.g. something like If DCount("JobNumber","JobTable","JobNumber = " & [Forms]![formname]![Job_No]) Then Msgbox "That Job...

One of the definitions of faith is "Belief that does not rest on logical proof or material evidence". That statement, in itself, says to me that it is possible to have faith without needing proof. Faith is a belief that stands upon the strength of its own conviction. After all, not intending to...

Yes. But as we find out new things about the universe and it's contents, different theories emerge and are considered. A religion is bound to faith-based explanation for certain things, regardless of whether or not logic dictates otherwise. Look at the whole 'Sun revolves around the Earth'...

I think so. Thanks for that. But faith is able to exist entirely without the presence of logic, isn't it? Logic suggests proof and if something need be proven before someone can have faith in it, where is the trust? While faith isn't based on a lack of logic, I do think that the two can...

So - and again forgive my ignorance - is there a 'line' in the Bible after which things are treated more as serious guidelines? Does this also mean that any 'instructions' (for want of a better word) from the Old Testament can be ignored? I'm not a believer myself, but I do find this kind of...

AA is also, unless I'm mistaken, by far the biggest alcohol dependency help group in the world. More members joining means word of mouth encourages yet more to join. If people expect someting to be a success, it very often is. Incidentally, if one of the steps involved wearing ski goggles, I...