I 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 Relatedmy 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 3 Replies View RelatedHi
I have 2 fields - "Balance" and "Date" - each time data in the "balance" field changes, the "Date" field updates to todays date (thanks to help from Kiwiman in the forum earlier).
I now need to keep a history/log of all data input into balances and the dates.
The new field to store this information is called "Balance History". so an example of what i want to end up with would be
01/01/08 300.00
01/02/08 250.00
12/02/08 210.00
Any help would be greatly appreciated
Thanks
Geoff
Is there a way to create or access a history file of all events in a database?
View 1 Replies View RelatedHow to extract the comment system from the Contacts Web Database template found in Access 2010? I can upload it if you like.
I would like to use it in a standard desktop database to track notes and comments in my records.
I am able to convert it from web to standard, but it still appears to use data macros or something, and my knowledge on macros is limited.
I just want to keep a history of my notes for each record, with the most recent always listed, and the comment system in the Contacts Web Database template seems perfect for that. I just don't know how to implement it into my desktop database.
I have a table that deals with current data (as in member rentals of items). The normalized tables that we have been given include a rental history table. The idea is that, when the member has returned the product a history entry is made in the completed rental table.
I wish to have a button which is clicked to triggers this event. Would I program a macro to do this? In other words, would I create an event that passes those values to the relevant fields in the other table (Name, date issued, return date etc)?
I have after much stress gotten my comments history field to appear on a form.
The following code gives me what I needed
Code:
=ColumnHistory([RecordSource],"LastUpdateBy","[ID]=" & Nz([ID],0))
I have only one simple thing left, that is perplexing to say the least.
Some comment fields will be many short notes, spread over time.
My desire is to change the sort order of the results so the most recent (rather than the initial) comment is at the top.
I have two linked tables (uneditable). They are linked by PersonID and they also have email address in common. For sake of example let's say one table has names of people, and the other table has the address they live at.
I have a user who requires a "datasheet" view of certain columns from each table. No problem, can do that easily in a query.
The issue is that he also wants to have an editable column that would have say "Address Confirmed". Clearly I need another table. If I make a three table query I find no way to edit that new column.
Hi,
I have a basic form which currently displays different information such as name, date, country etc.
At the moment if I type anything into the fields it edits the data (allow edits is on).
Is it possible that if can type in a name and it will find the pieces of work by that named person rather than edit the field? At the same time I might want to search by name and date.
Currently I have a listbox that lists all the names and when selected it requeries that data and lists all records just by that name. I am wanting to also search by the fields.
Can anyone help?
I want to be able to store 2 identical fields on the same table in the database. The copy will start off being the same as that input in the original field. 90% of the time the 2 fields will always be identical but the copy may be changed at a later stage. I looked into using the copy as a calculated field but found out these can not be updated. Is there another control I can use or do I have to code the population of the 2nd field specifically (in AFTER UPDATE EVENT?) myself. The added complication is that the original and copy must be selected from a combo box as all values are held in a separate table.
Also trying to make the second field = to the first field in the design stage of the table using default value
SO if I put default value = [table].[fieldname] I get an error stating could not find field 'table].[fieldname', and yes the opening and closing square brackets are missing from the error.
I have a web database that I am trying to create a search feature for just 2 of the fields. The search is for a certain date and also a shop are the 2 fields I would like to have the search run for.
Once the search has been run I would like to generate it into a report.
I have already created the report/ form and the query. I am not sure where I need to go from here. I have created the from with the date and also a combo box for the list of the shops and then a button that says search that will go to the report. I just need it to show all the particular items that show the date and or shop. If you leave them both blank it will run a report and show everything. Then if you just put a date in it will run a report with just that date or the same with the shop.
Subject: Searching all fields in a table
Hi, All,
I have to send an Access table consisting entirely of Text fields to another company for automatic list cleansing. My table MUST NOT CONTAIN even a single comma, else the whole procedure will go Iraq-shaped.
Therefore before sending the table, I must apply FIND to each field (column) to search for that one comma that may have slipped in.
So far I know only how to search one column at a time. Is there a way of searching the whole table for commas within Access, rather than first exporting the table to Excel?
Thanks for your help.
Adrian
hi. i'm a novice with Access so any explantions need to be pretty simple. I'm trying to create a query that searches 2 fields when 1 word is entered into a parameter value box..... would any1 hav a sugestion. please post a reply if you don't understant what i'm trying to achieve.
Thanks :)
I am trying to do a query that is set up like this:
I have a table with several fields which represents company vehicles. In each field, a persons name is inputed, unless no one is using the vehicle, in which then the field is blank. Each record represents one day, so the date is the primary key.
I am trying to make a query look at each field, and pull out one persons name, and show which vehicles that person will use over a date range. I have a form setup where you put in the date and the name you want ([Forms]![staff printing]![staff name]), and I am trying to tell the query to look at the form field and bring back only the results with that persons name.
Here is an SQL portion:
((Vehicles.[901 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[901 Afternoon])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[961 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[961 Afternoon])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[979 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[979 Afternoon])=[Forms]![staff printing]![staff name])...
The date portion is working fine, which is why you do not see it here... it is only the portion where I try to pull the name for each vehicle that I have a problem.
I tried putting an "OR" where all the "AND"s are, but no luck.
Any thoughts?
(And let me know if I was not clear)
Clint
Ok, I used the wizard for the 1st time today to create a web page access to my database. Sure enough the fields I added all appear and can browse up and down the records.
My question is....How do you make it searchable ???
Is there already something there i can add to the page from design ?? or would anyone happen to have a bit of code I can manually add into the HTML to achieve this ??
Thanks for everything and anything.
I originally had this thread in the "queries" forum but had no answers. Maybe nobody knows, or maybe I was in wrong forum. I still might be in wrong forum, in which case apologies. It just sounds like an area I'd like to branch my database out as (I think). If this bit finds an answer my next problem is going to be to make sure that over the web page version I'd need it to be read only.
Hi, Im new to Access and VB so please be patient with me. Do know a little about sql queries though.
I have two tables. The first (clones) has another table (BLAST Nucleotide) which is dependent on it (ie: one clone can have many BLAST records)
I want to create a search where I can search by either clone name or BLAST name, and return the results in a list box, and then select an entry from the list & view
Any help appreciated
My zip file of my database can be found HERE
For some reason our database keeps "not responding" ...
The application stops responding when:A field is selected that has a input mask
A combo box is highlighted (forcing the drop-down menu to open)
Certain buttons are pressed (in fact all but two trigger not responding, why the two buttons are immune)
if I put a break point on a section of code that runs when I press a button (any button, it doesnt matter) and I then press the button which takes me to VBA, to the break point. Then I press F5 to continue to run the code until the function ends (essentially doing nothing, just running the code to the soonest break point I can in the function and then running the rest of the code as normal...) it all works fine again!!!!
I fixed the issue by creating the function:
Code:
Sub aiuewjgaop()
End Sub
saved the database, deleted the function and then saved the database again.
I 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
Hi,
Not sure where to put this, but as I want the information to be shown in form view, I guess this is the bext place to start.
In breif, I have created a database, in which infomation on machinery is held.
The problem I am having (atm), is I have to create a function, which I want to be presented in form form, where by each item can be searched by it's RequestID (unique) or the customer who owns it, so that its current location can be attached (or viewed).
I'm not sure whether i've worded this well, so to sumerise:
I need a form with 3 fields, RequestID, Customer and Location.
Where by I input the RequestID, which brings up the Customer and Location, or input Customer which brings up the RequestID and Location (obviously there will be mulitple results from Customer search).
Again, I hope I haven't confused anyone because it's pretty simple what i'm trying to say, but....
Thanks, Ben
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 ?
Hello everyone,
Im trying to set up a combobox on my Customer Contact Information form, where you can enter a phone/fax/cell/pager or any misc number, and it will bring up the appropriate customer.
Is it possible to make a query that will show the different phone number fields as one field?
Thank you so much for your help, and please let me know if I can clarify anything.
-Ben Bolduc
i have a form with a control for "repair type" and a subform that has a query that searches a table holding vehicle repair records. on the form the user can enter up to 5 repair types, [repair1], [repair2], etc.. Then the control on the form holds each type of repair to search by. Since the user could use one or all five repair fields and put repair types likes brakes in field one on one record and field 5 on another record, how do i search to just pull out those records that have the specified search criteria?
If i put in [form]![control] in each of the 5 criteria in the query it comes back with no records, because it it looking for that type in every repair field rather than once between the five fields?
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 Related