Clicking on a cell and opening a fillable form. How?

I’m new to access and I’m not super interested in becoming proficient in it. I need to build this single project and that’s about it.

I have forms built already, I just can’t figure out how to be able to click on a cell and open the forms. I’ve been trying to reference the templates, but I’m missing something.

Do you have to have another table or something somewhere? I’m so confused. Thanks.

submitted by /u/StuckinWhalestoe
[link] [comments]

Posted on

Have a table with dated updates to events with unique IDs (per event). How do I write a query to give me both the first and last occurrence of each event?

Each row in a table relates to a dated update for an event with a unique ID.

How do I write a query to look up each event ID and then give me the first and last dates ?

I’ve done this in Excel but don’t know how to do it in Access.

Hoping this illustrates…

=IF(A150=””,””,IFERROR(AGGREGATE(15,6,’Sheet1′!B:B/(‘Sheet1′!A:A=A150),1),””)) gives me the first occurrence, and =IF(A150=””,””,IFERROR(AGGREGATE(14,6,’Sheet1’!B:B/(‘Sheet1’!A:A=A150),1),””)) gives me the last occurrence.

A in Sheet1 is the Unique ID, but duplicated for each update to the event. B is the date/time of the update.

Ultimately all I’m interested in is the number of days between these dates, but unsure how else I could get it without getting these two dates first.

Any chance anyone knows how to help?

submitted by /u/toni_inot
[link] [comments]

Posted on

Form to browse long text fields with short text index.

I have a table like this: NoteDateTime DateTime Description ShortText Narrative Long Text

I’m trying to create a form so that on the left side of the screen there is a list containing the short text and description of all the rows. When I click on a row, the right side of the screen populates the narrative.

How can I go about this? Thanks!

submitted by /u/DevilDoc44
[link] [comments]

Posted on

DB Issues

I’ve created an Access DB and am using an APAN site to hold the tables. I keep running into issues where transactions are taking days to upload causing people to redo their work multiple times thinking it didn’t work and then randomly a few days later transactions will go through causing me to have to go and delete them all since they’re duplicates at this point.

Anyone run into similar issues before using APAN or a sharepoint site to store tables?

submitted by /u/Rayzr117
[link] [comments]

Posted on

DB Issues

I’ve created an Access DB and am using an APAN site to hold the tables. I keep running into issues where transactions are taking days to upload causing people to redo their work multiple times thinking it didn’t work and then randomly a few days later transactions will go through causing me to have to go and delete them all since they’re duplicates at this point.

Anyone run into similar issues before using APAN or a sharepoint site to store tables?

submitted by /u/Rayzr117
[link] [comments]

Posted on

Unable to read records of Query

Hi, I am new to MS Access and VBA. I want to run a query and then compare values from one field of the results against a range say, 1-6. If the record value is matches any element of record then do nothing. Else, create new records for the range values which do no exist in result of query. I have tried many things in past two days based off goolge searches but I am still unable to solve this puzzle. Would be grateful for any guidance.

submitted by /u/lonealone1
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

VBA – fill down blanks sequential values?

Hi everyone. I have a column in a table that I need to fill with sequential values. I remember doing this a year ago, and I found a VBA script on the internet that allowed me to do it. I do not know VBA. Could anyone point me to a script that could do this?

In this example, I would need 8116 and 8117 to be filled in after 8115.

Thank you for helping!

submitted by /u/walkclothed
[link] [comments]

Posted on

VBA – fill down blanks sequential values?

Hi everyone. I have a column in a table that I need to fill with sequential values. I remember doing this a year ago, and I found a VBA script on the internet that allowed me to do it. I do not know VBA. Could anyone point me to a script that could do this?

In this example, I would need 8116 and 8117 to be filled in after 8115.

Thank you for helping!

submitted by /u/walkclothed
[link] [comments]

Posted on