Search results

Hi All, I am exporting data from a query to an excel file using the following code from the Knowledge Base: http://support.microsoft.com/kb/904953 I have the code set up as follows: Public Sub WorkArounds() On Error GoTo Leave Dim strSQL, SQL As String Dim Db As ADODB.Connection...

I have a query which does some calculations. It is limited to 1 decimal place, and this works fine. However, when it returns a recurring number, it is not limited to 1 decimal place. E.G. 7.78156765 rounds up to 7.8 7.33333333 displays as 7.333333334 Is this a bug or is there something else...

Brilliant Thank you!

My bad - needed quotes! However, it now prints the report, rather than opens it! I never expected this to be so awkward.

ahh ok, i see where I was going wrong now. I get an error as follows now: action or method requires argument report name it picks up this line on the debugger: DoCmd.OpenReport (rptRemainingRubberSummary) I have verified that this is the correct report name and can't see the problem

So, from what I understand the of the structure, if I changed the Else to and ElseIf that would work. However, I get the same error. Im probably missing something obvious, but I never ever write VBA so i'm a newbie to it.

Hi i am new to using VBA, so please excuse my ignorance. I am trying to use the following code to select a full or summary report: Private Sub Command25_Click() If Me.Check20 = False Then DoCmd.OpenReport (rptRemainingRubber) Else: If Me.Check20 = True Then DoCmd.OpenReport...

aha! sorted. thanks for your help!

Have now changed the SQL as you advised so that it now looks like the following: SELECT qryEfficiencyUnbound.[Vehicle Reg], qryEfficiencyUnbound.Tyre, qryEfficiencyUnbound.Pattern, qryEfficiencyUnbound.OTD, qryEfficiencyUnbound.RTD, qryEfficiencyUnbound.Cost, qryEfficiencyUnbound.[Price Per...

I have a report which calculates the value of the tyre rubber remaining on a vehicle. The report is based on the following query: SELECT qryEfficiencyUnbound.[Vehicle Reg], qryEfficiencyUnbound.Tyre, qryEfficiencyUnbound.Pattern, qryEfficiencyUnbound.OTD, qryEfficiencyUnbound.RTD...

Is there a good example anywhere that you would recommend? & if not, is there another way around this for someone who has never written VBA Thanks

Hi everyone, I have set up a email contacts database for creating email lists. It contains both fleet and tyre dealer customers. I have created a form which (will) allow users to customise the query to give them the appropriate list of contacts. The form has a series of dropdown and tick boxes...

Ok i've just reviewed my sample DB and the query works. But it still does not work in the other database! The only difference is that I have made the sample a .mdb file instead of .accdb would this really make a difference?

No there are no summaries in there (unless i'm missing something). I have attached a sample db with the query in it because hopefully it will show what I cant describe so well.

Thanks for your replies. To answer your question: a) [inspectiondate] is in the query. The query contains every field in the table. It would be easier to give customers a datasheet view. But, it is the layout of the data that is important - it has to be laid out in a vehicle schematic style...

No ideas anyone? Many Thanks

I have a report based on a simple select query (Access 2007). When I run the query, everything is fine and I get the results I expect. However, when I run the report I get the error "you tried to execute a query which does not include the specified expression [tblinspection].[inspectiondate]...

Thanks again for your reply Like I said, I never built this particular DB, but I do use it from time to time to compare work actioned to invoices etc. I was thrown by the missing relationships at table level. Still, i'll make the changes to it and get everyone updated.... (:mad:) many thanks...

Please find attached the 2 tables and the form which lies over the top of the inspections table I really appreciate your help!

Thats what I don't understand though. I have checked the data types in both tables, and they match. If I am using the table from which the original value derived, as a lookup, then their should be no type mismatch. Which poses the question, why does the table which the query selects from...