ms access

how can i join table one, which does not have primary key, and second table which does not have foreign key without duplicated data? Thanks a lot, WIll

Hi, I want to search occurences of string "zeeshan" in a range in MS Excel through VBA from MS Access button click. Below is my code ... I am getting compile error : "method or member not found". With this error below line gets selected wordCount =...

Hi all, I am new to VBA and I am stuck in this issue for the last 2 days :( Please suggest me some solution. I am trying to create csv file from excel file. The file gets created but all the columns merge into just one column. :( i.e its not comma separated. The piece of code I am using for...

I am comparing data from access vs exported data from a system. Now I have excel data in ColA which is my primery key in access, and i want to extract the details of these pkeys from access and put it in ColB. Hope anyone can help me, I just learned extracting data from access, but I do know...

Hi Community, I am working on a database for about a week. This database is of a company which deals with creation of auto parts. Main needs of database are to record the date and project wise expenses which are (daily wages of labor, cost of machinery, and cost of material used materials are...

I have developed a Project based on Client-Server Project using table link functionality where back-end & front-end both are only MS Access 2007, back-end tables are stored in a separate desktop and front-end is circulated to my all team members. Now here I have a big problem for front-end and...

Hello...say I have an access database open and an excel book open...I need a macro in excel that will make a cell equal one of the textboxes in the access database form that I currently have open. The form changes based on what you click in access so basically I want a button in excel that will...

Hello...I would like to find a way in Excel to create a button that will copy from a textbox in an open MS Access form into an Excel field. Lets say for arguments sake the location of the database is C:\Test\Test.accdb, the form is called TestForm1 and the textbox is named TestTextBox1 and I...

I have a treeveiw in MS Access 2013. When I open the form with the treeview all works perfectly. After the form opens, the very first click on the Treeview does not expand the node I clicked. The very top node expands first. Then I have to click the one I want again. I prefer they all stay...

We use a third part data system to export data into a csv file. We then import it into a MS Access database. However, the size of the Access database seems much larger than it should be compared to the amount of data imported into it. Is it possible that there could be data imbedded in a text...

Hi! I'm new at using MS Access. My team needed a task tracker that would encompass various task groups so I decided to use a Task Management template to create an MS Access database. Under one task group, we have a number of sub-groups that currently keeps one excel file tracker each. For...

I have a database I am working on building and I've created a report that I would like to have open based on information chosen in a form. I have added it to my queries but when I click the button on the form it still asks for a parameter value. My DB includes table names: Events CEQuestions...

I am trying to use MS Access to query an MS Access database that is not the current database. I am using: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera...

I'm having an issue that really makes you want to pull your hair out. I have constructed a query in MS Access, which executes as expected. If I use the same exact query using the MS Query method, I get a General ODBC Error if one of the parameters is a string, and works just fine if the...

Greetings - I'm trying to get my head wrapped around this one; I may need just some general guidance, as I have light experience with Access. I am creating a database that is meant to A) find all possible combinations of given parts/components, and then B) bundle together the price of each of...

Hi, I have been trying to figure this out for several days, hopfully some genius out there can help me. I know I'm close, but just can't get the results I am looking for. Background: I have created 5 report in Access: Have successfully exported them to an Excel Workbook: Now, I am trying to...

Bit of a long-shot on here, granted, but I wonder whether anyone could give me some generic advice. I have a sharepoint list with about 50k records (I know this has busted the recommended capacity by a considerable degree!), and I have linked this list in MS Access 2003. Now, this list has...

Hi Guys, I have a written a code for a button in a form to import text files with the following field names in the text file. Title LastName Firstname Address City State Please see the below code and help me in finding the issue with the code. Private Sub...

Hi i am new to ms access databases, really struggling with my tables relationships my database has more than one many-to-many relationships, for example one instructor can have many classes, one class can have different instructors, one client could have different instuctors, one instructor...