Search results for query: *

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...

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...

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.

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...

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.

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...

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...

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 =...

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...

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.

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...

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...

Same error, unfortunately.

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...

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...

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...

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...

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.

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...

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...