Forms, Queries And Reports (Searches)

Jul 16, 2007

HI folks

I have a db. I have created a search form which when you click the search button executes a query to find the required records.
The query is currently outputting to printpreview of the query.

What i want to be able to do is have the option to select the correct record and then print it. The search can either be exact and return 1 record or use a wildcard and return a few records.

I have the report setup and working I just can't for the life of me figure out how to link everything.

Maybe I've missed something I don't know.

View Replies


ADVERTISEMENT

Queries :: Wild Card Searches With Brackets

Jun 26, 2014

I want to prompt the user to enter a merchant name, but want the results to return close matches.I know how to use the wildcard in the Criteria field of the query, but I want to use brackets.I know that "*Southwest*" Will return Southwest Airlines.So I tried *[Southwest Airlines]* and it treats the criteria like a text string.

View 1 Replies View Related

Make A Querie That Searches For Other Queries That Contain A Certian Word

May 10, 2007

ok, i wanna make a query that will display the information from other queries containing the word "complete" in their title. All of these queries have the same columns names to them so they should fit together nicely but if someone adds a new query in the future with the word "complete" in the title i want this query to pick it up. Is this possible?

View 9 Replies View Related

Queries :: Performing Keyword Searches Of Text Field

Nov 16, 2014

I am trying to perform some keyword searches of a text field. My preferred option would be to hold all the keywords in a separate table and then use something like

SELECT * FROM Text Table, Keywords Table WHERE (((InStr[Text Table].[Text],[Keywords Table].[keywords])) > 0 ));

This works and returns anything which has the string from the keyword table, however I wanted to look for whole words only. I can do this in SQL using a regular expression along the lines of [!a-z] keyword [!a-z] which only finds the string where it has no letters directly either side of it.

What I would like to do is combine the two methods so I hold my keywords in a table and then use them with the reg ex to find whole words only.

View 6 Replies View Related

Newbie To Searches Through Forms

Oct 13, 2005

I have a form with a search text field, inwhich i want the user to type in a value to the search text and then I want a query which would search two tables and return which table the results in. i.e

Form:
Search Text Field ----> ABC12345

Table 1
Date
Container Number -----> No Record of that number

Table 2
Date
Container Number ------> Number Found

Result of Search

Date
Container Number ABC12345
Table 2

Can any one advise how to do this??

View 4 Replies View Related

Forms :: Limit Searches To One Text Box

Sep 19, 2013

I have a db with around 400 records. It contains user's basic information such as first name, last name, supervisor...

Problem is that one supervisor can be multiple users supervisors so they are showing up a lot each time I use the search tool. Is there a way to disable searches on the supervisor field?

View 1 Replies View Related

Reports :: Print Out Single Page Reports (or Forms) To Show Detail From Several Tables And Queries

Apr 21, 2014

I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.

View 2 Replies View Related

Forms :: Combo Box Query - Form That Searches A Table To Show Certain Criteria

Jul 21, 2014

I have created a form that searches a table to show certain criteria. I am having trouble with a part where the table uses a checkbox and I am trying to use a combo box on the search form to return the results based on is it checked? Yes/No or both. When I test it I keep getting Runtime error 3075 missing operator.

The sql I am using is below and when I try and see where it is going wrong it highlights the line.

Code : Me.Filter = strWhere

Code:
Private Sub cmdFilter_Click()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "#dd/mm/yyyy#"

[Code] .....

View 1 Replies View Related

Linking Queries To Reports From Forms

Sep 8, 2004

I KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?

Please help!

View 1 Replies View Related

Newbie Question – Forms, Queries And Reports

Feb 15, 2006

Hi All,

I’m completely stumped … could be because its so late or my brain has just decided to give up on me!

Short of not going into too much detail, could someone advise … does one HAVE to create a query in order to create a report based on a form OR can one create a report based solely on a form?

Is there a right way and a wrong way ... ?!?!

Hope someone can help me ... thanks in advance.

View 2 Replies View Related

Forms Instead Of <Variable>: [Prompt] In Queries/reports

Mar 30, 2005

Ok, so now this is where it's getting more complicated... (though I guess this is where you guys usually start)

When you have a query, and you type in your inputbox thingy like so:
http://reenen.fateback.com/image.jpg

PeriodEnd: [Enter period end date dd/mm/yyyy: ]


And you can have multiple, then it will prompt you for several of them.

Now this is not very tidy, so I'd rather do it on a form. How can I display the form as the query/report runs, and insert the values entered into the form as the inputs into my variables? (This case PeriodEnd)

-Canderel

Grrr... I can't get the image to display.

View 11 Replies View Related

Copying Numerous Forms/queries/reports

Jan 10, 2005

I have a problem that is very tedious. I have 9 separate copies of the same databse (there is a copy of each database for every branch of my company. Each database has small custom features that show what company it belongs to) i was told to make a new feature, and in the making, i had to make 40 new queries, 12 new forms 8 new macros, 12 new macros and 6 new forms. this feature needs to go into all of the databases. As far as i know, im going to need to copy and paste each individual query,form, macro and form. Thats 72 different things i will have to copy and paste into 9 separate databases. Does access provide an easier way to go about this?
any help?

View 4 Replies View Related

Tables, Queries, Forms, Reports And Modules Have Disappeared

May 24, 2006

Good morning All.

I have a database which updates via a Function in a module every morning (i.e imports and exports data).

Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.

When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.

When I selected the Tables tab the following message appeared:

Operation Invalid Without Current Index

this was then followed by another message:

"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names

This also appears if I try selecting the other tabs i.e. Queries, Modules etc.

The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.

Does anybody have any idea of how I can sort this out?

Regards

Chathag :confused:

View 1 Replies View Related

General :: Securing A Database / Can't Edit Forms / Reports / Queries

Jan 21, 2014

I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc.I'm splitting the database, making an ACCDE for users:

1. I inserted code to disable the bypass key.
2. I inserted code to hide the Quick Access Toolbar (QAT) in the On_Load sub of the form that opens with the DB.
3. Deselect Navigation Pane, Allow Full Menus and Allow Default Shortcut Menus are deselected
4. Then, I use the immediate window to show the QAT, I then create an ACCDE.

How do I link this ACCDE with the original ACCDB? Am I supposed to delete tables from the front end and link the forms/reports to the back end DB?

View 7 Replies View Related

General :: Naming Of Tables / Queries / Forms And Reports For Identification

Sep 22, 2013

Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?

View 1 Replies View Related

Searches

Aug 3, 2006

Hello,
I am creating a database for a client and have come across a small problem.
The basic background of the database is that it will be used to record and maipulate the results of observations that are conducted on members of teaching staff.
The client wants the ability to search for people that have not had an observation or have an outstanding observation. The observations are made on a termly basis (so there are three terms. 1, 2 and 3). When an observation is entered into the database, the term number is selected from a drop-down box.
I was woundering if anybody could help me with this as I am unter the impression that I am going to need to search for records that don't yet exist and I am unaware of how to do this in a database.

Any help will be much appreciated.

Many Thanks
Jason.

View 1 Replies View Related

Speeding Up Searches

Mar 18, 2008

My Access DB has two Number fields and five Text fields (each having field size of 200). They contain text. The DB is organised year-wise. I have now crossed 15000 records. I find that the search is very slow. Search is done on all these text fields for each word typed. Some one suggested that I index the fields to speed up the search. When I tried to change the indexes to Yes, it didnt accept. Is there any other way to speed up search?

As an alternative, I created an append query to append records of the year I select in my form to another table so that I can search that table instead of the main table which contains all years records. But the append query is not appending records.

Any solution would be appreciated

View 1 Replies View Related

Boolean Searches? Possible?

Jun 21, 2005

I have a search tool, but right now it is 100% case sensitive in the sense that if i search for "test" and my entry is "Test" it will not return any results.

is there any way to setup so I could say search for "Test" and it would find "test" properly? Or even to the extreme where I searched for "Tes*" and it came back with the "test" entry.

Thanks,

View 8 Replies View Related

Item Searches

Jul 6, 2005

Hi everyone i was just wondering if anyone new how to do the following;

Data is entered into a text box named txtItemNo on exit a search is performed and the next textbox txtDescription displays the results.

There is a table with itemnumber and item description in it the results would be the description.

Any ideas? This is on a subform, dont think this amkes any difference though
Thanks in advance :)

View 2 Replies View Related

Combo Searches

May 25, 2006

Hi Guys,

I apoligies in adcance, this has probably been asked several times, but I tried searching the forum but couldn't find anything.

Just now I have a report running from a query were a name is input, the data is pulled out the table and is presented in the report.

I want to take out the potential for user error by having them select the name from the drop down and then running the search.

Years ago (I'm a little rusty) I managed to figure it out, but for the life of me I can't remember!

Any ideas?

Thanks

Steve

View 2 Replies View Related

Mutlpe Searches For One Query?

May 11, 2005

Hi, in my attached databas ei have a form. If you look at the form you can see what it does. Where it pulls records for a student, i would like another button, that when pressed, will search all records for that student, with these records it will, then scan all the dates and the attended field. if the attended field for one date is all absent it will return the number 1, if theres two date where the attended field is all absent it will send back 2 and so on... the number will be outputed to a textbox

any thoughts
Thanks
Chris Lynch

View 2 Replies View Related

Wild Card Searches

Jun 22, 2005

Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query:

[Forms]![Search]![BoxNo]

So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13.

How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:

View 4 Replies View Related

2 Issues With Combo Box Searches...

Oct 10, 2006

Hello, here goes...


#1

I have a form with a combo box to be used for navigating to records (created using the wizard), based on a query with these fields:
1 - Last Name (Sorted Ascending)
2 - First name (Sorted Ascending)
3 - Company
4 - CustomerID (PK)

The combo box only partially works, it pulls up a list, but here is the problem:

If the name comes up 'Hartman, BillyBob', and there is only one Hartman, then all is well.

But if you have several Hartmans, say:

Hartman, Ace
Hartman, Bob
Hartman, Stan

and say you try to select Bob, it always goes to the first Hartman in the list (in this case Ace).

It is a pain in the ace, what am I doing wrong? Thanks for any help...

(I will ask #2 after this is resolved)

View 14 Replies View Related

Disable Wildcard Searches

Jan 30, 2008

Code:If Me.Search_Criteria_textbox = "*" ThenMsgBox "Please enter a full part number" & vbCrLf & "Wild cards are disabled", vbCriticalGoTo Exit_cmdSearch_ClickEnd If

This is the code I am using to stop * wildcard searches and it works fine. My problem is when users enter partial number enclosed like this *1345*.

Is there a way like above to stop them from entering that?

Thx!

View 2 Replies View Related

Adding Multiple Searches In Where Condition

Oct 16, 2013

I currently have this for my where condition, and searches the form based on the clientID selected in the combo box.

The catch now is i have to add another search.

="[ClientID] =" & [TempVars]![ActiveControlValue]

now i have to also search [ProductID]

The combo Box is set up like this:

ClientID....ContactName....ProductName....ProductI D
Hidden.....Visible..............Visible........... ..Hidden

How can i add [ProductID] into the existing where condition to add an additional parameter?

View 4 Replies View Related

Form That Searches Query With 30+ Linked Xls Files

May 4, 2006

I've been looking around and have found some posts that pointed me in the right direction, I just can't get it to work. What I have is 37 excel files of competitor cross references. There are 2 columns in each excel file, our number and their number. I have inserted them as a linked table in the db. What I want to do is create a form that has a field for every part number and make all of those fields a search field. That way they can type in any number and get all numbers back. I have created a query but once I get past 4 linked excel sheets then I get errors about a type mismatch in expression. Also I can't get the form fields referencing the query to show up when I open it. If I leave the query at 2 or 3 fields and use [Forms]![CrossRef]![txtItemNumber] in the criteria of our number in the query, it works. I get a window that pops up when I just open the query asking for a number, I type it in and the query returns the number and competitor numbers. Am I doing this the hard way?? Thanks for any ideas...

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved