Search results for query: *

We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before publishing to production. All was great back then, before the revamping of the managing of linked...

I found code that describes what I want to do... Execute a SPROC (MS SQL Server) and directly populates a local MS Access Table. I am just uncertain in their code what the actual SPROC name is. I am not a member of that forum and rely on this site for my primary resource. Thanks, Site: Link

I am using a single table UniqueID LastName FirstName ManagerID Title ======== ======== ========= ========= ===== 1 Smith Frank VP_Sales [highlight #FCE94F]2 Moore Bethany 1...

I have an ADP data dump that shows all associates in a company. With each associate there are two data points I am focusing on, their UniqueID (or AutoID ADP gives) and a ManagerID, which is the UniqueID of the associate that manages the associate in the row. If I am a high level manager, my...

I am versed on how to use Recordset in VBA (MS Access) and am attempting to mimic that code in SQL Server in a Sproc. I am somewhat new to sproc programming and was hoping to use the following code to use the row data of currently filtered values so I can use that data for filtering an inner...

I am trying to update current record being processed in a loop based on a SQL statement. But I am getting the error "3027: Cannot update. Database or object is read-only." Set rsGenerateMe = CurrentDb.OpenRecordset(SQL, dbOpenDynaset, dbFailOnError + dbSeeChanges) If Not...

I have a task to take a form that uses many similar field names but the difference is the 2nd character (pertaining to sections on form). Field names on form frmSomeName. S1ClientID S1PracticeID S1ProjectName S1ChildRoleID S1ServiceTypeRadio S1Parent1ID S1Parent1RoleID S1Parent2ID...

I was looking at thread (Thread) And an image Oxicottin posted 10 Feb 16 17:01 (Example) I want to create a Multi-Select using the check boxes approach and the main box displays the values captured, but behind the scenes I want to capture the PrimaryKey for each item to be stored for table...

I have code that updates a table with two different but similar fields to be updated. Neither updates deal directly with an IDENTITY column. However ONE of them uses the IDENTITY column in the WHERE statement. The 2nd code works like expected... the first crashes saying "You must use the...

I have a query returning any number of rows. For the sake of the user, I want a field that is just a counter (incremental field) to be displayed. Example below: No. UserName --- -------- 1 Black, Bob 2 Cash, John 3 Doe, Jane 4 Caruba, Crystal...

Have a working loop that uses a variable name that is using the loop value (i) within the string name for populating. I am working on a nested second loop that sits within the first loop and need that loop value (r) to do data checking on specific values. The (i) loop is working wonderfully...

Using: Access 365 - Version 1902 (Build 11328.20392) We are experiencing a new issue which I believe happened since the last MS Access update that now all our forms (formerly tested and validated) were working as expected with particular fields hidden (visible=FALSE) are now fields are visible...

I have lengthy code that I have DEBUG.PRINT scattered within so I can watch the code process. I am currently getting the Immediate window will be populated with a few rows (not always the same rows) but no more populating to the immediate window. After a random time period, the Immediate...

Simple explanation of my project. I have nested loops that each are based on a linked table query (source = SQL Server tables). Loop1 start | Loop2 start | | Loop3 start | | | Loop4 start | | | Loop4 end | | | Loop5 start | | | Loop5 end | | Loop3 end | | Loop6 start | |...

I want to have an array that has 5 deep with x values (so it would be V=0-4 and X = open ended) Here is what I have currently Public GlobalArray() As Variant Function ObtainOldWorldData() Dim OldRoles As Variant Dim vItem As Variant OldRoles = Array("cboCRM", "cboPM1", "cboPM2", "cboLC1"...

Working with Stored Procedures is new for me. I have a Sproc: (snippet of code we are using) CREATE PROCEDURE [dbo].[Test_SProc_SurveysScoresandComments] @Associate nvarchar(9), @PeriodBegin date, @PeriodEnd date AS /* DECLARE @Associate nvarchar(9) DECLARE @PeriodBegin date...

I am sharing a screen capture of a report that needs to be made into a form. The issue is this needs to be a form for additional button controls and for continuous scrolling down. The data is dynamic for the number of rows and the orange boxes also grow based on values (to the left of bar)...

I have been trying many methods to go from: me!rpt1.Report.RecordSource = SQL me!rpt2.Report.RecordSource = SQL me!rpt3.Report.RecordSource = SQL me!rpt4.Report.RecordSource = SQL to something like this For N = 1 to 4 me!rpt[N].Report.RecordSource = SQL Next N but it's not working and I am...

thread705-439774 I see this thread is closed but there was a directive to go to a URL. the URL no longer exists (http://www22.brinkster.com). Does anyone have something that was close to what MP9 was sharing? Thanks

I have a query that is a pivot table output. The column names are populated out of values found in source table [Code tblAssociatePerformance] aID AssociateID Year Rating --- ----------- ---- ------ 1 as34afeet 2017 Exceeds7 2 dafsjkl34...