Search results

Finally! Now accepts numeric. Thank you, DBL!

Numeric, that's what cause problem.

Worked, thank you Tim!

still no change...

still the same.

Didn't work, still says runtime error 3464: data type mismatch.

How to make the following accept numeric value? Private Sub Kood_BeforeUpdate(Cancel As Integer) If DCount("[Kood]", "asukohad", "[Kood]= '" & Me![Kood] & "'") = 1 Then MsgBox "Already here." Me.Undo Cancel = True End If End Sub

How to format data depending on value's lenght. Example, format a 8-characters value 12345678 to (123) 45 678.

Hmm, I'll give a try. If something will go different then I will let know.

Thank you pcs, I should become it myself:]

How can I make Access XP show quotation? Example. Report output should be Title "title" and I used in control source ="title "" & [title] & """. Access, of course, is confused. There must be a way to present quotation.

How can I retrieve customized contents text output file when to click button? @ the moment I use DoCmd.OutputTo acOutputQuery, "myQuery", acFormatTXT, "96.txt", True

Actually I have a text file containing minutes and seconds only. In conversion Access will report errors, of course (because of mine has totalminutes:seconds only).

How to make Access XP understand minutes and seconds only? Like 110:06, not 1:50:06?

And how do I do that, 'You can choose the option to enforce referential integrity'?

I'm trying to modify pk itself and all related data. One to many.

Why so? The only way to modify is only through tables?

I can edit all data when I select or type a value from primary key combo box. But how can I edit primary key value itself so it will apply all related data? I have a form with a subform. I tried to duplicate a record but of course duplicate value errors appeared. I think an additional text field...

But which units these are?

Now it works! Believe I had Data Entry set to Yes. so it didn't work. Thank you, Graham!