Search results for query: *

YES!!! Thank You Thank You Thank YOU! I hope others can learn from my trip down this road. I know I have! Thanks for your willingness to see it through!!! John

Okay, first of all thank you for your patience... I have renamed all of my fields to follow the naming rules so bear with me. (I think this was getting me in trouble and could still be the problem!) I checked the four selections as you requested and they are accurate: 1. Its name is 'Table1'...

Thanks so far this last post was a great help in understanding. It also worked for the first record entered in to the database! However, I am now getting a "Run-Time Error: Too few parameters. Expected1" Here is all of the code in the after update event of the ItemNumber Text Box...

My apologies for the lack of info... Form Name: "UPC Adjustment Form" Contains text box "PreviousAdjustments" control source set to "PreviousAdjustments" and textbox "PA Record" control source set to "Sheet" ( "Sheet" would be the...

This DB will be distributed widely via email and I will not be able to add the .dll to everyone's PC. Is there a possible work around I can use? Is it possible to place this library in the code of the app? I tried making the file an MDE and that still causes problems. In the future I will...

Yes! I do want the most recent adjustment. I do have a date field in the adjustments table. However, I have a couple of questions about this. I need to have the response populate two text boxes on the form. The first text box is "PreviousAdjustment" which should return...

2nd question of the day.. I have a form that is used to record adjustments made to items in an inventory file. I use the DLookup function to pull data from my inventory file into the form with a primary key on the item number. Once the form is completed it is then recorded into a table and...

I have adapted a filter form to my database created by an add-in I found as freeware on the Internet(Smartforms). It's exactly what I need and seems to work fine on my PC. When I load the Database on other PCs and use this form it gives me a Compile Error: "can't find project or...

Thank YOU! I have a second question related to the first. How do I get the text file to replace existing primary key information? Explanation: My primary key is set on item number however there is a cost field associated with every item number. My new text file will have the newest cost...

I have a macro that imports text to a table to update the table with new data. The import works perfect accept Access gives me the following message: "The contents in fields 0 record(s) were deleted, and ##### records were lost due to key violations. *If the data you pasted or imported...

I have a report the runs from a query. When I click to open the report I get a message box that says "Enter Parameter Value for Adjusted Amount". "Adjusted Amount" was an expression in the query, but was deleted from the report and query so I'm confused as to why it is...

I'm having trouble adding a new command to my switchboard. I used the switchboard manager, but It does not give me an option to Open a table. Any thoughts?