Recent content by whojstall11

  1. W

    Create a Temp Table

    I do I going to open a new thread now.
  2. W

    Create a Temp Table

    I need my users to be able to copy excel data into the Database. Then I need that data copied to generate a report that sends emails. Everything works but my database is set to have a query filter the data my user pasted in with data from a different table (it only shows data that matches both...
  3. W

    Create a Temp Table

    Ill take it back this where I should change the data, but how to I tell access to change it. I know it goes before this For intCounter = 0 To num_fields - 1 strCreateTable = strCreateTable & "[" & strFields(intCounter) & "] varchar(150)," statement but how. Public Function...
  4. W

    Create a Temp Table

    I have some code that creates a table based off another table. This code works perfect but Im trying to alter my ID field and change it to an auto increment. How can I fix my code so that it alters my ID field? Private Sub Command0_Click() 'OBJECTIVE: to build a table by extracting some...
  5. W

    automatically login in to orcale ODBC Connect

    Ok im using this code Private Sub Command0_Click() Dim dbsCurrent As Database Dim tdfLinked As TableDef ' Open a database to which a linked table can be ' appended. Set dbsCurrent = CurrentDb() 'OpenDatabase("DB1.mdb") ' Create a linked table that points to a...
  6. W

    Sending Email form report

    IT doesnt give the error number just the description. But I attached it to the last post.
  7. W

    Sending Email form report

    Yes I have this in my report. Could it be lngCount As Long, lngRSCount As Long I dont have these in my report. What should they refer to?
  8. W

    Sending Email form report

    I am trying to send an Email from a report . Using this code On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset Dim strBody As String, lngCount As Long, lngRSCount As Long DoCmd.RunCommand acCmdSaveRecord Set MyDB = DBEngine.Workspaces(0).Databases(0)...
  9. W

    Best Practice for Creating Data Entry

    I have a database that tracks Credit information. I trying to implement something that my users can paste in a large amount of data (Name, CardNumber, Amount) into a table (ImportFundedCardstbl) OR a form that triggers an email function anytime somebody adds new entries to the database. My...
  10. W

    Casacading Comboboxes Changes the Row Source

    Bingo thats it the second one worked for me. Thanks
  11. W

    Casacading Comboboxes Changes the Row Source

    I want to know is it possible to have a combobox change the row source of another combobox with vba code or some other way.
  12. W

    automatically login in to orcale ODBC Connect

    Does anybody know any code to Automatically login in to orcale ODBC Connect (Link Tables). Im trying to write some vba code that automatically enters in the user name and password when ever the orcale ODBC Connect box comes up.
  13. W

    Hide First 6 Digits in Textbox

    It worked I end up making another column on my table then in my form I had it take the last four from my new column. (that the short explantation) Thanks.
  14. W

    Hide First 6 Digits in Textbox

    Well I take it back is there a way I can still store all of the numbers in my table but only display the last for in form?
  15. W

    Hide First 6 Digits in Textbox

    Ok thank you that worked
See more
Top Bottom