Search results

What makes you think that I cannot read and made the combos not bound? Update: actually, never mind - I really need to move forward so I use the textbox in front trick, so do not do anything.

Sprinkle some square brackets over those field references. Why recordsets? Cannot use the matching or missing records query wizards?

Yup. Please explain why you are moving records from one table to another, instead of just flagging the appropriate records, which would be a more usual procedure.

Look up MsgBox in the documentation. The second argument specifies what is shown on the popup dialog box, bitwise. So you can specify, e.g., vbInformation + vbYesNo etc, each component having some bit value and the total makes up 52 here. Try it.

What is "folder share"?

I've dissected CJ_London's Cascading Combos from here: http://www.access-programmers.co.uk/forums/showthread.php?t=275155 Been fiddling with it for ages, but have not been able to make it do a simple thing. I need a setup, where an unbound column (1) of Combo1 is shown, and restricts...

I have been making texts and mails and sending with Outlook for ages. But now I need to be able to prepare, in Access, customer mails with custom-chosen pictures (and their number) - and no, not signatures but visualisations of goods sold in a webshop. Anyone tried that? So far I've been...

So anyone have a trick?

You do - you've already got a Thanks thumb-up - anything else? :D

Aaaaaaaaaaaaaaaaaargh - could you hear the scream? A bloody error 40 again! Of course! EmbJobID=@EmpJobID should be EmpJobID=@EmpJobID"

Tried - replaced @ by P - no difference. The monster wants one more parameter! (I have @ all over in another db and it works fine there)

When I do the above then it wants 3 parameters!

Because I am trying to keep consistency throughout my db, because I like parametres in that they do not require messing around with date formats or ' or " in names, and now 'coz I'm utterly mystified by why it wants 6 I have another db where I use querydefs and parameters throughout for saved...

strSQL = "UPDATE tblEmployeeJobs SET EmpID=@EmpID, JobID=@JobID, JobStart=@JobStart, JobEnd=@JobEnd WHERE EmbJobID=@EmpJobID" Set qdf = CurrentDb.CreateQueryDef("", strSQL) With qdf .Parameters("@EmpID") = Me.txtEmpID...

Search my name and 64. The last or so post has a link to Microsoft listing of all API's changed for 64 bits

Double posted:http://www.access-programmers.co.uk/forums/showthread.php?t=281445

You have to choose: you display date in the format windows lets you, and then you can input a date in that fields also using the datepicker, OR you do what CJ_London advised, but then you cannot input a date easily. I would not recommend going against the standard date display: if that is the...

Yes it is. FYI: "Is it possible?" questions can get you a bitchy response like above.Simply because it is like asking "Is it possible to make a million"? When asking, ask for specific issues, and show what you've done so far and what you are stuck on. As to your students, you do not store an...

Take great care using the SQL function Last. That function does not always do what you'd expect, see the docs. Max and Min are much more reliable.

So you do not need to produce unnormalized data but can easily save each price in a separate record.