Go Back   Access World Forums > Search Forums

 
Showing results 1 to 18 of 18
Search took 0.00 seconds.
Search: Posts Made By: templeowls
Forum: Queries 06-20-2019, 11:49 AM
Replies: 12
Views: 285
Posted By templeowls
Re: Can a single query parameter allow multiple entries?

That actually worked! I was being really dumb and putting the Where code in design view, and not SQL. Thank you!
Forum: Queries 06-20-2019, 11:23 AM
Replies: 12
Views: 285
Posted By templeowls
Re: Can a single query parameter allow multiple entries?

For simplicity sake, we can keep it as numerical, as I would like to be able to search the ID as well. Plus that is what the blog post is focused on. I again repeated the steps but am still getting...
Forum: Queries 06-20-2019, 11:06 AM
Replies: 12
Views: 285
Posted By templeowls
Re: Can a single query parameter allow multiple entries?

What do you mean? I followed theDBGuy's article exactly and used the Solution #2 code, but I got a syntax error. Plus, I am not looking to use a list box. There are thousands of employees. Being able...
Forum: Queries 06-20-2019, 07:42 AM
Replies: 12
Views: 285
Posted By templeowls
Re: Can a single query parameter allow multiple entries?

I added in his Solution 2 code and I am getting a syntax error....Can't really figure out why
Forum: Queries 06-20-2019, 05:00 AM
Replies: 12
Views: 285
Posted By templeowls
Re: Can a single query parameter allow multiple entries?

Cross posted here btw: https://www.accessforums.net/showthread.php?t=77311
Forum: Queries 06-20-2019, 05:00 AM
Replies: 12
Views: 285
Posted By templeowls
Can a single query parameter allow multiple entries?

For instance, if I have a query parameter set up for "Employee Name:", is it possible to build it in a way that lets me input "Smith, Johnson" and it pulls up all entries will Smith or Johnson listed?
Forum: Reports 06-19-2019, 04:39 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

So is there a way that after selecting those entries, you can run a report that shows them?
Forum: Reports 06-14-2019, 10:21 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

I did check out the link, but I'm not sure how that applies to running a universal report from various IDs
Forum: Reports 06-13-2019, 08:51 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

So locations refers to our stores. We have 18 stores so it could 1 of 18. And we have a form where users look at an event in its entirely. So basically users "control+f" and type in an employee's...
Forum: Reports 06-13-2019, 07:53 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

And I can't post the crosspost link, as I haven't posted to required 10 posts yet
Forum: Reports 06-13-2019, 07:50 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

That's what we do now, but the issue is the reports are never standardized. Basically when a manager does this, they create a new report and it's always different than one before and after it.

Is...
Forum: Reports 06-13-2019, 05:15 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

Sorry didn't realize that wasn't allowed. I'll try to delete the other one
Forum: Reports 06-13-2019, 04:49 AM
Replies: 20
Views: 647
Posted By templeowls
Re: Report that prompts ID number, and then creates report based on that ID(s)

It's a rather simple table. There are 8 columns in the table:

- Access generated ID
- Date & time of event
- Submitted by
- Event Type (complaint, injury, etc.)
- Location
- Employee(s)...
Forum: Reports 06-13-2019, 04:27 AM
Replies: 20
Views: 647
Posted By templeowls
Report that prompts ID number, and then creates report based on that ID(s)

So basically I have a table with thousands of events (complaints, injuries, compliments, etc.) for our retail stores.

I'm looking to create a report with a standardized format that shows the...
Forum: General 06-13-2019, 04:07 AM
Replies: 7
Views: 200
Posted By templeowls
Forum: General 06-12-2019, 03:32 AM
Replies: 7
Views: 200
Posted By templeowls
Re: Create a query from two tables that autofills column

When I do that, I get the error "Cannot join on Memo, OLE, or Hyperlink ([Events].[Store Locations]=[Managers].[Store Locations])"
Forum: General 06-11-2019, 10:14 AM
Replies: 7
Views: 200
Posted By templeowls
Re: Create a query from two tables that autofills column

Link the LocationID from Table 2 to what? This database is likely not perfectly set up to adhere to Access' standards, but has always performed what we needed up to now. I don't want to redo the...
Forum: General 06-11-2019, 09:13 AM
Replies: 7
Views: 200
Posted By templeowls
Create a query from two tables that autofills column

I have retail stores with a database that tracks events from the locations.

I have two tables:
Table 1: houses all the events and the data associated (location, date, description, etc.)
Table 2:...
Showing results 1 to 18 of 18

 
Forum Jump



All times are GMT -8. The time now is 08:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World