Search results

Greetings, On my payment entry form, I've the following buttons: Add to input a new payment, and Edit, to make changes to existing payments. Lately, when users click Add, they receive run-time error '94' and clicking End will exit the database and create a _backup file, when they click Debug...

Greetings, Attachments We have a button on a form when clicked it will take users to the attachments they saved for a particular case. The attachment folder is stored in the agency’s shared drive. Just recently, users reported that when they click on attachment button, they no longer see the...

Greetings, I’m using access 365 in be/fe environment. The be is stored in the shared folder and each user has a copy of the fe on the desktop. Following are some issues I recently start experiencing: 1. Everyone can access the copy of the fe on their desktop, but some people experience issues...

Greetings, When creating query and attempted to add table, I noticed few changes: 1. One of the tables has a yellow border in the relationship window. I researched online and learned office 365 has a new feature to allow selection of multiple tables 2. . When I right clicked and selected...

Greetings, We are using office 365/ ms access db split into BE/FE. The BE is located on the shared folder on the server and each user has a copy of the FE on his/her desktop. Currently, everyone is working from home using their laptops and accessing the database via remote desktop. Which seems...

Greetings, We're currently running office/access 365 the db is deployed in split (be/fe) environment. We have a provider table w/ almost 80k records. The way the db is designed (by someone else), or supposed to work is as follows: Whenever users create a new case, a search window appears...

Greetings, I'm supporting an a 2016 access db that was designed by someone else. The requirement is for me to add a new drop down field with in a tab in the form. The name of the tab is pgeFinancial and the drop down field I attempted to create is called disposition with items like guilty...

Greetings, I’d like to auto populate a textbox (txtDAUEmail) based on selection made in a combo box (cboDAUNM): If John Doe1 is selected from the combo box, then the textbox should auto fill the analyst’s e-mail address. e.g. John.Doe1@emiladdress.com I changed the row source of the combo...

Greetings, Given my tables tblSuspension and tblSuspStat I tried to create a query to show open and close suspension cases. SUSPSTAT in tblSUSPENSION is a numeric data type (1 & 2) whereas STATUS in tbl SUSPSTAT is a text data type (close & open). It was requested to display the text value...

Greetings, I am trying to find out how many CODE that start with 772 exist for a given day. In my query I used CODE Like “772*” which gives me part of what I want. What I’m looking for is the number of CODEs per a given Date. Please see the attached sample and let me know if you have...

Greetings, A former employee developed a case tracking (ms access 2016 db) that is getting bigger in size. The management inquire about archiving those cases (along with attachments) that were 'closed' prior to 2016 onto a removable HD and delete them from the DB. Moving forward, do the same...

Greetings, I’ve a login form that users have to input username/password to access the DB. However, here is some scenarios that I’d like to enhance the code to avoid the following error: 1. If an invalid username is entered, I get the following error: Run-time error ‘3021’ No current...

I’ve the following combo & text fields: 1. cboAnalyst (dropdown) analyst1 analyst2 analyst3 2.txtAnalystEmail (text field to enter e-mail address) Depending on the selection made in cboAanlyst dropdown, I would like the txtAnalystEmail to auto populate the analyst’s e-mail address. e.g...

Greetings, I created a blank form ‘frm_CASES_All’ and added a button to open my report ‘rpt_CASES_All ‘ which is based on my query ‘qry_CASES_All’ On the form I used the following for my button to open the report DoCmd.OpenReport " rpt_CASES_All ", acViewPreview However, my goal is to use...

Greetings, We’re currently running access 2016 split database (with individual front-end and shared back-end) Couple of questions: 1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the...

Greetings, I just started supporting ms access 2916 db that was created by someone else. A report was created for managers whereby they run ‘open case report’. The issue I’m encountering is that managers can access the report, they will be prompted to enter a name, managers enter...

Hi, Given the attached sample report 1. I would like to filter only the needed columns that are highlighted (Columns: A, E, F, H, L, W & X) 2.rearrange and list columns the same as Order Rpt (below) A = Order Number B = Order Date C= Supplier D= Account Code E= Blanket Order F= Order...

Greetings, I start creating the attached access db to simplify the data entry process currently done using Excel. We also purchased a third party application (for data definition purposes) that allows us to import what we already have in place. But, in order to export to the third party...

Greetings, We use Excel 2010 to input detailed information about a given data element and use save as CSV to export to a third party application that we use for data definition purposes The third party application allows us to import a CSV template limited to 10 fields (A – J). Since we...

Greetings, Following is what I would like to automate: Take a record from Workbook #1 column D and search if this record exists in Workbook #2 Column P. If the record exists, then take the corresponding record from Column W in the same Workbook (workbook #2) and copy the record in Workbook...