Activity Stream

I have created a search function on a form in my database. I am trying to have a user enter a identification number for a table and be able to pull...

I am trying to transfer data from Access (latest version) to Excel. The transfer has worked for a long time and works OK until I add two fields to...

I have been working on creating a database to keep track of where wires/cables have been ran. I have information in an excel document that has all...

Unbelievably stupid on my part... I am about 99.9% sure I know the answer to this, but I thought I might as well ask... This morning, I am...

I have mdb file with addin-in custom menu, it was working fine in windows 7, office 2013 and shared network environment. Now I am trying to open in...

I have Office Pro Plus 2021 ver. 2205 on Windows 10. I've been playing with relationships between two tables, and then trying to get a query to...

I have a form used for importing member records into my database from an Excel workbook. The workbook contains the new members to be imported into...

Have been searching all morning. In vba, is there not a folder picker that also shows files but allows you to pick the folder? I suppose I could use...

Hello chaps I am trying to "decipher" northwind because i want to copy some of the code into my own programs where can i find how to use autoexec...

Ive got a table in which I store my buyers and a auto number for which buyer is which, how do I link another table to where when I put in the name of...

I am very much an access novice. I am struggling to figure out how to follow this guide. I've been working on it all day. I'm not sure how to...

I have Form A which is based on a table and Form B which is based on a query. Currently I have code written so when I change a certain field value...

Olá Preciso somar a quantidade das vendas que estão na tabela esquerda, porem com critérios diferentes para cada supervisor da tabela direita. Como...

Hi I work primarily with Medium Voltage (MV) cable and 'm trying to create a tool using MS Access in order to help myself on the engineering side to...

Hi all, I have 4 fields on my form (see below) that I'm working on. Here's what I want to do: 1. User enters date into "Date_Zipped"...

Hello Everyone. This is my first post here in this forum. Some background info.... uni grad, engineer, practically a noobie to data management of...

Is there a way to obtain the numerical value of a color chosen for conditional formatting? I tried to capture the BackColor property of a control...

Hello, I am new to MS Access. I need help to create query and form for an Inventory Item DB. Scenario: 1. Select the desired item with a query...

Table shown below. Need to setup a query to prompt a name input and have it search multiple columns (Op1, Op2, Op3). I'm trying to identify a task...

I have a continuous form where each record contains a "box color name" field. The form has an un-bound image control wherein I want to dynamically...

Access reports that I have this version, 2021. But I can't add that to my profile.

Hi I have a reportage system in access, 2 frontend Linked to one backend. Starting 01 Jun I get sometimes a data conflict copy of the backend....

Hi Guy's is there a method to find a file name that is closest match to a Date ? I have searched into this and found Application.FileSearch but...

Hi Guy's would you be kind enough to tell me where this is wrong please ? I am outputting 1 single record into tblJobSheets2 (this is to combine...

Hi Guy's, I have 2 combos 1: cboField, this is RowSource Field List 2: cboData RowSource Table/Query So i am going to update the rowsource...

I'm getting back up to speed, after 20 years of avoiding Access. I have some questions on how best to organize tables. I have read a bit on...

Here is a little puzzler that's been in my mind for years. I don't do much with Access, other than poke around and look at samples. I've never seen...

We're running a shared Access 2016 database with multiple users on Win10 workstations. Several users have it open at the same time, no problem. ...

In following Microsoft discussion pertaining to variable referencing in the Recordset collection, I've tried without success to solve the runtime...

I have three tables, tSales, tCustomers and tContacts. I have created a form that lists the Customers name and address details. I have then created a...