Search results

I have a form that is used for creating sales proposals. I need to add a check box that will be used to toggle the form from allowing data entry to being Read Only. Before the sale proposal is given to the customer, data entry is permitted. After the proposal is given to the customer, the check...

I'm new to coding, so I'm not even sure where to start. I have a table with prices by day. I want to start with the first day, 1/1/2009 and step through each record in date order. I want to set a flag when the price goes below 11.25, and then count how many days it takes to go above 11.75...

I have a form that is used for creating sales proposals. I need to add a check box that will be used to toggle the form from allowing data entry to being Read Only. Before the sale proposal is given to the customer, data entry is permitted. After the proposal is given to the customer, the...

I'm writing a sales history report using Crystal XI. I want to create a cascading parameter based on a part number that a user will enter. The flow would be: Part ID - entered by the user. Sales Year - Cascading parameter based on the part ID. Only display...

I have an 2003 access database and the security mdw file located on our network. If a user doesn't have a network connection, then access uses the system mdw on the c drive. I would like to set the database to always use the network mdw file. I checked the microsoft access website and...

I have a simple macro that makes a copy of table. The macro runs correctly by itself. However, I then added a button to a form to run the macro. When I click the button, I receive an error "the database engine could not lock table because it is already in use by another person or process."...

I'm working with EDI data that is logged to a microsoft access database. Each document is controlled by a sequential document number. I need to write a report or query that shows if any of the control numbers are skipped. Each document is a row in a table. For example, over the weekend we...

I have no experience using modules or vb with an access database, so I need some help. I have a make table query. When the new table is created, I need to include an autonumber field. I have spent most of the morning searching this forum for a solution. One solution is to run the make query...

When a part number is set up in our manufacturing software, the user clicks a check box to mark the part as purchased. I'm creating a similar form and want to have a check box display the same information. The manufacturing database stores the check box as Y when checked and N when not...

I have a main form with 2 check boxes. The title of the first box is Manufacturing and the title of the second check box is Purchased. I have 2 different forms based on the titles of the check boxes. After the user checks one of the boxes, I want the user to click a command button which opens...

I have a main form that displays different part numbers and the corresponding material type for each item. For example, Part 1 metal part 2 candy part 3 label I have created specific subforms based on the type of the material. I want to place a command button on each record, and when the...

I have a manufacturing report that is grouped by manufacturing operation. Depending on the product, there can be can be one group, meaning that it only takes one operation to make the product or up to 5 operations to make an item. At the end of each group are subtotals, Instead of having...

This seems like an easy question. After I create a crystal report, I do not want the end user to see the design page. When the user opens the report, they should see a copy of the report but not the design page. In fact, we want to restrict the user from getting to the design page so they...

I searched the forum and couldn't find a thread to answer my question so here goes . . . I have a form to lookup item number information. The user enters the item number and clicks on a "refresh" button to view information related to the item. Also the user can edit some of the fields using...

I have a form that calculates freight costs. I'm using a combo box for the user to select the route of the shipment from shipping port to destination port. The combo box has 2 fields. The index which is stored in the database and the description which is displayed to the user. I used the...

This is related to financial audited statements. I want to write a macro or vb code to scan a document looking for keywords. When the keyword is found, all of the data after the keyword is stored in a field until the next keyword is found. Here is an example. The original document is a...

I have a form with two combo boxes, one for shipping point and one for destination point. I then use a text box to concatenate the 2 values together. All of this is working fine on the form. I now want to store this value in a freight table. I'm using the table as the controlsource for the...

I searched the archive for how to store a calculated value and found a lot of controversial dialogue about the pros/cons but not really a solution on how to do it. I have a form based on a query. The database behind the form and query is our ERP database and is connected though an odbc...

I have a form based on a query. The query uses a parameter to filter the data to be displayed on the form. The user then enters additional data. I'm using a requery macro to refresh the data after the user completes the data entry. The problem is the user has to enter the parameter value...

I have a form with a combo box for the user to select a specific date. I need to update the date field after the combo box loses focus instead of on the change of a record. Can someone provide me the vb code that will update the field when the focus is lost? Thanks for your help, Jeff