Recent content by prasadgov

I resolved it.

Which property in particular. The Recordset Type is Dynaset (Inconsistent Updates)

HI, I have a tab controlled main form and a tab controlled sub-form. While the controls in pages, HV, Major and Appellate work without issues in standalone form mode, the sub form controls are inactive when included inside the main tab controlled form under Page, BiasReportsByRegion. Is it any...

Not sure what you meant but it is certainly shorter.

Hi, I have a Main form within which I have a tab control. When in form view the tab control shifts up and the and the page controls are not visible. I have to scroll up to see these controls. It has to be like this in the form view but It comes up as below with BiasReportByRegion and...

As the previous poster mentioned, it is left to the IT folks and since we are a part of a large organization that has a more than 1000 employees, they cannot just do it for one team

I'll try the decompile/recompile sequence since reverting to an old Outlook version is ruled out because we are part of a large organization.

Hi, I get this error sporadically. This is a button on my Access application which creates and sends a pdf through Outlook. What is this Outlook error due to? we have Office 365 and not a older Office version. Is it because of a slow PC? How to fix this? TIA

This worked neatly.

Yes and my values are 1-31

Resolved it Mid([QuestionText],5) did the trick

It did this It eliminated numbering and spaces only for the double digit values (after 10 but not before) QuestionText Expr1 9. Moving the proceeding in an appropriately expeditious manner 9. Moving the proceeding in an appropriately expeditious manner 9. Moving the...

Hi, I have a field in Access table with values such as 1. abc 2. efg ....... 10. ijk It has two spaces between the numbers and the string, which is uniform. I want to eliminate the numbering and just retain characters. How to identify the space between the single digit numbers and the...

Hi, One of the Access DB I inherited has a code which drops a temp table, runs a make table query, which queries all the fields of a linked table and creates the temp table. The query uses fields from only the linked table and not other data sources. This is fine and no issues. Can I rather...

WriteToFile line shows disabled and also I get an error at "i As Counter" User-defined Type not defined. Can I use Integer or long?