MS Access

214K

Solutions

150

Articles & Videos

45K

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.

Refine results

Hi,

OnClick I'd like to open a form, filter by a field, and with ONLY the filtered records I'd like to update a Yes/No field in a table.

I've done the easiest bit, but also I'd like to update a …

20 views
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

I receive the following Run-time error 2501 when opening a form which was created in Access 2003, but I am trying to make available now in an Access 2013 dbase.

(CODE)



During debugging, the …

811 views

Hi,

Seems very simple but I can't seem to make it work properly.
I have a macro created for me which exports reports as pdf files. WHich works great.

However I'd like field ("Printed") in my "C…

60 views

Hi Experts

If I have a list like 'y','i','for','xyz','abc', and I also have a table with one column containing items,
mytable.column1
y
xyz
i

How can I get in one sql what items on the list…

4246 views

I am using access 2010 and I used to see the name of the forms or tables that I had opened to add data or modify the forms.
Recently, they disappears.
I know that I was playing with some of the opti…

432 views

I have a main form called "Form" and a subform on the main form. That Subform is called "ProdSubForm".

The are linked Master to child by the field "SkuID".

"Form" is from the table called "SKU…

250 views

I am trying to populate a date field in a table when the user clicks the close form command button and has made a change in the data on the form.

Here is my code but I am getting a type mismatch er…

50 views

I have a table called LineItemDetail in Access 2003.  I want to copy the Fiscal Year 2016 records back into the LineItemDetail table with a set of records that now have 2017 in the Fiscal Year column.

20 views

Hi, i have an access table where i have multiple organisations in one field

eg

abc, xyz, oec, mba etc

In many fields i have a problem of a repeated organisation e.g

abc, abc, abc, oec, x…

411 views

I am trying to write a script that will run a .sql file directly from Access to update the Access database and SQL database at the same time.  My script works great in SQL Management Studio,  but I am…

89 views
Anonabox PRO Tor & VPN Router

PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

We have an Access database which contains a list of offerings.

Every single offering needs to have these information supplied:

ID number of the offering
Country and City
Name of the offering

69 views

We need some recommendations on good solid database design for the following scenario with an MS Access Database.

We have a list of the URLs assigned to each offering where we display a list of the…

77 views

How can I encrypt a piece of text so that I can store it in the registry, retrieve it at some later date, and decrypt it back to the original value eg. a date or a user name?

Thanks in advance.

211 views

hi,

we are now undergoing the permission review and we tried to make less database role, so I combine all permission from previous role to a single role so all developer under that role will all ha…

2825 views

I have searched for hours and have not completely understood this or something.  I am needing to Concatenate Field Strings Together From 2 Separate Tables Into One Field caled ProdConSku.

Tables ar…

109 views

Hi Experts,

I have a Menu Form that displays a record.  I want to trigger a Form Event whenever I move to another record on the form BEFORE actually going to the new record.  I need to stop going t…

198 views

I have some Data/Time fields in a table in Access, where I have set it to Required = No.

When I fire off an INSERT (via ADO) to insert data it doesn't like it if there is no Date. ie. Blank.
In my…

713 views

I am using MS Access 2016 and I am needing a way to have a button that I click and it will open up a file browser and allow me to navigate to a file capture that files path and then display it in my n…

1220 views

what is the most efficient way to transfer data (several thousand rows) from an msaccess database to a cloud based sql server 2012 server?  should I export to file, send, and then bulk import, or is t…

313 views
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

I'm running three DoCmd's, one after the other -- a delete query to clear the table, an append query to add new data, and finally an OpenTable command to view the new data.  The delete query and OpenT…

922 views

I would like to create a total in the footer of a report, but looks like this isn't possible.

Does anyone know another way I can show a total at the very bottom of a report?

29 views

Greetings!

I have a report tied to a query that has the "Record Date" sorted as "Descending"
However, the report shows the data in ascending order.

I notice the dates early in the month as 8/3/…

1723 views

Ok I am very lost on this part. I have Products and each product has 4 Product Conditions. These Product Condition Codes are NSOP NSSP USOP USSP . Each Product has a parent. Basically Just the Product…

13350 views

We know we have to go thru a partner regarding actual MSDGP prices.  However, any EE have maybe a ballpark figure as to the subscription on MS accounting or ERP software? (15 users)

319 views

With the generous help of this forum I currently have a 2010 access db which will export individual grouped reports as PDF.

I was wondering whether I could take this a step further and email each r…

519 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,107)
  2. Visual Basic Classic
    (163,444)
  3. MS Applications
    (43,119)
  4. Databases
    (53,340)
  5. MS Excel
    (127,846)
  6. MS Office
    (56,858)
  7. MS SQL Server
    (156,087)
  8. MS Development-Other
    (47,910)
  9. VB Script
    (36,163)
  10. MS SQL Server 2005
    (71,399)