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

Your response solved my question. After researching the cartesian join that you mentioned, I had a better understanding on writing the queries. I spent the weekend testing the queries, and they are working perfectly. I appeciate the help. Jeff

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

After much googling, I found a code solution. I would love to give credit to the website and programmer but in my haste to try and test and implement the code, I lost the website. Here is the solution that I have working: 1. Created a module with this function: Function SetMDWLink() 'The...

Here is the background to the issue we are having: We use an Access database as a front end to create sales proposals. Access has the forms and reports the sales department uses. The back end is a SQL database that holds all of the data. This past weekend some of the sales staff was in the...

Thanks for your help. I was able to get the short cut to work correctly. Clicking on the short cut, the database now uses the network mdw file. However, I have to go back to my original question of how to create code that sets the mdw file when the database is opened? I was reminded that...

Thanks for the response. I did the following steps: 1. I modified the code you provided to match my network path and file names. 2. Opened the access database. 3. Clicked on Edit and then Create Shortcut. 4. In the Full Path Field, I deleted what was there and copied and pasted the code...

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

Problem solved. The suggestion to create a query and then bind the form to the query worked. Both the form and the macro are now working as designed. Thanks for the help. Jeff

Thanks for the responses. We are using a sharepoint site linked to an access 2007 database for tracking container shipments. I have written a query which compares the expected receipt date to the receipt dates on the purchase orders. The purchase orders are in an Oracle database as part of...

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

Thanks for the response. The article provided several solutions for me to try. I will only post a new reply if I run into problems. If you don't hear from me, then I was able to use one of the solutions from the article to solve my problem. Thanks, again, Jeff

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

I moved the code to the afterupdate and it still not working. You are correct. I had the end if statement as part of the code but left it out of the example that I typed. If it helps, the checkbox is for display purposes and the user cannot change the checkmark by clicking on the box. The...

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