office 365 home access 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2254706%22%20slang%3D%22en-US%22%3Eoffice%20365%20home%20access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2254706%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20database%20with%20over%2012000%20records%20the%20input%20data%20table%20is%20fine.%20when%20i%20run%20a%20query%20i'm%20no%20longer%20getting%20a%20popup%20window%20as%20a%20search.%20i'm%20looking%20for%20someone%20to%20walk%20me%20thru%20the%20creation%20of%20a%20pop%20up%20window.%20i%20have%20spent%20two%20weeks%20on%20this%20and%20have%20nothing%20to%20show%20for%20it.%26nbsp%3B%20i'm%20not%20even%20able%20to%20get%20a%20tech%20on%20phone%20from%20microsoft%20so%20that%20the%20database%20could%20be%20shared%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2254706%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2254941%22%20slang%3D%22en-US%22%3ERe%3A%20office%20365%20home%20access%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2254941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1017530%22%20target%3D%22_blank%22%3E%40trifectapete%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20by%20%22popup%20window%22%2C%20you%20are%20are%20referring%20to%20the%20dialog%20box%20which%20opens%20asking%20for%20a%20parameter%20to%20a%20query.%20I%20don't%20use%20them%20because%20it's%20usually%20more%20user%20friendly%20to%20offer%20users%20a%20combo%20box%20on%20a%20form%20as%20the%20parameter.%20That%20means%20the%20user%20only%20has%20to%20select%20a%20valid%20value%20from%20the%20list%20in%20the%20combo%20box%2C%20not%20remember%20and%20type%20in%20the%20exact%20word%20or%20date%20they%20want.%20However%2C%20to%20address%20you%20specific%20question%2C%20the%20query%20should%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESELECT%20field1%2C%20field2%2C%20field3%3C%2FP%3E%3CP%3EFROM%20YourTableNameGoesHere%3C%2FP%3E%3CP%3EWHERE%20field1%20%3D%20%5BEnter%20the%20right%20value%20for%20a%20parameter%20here%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%2C%20for%20some%20reason%20that%20WHERE%20clause%20has%20been%20removed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can't%20find%20and%20fix%20the%20problem%20from%20this%20overview%2C%20you%20can%20upload%20it%20as%20an%20attachment%20for%20someone%20to%20look%20at.%20Remove%20any%20sensitive%20or%20confidential%20data%20from%20a%20copy%20of%20the%20accdb%20for%20upload%20if%20you%20want%20to%20do%20that.%20Leave%20only%20enough%20sample%20data%20to%20illustrate%20the%20requirement.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i have a database with over 12000 records the input data table is fine. when i run a query i'm no longer getting a popup window as a search. i'm looking for someone to walk me thru the creation of a pop up window. i have spent two weeks on this and have nothing to show for it.  i'm not even able to get a tech on phone from microsoft so that the database could be shared

3 Replies

@trifectapete 

 

I assume by "popup window", you are are referring to the dialog box which opens asking for a parameter to a query. I don't use them because it's usually more user friendly to offer users a combo box on a form as the parameter. That means the user only has to select a valid value from the list in the combo box, not remember and type in the exact word or date they want. However, to address you specific question, the query should look like this:

 

SELECT field1, field2, field3

FROM YourTableNameGoesHere

WHERE field1 = [Enter the right value for a parameter here]

 

It sounds like, for some reason that WHERE clause has been removed.

 

If you can't find and fix the problem from this overview, you can upload it as an attachment for someone to look at. Remove any sensitive or confidential data from a copy of the accdb for upload if you want to do that. Leave only enough sample data to illustrate the requirement.

 

 

 

 

Hello my name is Peter Salerno contact number is in the USA 1-727-400-6157. Office 365 This database has a table of 12000 records. Having a few issues on how to do things. My resources have been online,access for dummies and access part-1. If there is a fee for service just let me know.

Main Team Query Form KEEP (Option 1-7) When this query is run the options window opens. From here if By Spread Number Keep (Option-1) is selected the error window opens and if ok is selected the window closes, I would like to be able to have a dialog box popup and offer me a search by the All Team Data Main 12k records KEEP table. A search by Spd field name and then a print to screen report.
Would like to be able to select option-2 from the menu and have a search window open a be able to search the following all games (all records) fav or dog (Fav/Dog) field name (SW or SL) field name and then a print to screen report all Field name would be found in the All Team Data Main 12k records KEEP table.
Would like to be able to select option-3 from the menu and have a search window open and be able to search the following all Team table (team names) Fav/Dog field name and HorA field name found in the
All Team Data Main 12k records KEEP table. and then a print to screen report
Would like to be able to select option-4 from the menu and have a search window open a be able to search the following (Team vs Opp) team and opp field name and O/U field names found in the All Team Data Main 12k records KEEP table and then a print to screen.
Would like to be able to select option-5 from the menu and have a search window open a be able to search the following (Team vs Opp) team and opp field name all field names found in the All Team Data Main 12k records KEEP table and then a print to screen.
Would like to be able to select option-6 from the menu and have a search window open a be able to search the following (O/U) and (TPL) field names are all found in the All Team Data Main 12k records KEEP table and then a print to screen.
Would like to be able to select option-7 from the menu and have a search window open a be able to search the following (any team report) All Team Data Main 12k records KEEP table and then a print to screen.
not sure on how to upload database

@trifectapete 

Unfortunately, a minor health problem is preventing me from staying on line today. I'll see if I can't get someone else to step in. I apologize.

That said, you are using terms that come from your own specific work environment, but which mean little to someone outside, e.g. "Main Team Query Form KEEP (Option 1-7) " and " By Spread Number Keep (Option-1)". You know what you mean by "KEEP (Option 1-7)" and "Spread Number Keep" but, of course, no one else can know that. It's better to explain using more generic terms that anyone can relate to. Even more useful will be an example of the actual SQL from that query. 

 

That said, I'm off to try to get into the clinic, but before I go I'll drop a request to see if someone can't step in.