Search results

I do I going to open a new thread now.

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...

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...

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...

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...

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

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?

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)...

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...

Bingo thats it the second one worked for me. Thanks

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.

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.

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.

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?

Ok thank you that worked

I am trying to hide the first 6 digits in a textbox and only show the last for digits in a text box. So far I a putting my code in the Format Format section in Property Sheet of a form. Its not seeming to work. What am I doing wrong? Left([Card Number],Len([Card Number])-6)

Ok thank you. But I should probably be able to use a if statement that looks something like this right. if "Software" = [Lawson Prod] then docmd.open form, etc etc

I have a Multiple Value Combobox that I have linked to one of my forms and I am trying to write some vba code that will allow on update, "if a certain item is clicked open up a different form". Here is the Multiple Value Combobox Multiple value combobox3.JPG Here is the formFormaccess.JPG.

I have a Multiple Value Combobox that I have linked to one of my forms and I am trying to write some vba code that will allow on update, "if a certain item is clicked open up a different form". Here is the Multiple Value Combobox Here is the form.

It adds a new form along with the new record. So instead of form #330 and #331 being identical, I just need the statement to update form #330 and not make a new form (#331).