my database lag whenever i start searching, not really bad but i could notice that it blinks whenever i press a key on my keyboard. computer has a big ram (4gb), i5, with 500gb HDD... lots of free space. the database file is only 6.9MB..maybe there is a code that disable or makes the blinking unnoticed?
View RepliesI have a database and would like to search history of some fields but they are autonumber and it won't let me search them.
The fields in question are on the form Workorder:
WorkorderID
CustomerID
I am looking to transfer a number of spreadsheets that I use to track IP Addresses to an Access Database, I have set up the tables and fields, what I would like to do is search for unused IP Addresses from populated table/fields.
View 2 Replies View RelatedI have built a basic database to hold details on all my computer books and software as i hundereds of them.
I have built a table with text, number and memo fields which i want to be able to search.
What i would like is a form where you can enter details into various fields (eg Title, Author, a field to search all fields, etc) and then display the results in a table in the form below it. Then when the record is double-clicked it opens the record ina new form displaying more details.
Is there a way to do it as i have spent months trying to figure it out and trying to include the sample databases?
I have attached my database so any help will be appreciated.
Thanks,
Aden
hi
does anybody done this project that posted below in little more advanced mode ?!
http://www.access-programmers.co.uk/forums/showthread.php?t=79612
I have a small search page that is very precise. ie. it returns the first record that is the same.
Is there anyway I can make a search form that is a bit fuzzy. ie if i had a field dedicated to the make of a vehicle can I filter it out for that make of vehicle. I've been using a filter, but it all seems rather messie.
Help
Regards
Asperation
PS, on the upside if there is anyone that needs help making a precise search page im happy to paste the code.
I was wondering if there is a program that allows you to do a search of your database.
For example, if i wanted to find out where im using certain queries, is there a way to do a "ctrl+F" for access ?
I want to know how to create a test box one or more than one and can search with a button. I did that but I have to fill all the text box to have a result and i want to know how to search even if i did not fill all the text box ...
View 2 Replies View RelatedHi there,
I am designing a search tool for a database table which has attributes such as part number, manufacturer's part number, description, etc. Each item in the database has all these attributes associated with it.
When I search, I am trying to allow a popup to occur when I want to access a modified report that has my search results computed. I created a query and a report, added some SQL code to it, etc. I can basically click the report and have my inquiry window come up asking for the part number, but I'm not sure if it's associated with my database because when I put in the #, the report comes up blank.
I right-clicked my Report and look under "Objects that I depend on" and my Queries tree is full of dependencies that point me to my database table. There is, however, still no report with any substance that I can pull up no matter what part # I put in.
Does anyone know what's going on? I know this is really easy and it's driving me crazy cause I've never used Access before. I don't necessarily have time for tutorials and any lesson enrollment since it's for work, and my profession has absolutely nothing to do with this. Ha.
Thanks for any help you may be able to offer.
Richard
I have a requirement of searching the database based on 3 columns. I have attached the search form and the code.
Private Sub cmdSearch_Click()
Dim strSQLHead As String
Dim strSQLWhere As String
Dim strSQLOrderBy As String
Dim strSQL As String
Dim strJoin As String
[Code] .....
I would like to filter a table with 3 fields: Name, Surname, and Chart number.I would like to have the results in a subform designed in the same form.In fact every patient can have several admisions (1, 2 or more).I have arranged the main form named men with 3 text unbound box (name, surname, CCN) and 2 button clear and run the query.I have created a query .The problem is that when i push the button the SQL starts and a different window is opened. I would like that when you type the name for example in real time the subform should select the record with that criteria. Moreover I would like that when in the subform appears the records with the criteria the users could click on the selected record to open a different form.
View 3 Replies View RelatedI already have many table for each month , JanuaryT-DisemberT. I'm using simple form to key in data inside that table. Inside to that table (JanuaryT-DisemberT) have project number data i want to notice pop up when i try key in if that project number not valid..
example
JanuariT
Name -Project Cod- Validation
John -2012ABC - Not valid
Michel-2013WER-Valid
Mike-2014TERG-Valid
FebruariT
Name -Project Cod- Validation
Ann -2011AAA - Not valid
Sam-2012BCB-Valid
Tony-2013TEC-Valid
What i want to do is when i want to key in data in MacT using Form with ADD butoon, some notice will come out if .... for example : Daniel-2011AAA or Jony-2012ABC the notice will come out " THIS PROJECT COD NOT VALID, PLEASE CHOOSE ANOTHER COD". it something like notice to tell me that project cod already not valid yet. It look like "automatic searching" data for every table. It Is possible to do like this?
1.
i create a form and i want do do the searching in it so i but a button and combo box and the list box to show the results and the searching is from query
my form name is form2 and the button name is search and the combobox name is combo212
2.
how can i show the total in the charts in access like i create a chart for students and years so every year i know how many student in and i want to know how to sum all the student in all the years ans show it in the chart?
3.
i create a tow search combobox and button the question is how can i siprait the searching from the tow combobox like i search for the interest in the first combobox and the seacond one is for the years but i want to search for the interest in all years i tray it but it sis not work with me so how i can do it
4.
how can i add data to the combobox without going to the table ?
Function that searches modules for instances of early binding? Im sure i could write one, but why reinvent the wheel?
View 2 Replies View RelatedI'm wanting to create a way of searching through and displaying a large number of pdfs. These will be of different lengths and most will have images embedded in them. Each pdf will be categorised using a variety of fields to enable fairly sophisticated searches. I then want to link this database to a Joomla CMS website.
View 6 Replies View RelatedI have a database in which the year is stored in a table called year with as laid out below
"YearID" autonumber field and the
"Year" field which is a date field.
I am trying to search for records via a query for just the current year, i.e. the highest autonumber and I am having no success.
I want to have a list box, which is populated with information from a table/query, to 'filter' what it displays based on what i type in a text box, but i need it to search multiple fields. E.g. say I have a field called name and another called address, and say there are 3 johns in the name field of the table, i want the list box to filter all the other names out and just show me the johns and update automatically. but using the same text box i would like to also be able to search addresses and filter them.
code for the 'On Change' event of the text box to reload the query in the list box. I need to put in the 'criteria' section of the query, i have sound this so far but unsure if its right for every field in the query:
LIKE "*" & [Forms]![Form1]![txtSearch] & "*"
Database: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
How to add the IM Gtalk to my database.I have daily queries running and want to send ta IM to some employees when it is done for them to proceed with normal work. Yes you can do it by email, but normally there are so many emails they will miss it.
View 1 Replies View RelatedI have Access 2013, part of office pro, and for some reason it now cannot create a new database, ie nothing is created where i told it to It then comes up with "cannot open a database created with a previous version etc".This is NOT a previous version, it physically does not exist.This did work, well last week.Tried doing an office repair, no differance, tried delting system.mdw.If i click OK on previous message, i do get "Close ole server and restart it outside of access"
View 3 Replies View RelatedI'm trying to change database name, and not the one in database properties and changing the title. I've done that already.
View 8 Replies View RelatedThe database I am working with suddenly says that is ready only, and I cannot make changes! How can I make it not read only?
View 2 Replies View RelatedI have been asked to develop a new application (not using Access).I have the original Access Database and while I can get the data out I was wondering how I can get the images out of the database.
View 1 Replies View RelatedI want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products).My client needs to routinely send me lists of tests and the products that are in each test. I then need to put this information in to my database
I don't want to type out the information they send me, instead I want to devise a simple form for them to complete and email to me (perhaps in excel) that they populate, and I then import/paste in to my database.How should the excel form be structured so that it is both easy for my client to populate and easy for me to import/paste in to my database. e.g. importing lots of test and product information, rather than type it in. Bearing in mind the 1:M structure.
I have a database (already splitted in FE/BE) which Clients use on site.Part of the service we offer is Outsourcing: We do all the capturing and when they login on their side, it downloads the latest BE file for them to use "Read-Only".
However we added a new module in which half of the data on a particular table needs to be completed by the Client.So we need for the table to be splitted in such a way that they can capture their info on the form and when we log in on our side, it has to download the data they entered in the same way as when they login and download the data we captured.
Was thinking about adding a 3rd database file to the mix with just one table and in some way link that table to the existing table for the new module. But the intermediate link I created is not updateble.