Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. herbivorous

    Using PHP to print to Avery labels

    I am trying to print labels from PHP onto avery labels. I have tried to implement one solution that dumps dynamic content into a Word document formatted for the label size -- unfortunately, when the Word document downloads and opens on my machine, it resizes the margins and the table cells...
  2. herbivorous

    HELP! with Data Entry using Multi-Select Listbox

    I came across this thread months later, and found Neil's sub very helpful, though I recast it as a function that returned the semi-colon delimited string so that I could insert it into a field in the underlying table, rather than into a control. This would be useful to do after update or on...
  3. herbivorous

    Filtering based on contents of unrelated table

    OK, I see the missing quotes there near the end, but I end up baffled as to how to handle what would be, I think, a third level of nested quotes around Book Tour. So help is still needed.
  4. herbivorous

    Filtering based on contents of unrelated table

    I am building an app that tracks, among other things, contacts with members of the table People. I am working on a master filtering page, and want to be able to slap on a filter so that only those with a certain contact code come up. My first attempt has been to build a DLookup into the SQL...
  5. herbivorous

    WMP super-slow disc copy

    I haven't had another disc handy to copy and watch the specs, though otherwise I don't seem to be redlining. It's interesting information even if it isn't the problem here. I appreciate being directed to the article.
  6. herbivorous

    WMP super-slow disc copy

    My Windows Media Player, using XP, takes for-freakin-ever to copy a CD onto the hard drive in MP3 format. I recently upgraded to WMP 9.0, and this didn't help the situation. Often, I can copy from one CD, but the second one I do takes as much as two hours to copy a normal audio CD. If I...
  7. herbivorous

    Subforms driving Main Form through selection

    I am not quite sure what you mean. I have a form that displays data about one of my organization's members at a time. On the same form is a subform that shows all members in alphabetical order on which one can select the member that one wants to see more info for on the main form; there is a...
  8. herbivorous

    Subform based on form recordset

    That will actually come in quite handy when I get to it, but to get there, I need to solve this initial problem. I have a TabControl in Forms frmPeople that contains only a subform -- Child97, sourceobject being frmsubList. When I hit that page, I want to Set frmsubList.recordset =...
  9. herbivorous

    Subform based on form recordset

    I am putting together a database where most everything is on different tabs of a single form. There will be a tab showing the detail of a single record, a tab where the user will specify and impose their filtering criteria, then (I hope) a tab that will give (essentially) a datasheet view of...
  10. herbivorous

    Class or Object does not support set of events

    Never freaking mind. I rebuilt the form from scratch and now it works. I spent most of my day trying to get past two errors, both of which were the product of bugs, not my coding. Grrrrr.
  11. herbivorous

    Class or Object does not support set of events

    I have a combo box on a subform with a 'not in list' event. Whenever the event is triggered, I get this error message -- Class or Object does not support set of events, specifically referring to the 'expression On Not In List'. I've been tinkering all afternoon to try to get around this load...
  12. herbivorous

    How to change a link field to null in a query under form

    It isn't a primary key, though it is linked to the primary key in the underlying query. It is simply a long integer. The query links the table, and I need a way to break that association when someone moves to another organization -- the user will from here be able to either select from one of...
  13. herbivorous

    How to change a link field to null in a query under form

    Same error, unfortunately.
  14. herbivorous

    How to change a link field to null in a query under form

    My form links tblPeople and tblAddresses via AddressID, the primary key of tblAddresses. I am trying to run an event to set People.AddressID to null, thus emptying a couple of address fields. Just having the module say People.AddressID = Null gives me an error complaining that the variable...
  15. herbivorous

    Concatenating two records into one

    Yes, open a module and paste the above in and save it. Check to make sure that all the field names and table names are correct to what you have. Then you can enter it into your query grid as an expression (in place of a field along the top, if that makes sense.) Just type in...
  16. herbivorous

    Concatenating two records into one

    I think you'd want a VBA function that looped through the records, concatenating strings as you went along. For things like this, I often write function that take the user ID and return the string of information you want. For you, something like this, which takes a record number: Function...
  17. herbivorous

    Changing a foreign key in form based on query linking tables

    Is that a helpful header? Here's my issue -- I've got a form which is based on a query linking three tables: People linked to Organizations linked to Addresses (each Org may have multiple addresses.) If you change the Organizations (via combo box), I want the Address information to then clear...
  18. herbivorous

    Binary operations in Access

    Thanks -- problem I was having was looking for it in Access rather than in VB. I need to use it on a query grid, but once I found it in VB I was able to write the world's simplest function to give me the use of it in the query. Thanks for your help.
  19. herbivorous

    Binary operations in Access

    My question in micro is whether within Access there is an easy way to do a binary AND of two numbers -- to see if the two numbers share any bits that are ON (1). The bigger picture is this -- I have a table of people with a linked table that indicates areas of interest. These areas of...
  20. herbivorous

    Variable Data Type in Custom Function?

    If there is no other option forthcoming, I can certainly do it that way. I had consulted with my other primary user and decided that having one function with a variety of parameters was actually easier to remember and use. So I remain hopeful of another solution. I'm always trying to do...

Part and Inventory Search

Back
Top