Search results for query: *

Thank you, Nancy2. Just what I needed, a place to look that was right there all the time. I wasn't getting any error message, just not able to edit. The funny thing is that the query looked as though it worked. The correct record was retrieved. I removed two fields from a non-related table and...

It happened when I wan't looking but, before something got set, I could edit this form without trouble. Now, all its buttons work and it displays debug message boxes (on open & on activate) which say "AllowEdits = True". Which is a lie. Also no locks anywhere. The form in question...

Thanks for the info about using Alt key labelling. I didn't know you could do that in Access. But what I really was asking is how to use a user-invoked listbox event, other than Click/2click . The user may just be browsing through possible selections, so I want an event that means the user...

I would like for the user not to use the mouse to click a selection from a list box. Uing the down arrow gets to the selection but then I can't see how to activate it nicely without leaving the keyboard. Ideally using the ENTER key would work just fine. Any ideas would be greatly appreciated.

I wish it were References. Discovery of that Access trap for the uninitiated happened a while ago. Everythings been working with (in order): VB for App,MSAccess 9.0,MS DAO 3.6,OLE Automation, MS VB for Apps Ext 5.3,MS Scripting Runtime. Now everything works except for this one main form and that...

I seem to have broken a form that was working quite well until I started working on a list box index. When I try to click it on in both design and open nothing happens. The documenter message is "Application-defined or object-defined error. Is there any way to recover any of the 3days of...

OK. Dumb. I thought Access would use file name the report name as a file name. Sometimes I get tripped up by doing what Access does by itself! Just learn it, I guess.

DoCmd.OutputTo acOutputReport,"rptPending","d:\Archive" produces a runtime error 2024: The report snapshot was not created because you don't have enough free disk space for temporary work files. The report is very small and available disk space is at least 10Gigs. TIA for...

The table containing the data I want to display is not related in any way to the form source. I only want to display the data not use it. Thanks, kd

I would like to display on a form, general info, such as "meeting date" from a table not associated with the form. I think it might be done using a label to display the date as text, but I have no idea how to do it. Any help would be wonderful. Thanks, kd.

Trying to evaluate or assign Null to a non-variant data type causes an #Error MS knowledge base tells me. Changing the Date type to Variant in the function parameters did the trick. Thanks.

I wrote a very simple Date function with one date parameter. It is supposed to return 1/1/1999 if the parameter date is Null, else 1/1/2000. A record with a null parameter date returns #Error, while all other records return 1/1/2000 correctly. Changing the Null date in the record does eliminate...

I wrote a very simple Date function with one date parameter. It is supposed to return 1/1/1999 if the parameter date is Null, else 1/1/2000. A record with a null parameter date returns #Error, while all other records return 1/1/2000 correctly. Changing the Null date in the record does eliminate...