Search results

Jon - Still hangs on Post Quick Reply - I haven't tried waiting indefinitely to see if it ever loads, but I've waited 5 minutes and it never connects. (using Firefox 1.5) - grommit

Hi - Is the main form bound to a table or query? If so, then if you bind the combo box to a field, it should only affect the current record. If you have an unbound combo box on a continuous subform, then there is only one instance of the combo box (it just looks like there are multiple). If...

Hi - You will need to break up the input line into multiple search keys. Take a look at the InStr function, which may be helpful. You can use it to find the spaces that separate words. Then use RIGHT or LEFT to break off the words. Store the search keys in an array or collection. Then when...

A database with a search form that allows the user to enter multiple criteria and then retrieve the matching records using a "Search" button. Open the form frmSearch and enter criteria in the appropriate fields then hit search (enter just a few or you may get no records). A variety of search...

Hi Lindsey, Can you post a small zipped version of the database with the query? - g

Thanks for the extra clarification. If I'm understanding, you have two distinct tables and are comparing certain fields in one against a certain group of fields in another. The attached sample shows one example of how to go about this. Open the form frmCompare and click the button. The VBA...

Glad to help :)

Existing records on the subform already have a record in the Asset table. For a new record, the code is trying to create a child record (Asset Computer Decsr) before the parent record (Asset) has been saved. You need to force the Asset record to save before trying to create the child.

Hi - You need to switch the subform to form view (looks like datasheet view from your image). - g

You don't need to join the tables you can just use the HeaderID as the criteria for the query: SELECT tblNewborn.MLNAME FROM tblNewborn WHERE tblNewborn.MLNAME = "M*21994" Are you trying to do pattern matching? Wildcards? Then look at the LIKE clause for a query. hth, - g

More specifically, the relationships between your tables require that any record in the Asset Computer Description must have a valid Asset ID from the Asset table. So, I assume that your code is trying to create a record without setting a valid entry in the AComID field. - g

Hi - Not sure what specifically you are looking for assistance with. If you can write a query that will return the related addresses, then you can write those records into a spreadsheet. Do you have to search the spreadsheet to find the matching address? - g

Hi - 1) Create a query, Query1, to UNION both the top 25 and bottom 25 percents: SELECT TOP 25 PERCENT * FROM tblValues ORDER BY tblValues.Value DESC; UNION SELECT TOP 25 PERCENT * FROM tblValues ORDER BY tblValues.Value ASC 2) Create a second query, using the IN predicate: SELECT...

Hi Jayce - You can use the logical NOT to get the reverse in your WHERE clause. E.g. WHERE (Age > 10) AND (Age < 15) can be reversed by WHERE NOT ( (Age > 10) AND (Age < 15)) Note that a set of parentheses needs to go around the entire WHERE statement before using the NOT. hth, - g

A simple calendar form that does not use ActiveX. On load, the calendar displays the current month. There are month navigation buttons to move forward and backwards. Clicking on a date changes the background color of the text box. A message box also pops up displaying the date clicked...

You're welcome! Happy holidays and all the best for the New Year!! A standalone version of the calendar form is now posted here... http://www.access-programmers.co.uk/forums/showthread.php?t=99301

Okay, attached is an expanded example that now includes a) You can click on any date on the calendar and it will gray the appropriate box b) If you use the next month / previous month arrows, it will add / delete the proper records. Comments 1. Mouse Clicks - I used the MouseDown event to...

yes, that's my problem too! I know what I want to do, but Access just won't do it :) Again, my comments are just one suggested way to approach this, you might have some other ideas that work even better. Basically, your questions (and barking) is spot on. I think you just need a little...

Hi - My knowledge here is incomplete, but I'll at least offer what I know. I think the problem you are getting with the option group is because when Access displays a subform there is one instance of the unbound control. So you are not looking at 20 OptionGroups, but the same one. You can...

Hi - Take a look at the following site http://support.microsoft.com/?kbid=304302 The general approach is to write some VBA code that looks at each of the criteria boxes, builds a SQL statement and runs a query to fill a form or subform. Hope that helps, - gromit