UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Double Click To Open Form, Access 2016    
 
   
zeke1507
post Sep 21 2019, 12:58 PM
Post#1



Posts: 4
Joined: 21-September 19



Hello,

I am volunteering for a non-profit and built the attached database. It does everything I want it to except one thing. The user wants to have it in either Table or Datasheet view (Whichever gets this to work). "Church and School List" or "frmCSList". From there, they would like to Double Click on a record and have it open in Form view. (Basically open ChurchAndSchoolForm to that specific record.) I am writing explicit instructions so if they have to click on a specific column or something, that's fine. I just don't know enough code to get this event to take place. It seems like it shouldn't be too complicated, but I've reached the limit of my knowledge.

Thanks for the assist.
This post has been edited by GroverParkGeorge: Sep 21 2019, 01:06 PM
Reason for edit: Removed Accdb with real data
Go to the top of the page
 
GroverParkGeorge
post Sep 21 2019, 01:05 PM
Post#2


UA Admin
Posts: 35,896
Joined: 20-June 02
From: Newcastle, WA


Welcome to UtterAccess.

This Access Relational Database appears to contain real data, including email addresses.

I will download it for review, but I'm also going to remove it from the post. Privacy concerns are not to be taken lightly these days.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
jleach
post Sep 21 2019, 01:18 PM
Post#3


UtterAccess Editor
Posts: 10,152
Joined: 7-December 09
From: St Augustine, FL


Hi, welcome to UA.

As George mentions, we have to be careful about what we're posting. Usually the ideal scenario is when you can replicate the issue (or enough information to get the point across) in a sample database with fake data. For most tasks, this does not need to be more than a few rows in relevant tables. At the very least, all names and contact information should be removed or set to some fake value.

Good luck with your project,

--------------------
Go to the top of the page
 
GroverParkGeorge
post Sep 21 2019, 01:24 PM
Post#4


UA Admin
Posts: 35,896
Joined: 20-June 02
From: Newcastle, WA


I took a look at the table in this accdb.

It is one flat file. It could be an Excel Spreadsheet, and in fact looks like it might have been imported from Excel.

Please invest some time in learning how Relational Databases, like Access, need to be designed to work with Relational Data.

The problem is not that you can't do it this way. You can. The problem is that "spreadsheet style" tables are so much more difficult to work with in a Relational Database. While it does take an initial investment in learning the difference between this sort of table and properly designed Relational Database tables, the pay off is down the road when it's so much easier to perform basic tasks, such as the one set out here.

Post back, please, with sample data that doesn't reveal personally identifiable data, and we'll help you get going.

Also please study the materials here. That will help you understand why we need to work on the table design as the first step.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
arnelgp
post Sep 21 2019, 02:04 PM
Post#5



Posts: 1,478
Joined: 2-April 09
From: somewhere out there...


at least give us something to work on.

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Sep 21 2019, 02:16 PM
Post#6


UA Admin
Posts: 35,896
Joined: 20-June 02
From: Newcastle, WA


I removed the first upload because it contains REAL names and REAL email and phone numbers. We try to avoid that.

We asked for sample data already.


--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
zeke1507
post Sep 21 2019, 02:50 PM
Post#7



Posts: 4
Joined: 21-September 19



I appreciate the assistance with the security. I apologize. I've never used a site like this before. Also, it was downloaded from Excel. Like I said, I'm volunteering for the org and not trying to invest too much time in this. It was a summer project I'm trying to help with, but I'm in over my head. We aren't trying to get this to do too much more and aren't looking to grow the database. Here is a database with fake data. Just a few records. The goal is to be able to open the frmCSList, double click a record and have it open to that specific record in ChurchAndSchoolForm.

I've taken a database class and know a little about the relational database component, but I didn't have the time to build it from scratch and still meet the deadline they needed the database to function by. I had to combine three Excel spreadsheets data into this one database and the manager loves what I've done so far, they just want this last addition. I know it's more difficult, but I don't have the capacity to put in the front end work, and it doesn't seem like it would be worth that amount of effort for this situation.

Again, thanks for the help.
Attached File(s)
Attached File  CS_Copy.zip ( 266.83K )Number of downloads: 5
 
Go to the top of the page
 
June7
post Sep 21 2019, 03:09 PM
Post#8



Posts: 887
Joined: 25-January 16



I've seen worse "flat file" database.

Advise not to use spaces nor punctuation/special characters in naming convention. Better would be: ZipOrPost, ParishOrSchool, IsEvent, DateAndTopic. Why would date and topic be in same field? Advise to separate.

I see you have some VBA code behind ParishShool textbox, however, event property does not have [Event Procedure] setting. Without it, control is not connected to code. How did you manage to accomplish that?

Also, filter criteria is wrong. And there is a misplaced comma in command parameters. Should be:

DoCmd.OpenForm "ChurchandSchoolForm", acNormal, , "ID = " & Me.ID


This post has been edited by June7: Sep 21 2019, 03:39 PM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
zeke1507
post Sep 21 2019, 03:20 PM
Post#9



Posts: 4
Joined: 21-September 19



I deleted the Event Procedure and didn't realize the code had remained. I had looked at some forums previously and that was the code that I copied from there. I have no idea how to troubleshoot it. The thought process was if I double click the record in the parish school criteria, the form would open, but I got an error '13' message. So rather than knowing how to edit the code, I tried to delete it and start from scratch asking for help. I tried to piece this code based upon the code and form names in the piece being discussed.
Go to the top of the page
 
June7
post Sep 21 2019, 03:37 PM
Post#10



Posts: 887
Joined: 25-January 16



Deleting parameter from event property does not delete code, however, deleting entire code procedure would remove parameter from property.

Did the fixes work?

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
arnelgp
post Sep 22 2019, 02:35 AM
Post#11



Posts: 1,478
Joined: 2-April 09
From: somewhere out there...


here used Cris'O technique, modified
for 64x msa.
Attached File(s)
Attached File  CS_Copy.zip ( 196.9K )Number of downloads: 2
 

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
zeke1507
post Sep 22 2019, 10:48 AM
Post#12



Posts: 4
Joined: 21-September 19



Yes this worked. Thanks so much!
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st October 2019 - 03:55 PM