StockCode QtyOnHand ReleaseQty QtyOnB/O
AAA111 1000 994 6
AAA111 1000 988 10
AAA111 1000 978 ...
Hi,
I use global variables in my login code [Global CurUser As String] so that i can call the users name when ever i need to add it to a specific database process. My question is, how do i...
Hi,
I want to categorize existing numeric Fields.
For example,
Say, I have Field called [area]
The values of the field in each record are range about 40 to 200.
I want to categorize the ...
Hi everyone,
I have a Microsoft Access project. It contains a table with a Date/Time datatype.
But in this column, I do not want to store full-scale date time. I merely wanna store time ...
Hi, I am creating a database where I use a combo box to select a company name which then filters by companyID.
I can use the inbuild function of the combo box to do this but i dont want to, t...
I have a database of calendar type items. I generate a weekly report that pulls all records with a Start Date of the current date through the next three months using the following function: Be...
I have a database, created in ms sql server management studio express, that is maintained in access 2003. I have the following columns: LoanNumber, LoanAmount, LoanTerm, LoanDate, InterestRat...
I have a very simple form that I enter temperatures for a range of dates. The fields are Date, High, and Low. The record source is a table called tbl_HighLow. For this particular tables fun...
I am adding a set of data from an access 2000 form to an access 2000 table. This all works well until I close and reopen the database. before the database is closed all records are concurrent....
