Search results

Good to hear it worked. I expect (and must say I don't nearly fully understand the behind the scenes stuff in Jet) it is to do with fragmenting the table and/or it's indexes when the fields get added because it has to insert pages a hundred thousand times up the table. Even if it doesn't crash...

You're welcome, glad it did the trick

I find it hard to believe a VBA function would work quicker. And hours and hours is surprising even on a huge table. Are all those fields indexed? And is the underlying query order by those fields? It might give it a helping hand to base it on a subquery that is. I'm not sure whether it would...

Cool. You're welcome. Font is a property of a cell like Value is Bold is a boolean property of that Font property. The code sets the value of the cells in the new rows with Me.Cells(iRow, i).Value = sCell(i) Setting the value of the same cell's Font's Bold property to True: Me.Cells(iRow...

Sorry forgot to set fonts to bold. See if you can work out how. It would be another line within the innermost loop. If you can't say so and I'll show you.

This should do it: Option Explicit Private Const ROW_FIRST As Integer = 1 Private Const ROW_LAST As Integer = 100 Private Sub DoStuff() Dim iRow As Integer, iRowsAdded As Integer, iSemicolons As Integer, i As Integer, j As Integer Dim sCell(1 To 7) As String iRow = ROW_FIRST...

When you say "file" you mean an excel spreadsheet?

At a glance it looks like a wizard would be best - a series of forms asking a series of questions. I'm not a huge fan of wizards. Generally, I'd rather be asked all questions at once so I can see how they relate to each other (see what questions are coming up - it's annoying to have to press...

:D good one

You can still include the three fields in the Mate Table Query without assigning values to them - to leave that to the VBA. Just try to get rid of the changing the design of the table in VBA, which is the thing that would cause it to crash I'm sure. Doing all the updates in VBA is sure to be...

And here is that demo. Note the Names subform shows the Dates field so it can be entered and if it is filtered (by opening via the Dates form) then it will set the default value of that field to the Date selected on the Dates form as well as filtering the records for that date. Note the code...

Ok first I'me uploading the database to do what it was trying to do: open the Names form filtered to a date selected on the dates form. Notice I've removed the Dates table, undound the Dates form, renamed the Date textbox to Dates, set Command3 OnClick to Event Procedure and changed that...

I can't say I'm surprised that this crashes on a table with 650,000 records. One question: why not have those three fields permanently in place (put there as part of the make table query)? Why have to modify the design at runtime if it's always going to be doing the same thing? Then it would be...

It doesn't happen on a little test db I've made trying to replicate it. It scrolls right and down to show the active control on a tab page behind others and off screen at the start. I can't think of any setting that would change that. Maybe it's just too complicated for Access to deal with...

Yes it surely is possible but we'd need to know the relevant tables, fields and forms to say exactly how. I wonder about "select a date on a form that is connected to a table that just records the date". The table records the date? Any particular date? The form is bound to the table? Is the...

If Load Date stores the date and time then it will only show those added at midnight precisely. Try: DCount("[Device]", "StarReportTbl", "Int([Load Date])" = CLng(Date)) Converts the dates to integers, which strips out anything less than a day (the fractions) and so compares whole days

For a query with parameters, to ask the user for the parameters, I don't think CurrentDb.Execute will work. I think it has to be DoCmd.OpenQuery. I would certainly advise being a bit careful about turning off warnings but it's not a bad thing to do so long as you turn them straight back on...

Well you can only show one subdatasheet in a datasheet. You need to choose which you want, Events or Organisations. In table design, properties window there is Subdatasheet Name property where you can specify which you want for a table. But anyway, the way to display these two sets of records...

Just use DoCmd.SetWarnings False DoCmd.OpenQuery "qry6mrfFlag" DoCmd.SetWarnings True Does what you were thinking of I expect.

It's only a little bunch. We're all just monkeys with technology so just pretend they're bananas.