Search results

howdy Conor If I understand right, you want to insert the 'DAM's ear Tag Number' (from the mothers table) into the 'CALF's ear Tag Number' (of the calf's table.) If so... Build a regular select query, that returns the 'DAM's ear Tag Number' based on the mother's table. You can make the query...

Yes, I too have the same problem. I have tried repairing to no avail. Sometimes I even get a message asking if I would like to install the files. I put my disc in and it runs, but still no help files. I hope someone can help us on this one. Tom

My invoice form is based on my invoice table. The invoiceID is an auto number, wich is related to the invoiceSub. I have deleted an invoice (9066). I still have 9065 and 9067. Is it possible to replace a deleted autonumber? I would like to put 9066 back in.

I got it! Thanks for the help! Private Sub cmdCalc_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim StockTakeDate As String strSQL = "SELECT TOP 1 Inventory.StockTakeDate, Inventory.InventoryID, InventorySub.ItemNo...

I tried adding the spaces but that didn't quite do it either. I have simplified my code trying to trace my problem. Please check this out. Private Sub cmdCalc_Click() Dim strSQL As String strSQL = "SELECT Inventory.StockTakeDate FROM Inventory ;" MsgBox StockTakeDate...

Thank you for your replys. Please have a look at what I have here now. I am getting a run time error 3075 Private Sub cmdCalc_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String strSQL = "SELECT Inventory.StockTakeDate" & _ "FROM...

I am trying to get the results of this sql statement into a msgbox. I just get the statement repeated in the msgbox. What I want is the result of the sql statement. Private Sub cmdCalc_Click() Dim strSQL As String strSQL = "SELECT TOP 1 Inventory.StockTakeDate" & _...

I am running ms Office 2000 on Windows 2000. I have quite a number of different dbs that I have been working on, all on my C: drive. As of late I have been getting odd problems. If I import a form from one db to another, I get errors. Code that works in one db, will not in another. Parts of...

A man gets a phone call from his doctor. The doctor says, "I have good news and bad news". The good news, "You only have two days to live". The bad news, "I couldn't get in touch with you yesterday". A man walks into a psychiatrists office. The man says, "Nobody listens to me". The...

I hope this makes more sense. Thanks Tom

Mile-o-phile & Rich You and so many others have been such a great help to me and other new Access users, on this bulletin board. Your expertise has been greatly appreciated and the fact that it is given free, is a credit to all. Having said that I would like to defend Martin Green just a bit...

Thanks for the reply Paul I have put several records in the forms table. In the search field 'Notes', I have entered names. I put several names in each record. I put the same name in many of the records too. If I use the name 'Bill' for a search criteria, it should show up a number of times in...

This is a peice of code I adapted from Jack Austin. My form has an unbound textbox where I enter search criteria. (txtSearch) The search is performed on a memo textbox called (Notes) The problem I have is that it will only search with in the record that is open. Jack Austin's Access97 demo...

soundsfishy Wow! This is a great example, I hope lots of people download it. Thanks Tom

Thanks for the reply, guys. I am still having a problem with the syntax I think, as I get an error when I run this line of code. I tried a few things and nothing works yet. \ I think its the quotes are giving me trouble. Do you see what is going awry? My SQL is limited. Thanks Tom

Ah yes, I'm being a bit vague. I have a search form with a text box for search criteria. When the search is started, a subform shows the filtered data. The subforms record source is changed with an SQL statement in code. This only searches the first line of the memobox. How can I get the...

I have a large memo box that I would like to search. The memobox will have data similar to this... I want to be able to hit the return key and enter another line in the memobox. When I do a search on this field, the top value can be found, but not the values after the 'enter'. eg: Above I...

RichO Thank you for the reply. For some reason I was unable to make the work, but this works great... Thanks a bunch! Tom

I would like to have a message box pop up after 15 entrys have been made in the subform on my Invoice form. How do I count the entrys on a subform? Thanks Tom

Images On Continuous Forms Is it possible to have linked images on continuous forms? And have each file have its own image? Tom