Search results

I’m not sure if I’m posting this in the right place. I Migrated my Access 2016 Application to SQL Server Express using Microsoft SQL Server Migration Assistant (SSMA) for Access, Version 8.16. for the first time. It migrated my successfully. No errors. I linked the tables and the Application...

Thanks in advance for your help. It is greatly appreciated! Two part question. But the first question needs to be addressed before I can move on the second one. I have a bound Datasheet Form. Technically, it’s a Subform in a Form that just holds a Heading Label. I use FormatConditions to...

I’m using Access 2007 I’m attempting to apply a filter just one Control on the Main form, such as Date I have a Main Form with 2 subforms. Everything works fine until I try to use Filter by Selection. After filtering the Main has the correct information and has the correct number of records in...

I hope someone can help me. I have spent a lot of time on this and yet I have not been able to find a solution. I’m trying to execute a VBA SELECT, FROM, with a WHERE Clause. I first created this in a Query and thought I could just move the Code over to VBA and I’ll be done, NOT! Firstly, VBA...

Let me thank you in advance for you help. I have a ComboBox that shows Detail records. When one record is selected, it is loaded to the PODetail Table. I want to prevent a duplicate selection of a ComboBox record. I’m trying to use a Dlookup in the AfterUpdate Event of the ComboBox in the...

Dear Members, I need some help. I have a Report with Page Headers, Detail and Page Footer. When the Details are filled with a full page of 10 records, the Report creates a second Page instead of printing just 1 page, with the Footer totals at the bottom. If the Detail has 9 records, 1 page...

My original contact to the Forum was at http://www.access-programmers.co.uk/forums/showthread.php?t=291003&highlight=HideBlankColumns I initially contacted the forum regarding a Sample Database to Hide Columns on a Report Located at...

Does anyone know how to Contact the Administrator. I have Private Messaged Vassago and he has not gotten back to me. Does anyone know if there is anyone else besides Vassago who has Administrative Privileges. Someone with the authority who can 'Email' a Member and tell the Member that their...

I need help creating a SIMPLE solution for Retail rounding. Below are is an Example of Detail lines in a DataSheet Form that represents the price for an Item. QuantityXUnitRate = Quantity * (UnitRate*Pct) $14.0049 = 1 * $10.53 * 1.33 $14.0049 = 1 * $10.53 * 1.33 I need the price to end with...

I hope someone can help and has solved my exact problem with a simple solution and very little coding. You should know that I consider myself a beginner in VB and MS Access. I have 3 forms: Main form FrmCustMainAboveSubJob Caption Customer Record Source Customer Inside...

I'm looking for Macro that will help control inventory. What I have is 190 rows and 10 columns. Starting position is currently G4 ranging through P193. If an item is in stock it will be flagged with a “Y”. Whenever any single row of all 10 columns is either empty or blank, I would like to...