Search results

Hello I'm creating a database where I have a set of data imported from excel. There are various fields in this table. Each record represents a client, which contains a group number that they pertain to. For example: Name: Jane Doe Group #: SD123 Group Status: Completed Name: Jack Black...

Hello, So I have 2 Tables -Daily_cumulative -tbl_Import I have a button macro in my form which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative. tbl_Import should display for me the name (or path) of the file I just uploaded as well as...

Hello, I used the following code below to open an excel file using a button in a form. I want a similar button to open an exisisitng PDF fillable form. How do I change the CreateObject to Adobe? Private Sub PL_Submission_Form_Click() Dim xlApp As Object Set xlApp =...

Hello, I'm using the below code to import data into a table daily. I would like a way for me to log the date and time of each import. Is this possible? Ideally I'd like a table to have the list of each import (they had different names), and the date and time. In the code below...

Hi, I have the following code that runs: Private Sub Recurrence_review_BUTTON_Exit(Cancel As Integer) DoCmd.OpenQuery "Delete the appended records to Recurrent rc from cumul" DoCmd.OpenQuery "Daily Review of new/oustanding", acViewNormal, acEdit End Sub In the event there are 0 records...

Hi, I have a form which has a button which opens a query using this code: DoCmd.OpenQuery "Find duplicates for Pending Report - Cumulative", acViewNormal, acEdit The user will do a set of actions. I want for the following code to be run when the query is closed. is this possible...

Hello, I have the below macro i'm using to upload an excel file into a table in access. I want there to be a prompt before the upload happens to confirm the number of records that are being added... Also for the same code I want a way for there to be a prompt if the user tries to upload a...

Is there a way to create a query which would display only the first occurrence of duplicates entries based on a uniqueID, but would include a count of how many occurrences there are? I am using MS Access 2013. thanks,

Is there a way to create a query which would display only the first occurrence of duplicates entries based on a uniqueID, but would include a count of how many occurrences there are? I am using MS Access 2013. thanks,

Hello, I've created a database where a user will upload a new excel datasheet daily. The user has to review the information and indicate within the record if they've dealt with the issue. once dealt with they change the status of the record. This datasheet comes from an external system. If...

Hi, I'm trying to run a very simple VBA linked to a form. What I need is for this VBA to open up a form with multiple criteria. I've found many forums with this information however, my filter is in the same column. Basically, my form is linked to a table where I have the column [Status]...