Search results for query: *

Hi, Thanks for the response. Yes, the forms are visible in the VB Project Explorer, but I get error messages (the form "X" is misspelled or refers to an object that does not exist) if I try to open them. Also, I can create a new form but I can't add code to it. I've tried to...

Hi, I'm having a bad Monday morning! I have an Access 2000 database and my forms are gone. I've tried to import them from a backup, but even though the import seems successful there are no forms displayed in the 'Forms' section of the database window. I try to copy-and-paste and nothing seems...

This is very helpful, thanks! One other question -- I get a Run-Time Error '2501' when my report closes. Is there a way to avoid the error? Thanks!

Hi -- I have a very complicated shared Access database which, for some reason, chooses to randomly become read-only. It will usually become not updateable again after a few hours. It does not seem to be a problem w/ users as there isn't anyone else w/ the database open. Has anyone else...

Thanks for the help, but it still doesn't work. The list will reset if I put Me.Requery in the 'on click' but only if I actually select a record, which is from the previous list. I would like the list to update when I select something from the list above w/o having to select a record from the...

Hi, I have a form which pulls up a report; a user can limit the query results by Branch (cmbBranch), Referral Category (cmbRefCategory), and Referral Source (cmbRefSrc -- more specific than Referral Category). What I want to do is, if someone selects a Branch, this restricts what appears in...

Yes, it did. Thank you.

Thank you very much!

Hi Bob, Sorry to be so thick, but I used your code and it comes back blank. I changed the field names to what (I think) is correct; my main table is called tblContacts2 and the join field is [contact_id]; my phone numbers table is called [tblPhone_Numbers] and the join field is the same...

Hi Bob, One more question -- it runs, but there's nothing in the Phones field. Where do the phone numbers fit in? I never actually name that field anywhere.

Thank you very much, Bob! I can't get this to work, however; I am getting a run-time error 'data type mismatch.' My contact_id field is not an integer (it's text) but I tried changing it to a number and I'm still getting the error. Sorry, I'm not a programmer, so I'm not sure how to debug the...

Hi, I am writing a report which lists clients and their phone numbers. I would like it to display as one row -- Client Name Phone 1 Phone 2 Phone 3 Phone 4 However, the phone numbers are stored in a separate table then the client info and when I join them, the query ends up with...

Hi, Can someone please help me with a function to find year-to date info? I've been using a hard-coded date w/ Date(), i.e. in a query or report saying 'return info from Between #1/1/03# And Date()'. However, I would like to avoid hard coding if possible. I think it is reasonably simple...

Hi, I am trying to do a report which joins a transaction history table and an accounting table. Because it's an accounting table, there are two txns for every one on the lending side if a txn is reversed (there's a debit and a credit) which is messing up my report. Is it possible to use two...

Hi, please help! I'm trying to write a report which lists all transactions by transaction code. This part is easy -- I sorted by code, listed the transaction info in the detail section, and summed the information in the group footer. However, I would also like to include a figure in the group...

Hi, I have a webpage where I use a javascript function (below) in order to make my page behave like a tree menu (basically, when you click the plus a hidden cell displays and when you click the minus it hides). However, Netscape keeps giving me the following error: document.cmarquee01 has no...

Hi -- I am trying to write a query that returns records in table A that are not in table B. It seems like you should be able to do it in a union query but I haven't figured out how. Please help! Thanks.

Hi -- Up until yesterday, my database was working fine. But suddenly all of my reports that use Date() are not running properly. The message I get is "Compile error: Can't find project or library" but when I check my references, nothing is marked as missing. Any ideas? Thanks!

Hi, I have a form which is basically a survey questionnaire. You type in data as you go, tabbing through, and when you <Tab> at the bottom, you move to a new record. However, the new record contains data from the one before, and you have to type over it. For the life of me, I can't figure out...

Thank you !!!