Search results

i think he wanted to create, not to Buy..

revisited and added some "priority" coloring and at a glance you can know how may appointment on a particular day (number of appointments in parenthesis beside day number).

i tested the finnish sort order on a test db with some records with extended chars and it sorted right, same as in english sort order.

it's not about the backslash, it's about the code actually. it is different from what code you posted.

you can create an Update query to remove those "space" thing (be sure to make a copy of your table first, for backup). Update YourTableName Set [SecondFieldName] = RemoveNonPrintable([SecondFieldName]) Where Not ([SecondFieldName] Is Null); on a module: Function RemoveNonPrintable$(ByVal...

did you try the "code", because it is different from what you have.

what do you mean by ANSI codes?

not sure if there are "non-printable" characters on your field. sometimes these hidden chars are the culprit. they can get there by copy/pasting from other source apps.

on which field(s) did you sort?

if you want your Form to be Always on New Record, you set it to Yes.

or you can create a "button" on your form (btnCopyID) and on the click event of the form it willl copy the "formatted" id: Private sub YourBtn_Click() Dim sID As String If IsNumeric(Me.ID) Then sID =Format$(Me.[ID], "PUR00000") 'copy sID to clipboard Clipboard sID End If End Sub '...

the "Format" is for "display" purpose only, what is stored is Numeric (your field is Numeric). if you need to make copy of the "formatted" textbox. create another textbox (dummy textbox) and assign =Format$([ID], "PUR00000") as the Control Source.

your Main Form's Data Entry property is Set to Yes. set it to No. Property->Data->Data Entry No

you can also use the Status bar of Ms Access to show the progress: syscmd acSysCmdSetStatus,"40% completed" when done, just clear the Status bar: syscmd acSysCmdClearStatus

i believe strOutFile is the externa db name, 'make sure to add backspace to OutPath strOutPath = Replace$(strOutPath & "\", "\\", "\") strSQL = "Insert Into [" & strOutTableName & "] In '" & strOutPath & strOutFile & "' " & _ "Select X.* from [" & strSource & "] As X;"

it's not a problem alright. it tells that the return of the function is a string. that is the old vb declaration and still works.

it will not affect previous saved records. btw, just tested on ms access BE, and did work.

the startup form has an arabic control name (the detail section of the form). so you need to rename it to english. you create new db and copy all objects from the original db.

use: =Now() as the Default value and don't use any Format on it. on design view of Form, Forms!Form0_AddEditJob, click on TBOX_DateInitial textbox and on Property->Format, use: dd-mm-yyyy ms access save date in US date format. the Format property of TBox_DAteInitial is for viewing purpose...

if somehow the reference to the Object is lost, can you "force" re-create the object again: Public Function RegKeyRead$(ByVal RegKey$) ' Reads registry key RegKey, if key doesn't exist, return value is "" On Error Resume Next ' re-create the gbl_SH again before ' calling any of its Method ' '...