Search results for query: *

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

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

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

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

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

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

Why would I have to do this again?

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

I'm using version 5.1.3

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

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

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

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

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

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

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