Recent content by mike.molina

I am using Access 2013. When I generate a report there are multiple repeat values. I would like to leave field blank if preceding value was a match. example report and desired result please see attachment. please help me find a way to correct this all attempts I have tried, unique values =...

[SOLVED] Hair is coming out (VBA HELP) [SOLVED] Thanks for all of the input you guys provided...although they were good recommendations, I found the only thing I needed to do was add a specification name within my code due to the fact that the file is a CSV. Apparently, this is a known...

this is what the code looks like right now: Private Sub Command36_Click() Const Filepath As String = "C:\UUAM\" Const Filename As String = "Subinv" Const Fileext As String = "csv" If FileExist3(Filepath) Then Call subImport("SubInv", Filepath, Filename, Fileext) Else MsgBox "File not found...

Same error received...

arnelgp, Thank you for responding. I copied and pasted the info you provided; however, received an immediate error. "File not found. Please check fieldname, file extension or file location." I double checked the raw data and table and both are labeled correctly. R/s, Mike

[SOLVED] Hair is coming out (VBA HELP) Hello All, I have a database in which I am importing data from .csv to an Access table. I keep getting a run-time error of 2391 which reads "Field XXX doesn't exist in destination table 'Subinv'" The "XXX" is where the error display some weird characters...

No, the excel file is downloaded to the C:\Drive with no password restrictions. If I manually open the excel file and select enable content, then save and close file. I can then go to the database and select an import button which would then import the data without error...but I want to...

Gurus, I have an Access Database which imports data from an excel workbook located on C:\Drive. My problem is the excel workbook is not enabled so when the import occurs no data is imported into Access. If I manually enable the content on the excel workbook the import will work fine. Is there a...

Thanks JDraw I will try that out. R/s, Mike

I have a query which contains a list of names; ex: MOLINA, MSGT MIKE D. I want to be able to remove the period; however, not all names contain a period because some users do not have a middle initial. The code I used to remove the period worked but I now have an error in the field which did...

Hello everyone, I am new to access and know the basics, creating tables, forms and queries. However, I would like to create a command button on a form that will "import" an excel spreadsheet into an existing table without overwriting what is currently in the table. Is there anyone that may be...

Aloha, My name is Michael Molina and I live in Hawaii. I work in Logistics Analysis capacity in which I have begun to improve my knowledge in Microsoft Access; however, it has been very slow going. Hopefully, I will be able to learn from all of users within this site. thanks, Mike