I am entering daily sales into a table named tblSales with fields SalesCounter, Date, Shift, FoodSales, Tax and PayType.
I am loading this table from a form, frmDailySales, with two sub forms, frmDailySalesLunch and frmDailySalesDinner.
Forms frmDailySalesLunch and frmDailySalesDinner - both...
I am attempting to make a query for 10 text boxes. I have tried to enter it in the Zoom Box and I,ve entered it row by row in the query. Every time it gets cut short after being saved. How do I accomplish this?
Example of saved version (Incomplete)
Like "*" &...
I want to be able to run a printer alignment test by clicking a button. I need to limit the number of labels printed in order to test printer alignment. How can this be accomplished?
I am trying to open a Dialog Form that populates a Report. I open the Report to start the Dialog Form. The problem I have is the Dialog Form opens then the report comes up before the dialog form can be can be filled out. I have the code in the report “open event”.
This is the Code I am...
I have a form that I am using to run a query. The query name “qryUCQuery” the form name is “frmSelection” it has 2 text boxes on it ,Text0 and Text2. I am using “frmSelection” to specify the values for “qryUCQuery”. The criteria for the query is “Like "*" &...
I have a query with a field called Category with text records, one record example: "3 4 SW SRV CCR GR FAF FCO FCR SCR FGR". This example shows 11 categories. I want to use a form to specify up to 10 criteria for this Query. The output will be used to make mailing labels. any help much...
I have a report where I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.
I want to activate a textboxes color when the value of another text box = 0. Example: I have a parts list when the value of [parts ordered]-[Parts recieved] = 0. I want a textbox that I have placed over the that record to hilite a color.
In Win95 I uninstalled Com2 Com3 Com4 and LPT1 in the device manager. I left Com1. I was having a problem with Com2, I thouhght I would uninstall these then reinstall them. After closing down the computer I tried to reboot but I can't even get to the CMOS. When I turn the power on the fan goes...
How is the symbol for degree. ex. 100 "degree symbol" , or the symbol for diameter ex, 1" "diameter symbol" displayed in a text box in Access?
Is it possible to build an Access 2000 Application, where the entire application is kept on a web site. Ex. A Bookkeeping application located at a web site, where the different people doing different tasks, can go to the Web site and do their task.
I need to calculate times on a form (Employees clocking in and out). The purpose is to record daily employee hours. The fields are [In], [LunchOut], [LunchIn], [Out], [OtherIn], [OtherOut]. These are Date/Time fields. Using the AM/PM format I am unable to calculate the employees daily hours. How...
I would like to find the correct way to install Microsoft Access 2000 in a Server - Client Network.
Currently I have the data Database on the NT 4.0 Server. The Application (Microsoft Access 2000) is installed on the Cleint. The Forms and Reports Database is installed on the Client. This loads...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.