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 Chriss Miller 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: *

  1. ethan1701

    complicated problem in sales subform

    Hi, I have a database for managing my inventory, sales, orders, etc. For the sake of easy search, updating and reporting, I grouped my products into categories, via a Categories table, and each product had a Products_category_ID, which tells me in what category it is. I created a form called...
  2. ethan1701

    modify dates in database

    That worked like a charm! Thanks! oh, and who else thinks there are too many date related functions? :-)
  3. ethan1701

    modify dates in database

    Hi, I have a database, were dates were stored impropperly. When I sent to it july 1st, it saw it as January 7th (7/1 or vice-versa). I managed to fix the bug causing this, but now I have a few hundred records to fix. I'd appreciate an yadvice on the best way to fix the dates, using either the...
  4. ethan1701

    access doesn't understand LCID and ruins my dates

    I used PHV's solution of replaceing now() wth cDbl(now()), and it works great! Thanks! Now I just have to convert some 500 records to their correct values. any idea how I could do this? -Ethan
  5. ethan1701

    access doesn't understand LCID and ruins my dates

    Hi, I have an ASP form which updates an Access 97 DB. One of the things I update is the date and time a record was stored. I do this by inserting now() into a column (TimeStamp). I've found that when the date is before the 10th of the month, access gets confused. Depending on the LCID I use, I...
  6. ethan1701

    normalization?! I just want to have an order total in parent form...

    Okay, here's my situation: I have a orders_total table and an orders_detail table. they are joined by order_id, which is a unique key in orders_total. I built a form with a subform built on these two tables. In orders_total, I have a column named orders_income. I'd like to make a textbox in the...
  7. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    Why would I have to do this again?
  8. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    Hi, aparently, the version isn't the problem. I got an answer on a forum: http://www.forumtopics.com/busobj/viewtopic.php?p=128058#128058 that said: Do a "Save As...", check "Save for all users". Then try to uncheck the box in question. This did in fact solve the problem. Thank you guys for...
  9. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    I'm using version 5.1.3
  10. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    I am in fact the owner of the document (I created it) I only have this problem with reports that incorporate an Excel file, though in this case, both data-providers are non-editable...
  11. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    I looked over there, and that's exactly the problem! I made a screenshot of the problem, you could see it here: http://www.madab-il.com/BO.GIF Like you can see, the checkboxes are disables, and I have no idea why, or how to uncheck them... -Ethan
  12. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    Sri, What settings should I check? the file properties? no author there... I created all the filed I'm dealing with here... I wish I could uncheck the checkbox... -Ethan
  13. ethan1701

    disable refresh option for Excel based data in BGusiness Objects

    Hi, I have several reports, where one of the data providers is an excel file, and I do not wish to refresh this rpovider with every refresh to the file. However, the Refresh checkbox on hte provider (in the Data Manager windows' Definition tab) is disabled, and checked. I have other reports...
  14. ethan1701

    macro button sending its location to the macro?

    I'm building a phone book like BD. sheet1 allows the user to add new entries, which are copied to the next free feild on sheet2. I allowed 1000 free reos for the DB. as of row 1001 of sheet2, I have a shearch area, where the user can enter the details for which he's looking (currnetly limited...
  15. ethan1701

    macro button sending its location to the macro?

    okay, so lets try a diferent approach: can I put an href link in the excel, that will call the macro and send along the relevant arguments? -Ethan
  16. ethan1701

    macro button sending its location to the macro?

    I want to write a macro that would delete a certain row of the spreadsheet, based upon a value in the field under the button. for example, range("U1017") contains the number "6". the maro I place on it should read this value, and remove row #6. This is important, because I...

Part and Inventory Search

Back
Top