Recent content by jalverson

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