Search results

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