Microsoft Access

220K

Solutions

51K

Contributors

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts,

I just created a system dsn (see 1st attachment).
And when trying to use it in Access wizard to select as data source, its not showing up there...
See second attachment.
Untitled.png
Untitled1.png
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

When I create a new record using a form, I have a field that I want to auto populate with the current year and a 5 digit number.  So, for example, it I am creating a record for this year I want the field to indicate "201900001".  And the next record to be 201900002", etc.
0
In open office how to insert one shape inside other

as attached i have big rectangle
I like to insert small circle into that rectangle
how can i achieve it

please advise
OpenOfficeShapes.png
0
visio 2013 standard i opened blank diagram,

I do not see any shapes like circles, rectangles, person, arrows etc on the left hands side

how to enable them and keep them there all the time so that whenever i open visio i can just drag and drop and make the diagram
please advise
0
How can I calculate the vertical size available for a Group footer, on a report, when considering the space used for page header, details and Group headers (and leaving room for the page footer also) on an access report ?
0
Unit-Checkv1.mdbGood Afternoon;

I am working on a database that will email unit checks to customers.  I have a query that will show the email addresses of our customers based on the selection made on the unbound form for the company name.  I also have in column 3 of the employee drop down contains their email address.  When the user selects their name, the email address populates in a text box (for test purposes only), however when they drop down the company name I should get several email addresses based on the number of people each company would like notified on the unit check.  The email piece works fine, I just need to find another way to get the other emails to populate with the employees email address as email; email; email; and so on.  I have tried Dlookup and only get one email address for the company and not the rest.   I may need a loop but i will need help with that.  

me.txtemailaddy is a text box on the main unobound form.  This is being pulled from a combo box cbo.Emp column3 (where email for the employee is stored)
I have a query Q_ContactEmail that returns the correct email addresses based on the cboCompany combo box.  
I would like to have me.txtemailaddy and Q_contactEmail.[emailaddy] to be concactenated into multiple email addresses in the to: line of the email.  

I hope this makes sense.  

Thank you,

Lisa

The email code is as follows:
Private Sub Command67_Click()
Dim oApp As New Outlook.Application
Dim oEmail As …
0
I am having an issue when exporting Access Reports to PDF.  I am using the 'DoCmd.OutputTo acOutputReport, stdocnameTrend, acFormatPDF, FileNamePDFDets, , , , acExportQualityPrint function.  

The function is working however when I open the PDFs not all of the images are showing, I have looked at the "Display When" and they are all set to always.  When I print to pdf it works, but I can not find the code to automate printing to PDF...

Anyone have any success with this?
0
Install and run a Microsoft Access application with one click

A revised article on this topic has been published:
Deploy and update a Microsoft Access application with one click
Microsoft Access on Windows 10
Deploying a Microsoft Access application in a normal Windows environment is not difficult but takes a few steps. The method and script provided here will - literally - turn the process into a one-click process for the user, even in a Citrix environment.
0
I'm getting so tired of x' ing out of all of those visual basic windows in MS Access code view.
Had the same problem with A2K.. now using Office 365... have they added a function key or key shortcut for this yet???
I can't believe you experts deal with this problem..do you?

Thanks..p
0
Deploying a Microsoft Access application in a normal Windows environment is not difficult but takes a few steps. The method and script provided here will - literally - turn the process into a one-click process for the user, even in a Citrix environment.
0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Hi Experts,

I am building a database for eventual deployment on our network for multiple users.  I am trying reduce the amount of forms I've created for each department to a master form that is filtered for that department's items when the form is opened (e.g. on the attached db, switchboard>dietary>manage items).  When I open frm_ItemsMstr,  I set the query in the command button click event in the switchboard and when the form opens the records are filtered to that department.  However, I created an option group on frm_ItemsMstr to filter the items based on their status of active, retired, etc.  and am having the unexpected results of other departments' items being included in the filter for most of the options but not all.

What is the best practice when trying to create a form like this in a multi-user environment so each user only sees their department's items?   Any idea why my options group is behaving like this?

Thank you, your help is always appreciated!
VernonHomes_Inventory_ver-1.0-not-.accdb
0
I have a cash and bank query which I intend to use as a bank reconciliation, now I want to have the details showing on the picture on a form in ms access so that whenever I see the same transaction on the bank statement I tick the yes button and then post using update query . The idea here is to filter the final report so that on those not appearing on the statement can remain.

(1) How can I a form so that I'm able to see the transactions like a datasheet.


Regards

CashbookQuery.png
0
I have a form with 7 subforms.  Each of the subforms has a date field and the control source is Me.txtScheduleDate = Forms!frmScheduleDateRange.txtStartDate for Sunday, Me.txtScheduleDate = Forms!frmScheduleDateRange.txtStartDate + 1 for Monday, Me.txtScheduleDate = Forms!frmScheduleDateRange.txtStartDate + 2 for Tuesday, etc. through Saturday.

On the subform is a command button that opens a 2nd subform.  The 2nd subform has date field that I want to populate with the date from the 1st subform.  Is this a case for a TempsVar to be used?   If so, I don't know how to code it.  Maybe a temporary variable in the command button on click event can be stored and then used in the date field in the 2nd subform?
0
I have an access field in my database that has date and time and the only way to view all the values for a given date is to select a > < (between) date range such 1/8 /2019 - 1/9/2019 to view all the rows for 1/8/2019. I would like to only query based on the date so when I query for 1/8/2019 it should bring up the rows for that date instead of having to search for a range or go to the next day. I know the easy is to change the column settings but I am unable to do so and would help on the correct date command or another function to make the change.
0
i see some templates here.
i downloaded zip and unzipped and copied those contents and placed at
C:\Users\xyz\Documents\My Shapes

http://softwarestencils.com/uml/index.html

any other visio similar templates to reuse existing shapes and sequence diagrams etc

please advise
0
i have one flow diagram in the word document.

how can i copy paste that same diagram in visio and make minor changes to it.

please advise
0
I am trying to list files from folder\subfolder from this sharepoint folder.
SharepointAddress = "https://centralhub.XXXXX.com/team/CHS/SRS/Account Set Up Templates/"
I would like to do this from a button on a form and put the information in a table for exporting.
I have never done anything like this before thru a network except normal dir stuff.
Does anyone have any code that can help me do this. I would greatly appreciate it.
0
Hi

It would be great if you could convert below MS Access VBA scripts to a ms dos commands (so that I can create bat file to do the same job)

Public Sub SetAttribNormal()
SetAttr "X:\Report_New.xlsx", vbNormal
SetAttr "N:\Report_New.xlsx", vbNormal
SetAttr "X:\AA\Projects_New.xlsx", vbNormal
End Sub

Public Sub SetAttribReadOnly()
SetAttr "X:\Report_New.xlsx", vbReadOnly
SetAttr "N:\Report_New.xlsx", vbReadOnly
SetAttr "X:\AA\Projects_New.xlsx", vbReadOnly
End Sub

Thank you
A
0
How to create Access Table from Querydef in MS Access? I have a SQL stored procedure I'm running with some code in VBA. I want to take the results of the procedure and put them into a table in my MS Access App. I think I am close but just can't quite figure out the code to append the records to the table (tblTEMPFinalTV2). Here is the code I currently have:

    Dim qdf As DAO.QueryDef, rst As DAO.Recordset
    
    Set qdf = CurrentDb.CreateQueryDef("")
    qdf.Connect = "ODBC;Description=EpicorLive10;DRIVER=SQL Server;SERVER=SE10SQL0;UID=AccessUserRO;PWD=Seyer123;DATABASE=EpicorLive10"
    qdf.SQL = "spFinalTV"
    qdf.ReturnsRecords = True
    Set rst = qdf.OpenRecordset
    MsgBox rst.Fields("GroupName")
    
    'DoCmd.RunSQL "SELECT " & rst.Fields("GroupName") & " INTO tblTEMPFinalTV2 FROM " & rst

Open in new window


Thanks for the help!
1
Protecting & Securing Your Critical Data
LVL 1
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

is there an easy way in access, to merge all data in all fields into a single list? I have received some data and it looks like 95% of the cells in most columns are empty, but I need an automatic way to merge all data from all columns which are not blank into a single list of data/column of data. Any suggestions if this can be done? there are over 60'000 rows of data, the first column is full of entries, but then there are dozens of fields and 95%  of them seem to be blank, so merging all cells in the table from all fields, where the cell is not blank would be a great help. Is there also a limit on the number of fields you can import into access?
0
Hi,

I am trying to automate report (excel spreadsheet) production using access vba script and windows task scheduler.
I am getting error message at beginning of the scripts itself(given below).

SetAttr "Z:\Report_New.xlsx", vbNormal

(because I apply SetAttr "Z:\Report_New.xlsx", vbReadOnly at the end of all scripts.)


"Z" is a mapped shrepoint drive. The run time error 75 tells Path/File access error. But when I run the script manually there is no issue. When I left it to run over night, vba editor throws this error message.

Please let me know  if you have any suggestions
Thank you
A
0
Hi

I want to replace the Dlookup function in my FORM  with a sub query see below but I'm getting a syntax error:

=DLookUp("[CompanyName]","[tblCompany]","[CompID]= 1")

= SELECT[tblCompany]. [CompanyName] FROM [tblCompany] WHERE ((([tblCompany].[CompID]) = 1))Formbalancesheet.png
How do I correct it?

The motivation behind this is to improve the performance.

Regards

Chris
0
I have the following in a query design view, which if I just double click the query to see the results, it works fine (I see correct data in all records). But, if I export the query to Excel or a txt file, the iif isn't working... there are 4 records that do not have Company, so they should return Name because Company is null. Again, this works fine when just executing the query, but does nothing (just shows Company, null or not) if I export it.

Ship To Name: IIf(IsNull([Orders].[Company]),[Orders].[Name],[Orders].[Company])

Open in new window


Here is the SQL view:
SELECT Customers.CustomerID AS [Ship To ID], IIf(IsNull([Orders].[Company]),[Orders].[Name],[Orders].[Company]) AS [Ship To Name], Orders.Address AS [Ship To Address 1], Orders.Address2 AS [Ship To Address2], Orders.City AS [Ship To City], Orders.State AS [Ship To State], Orders.Zip AS [Ship To Zip Code], Orders.Phone AS [Ship To Phone Number], Orders.OrderNumber AS [Invoice Number/Credit Number], [Order Details].ItemNumber AS [Invoice Line Number], Orders.LocalSortDate3 AS [Invoice Date], [Order Details].SKU AS [Your Item Number], InventorySuppliers.SupplierSKU AS [MA Item Number], [Order Details].Product AS [Item Description], [Order Details].QuantityShipped AS Qty, InventoryProfile.SoldAs AS UOM, InventorySuppliers.Cost AS [Your Unit Purchase  Price]
FROM ((([Order Details] INNER JOIN Orders ON [Order Details].OrderNumber = Orders.OrderNumber) INNER JOIN InventorySuppliers ON [Order Details].SKU = 

Open in new window

0
using Access 2010 vba  code
to get
excel 2010 data

I have looked and looked but cant seem to find answer to this question.

for any given cell...no matter what the formatting is in the cell.

I'm trying to pull just the displayed text/value...
not any underlying number that is stored or whatever, just the displayed value..

I have tried the following.  from access vba
CellDataEvaluate = Trim(.Cells(i, j).Value)
CellDataEvaluateR = .Cells(i, j).Text
0
word document i made changes to its content by adding more pages and changing digrams, headings etc.

Table of Contents in first page is not reflecting the changes with changed page numbers, navigation etc. Please advise how to fix it
0

Microsoft Access

220K

Solutions

51K

Contributors

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.