Bart van Beek (Developer)

Whether you just want to browse huge image gallery or want to share your personal photos with others, this is the site for you!

Browse through the categories of huge gallery containing over 350.000 quality stock photos by more than 30.000 photographers! Need a wallpaper for your desktop or illustration for your blog? Need a pic for your commercial website design? Looking for inspiration? Have a look around.

Have you ever started a lengthy NAV batch job, and then wondered how much longer it is really going to take? NAV forms usually have progress bars. Good. But how about something like this:

Read the rest of this entry »

Cobetec Veenendaal/Rotterdam BV is een middelgrote dienstverlenende onderneming die zich sinds 1997 bezig houdt met detachering van elektromonteurs.
Cobetec heeft 30 elektromonteurs welke allen in vaste dienst zijn.

With over 10 years of experience, Experts Exchange has been an online IT resource that connects members to Experts around the world providing solutions to their technology issues. Experts Exchange has acquired a knowledgebase of over 2 million proven IT solutions in more than 950 unique technical zones and currently has over 10,500 Experts assisting in these various zone.

Experts Exchange offers several types of membership plans: monthly, six month, one year, two year, corporate, limited and free accounts to qualified experts.

Automatisering moet bedrijven helpen om hun mensen en concurrentievoordelen optimaal tot hun recht te laten komen. En om mee te groeien met hun klanten en markt. Qurius helpt om dit te verwezenlijken. Daartoe maken we gebruik van Microsoft-software en- technologie.
Read the rest of this entry »

Qurius provides architecture, realisation and systems management of Microsoft technology based business and IT solutions, including infrastructures. Qurius has over 1,000 staff members and our headquarters are located in The Netherlands. Qurius has been publicly listed on Euronext Amsterdam since 1998.
Read the rest of this entry »

Since 1995 - The Microsoft Dynamics Online User Community

The first recommended site is MiBuSo.com

It’s not strange because this is THE site for Microsoft Business Solutions

A Toolbar to start External Programs from Navision with parameters.

What you can do:

- You can define your own programs to start with parameters, for example:
+ Internet Explorer
+ Windows Explorer
+ Notepad
+ Calculator
+ Microsoft Outlook
+ Microsoft Word
+ Microsoft Excel
Read the rest of this entry »

Do you want to SAVE TIME to Open Databases with different NAV Clients?
: Read the rest of this entry »

The New Functions: Filter the Object Designer (OD) AND Code Coverage (CC) to a file.

How to:
- Select the rows in the OD or CC.
- Copy these rows to Clipboard.
- Choose your Filter action in traymenu or in mainmenu.
- Please wait for the result.

Other older functions:

- Filter *.fob files
- Filter *.txt files
- Count number of objects in *.fob and *.txt files.
- Count modified objects in *.txt file.

Extra’s:

You can edit the output file structure.
You can log your filter history.

Create filter from a FOB or TXT in Navision.

How to:

1 - Import the ‘Navision Object Filter.fob’. (range = 50000..50001)
2 - Run Form 50000
3 - Click Functions
4 - Click Import File
5 - Fill source file to filter
6 - Choose if you want to filter
7 - If you want to filter select Destination

On Form 50000 you can also create filters…

View Dynamics NAV Table Info and Field Info in one form.

And you can learn how to use Table Reference and Field Reference.

Nice to have…

(Click to enlarge)

Generate Tables in one Form. You must try…

Table options:
- Table No.
- Table Name
- Table Version
- Lookup Form ID
- Data per Company

Field options:
- No.
- Name
- Caption
- Field Type
- Field Length
- Decimal Places
- Option string
- Editable
- Blank Zero
- Not Blank
- Closing Dates
- Auto Increment
- Numeric
- Min Value
- Max Value
- Field Class
- Primary Key (You must select this field if you want that this field is a part of the primary key)
- Secundary Key (You must select this field if you want that this field is a part of the secundary key)

You can add 10 secundary key’s.

Simple tool to create a shortcut.

Converts any decimal to text. (See screenshot)

Supported Languages:
- Dutch
- English

Show Object Designer Info in one form: No. of Objects, Modified Objects and Not Compiled Objects.

Handy for a development area.

Updated:

You can filter on Object Fields:

- ID
- Name
- Version
- Date
- Time

A handy tool for all mibuso visitors! Just try it out!

Do not wasting time to search in a object text file, use the Quick Search!

Find your text in 5 steps:

1 - Start the Quick Search
2 - Select the Object Text File.
3 - Give your Search string.
4 - Click on the Search Button.
5 - Open the output file in Excel

Note: The search is case sensitive.

Each company (I hope) creates every day or week a backup of the database.
Because when the database crashes, there is a backup.

O no, I forgot my SUPER user password!

No problem, restore your backup and after restore do not close the database because you are in the database.
Yes, without username and without a password!

Thanks Bill!

When getting the following error (for example):

(Click on image to enlarge)

This problem arises as result of a not registered dll of the Automation. But which dll?

Follow next steps to found and register the Automation dll:

1. Open the Object Designer
2. Create a new Tabular-Type Form with Table: Automation
3. Add all fields on the form
4. Press preview
5. Filter on the GUID collumn with the value in the error message
   (this example: {9A2E02D5-9163-46AA-8D07-EE72842AC205}
6. In the collumn TypeLibFile you see a dll
7. Register this dll (You can download the Dll Register)

After the dll registration the problem has gone!

Usefull navision tips!

Another blogger:

Waldo’s blog, nice nice nice blog…

Nice blog to enjoy yourself…

A blog about Performance and SQL:

An nice page with interesting links:

Define the following variabels

• RecRef as RecordRef
• FldRef as FieldRef
• RecReftmp as RecordRef
• FldReftmp as FieldRef
• KeyRef as KeyRef
• KeyFldRef as FieldRef
• i as Integer
• x as Integer
• BestKeyIndex as Integer

Define the following function: GetBestKey()

RecRef.OPEN(27,FALSE,'Company Name');   //Open table 27 - Item
FldRef := RecRef.FIELD(3);              //Get field 3 - Description
GetBestKey();                           //Get the best key to decrease performance issues
IF BestKeyIndex > 0 THEN
  RecRef.CURRENTKEYINDEX(BestKeyIndex); //Set the best key if exists
FldRef.SETFILTER('*@as*');              //Filter on description
IF RecRef.FIND('-') THEN BEGIN
  REPEAT
    RecReftmp.OPEN(27,TRUE);            //\
    FldReftmp := RecReftmp.FIELD(3);    // \
    RecReftmp.INIT;                     //  Empty description
    FldRef.VALUE := FldReftmp.VALUE;    // /
    RecRef.MODIFY;                      ///
  UNTIL RecRef.NEXT = 0;
END;
//Function GetBestKey() code
FOR i := 1 TO RecRef.KEYCOUNT DO BEGIN
  KeyRfr := RecRef.KEYINDEX(i);
  FOR x := 1 TO KeyRfr.FIELDCOUNT DO BEGIN
    KeyFldRef := KeyRfr.FIELDINDEX(x);
    IF FldRef.NUMBER = KeyFldRef.NUMBER THEN BEGIN
      BestKeyIndex := i;
      EXIT;
    END;
  END;
END;

You can use this code in de OnPostDataItem trigger function.

It’s usefull for Correction Report / Dataports.

Object.SETRANGE(Type,Object.Type::Report);
Object.SETFILTER(ID,DELSTR(CurrReport/CurrDataport.OBJECTID(FALSE),1,7));
IF Object.FIND('-') THEN
  Object.DELETE;

Sometimes you want to have a lookup on a dataport or report option tab.
Here my solution to program the lookup:

CLEAR(FORM);
FORM.SETTABLEVIEW(RECORD);
FORM.LOOKUPMODE(TRUE);
IF FORM.RUNMODAL = ACTION::LookupOK THEN BEGIN
  FORM.GETRECORD(RECORD);
  Rec.FIELD := RECORD.FIELD
  MODIFY;
END;

An easy tool to register a dll file.
(you can register dll’s in batch process)

(using regsvr32 command)

If you’ve got a problem in a time consuming process and the debugger is not usefull enough.
You can use this code to write each value to a text file, wherever you want:

Define gFillTemp as File 

gFillTemp.TEXTMODE(TRUE);
gFillTemp.WRITEMODE(TRUE);
IF NOT gFillTemp.OPEN('filename.txt') THEN
  gFillTemp.CREATE('C:\filename.txt');
gFillTemp.SEEK(gFillTemp.LEN);
gFillTemp.WRITE('text to write');  //Write text
gFillTemp.WRITE(gRecitem);         //Write record
gFillTemp.CLOSE;

Start any program from navision:

For example:

SHELL('access.cpl')

[code] = run Accessibility Controls

Accessibility Wizard - accwiz
Add Hardware Wizard - hdwwiz.cpl
Add/Remove Programs - appwiz.cpl
Administrative Tools - control admintools
Automatic Updates - wuaucpl.cpl
Bluetooth Transfer Wizard - fsquirt
Calculator - calc
Read the rest of this entry »

hotcopy
source=C:\test.fdb
destination=C:\backup
description=”Text”
email=test@test.com
servername=ServerName
username=User password=Password | osauthentication=yes
dbtest=normal
cc=yes
nttype=tcp

Define these Globale:

• gDlgWindow as Dialog
• gIntNoOfRecords as Integer
• gIntRowCounter as Integer
• gTimNextUpdate asTime

            Define these Text Constants:

• Text001 with text: Processing records:\
• Text002 with text: Number: ##########1#\
• Text003 with text: @@@@@@@@@@@@2@\

gDlgWindow.OPEN(Text001 + Text002 + Text003);
gIntNoOfRecords :=  Rec.COUNT;
gIntRowCounter +=1;
IF TIME > gTimNextUpdate THEN BEGIN
  gDlgWindow.UPDATE(1,Rec.Field);
  gDlgWindow.UPDATE(2,ROUND(gIntRowCounter / gIntNoOfRecords * 10000,1));
  gTimNextUpdate := TIME + 200
END;
gDlgWindow.CLOSE