Search results

use Stephen Lebans RowNum() function. you do not need to save the value to a table.

i've never use a gantt chart, so my sample simple gantt chart might not have the function you are looking. but this is an entry level, no sub-category, just straight single tasks. it took me some hard thinking on this one.

how about support, is he willing to train and give support for Free? :unsure: i've seen his demo, but it is ridiculus to work with, specially the mouse.

did you get his Gantt Chart for free?

NO, i don't need to buy anything from anyone.

yeah right, like in .accde or in .mde?

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