How to convert data type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my form i have command button 'Update'.
the command button updates from link tables (SQL Server DB) to access tables
data.
When i do my updates i have to go to access tables and manualy change in one
column 'Names' data type from bit to text.
How can i hard coded in my command button 'Update' to convert this data
type???


Thank you for help.
 
Hi GGill,

Can you post the code for your command button "Update"? Usually, if you
convert the data type from number to text, you use the function "str". On
the other hand, if you convert from text to number, you would use "val".

Thanks.
 
The code in this button just opens and runs queries. That's all.
When it's finish it creates table for example;
tblClient where field name 'Names' is data type bit and need to manually
change to text. To automate, it can be done in module or in 'Update' button.
Could you give me specific info on this.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Automatically Send a notification email once a record is added 0
Consistent data updates 1
How to use multiple command button to copy user form data to multiple worksheet 0
Form with Subform not Refreshing 1
command buttons access 2007 2
VBA - retrieve data on last create named range from previous inserted named range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top