School Survey

School Survey

Hey guys, I have a school assignment which requires me to use data which we collected through surveys and input them into databases on Access. One of the requirements of the survey was to find out the average amount of sleep a student gets each week, taking in account each day, and so I formatted the requirement into the question shown in the image below.

I am quite new to Access, so pardon me if this is something quite simple, but what I want to do is input the question as one field in the Access table.

Is it possible, or will I have to split the question into seprate days in order to input the data into Access?

https://i.redd.it/k173zee6d6u21.png

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

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Why is it called "Record Selectors"?

Here’s a question for everyone. Each form has a “Record Selectors” property. Why is it called “Record Selectors” if the form only has one record selector? Shouldn’t it be “Record Selector” instead?

(These are the kinds of questions that keep me up at night.)

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

Posted on

Specific Relationship scenario question

I run a roofing contracting business and I’m trying to transition from using Excel to Access but I’m having problems understanding how to get this situation to work.

We work on multiple Building Projects, each Project has multiple houses, each house has multiple orders made for it.

I understand how to set up a one to many relationship for a basic Customer table to Order table relationship, but I can’t seem to figure out how to set one up in my situation.

‚Äč

I’ve been scratching my head trying to work this out for 2 days now, could anyone offer some help on what tables and relationships to set up? Thank you

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

Posted on

Neutral table between temporary and actual table?

I have 3 tables: 1. temp 2. Brief 3. attachment

Temp table is used to import Excel data into the database and allow people to review / edit before appending to the brief table in other words, validate so doesn’t import crap and once the data is validated, that table gets deleted.

While the user is on the form that’s connected to the temp table. I want them to be able to add information to the attachment table but no sure what would be best way to connect them.

The brief table is on the back end (external database) and is multiple users setup so I can’t have the temp table (which is local) auto generate ID numbers since it might already have that number on brief table by the time the user hits submits.

My question is, what would be the best way to connect via relationship my temp table to the attachment table so when it gets appended to the brief table, I can identify that it was temp table and now is on brief table.

Worth mentioning that the brief table is connected to the attachment table in one to many relationship.

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

Posted on

Query with changeable date inputs not retrieving any/correct records.

I’ve created a database for our warehouse staff to log what xray screening they do. Got all the data being input correctly including two fields, one for what date and time they started screening and one for what date and time they finished.

The time is required – we need to monitor how long they spend screening.

I’ve then set up a query to pull out information from The main data sheet based on the screeners name and whether it passed or failed. Plus the two date fields.

The search boxes (combos and date selectors) are in a main form, the data is displayed in data sheet form in a subform.

Now for retrieving the data we don’t need to specify the time just what date it occurred on.

This is where I’m running into trouble.

Every time I select any type of date it displays no records.

I’m using the query builder with where criteria. I’ve looked around online and read about using >= etc but it doesn’t work. I’ve tried adding # but it throws a fit about it not being a proper date format. I’ve tried () no (). I’ve tried BETWEEN.

A lot of online solutions seem to assume I want the query to always run with specific dates – I don’t, I need it to run with whatever dates are selected in the main form.

I did have some isnull criteria to force the form to display all records if no criteria was selected. But I’ve removed a few of them as I think they were unnecessary and possibly confusing the query.

It’s really frustrating me. This is one of the last steps I need to complete before I hand it over to the screeners for testing and it’s taken me long to not find a solution than it has to build the rest of the database on the first place!

I’d like to stick with using the query builder if possible but if I absolutely have to I’ve got very basic understanding of VBA.

Thanks!

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

Posted on

Populate range of dates in a table

Hello everyone,

I have a form with 2 text boxes with start and end date. Also I have a table with 5 columns and the only empty one is the column with the dates. My goal is to have a table with as many rows as the dates that are between those dates in the form, and all those dates to be in the date column, and the other columns to have their standard values. How to achieve this?

Thank you!

submitted by /u/Akis-73
[link] [comments]

Posted on

What would be the best approach for a macro that updates a form field to a string of text if ANY of the form fields have anything input into them or updated?

I know what I could add an After Update macro for every single field so that a change to the field will cause “In Progress” to be reflected in a given field, but is there an easier way? Is there a blanket kind of form macro that I could set up like this if ANY of the fields of the current record were updated?

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

Posted on

Anyone have any good code to lock a database so that folks I share it with cannot unlock said code without some kind of password?

Presently, before I distribute my Access database (which largely a set of forms that folks fill out), I open up the Access Options, navigate to Current Database, and disable “Display Navigation Pane” as well as “Allow Default Shortcut Menus.” Savvy folks could figure out how to enable these again. Is there away that would prevent someone from making changes to the user tool that I can bake in? Maybe password protection of some kind? I’m definitely open to anything beyond what I am currently doing.

THanks!

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

Posted on

Query with changeable date inputs not retrieving any/correct records.

I’ve created a database for our warehouse staff to log what xray screening they do. Got all the data being input correctly including two fields, one for what date and time they started screening and one for what date and time they finished.

The time is required – we need to monitor how long they spend screening.

I’ve then set up a query to pull out information from The main data sheet based on the screeners name and whether it passed or failed. Plus the two date fields.

The search boxes (combos and date selectors) are in a main form, the data is displayed in data sheet form in a subform.

Now for retrieving the data we don’t need to specify the time just what date it occurred on.

This is where I’m running into trouble.

Every time I select any type of date it displays no records.

I’m using the query builder with where criteria. I’ve looked around online and read about using >= etc but it doesn’t work. I’ve tried adding # but it throws a fit about it not being a proper date format. I’ve tried () no (). I’ve tried BETWEEN.

A lot of online solutions seem to assume I want the query to always run with specific dates – I don’t, I need it to run with whatever dates are selected in the main form.

I did have some isnull criteria to force the form to display all records if no criteria was selected. But I’ve removed a few of them as I think they were unnecessary and possibly confusing the query.

It’s really frustrating me. This is one of the last steps I need to complete before I hand it over to the screeners for testing and it’s taken me long to not find a solution than it has to build the rest of the database on the first place!

I’d like to stick with using the query builder if possible but if I absolutely have to I’ve got very basic understanding of VBA.

Thanks!

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

Posted on

School Survey

School Survey

Hey guys, I have a school assignment which requires me to use data which we collected through surveys and input them into databases on Access. One of the requirements of the survey was to find out the average amount of sleep a student gets each week, taking in account each day, and so I formatted the requirement into the question shown in the image below.

I am quite new to Access, so pardon me if this is something quite simple, but what I want to do is input the question as one field in the Access table.

Is it possible, or will I have to split the question into seprate days in order to input the data into Access?

https://i.redd.it/k173zee6d6u21.png

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

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on