Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Norminator

    Code to format a table property in vb

    thanx very much remou it worked u surely know ur stuff! It was the first time i've encountered this problem so i had a hard time solving it. There is always room to learn more when programming. Nuff Respect!
  2. Norminator

    Code to format a table property in vb

    I tried it ok but it returned a error saying property not found. Here is the code: Const cDatabaseToOpen = "C:\Inetpub\wwwroot\CallAccounting\Database\CallAccounting.mdb" Dim oCA_Conn,oRecordset, sSQL, sCA_ConnStng Set oCA_Conn=CreateObject("ADODB.Connection") Set...
  3. Norminator

    Code to format a table property in vb

    oh ok not familiar with vb scripts still
  4. Norminator

    Code to format a table property in vb

    ahmm can u tell me the datatypes for each of the variables please: AcApp, db, tdf, fld where are the declarations?
  5. Norminator

    Code to format a table property in vb

    thanx for the reply i'll c if it works
  6. Norminator

    Code to format a table property in vb

    what do you mean by that? sorry for all the questions, but this is just for an update to an already built software which has been distributed to customers, so we need them to run this patch to update their database with the new table. So i need this patch to create the table and apply all the...
  7. Norminator

    Code to format a table property in vb

    hey thanx remou but cant you format the table while creating it?
  8. Norminator

    Code to format a table property in vb

    well i used a query as u saw in my code but how do i access the format properties through sql?
  9. Norminator

    Code to format a table property in vb

    is there a vb.net code?
  10. Norminator

    Code to format a table property in vb

    thanx remou but what is the variable CurrentDB? I've seen this code elsewhere in other examples! I'm using vb.net would it be correct if I do that?
  11. Norminator

    Code to format a table property in vb

    DAO what do you mean
  12. Norminator

    Code to format a table property in vb

    thanx for all the replies though, i've been searching on google and still havent found a solution! Appreciate any help!
  13. Norminator

    Code to format a table property in vb

    thanx for all the replies though, i've been searching on google and still havent found a solution! Appreciate any help!
  14. Norminator

    Code to format a table property in vb

    Its giving me an error whenever i use it and plus it doesnt shows how to use the key word Format in the field properties.
  15. Norminator

    Code to format a table property in vb

    well i'm writing a patch to update a database, which is already running with a different software that uses a table similar to the one i'm creating that must have these specific field properties as the software communicates with it this way. So are there any answers?
  16. Norminator

    Code to format a table property in vb

    thanx but I dont think that helps. Let me explain a bit more, I'm using ACCESS Database. When u create a table in design view and you look down the bottom and see FIELD PROPERTIES with the GENERAL and LOOKUP TABS and in the listing for GENERAL you have Format, Input Mask, Caption .... etc I...
  17. Norminator

    Code to format a table property in vb

    I need to know how to format each column (for example the date/time column i need to change it to Short Time) please offer any help. Code is below: Try Const strConnection As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source= C:\Inetpub\wwwroot\CallAccounting\Database\******. mdb" Dim...

Part and Inventory Search

Back
Top