Search results

That makes me wonder too. It looks like a lot of queries with different parameters in each or something and that can usually be whittled down considerably. Hazell - I would let pbaldy and spikepl help you with that. You probably don't need all of those.

Not really a sister forum, but Google Mr. Excel forums and that is a good one.

Does that table have, as its primary key, a field that is not INT but is BIGINT? Access doesn't like BigInt.

You have to instantiate a recordset object for it like this: Sub Keuzelijst_met_invoervak153_AfterUpdate() Dim rst As DAO.Recordset ' De record zoeken die overeenkomt met het besturingselement Set rst = Me.RecordsetClone rst.FindFirst "[NAAM] = " & Me![Keuzelijst met...

You can also set the top and left properties of the form Me.Top = 3244 Me.Left = 1200

I usually find that error means that the field in question has a null value somewhere.

A minor point (and not affecting this directly) but I would replace this: WHERE NOT TEMPTABLE.D7I_NEW IS NULL with this WHERE TEMPTABLE.D7I_NEW IS NOT NULL

In your report just use the Grouping and Sorting to set the sort (unless you need it dynamic). Reports do not use the sorting form queries. You have to set it explicitly in the Grouping and Sorting.

Re: Got pop-up error "Invalid Argument" when using UPDATE query in MS Access 2010 It isn't complicated. From the Ribbon Click DATABASE TOOLS tab Click Visual Basic The VBA Window will open Click DEBUG on the top menu Click COMPILE from that menu I would NOT do an reinstall like JHB...

And make sure that the combo box is UNBOUND.

A memo field can handle 65,354 characters in a text box by means of the usual bound controls. If you need more than that, you can do it if you use VBA.

Do you mean as in DATA that changed?

What I would do is store both fields as Rich Text even though you aren't using it so that the appropriate markups occur and you don't go through this hassle.

If you want to add to the memo field (to the existing contents) you would put this in the After Update event of the combo box: Me!MemoFieldName = Me!MemoFieldName & vbCrLf & Me.ComboBoxName Make sure the combo box's bound column is the right one so that the text and not the ID shows up. If...

A new Excel Application instance is, by default, hidden. You have to make it visible for it to be visible. So, if setting its visible property to false hides it then there is some code somewhere that made it visible to begin with. Hence what pbaldy and I wrote.

Re: Got pop-up error "Invalid Argument" when using UPDATE query in MS Access 2010 It may not be that query that is causing the problem. It may be something else. Go to the VB Window and to DEBUG > COMPILE and see if any errors show up. If so, fix and do it again until there are none...

See if this helps: CurrentDb.Execute "INSERT INTO ship1(Pilot, Skill, Ability, Ship) Values(" & Chr(34) & Pilot.Value & Chr(34) & "," & Chr(34) & PilotSkill.Value & Chr(34) & ", " & Chr(34) & Ability.Value & Chr(34) & ", " & Chr(34) & Ship.Value & Chr(34) & ")"

That would be my first thought too.

Are these graphs based on queries and not temp tables? If so, you might find that it is going to work better to generate the data into temp tables and then use those for the graphs.

You need to first open Access, not the database. Next, click FILE > OPEN Navigate to the database you want to open and click it but don't click so it will open. Use the method in my next instruction. Then when you go to open the file click the drop down here: Then you should be...