Search On ID / Datatype Problem (GIS Linked Database)
Dec 7, 2005
Dear All,
I have a property database linked to ArcView 3.1. It has a field that links to the ArcView Database called ID which is unique and set to a data type of double.
I have a further form that can go straight to a record if you know it's ID.
This form works fine so long as the ID field is no more than 5 digits. I have a series of polygons that have six figure ID's - the link to arcview works fine using these six fig ID fields however the form that looks for that particular ID can't cope with the six figure numbers...
My problem is although I could change all the ID's of the records in the Database so that the search on ID worked (ie five figure id) they then wouldn't match with the overlay in ArcView and I would not be able to link through using code without first changing and matching all the codes associated with the polygons (time consuming)
I did try changing the datatype of the ID field to long integer but still have the same problem. Strange that the search works for five figure IDs and not six.
Does anyone know whether this is a data type error or is it some simple oversight.? I can probably work out some way of changing all the ID fields to five figures but would prefer to keep the six figures as they are used in some pre-printed material as refs
I have been searching the forum for this scenario but could not find similar case, which is as follows: I have a Search Form with many Text and Combo boxes, linked to search criteria in a query. There is also a sub-form showing the search results. I am trying to replace one of the combo boxes on the form, with a List Box, so I can make multiple selections. For example instead of showing only "buy" transactions via the combo, I want to see both "buy" and "sell" transactions, which I believe could be done via a List Box.
For the combo box I have the following: In the Field section I have: [TransactionType]=[Forms]![frmSearchTransHist]![cboTransType] Or [Forms]![frmSearchTransHist]![cboTransType] Is Null
For Criteria I have - "True"
So, my question is what should I put on the query in order to make it work with a list box.
I also want to give credit here to Jon K who has an example of database with combos and texts - very helpful example! http://www.access-programmers.co.uk/forums/showthread.php?t=103312
Can we have two tables linked to one search query? I've some data that is confidential and woul like to have them in two different table. When I search for it using query form, only the relevant table results will be shown?
I have a database that uses four forms and each form has it's own table and each form has it's own search button to find a specific record within that table. I would like to use one search button that will look at all four tables and bring up the correct record when the request number is entered. Can I link all the tables to perform this or is code required? Can someone send me in the right direction for how to do this? Give me an example of code if it's required? Thanks for any help I can get.
I have a query linked to some combo/txt boxes on a form so the user defines which categories he/she is looking for then presses button and query comes up with relevant results. This works fine if the user inputs information that is actually there, but if they leave it blank it goes all wrong.
The statements I have in the query are as follows:
[Forms]![frmStockControlSigned]![comboSupplier] [Forms]![frmStockControlSigned]![txtPurchaseOrder] etc.
I thought the solution may be along the lines of this but it does not work: =if([Forms]![frmStockControlSigned]![txtDate]=Null,[Forms]![frmStockControlSigned]![txtDate],"*")
basically i want to make it so the user does not have to enter criteria into evey box, thus if every search box is left blank it would show all records "*"
Right what im after sounds complicated but its quite simple.
I have a client database, in this database each client has 3 skill fields, i also have a form with a listbox and an unbound textboxes that are linked to the query so when the textbox is typed in the listbox updates.
Now ive sorted out the problem of not all fields showing it some of them are blank now the problem is.
When input text into one of the boxes the listupdates, now if theres text in two boxes. and theres data in one of each that matches it will show neither, because the query is looking for data that matches in both fields, now i need partial matches so it will give results of data in both fields.
not understanding fully what i mean?
i have zipped my db, if you open the db then open the form 'MainListRecTrades2nd' and fill in data in both primary and secondary trades that matches from the list you will see.
http://awilderbeast.com/CWSystem.zip
The solution i was thinking of would to have 1 textbox that searches all the fields and displays data from any of the fields in the list
I have a table which lists all documents that refer to a certain entity. the table contains the file names and paths. I would like the user to be able to search for text inside these documents.Can I use Windows Search for that by using code? Is there any other way?
I have built a custom search form in a MS Access 2010 database so that users can find specific records to edit. After entering the search criteria and hitting a Search button, another form opens up that shows the search results. This second form includes a command button for generating a report of the search results.
Right now, the custom search form and the search results form are both working properly, but the search results report is showing every record in the database instead of just the search results. This is true whether I access the report via the command button in the form or the navigation pane. I'm not sure if I need to correct my VBA code or the report's properties.
I was recently asked to document all our applications and databases. Is there a way to tell what is linked to a database? I know how to tell what the source of a linked table is. I'm looking for a way to look in reverse. example. Database1 is a storage database of all our personal data. Database2 through database100 is linked to database1
Can I go into database1 and see what's linked to it?
What is wrong with this linked pictures in my database? I have made OLE field in a table and I want to insert pictures in that field with option "linked". But pictures are not exactly linked. First, they take a lot of space in a database, almost as inserted pictures (If inserted picture takes 30Mb than linked picture takes 20Mb). I thought it is only going to save a link (target location) to a file. Also, when I insert link to a picture ina OLE field and delete this picture in windows - I can still see this picture on a form in my application. So, is it linked or inserted (only difference is that I can't edit linked picture if it's deleted in windows but I can see picture in a form). How can I insert only link to a picture in my database so I can see pictures in forms and reports and pictures stays only in windows and takes a minimum space in my database (only for a target informations)??? Thanks!
Hello. I created two databases on my personal computer at work. One is called "Main" the other is called "Link". As you might have guessed, I linked the tables from "Link" to "Main" and imported the forms that were in Link into Main. On the opening page of Main, users click either a button that takes the into Main or a button that takes them into Link. On my computer, it works perfectly. However, when I went to put the database on the network drive, i get error message 3044, invalid path. This is probably something minor, but I am new to MS access and am stuck. Thanks for any help in advance. BTW, the company is still running 97; i dont know if that changes anything.
I have searched through a number of threads trying to find a solution to this problem that I am having without luck, so I figured I would post a new thread.
I have an application in access that pulls data from a SQL database. Users can already delete a record out of the database.
The problem comes when I try to give them the ability to update the information in a record.
First, I went to the tables listing and double clicked on the link table that contains my information.
Once that window opens up, I have tried to change a piece of data on this table, but it give me a 'Write Conflict' dialog box stating 'this record has been changed by another user since you started editing it. If you save this record, you will overwrite the changes the other user made.'
This is the same error if a user changes any information on the form and then tries to move to the next record.
What is set up incorrectly that is causing this problem?
I am slowly but surely learning more everyday about Access. I inherited a database system from a gentleman who set up a lot of great stuff but did not document anything! I am working with a linked database in Access. I am trying to add information to a look up wizard. I am unable to de-select the "Enforce Referential Integrity", so I deleted the one to many relationship in hopes of being able to add the information. However, I am still not able. A message pops up stating it is a linked table and some properties can not be modified. My look up wizard Row Source can not be modified.
I have one .mde application in which there are some linked tabels.. Now problem is the i can see two such a linked tabel which i can not find into a database(from where the table is exsit.).. this linked table is form same databse where other tables are exist. I tried..to show hidden objects,systemobject..but no joy... Could please how can i find them...Actullay i am working on applicaion which is developed by someone else. form the data of these tables it seems that these are backup data..because these tabe got same data as two others hae..which are amin tables in my application./
I've posted this in my usual Excel forum without any response so I figure someone here might be able to help. I'm using an SQL query in an Excel VBA macro to extract info from an Access table and dump it into an Excel worksheet, which works fine except for a Memo field, which is truncated to one character length - text fields are fine, just this one Memo field. I'm using the Microsoft DAO 3.6 library. Any ideas?
I have a bunch of queries put in 1 macro. Of course, some queries have the same parameter [Enter current monthend] so when I run a macro, there are few popups asking to [Enter current monthend]. It’s annoying for users to put in the same parameter 2 or 3 times for a report. Is there a way to avoid it?
I tried to make [Enter current monthend] as a new_field so the 2nd query could pick up new_field instead of [Enter current monthend] again but that gave me an error b/c the new_field automatically has ‘binary’ datatype instead of ‘date’ datatype. How can I fix this?
my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.
the standard value for the yes/no datatype = no..I try to set the standard value to yes but I can not be allowed for yes ? how do I set it to yes ? I have open the table, then I could not change to yes.
I created a database in Microsoft Access and then upsized it to SQL Server afterwards.
I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another table which contains a description of the column. e.g. Main_Table Case_ID Foreign_Key_Field_ID 1234 78
New_Foreign_Key_Table Foreign_Key_Field_ID Foreign_Key_Field_Desc 78 Describes the ID 78
I also setup a CONSTRAINTREFERENCE between the fields in these 2 tables.
I then relinked my tables using the Linked Table Manager to pick up the change to the table I altered (Main_Table). I also linked to the new table I created (New_Foreign_Key_Table).
My problem: In Access if I create a new table I can select the lookup value for a field in the Table Design view Lookup tab. However, I altered my table in SQL Server and then linked to it again to pick up the change. Now when I view the linked table in Access it does not have any lookup value AND it's not possible to change this for a linked table.
Is there some piece of SQL I can use in SQL Server to change the lookup value for the field in my table OR have I approached this the wrong way. Should I have modified the local table in Access and upsized it again?
Otherwise if I select all values from my Main_Table in a form it displays the Foreign_Key_Field_ID instead of the Foreign_Key_Field_Desc because the lookup value has not been set to Foreign_Key_Field_Desc
This posting is a bit long - I hope it makes sense.
Any ideas or suggestions would be greatly appreciated.
Wondering if anybody has any information about this.
Backgound information: My access database information comes from a 'card' where somebody has manually put crosses in a number of boxes. This information is currently being manually inputted into the database...
I know you can get scanners to pick up information from a document...but is this possible with microsoft access?
I have a database that links to an excel sheet and take data from it. For a fail safe i put deletes in several places in case of user error to make sure the sheet is deleted. If it is already deleted the other deletes don't act well.
I need to write a conditional iff statement that if it doesn't exist it ignores the delete call. Not sure how to structure it.
Private Sub Command3_Click() DoCmd.DeleteObject acTable, "Sheet1" DoCmd.Close acForm, "District Select Form" End Sub
When I export or do a make table query from Oracle to Access, the new table has some of the datatypes changed. Many of my numberic fields are decimal instead of Long Interger. I then need to go and manually cahnge them back. If I forget or miss one, it crashes another application we use.
Has anyone come up with a solution to automatically go through the table structure and change the datatype from one format to another? This would be a great help.
