access 2013

I am having a hard time getting my after insert macro to update correctly... Create Record In Customer For Each Record In Customer Where Condition = [Customer].[RepNum]=[Rep].[RepNum] Alias Rep EditRecord Alias Rep SetField Name Rep.Commission Value = [Rep].[Commission] +...

I want to create a query that calculates daily investment returns. The formula would be Market Value today divided by Market Value yesterday. Where I'm struggling is how to tell access to grab the market value from yesterday. My current TotalMarketValue query looks like this: <tbody> TotalMV...

Hello and thanks for any help. I'm a noob with Access but my company has asked a question about possibly importing some information for certain records in Access. Basically, I work for an insurance company and they have a claims system which was built in Access about a decade ago by someone who...

HI everyone, My code is below. I want to have a button that will allow someone to add a record to access without having to open up the VBA editor to select the reference library. Private Sub CommandButton2_Click()MsgBox ("MAKE SURE THE ENTIRE INPUT TAB IS CORRECT") Application.ScreenUpdating...

My VBA is working great my record is recorded correctly in access when I run the macro, my only issue is that every time I open a new workbook I have to reactivate the VBA Reference library : "Microsoft Office 15.0 Access database engine Object" I will be having other co-workers (not-VBA users)...

Trying to connect to an Access database, I copied some production code that works with the same .accdb file- why type it again, right? 'open connection Set cn = CreateObject("ADODB.Connection") cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\TestData.accdb;" 'build recordset sSQL =...

Hi, I have multiple crosstab workbooks like this, each representing ACV data for a particular Category-Country e.g. Foods-US. The workbooks filenames are e.g. INO-Food-US.xlsx INO-Pet Food-US.xlsx INO-CCare-US.xlsx INO-CCare-UK.xlsx INO-Food-UK etc. i can loop thru the folder and import all...

I'm working on a tracker for my service desk calls and came across the MS Access Call Tracker. I have managed to get virtually everything working almost the way I need but need some help. I wanted to upload a zip file with sample data but can't find how to upload files here on this forum...

I have been trying to import an excel table of over 281,000 rows and 92 columns to a fresh Access db. No matter what I do to achieve this, I end up seeing "The expression you entered refers to an object that is closed or doesn't exist". I thought it's due to memory problems and so freed up 8 GB...

I am trying to take a text string that will be used as a query in Access from an Excel cell and paste it into a criteria field in query design view in Access. Some of my queries will be lengthy so in Excel I have a character length formula warning me if I go over the character limit in Access...

The SQL below returns the field ‘TABLE.LAST_DTTM_UPDATE’ in this format: 'YYYY-MM-DD-HH24.MI.SS.FF'. Example field value: 01/14/2016 1:36:36PM Unfortunately, I don’t have any way to change this format within the SQL. When I try to import the data into a new table of an Access 2013 database...

I have an Access 2016 database containing names, email addresses and dates of hirers together with how many adults and children there were in the party (0-99). I use a form to enable the user to search by different criteria. All works well with the exception of the criteria for "Children" or "No...

I am bringing in an odbc connection to excel. I brought the table into excel without problem, but if a file gets changed in the database will it reflect in excel? And if I move the excel sheet over to an access database will that also see any changes made? I am using office 2013. Thanks...

Hi. I use MS Access 2013. I have a table the includes a date field. The format is Date/Time and dates are displayed in the field as mm/dd/yyyy (e.g. 01/31/2015) I want to be able to query on this field, but I want the query to return the YYYY-MM value for each date. For example, for date...

Hi All This is a very basic question but I cant seem to get around it. I have a query that I am using multiple times so I have saved that query in a string variable. Now that query is using ID in the where clause which I need to update dynamically so I made an Int variable and concatenated that...

Hi All, I am having some trouble trying to create a query that will return a default value if the date being looked up falls between any of the start and end times in another table. The date being looked up is in table1 and start and end dates are in table2. I need for the value in table 1 to...

I have probably spent more time trying to figure this out by myself than I should have. I have an access database that we use to process orders. I know how to send emails as an attachment but what we need is to have an HTML email open with specific wording. Below is the code I have entered...

Hello everyone, I have been searching this website as well as google for a week now and haven't found any examples that a novice like myself can modify to make work. I am trying to automatically populate an email with the results of 3 different queries. I have been able to successfully...

Hello, I have created a database with multiple tables in Access 2013. i have had no problems getting the relationships for the drop boxes set up. Where i am struggling is getting a unit price from one table, to be multiplied with a entered quantity in a fox text box to create a total that...

I am using Excel 2013 and Accesss 2013. I am trying to use Excel <acronym title="visual basic for applications">VBA</acronym> to open Access and run a specific query. I run the below code, then it highlights the "Dim appAccess As Access.Application" line and gives me the error message "Compile...