Recent content by Noway

Here is my SQL in my Module...I need it to go from one table to another table, and fill in the spaces that are open.. Public Function SQL_Input_Parts() Dim strSQL As String Dim Special As String DoCmd.SetWarnings False Special = """ / Name """ strSQL = "INSERT INTO Input_Parts ( Item_Name1...

What I thinks happens is that this set ups the excel sheet. This is what I have: Public Function RunExcel() Dim oExcel As Object Dim afe As Excel.Application Dim Filename As String Filename = Forms!Startup!txtAddFile.Value Set oExcel = CreateObject("Excel.Application") oExcel.Workbooks.Open...

Thank you!

So I know the problem I think..when it renames the colums it is deleteing all the information in those colums. Why is it deleteing all the data? I know you said the Selection.Delete Shift:=xlToLeft Should this only delete the first colum?

Yes, there are some Macros. The guy did not leave anything.

Why would I even need this? Why would I want the DB to even touch the excel sheet? I really just want it to fill in the slots on the table, and nothing else? Could I delete this Module?

Hello, I am working with Access 2010. I have a big Access Database that I got when I took the place of someone else. The database has never really worked correctly as I am told. I would like to see if this is a common problem which it is weird that the DB does this crazy stuff. I have a form...

Hello Everyone, I have a job where I deal with Access 2010. I have no idea what I am doing sometimes, so I will need help. I hope to make some great friends while I am here because it is all about networking. Lol Thanks!

It fills in a data sheet with information already in it, fills the spaces up with the dataneeded, I have Macros, and Modules...I cannot post them due to the job that I do but what could be the problem if it was working fine and then something changes...I believe the system changed it colums...

Hello, I have a Access 2010 database. I am trying to upload / import an Excel sheet using a form from the Access. When I upload the excel, it says wait processing, when it says done. I check no informtion was uploaded, and the excel sheet loosing all data and the colums are being renamed...