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 derfloh 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: *

  • Users: RLA
  • Order by date
  1. RLA

    Where have my forms gone?

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

    Where have my forms gone?

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

    On No Data Event

    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!
  4. RLA

    Random Read-Only Error?

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

    Easy Question -- populating one list from another

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

    Easy Question -- populating one list from another

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

    Making phone numbers display in one row

    Yes, it did. Thank you.
  8. RLA

    Making phone numbers display in one row

    Thank you very much!
  9. RLA

    Making phone numbers display in one row

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

    Making phone numbers display in one row

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

    Making phone numbers display in one row

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

    Making phone numbers display in one row

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

    YTD Info

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

    Two Criteria in IIf Stmt

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

    Summing with a condition

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

    Why is Netscape killing my design?

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

    Quey to return records in table A not in table B

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

    Compile error: Can't find project or library

    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!
  19. RLA

    How to clear data?

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

    Zero Denominator in Report

    Thank you !!!

Part and Inventory Search

Back
Top