Friday 8 June 2018

Micorsoft Ms Access Syntax Error Vb.Net Ado.Net

Welcome Visitor,


You are here to find solution for the problem of Syntax Error coming in query while passing Insert, Update and Delete query to Ms Access database.



Access Syntax Error VB.Net

Above error come because some keywords like MODE other words which Access Database used as keywords used in your query without [ ] square brackets.

Wrong Query Style:
Example:
Insert into tblOrder (Mode) values('Monthly')


Right and It Should be like this:
Example
Insert into tblOrder ([Mode]) values('Monthly')


Microsoft Support Link :
https://support.office.com/en-us/article/add-records-to-a-table-by-using-an-append-query-98a5bd66-2190-4243-9638-8ef649cf3596


Happy coding.


Tuesday 13 February 2018

How to add birthdays without contact info?


You here to get answer of question "How to add birthdays without contact info?" .


Its compulsory to have contact info under google account without its not possible.


I having one utilities which create vCard(VCF) file from excel. 

STEP 1:
In excel sheet you have to just enter only contact name and birth-date and rest of information like mobile number , phone number and address etc... not required.

STEP 2:
After updation of xlsx file (excel) sheet attached to system. System will generate the vCard (vcf) file.

STEP 3:
Import the generated vCard (vcf) files to google contacts.

STEP 4:
Check your calendar you will find your relevant birthdays details.




You can contact me on email id: mr.manojbkalla@gmail.com

I provide HTML, CSS and Dot Net (.NET),  Asp.Net, PHP Training in Malad and western suburbs of Mumbai and on-line training.

Contact Detail:
Manoj Kalla 
Mobile    : 98691 66077

Email ID : mr.manojbkalla@gmail.com


Note: Excel (spreadsheet) is registered trade mark of Microsoft.





How to check whether my PC is 32 bit or 64 bit?



Confused or don't know about your PC  windows running bit version. Here you will come to know about to check bit of windows operating system.

Basically there are two types of bit nowadays.

1. 32 Bit
2. 64 Bit


In this post you know how to check bit of Windows 7 operating system step by step.


STEP 1:
Click on StartMenu of windows then right click on Computer option as shown in image:





STEP 2:
After right click your screen will display look like this:



STEP 3:
click on Properties option. After click you will see one window open that window look like this image given below:






In above image you can see blue box showing System Type value



My name is Manoj Kalla you visit my other blog:
http://dotnettutorinmumbai.blogspot.in/


I provide HTML, CSS and Dot Net (.NET),  Asp.Net, PHP Training in Malad and western suburbs of Mumbai and on-line training.

Contact Detail:
Manoj Kalla 
Mobile   : 98691 66077
Email ID: mr.manojbkalla@gmail.com