Search results

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

SELECT DISTINCT Cards.Name FROM Cards INNER JOIN Sales ON Cards.CardRecordID=Sales.CardRecordID WHERE (((Year([Date]))=Year(Date())-1)) GROUP BY Cards.Name; I know not to use [Date] as a field name but I am linked to another database and can't change. The combo box is populated but won't let...

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.

Thank you, thank you, thank you. Just having one of those days.

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

Jack, Nothing I tried worked other than deleting and creating a new form. Now everything works. Thank you very much for your help. Brian

I just saw that I had "!" instead ot "." but still get the error. Thank you for your help.

This is the code I used: Private Sub Frame54_AfterUpdate() Select Case Me!Frame54 Case 1 Me!btnUPS.Visible = True Me!btn2.Visible = False Me!btn6.Visible = False Me!btn10.Visible = False Me!btn30.Visible = False Case...

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