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

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

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

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