Search results

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

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

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