Search results

I am trying to automate my Table export process and have been getting the error message: "Cannot Update. Database or Object is Read-Only.' None of the the Tables are read only, I'm not sure they even could be. Here is the code I am Using: Private Sub btnExportTest_Click()...

I am creating a Transaction database. The tblStock contains all stock items with StockNo as the primary key field. In the Transactions form the user enters the StockNo and the Description and price field are populated but locked. This, no problem. My boss now wants to have a 'catch all'...

I can't seem to be able to get the setfocus comand to work. I have it in several differnt codes and on different forms and non work. Is is somethingto do with properties? I have tried every combination of enabled and disabled but can't get it. It is not a huge deal but it is very...

Is ther a way to polulate a field on a form from date from a previous form. I want to transfer what is selected in a combo box to the new form for date entry. Brian

Udate new Price from Order I am creating a fairly simple order and receiving DB. Before I begin creatind the order forms, I need to get my mind around one area. How do I update the Cost & SellPrice Field in my Stock Table from the order form when there is a change? Ex: Hammer current Cost...

Good Day to all that read. I have a transaction sub form and use a combo box to select the item and to populate the UnitPrice field. I have tried to use the 3rd column to open another form if it ="34-15" My code: Private Sub StockNo_AfterUpdate() On Error GoTo Err_StockNo_AfterUpdate...

I think I am having a serious brain fart. I have a sipmle Order form and Order Deatils subform. The order for works fine and so does the subform, sorta. I have not been able to populate the UnitPrice field on the subform after I select the Item from the StockNo combo box. The form is based on...

Yes this is another Stock/Inventory question but not the usual. I have read about 300 posts on Stock DB and agree that calculating the Items in stock# is the best way. My question is after a few year or 100,000 transactions how ould one go about purging old transactions or making a...

I have a combo box on a form to which it is bound. When I try to select a different option in the combo box on the status menu I get: This redordset is not updateable. I can't figure out what causes this.

I feel really stupid asking this and I sure it is just a mental block but, I nees to yun a summary of last years sales from the [Sales] table with date from several years. I cant think of how to run a query that selects all sales from the previous year. The [Sales].[Date] field is formated...

Hello, I am a first time user. I am using a form to print several different sizes of labels(different reports) based off the same criteria in a combo box on the same form. I am trying to use an option group to select the different report (label size) to print. I tried using code to show the...