Search Or Find Current Customers

Jul 8, 2006

Hi,
I have 3 tables
Customers
Tranasaction
Items

Linked togather, working fine.

Now I have setup one form where i enter each transaction details

Item details, customer details and transaction details

I would like create customer find function, which will check current records for that customer account no, if customer account does not exist then form will let me create a new customer.

can anyone please tell me how can i do that . thanks
I tried using combo box, but shows me record but does not let me enter new customer account no.

thanks in advance : )

View Replies


ADVERTISEMENT

Queries :: Find Customers Who Have Paid With More Than One Currency

Jun 9, 2014

I need a query to pick the bones out of sales transactional data like this...

Code:
CustomerName Currency
A Smith GBP
A Smith USD
B Jones GBP
B Jones GBP
T Brown GBP
T Brown AUD
C Wong GBP
C Wong GBP
S Giles USD
S Giles USD

From the above data, only A Smith & T Brown ...have made purchases in more than one (different) currency. How on earth do I trap that with a query? (or will it need a macro?)

If so, the table is called sales & the columns are as per the data above (CustomerName & Currency)...

View 14 Replies View Related

Query To Find Which Customers Have Birthday Today

Aug 13, 2014

Query which I want to create about finding the date of birth of the customer.

I explain:

I have a table (tblCustomers) which among others contains the field "DateOfBirth". I would like to create a query so that looking into tblCustomer about the dates where the month and day of birth of the client is the same as the Date () so that I know every day which customers have birthdays.

View 5 Replies View Related

Queries :: Query To Find Current Location?

Sep 16, 2014

I am attempting to build a small database for my firm to keep a track of equipment. The equipment can be in one of three places. In the warehouse, out on a job or at the repairers. I want to create a query that will let me know where a piece of equipment is at any one time. I'm sure my tables are set up correctly. I have use a union query to work out when equipment is on a job or in repairs but I need one to show me where all the equipment currently is.

View 1 Replies View Related

Forms :: Find Current Record When Moving From One Form To Another

Aug 7, 2013

Lets say,

Form A has fields: ID, LN and FN

ID LN FN
1 A F
2 B G
3 C H
4 D I
5 E J

Form B has fields: ID, LN and TR

ID LN TR
1 A Y
2 B N
3 C Y
4 D Y
5 E N

I would like to be able to switch between these two forms and the form automatically set focus to the record that I was on the form prior. Meaning if I am on record 3 on Form A and navigate to Form B, I would like to automatically set focus to record 3. Is this possible?

A possible issue after this gets sorted out is what happens if with the same scenario above record 3 does not exits? is it possible in that instance to simply requery the form?

View 11 Replies View Related

Search Or Find?

Jan 28, 2005

i have a table with the following fields.
Customer
Rig
Vessel0
Vessel0serial
Vessel1
Vessel1serial

How can i do a search for a particular vessel when every customer will have two of them?

Thanks,
Tim

View 3 Replies View Related

Problems With Find/search

Sep 20, 2006

Hi, i am relatively new to Access, I have Access 2002.

I have created a contacts form but have a problem when i click on the find button. I click on this to try and search for a companies contact information and the following happens:

I get a box appear saying.
Compile error, Variable not defined.


Underneath the error message the following is displayed and highlighted yellow:


Private Sub cmdFind_Click()
'Flag1 and Flag2 are Global variables
On Error Resume Next
Screen.PreviousControl.SetFocus
If Screen.ActiveControl.ControlType = acComboBox Then
DoCmd.OpenForm "frmFind", , , , , acDialog, Me.Name & "^" & Screen.ActiveControl.Name & "^" & Screen.ActiveControl.RowSource
'Flags are set by frmFind
Select Case Flag1
Case "FindFirst"
DoCmd.FindRecord Flag2
Case "FindNext"
DoCmd.FindNext
End Select
Else
RunCommand acCmdFind
End If
End Sub


Any help would be greatly appreciated, i have tried using the help option but it doesnt help me.

Please can someone help me????

Thanks
emma

View 2 Replies View Related

Right To Left Search/ Find Last Instance

Feb 20, 2006

Hi all,

I have some records containing the following data

ABC (UK)
ABC (UK) Ltd
ABC UK) Ltd
ABC UK)

I need to pull out all the data with a ) but not a ( and add a ( to the start of the word before the ).

So for example, the four examples above would change to:

ABC (UK)
ABC (UK) Ltd
ABC (UK) Ltd
ABC (UK)

I have selected the companies that need updating, and I can pull the data to the left of the ), but I don't know how to find the first instance from right to left of " ", or find the last instance from left to right of " ".

Can anyone help?

Thanks.

View 1 Replies View Related

Forms :: Search Bar Is Only Looking At Current Form And Not At Records

Jan 9, 2014

I have several forms in a navigation form. On all the forms, the little search bar at the bottom shows # of 103 records. On my navigation form it shows 1 of 1 and won't allow me to search.It would seem that the search bar is only looking at the current form and not at the records.

View 1 Replies View Related

Ms Access Search/find Command Button??

Oct 29, 2004

I have a MS Access database, and I have set up a form for users to input

name, address, ssn and other data. I have command buttons on the form

to print a record, add a record, delete a record and to exit. I tried the

search option, but with 50k records on a netwoek, it was to slow.

Is there a way to have a search on a command button, (Macro?) on

this form to allow our employees to search by name or ssn?

Thanks for your help.

View 5 Replies View Related

Creating A Search To Find Nearest Location

May 12, 2014

I have Territory Mgmt database. Sometimes when I get a new lead I need to quickly find other leads in the database that are closest to it.

I am currently not tracking latitude/longitude etc. Do I need to? Is there a way to set certain location marks by address?

If so, once I put in the latitudel/longitude how do I create a search to find the nearest?

View 14 Replies View Related

Queries :: Search Many To Many Relationships To Find Single Record

May 22, 2013

I am trying to use a query to search 2 many to many relationships but i keep getting duplicate results because each record is slightly different.

I have a table with cameras, another users and another formats. I have a table linking cameras to users and another linking cameras to formats so it looks somthing like this:

tblCameras - tblFormatlink - tblFormats
tblcameras - tblUserslink - tblUsers

When i add all the tables into a query i get loads of results as expected because i get a result for every possible combination.

What i want is when i search for all cameras that are suitable for a user who is a beginner is to get just a list of unique cameras. When i do that search at the moment i get a duplicate record for each different format the camera can do.

View 4 Replies View Related

Find Command In Access In One Report To Search Throughout Whole Database

Dec 7, 2014

Is there a way to use the find command in access in one report to search throughout the whole database. For instance, I am designing a database that in a report it shows the number identifier of an item, and the actual detailed information is located in a separate form. What I want it to do is to be able to find the detailed information from a command within the report that only has the number identifier.

View 2 Replies View Related

Forms :: Search Text Box For Specific Word - Find Option

Sep 18, 2013

I have 5 textboxes and a multiline textbox in a form in my Access Database. I am going to type several keywords in those textboxes and I am going to type an article in the multiline textbox.

What I need to do is I want to calculate the keyword density in the article. I can do that if i know how to search the whole text in the article and count the specific word. And I want a function to count all the words in the article too.

View 1 Replies View Related

Modules & VBA :: Input Box Search - Find A Record In Main Form

Jun 5, 2014

Input box Search problem. I have been using the following to find a record in my frmMain using an Input Box:

Private Sub cmdClientIdSearch_Click()
'Searches for Client by ID number
Dim rs As Object
Dim strCriteria As String
strCriteria = InputBox("Please enter Client ID" & vbCr & "Do not type leading zeros")

[Code] ....

It works great if I run it from a command button from frmMain. But, if frmMain is open and I run it from a command button on my switchboard, I get the following error message:

Run Time error 7951. You entered an expression that has an invalid reference to the Recordset Clone Property. I tried inserting a command to open frmMain in the first line, even before the two Dim statements, but I get the same result.

View 6 Replies View Related

Find And Replace Search Giving Either Ascending Or Descending Results

Dec 21, 2014

I have a DB and I have a button that triggers the find and replace. this will search over 100K entries and filter a specific client. The clients record can be 100's of entries.

This all works fine, but its always ascending and I have to scroll to the bottom for the latest record.

I can't set it to show Descending permanently as some employees can't cope with change. so...

I have a checkbox on my form for either Ascending or descending results. Is there any way I can get the find / replace to reference it, Or can I re-sort them after the search.

I've tried putting re-sort code on the 'find' button as lostfocus and mouseup but it doesn't work.

View 6 Replies View Related

Reports :: Dentist Schedule For Current Date And Search For Upcoming Appointments

Jan 26, 2015

I am trying to create a report for 5 different dentists schedule for their current date ( and also allow a search for upcoming appointments)...

I know it requires a query but im not to sure what direction to take as i have never created a report before...

What needs to appear on the query? im aware it would be all the fields i want on the report but do i need to make changes in the criteria etc..

I also dont really know how i can create a report for each dentist because i dont want to have 5 different reports.. is it possible to have the report set where i type the dentist name and select which one i require and then i can view their schedule?

View 1 Replies View Related

Queries :: Keyword Search - Find Field Names Of True Checkboxes

Jul 10, 2013

I've recently finished constructing a database that uses forms with checkboxes i.e. when a user opens a form there are several checkboxes associated with labels, but the table only stores the check-boxes and the form labels are the field (column) names on the table.

Now, what I'm trying to do is create a search feature whereby if a keyword search is conducted, a search through the column names from the table with checkboxes takes place and only lines (rows) with true (checked) checkboxes are returned.

View 12 Replies View Related

Modules & VBA :: Search SubDirectory - Find And Open A Folder Based On Text Box

Sep 8, 2014

I am 2 years into my database. I am trying to find and open a folder based on a text box. The problem is folder could be in many sub folders which is hold on our J: drive.

To further complicate, the folder i am searching may not be exactly as the text box states.

EG. Text box could say 123456 however the folder could be called M123456 etc.

How do i locate a folder or subfolder and open it based on part of a text box...

View 3 Replies View Related

Tables :: Find Record Button Added To A Form To Adjust Search Function

Apr 6, 2015

Is it possible on the Find Record button added to a form to adjust the search function so it defaults to a specific box on the form? I have a form for tracking employee's and on my Find Record button I would like it to default to the Last name instead of the Record number.

View 3 Replies View Related

Modules & VBA :: Unable To Search A String Within Subform To Find Information Stored On Main Form

Dec 2, 2013

I'm trying to search a for string within a subform to find information stored on the mainform to which the particular subform belongs.

The problem is that the subform is generated from a query which uses a number from the main form to generate.

So the subform record is only generated when the correct mainform record associated with it is loaded.

Now to solve my problem I've made a new query that brings up ALL the results that could be generated by the main form and from that I can search to find my search term I'm after and read off the ID number to tie it back to the mainform.

But all of this is done manually, I want a way to do all this using VBA in a way that the user can't edit any records as they are doing it.

View 3 Replies View Related

Search Record In Other Table And Show Result On Current Table

Apr 11, 2012

Actually I have a small form of customer details, that i made in excel, the field name mention below,

Customer Details Table
First Name
Last Name
Contact Detail
Address Detail

Postal Code
Last Purchasing Date
Remark

Now i want to make a search form like this

Search Form

Contact Details

& the result is show which I insert the contact number.......

View 1 Replies View Related

Modules & VBA :: Search CSV To Find Specific Statement / Text On Specific Line?

Jul 8, 2015

how to read a specific line in a CSV file (using VBA), to see if the phrase "There are no records available." is present.

If it is present, then I'm going to do a debug.print stating that there are no records to load - and then the script will move on to the next file. If the phrase isn't present, then I'm going to upload the file to Access, parse the information, and then upload it to a CRM. (I already have the latter portion of the code up and running....I just need to account for the first part, where I can determine if the file has data or not).

The structure of the file never changes. The first row is composed of eight column headers (Post Date, Card Number, Card Type, Auth Date, Batch Date, Reference Number, Reason, Amount) and (if) the phrase "There are no records available." is present, it will show up on the second row, in the first column (under Post Date).

View 3 Replies View Related

Creating A Call Log For Customers?

Mar 6, 2013

I need to make a DBA that will have 2 tables. One Has general Infomation name, address, phone, ect. Another that will log each call made to that customer. The purpose is to log everytime I speak to a customer and be able to determine using a qury who I have not called in a while.

View 3 Replies View Related

Keep History Of Customers Information

Feb 23, 2012

I have a table for my customers with current information.

CustomerID:0001
CustomerName: xxxxx
Address:xxxxxx
Telephone :xxxxxx
etc.....

But some time customers change their information. I want to keep their old information in other table. How it is possible?

View 4 Replies View Related

Keep History Of Customers Address

Feb 18, 2012

I have a table in my database for my customers. Sometime my customers change their address but I want to keep these changes in other table. How it is possible.

View 1 Replies View Related







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