Search results

Because A comes before D, and D comes before J etc.

I'll see what I can come up with, but do you want the month in that order?

Yes it does, exactly as the example provided by you! :D I change it now only to show data from the current year. Database attached. So far I know I didn't build a table, could you please tell me the name of it and where you see it? I use the table "Sales Data" and pick the data from that table...

Is the below what you want?

I've Windows 8, MS-Access 2010, using Thunderbird for E-mail. By me, the E-Mail button is enabled.

The problem I/(we) have at the moment is to find out what data you want to output, what field(s) is/are involved and what criteria the are. The way you showed it in post #8, was perfect, if you could do the same for the other then .... :)

Thanks for the raw data, but I still need to see how you want the graph.

Try the below, (it is not tested). SELECT Records.SpotNumber, Count(qGetDatesForAvg.OnTime) AS CountOfOnTime FROM Records INNER JOIN qGetDatesForAvg ON Records.SpotNumber = qGetDatesForAvg.SpotNumber WHERE qGetDatesForAvg.OnTime = 1 GROUP BY Records.SpotNumber;

Could you show some raw data and how you want the graph, (in Excel or a printscreen)?

How much did you increase it? Precision = is for all digits in a number. Scale = max number of digits to the right of the decimal separator.

Have you tried to copy MyFileName.2.mdb today?

In the database you've attached, you haven't change the code to what I posted, why not? Then you've change the table in the recordset, why? I've put in my code and change the table in the recordset to what you posted first. But I do not get the below error, I get another that says it is the...

Could you please explain how to fill the List41 with data.

Try the below: Me.EntryList.RowSource = "SELECT tblEntries.EntryNo, tblEntryTypes.EntryType, tblEntryTypes.Bank, tblEntryTypes.Cash, tblEntryTypes.Customer, tblEntryTypes.Supplier, tblEntryTypes.Employee, tblEntryTypes.Owners " _ & "FROM tblEntryTypes INNER JOIN tblEntries ON...

Have you linked them together with the "Link Master Fields" and the "Link Child Fields" property?

The problem you are facing is because the correct name is "Me![RECORD NUMBER]" and not "[RECORD_NUMBER]". So try the below: DoCmd.OpenForm "EDIT_RECORD" , , , "[RECORD NUMBER] = " & Me.[RECORD NUMBER]

Replace what you've with the below: If Me.CurrentRecord = 1 Then If iTotal = 1 And iLine = 0 Then iLine = 0 Me!LastName.ForeColor = vbBlack Me!FirstName.ForeColor = vbBlack Me!Position.ForeColor = vbBlack Me!Building.ForeColor = vbBlack...

I would rename the tables to names that isn't the same as the linked Excel sheets.

Could you post your database with some sample data, (zip it) + description how to reproduce the error!

But even if it exist are you sure you're adding that value?