Search results

OK, I know you can't do a 3-way Boolean! But I'm wondering if there's a way to accomplish what I need: I have a field that I created as a Text field, but I need it to be Boolean in order to be able to have Access put an 'X' next to the correct entry on a printed report. There are 3 choices...

Actually the code isn't mine...I'm a beginner or maybe an advanced beginner. I found code that I could use, or I've gotten help from others here and elsewhere and that error trapping code was in their code so I used it. I can take it out. It was that simple? Wow. I see an "If" statement and an...

I've created a form, called frmReportsMenu. From this form, the users will be able to print the various forms required for client company stores. On the form there is currently 1 field: a combo box with the label Store Name (combo box is named cboStoreKey). The control source for this combo...

I have several reports that I've spent a LOT of time on (and some of you have, too). I do not want any of the users to be able to make any changes to these reports whatsoever. The database is split, and the reports reside in the front end. Should they be moved to the back end (is that even...

Just wanted to let everyone know that this issue is solved...I moved the code from PageFooter to PageFooterSection and it works beautifully. Just in case someone else has a similar issue and wants to use this solution!

Hi. I hae gotten such wonderful help here...many thanks to you all, especially Cheryl! I've used a report that Cheryl did for me as a foundation for another report, this time with the page numbers in the footer. It's another "group by" situation, with page numbers beginning at 1 for each...

Yay it's all fixed. That was the problem. As soon as I removed all references to the StoreProducts table from the main form, it began to behave properly. Thank you everyone!

I just solved part of it. I had based the form on a query that joined the Product and StoreProduct tables. I removed all references to tables and queries in the main form, EXCEPT to the Product form. It is now behaving the way I would like it to behave. A few tweaks and hopefully I can...

Attached is a screen shot of the form showing the buttons on the main form, and a screen shot of the VBA code for 2 of the buttons. If I can get it solved for the NextProduct button I can do it for the Previous button. The SAVE and NEW PRODUCT buttons are working fine. You notice on the...

I knew there was a way to make sure it was focusing on the correct field. Thanks! Yes, the button is on the main form not the subform. :)

Sorry I was unclear. I have a form, and this form contains all of the product information in tabs. The form also contains a subform, where we input the specific quantities of the product in each store location. The button in question is on the main form, not the subform, so I'm confused as to...

I've created a button to go to the next product in my product table. The code: Private Sub btnNextProduct_Click() DoCmd.RunCommand acCmdRecordsGoToNext End Sub The problem is that it's not going to the next product in the Product table...it's going to the next record in the Store Products...

I'm running Access 2010 on a Windows 7 64-bit machine. I created some buttons on a form using the button wizard. I wanted to tweak the macro behind one of the buttons. I opened the macro window and was able to make changes. As soon as I tried to close the macro edit window, I got the message...

THANK YOU!!! I tried the first response (Access 2010) and got the results you predicted...then I tried your way and it works. THANK YOU!!!

Is something about this query causing it to only pull from unique UPCs? Could that be causing it to leave out what it considers to be "duplicate" UPCs from different stores?

Because my issues in the past have been linked to the type of JOIN I have, I've looked at this piece of code and the fields. SELECT [Store Information].[Store Name], [Store Department].[Aisle Number], [Hazard Class].[Hazard Class], Product.ProductName, Product.Chemical...

OK I'm trying to come at this from another position. I have designed a different Query. SELECT [Store Information].[Store Name], [Store Department].[Aisle Number], [Hazard Class].[Hazard Class], Product.ProductName, Product.Chemical, Product.ChemicalAbstract, Product.PhysicalState...

I'm not sure where to join them. QuantityOnHandQuery contains 2 fields...the Store Product Key is the Access-produced unique identifier that indicates which product in which store, and the QOH which is a calculated field, taking the number in the package multiplied by the number of cases and...

It's supposedly waiting for a response from me...but if it's asked me something it's hidden behind the Access window which I'm trying to minimize but can't.

Well the query has now been running for 15 minutes and I can't break into it. Access is unavailable to me. Any suggestions?