Search results for query: *

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

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

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

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

Hi, I am trying to divide in a report, but sometimes my denominator is equal to 0. So, I was trying to use Nz to return $0.00 if the denominator = 0 and to return the quotient if the denominator is not equal to zero. However, Nz returns my formula [textA]/[textB] rather than the correct...

My problem is that I am writing a report that shows monthly, YTD, and inception-to-date columns. The inception to date data is not immediately calculable, because it is stored as totals pre-2002 in a table. My report calculates the monthly and YTD figures from queries and different tables...