Search results

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?

Hi, In my access app, I receive data through text files everyday. These text files have one entry each and I receive close to 200 of these each day. Due to an error in the upstream module, we did not receive these files for few days. After finding out the error, the upstream team sent the data...

hmm..I think this line is not needed strFile = strFolderpath & olMail.Attachments.Item(x) Instead should it be? Do Until x = 0 olMail.Attachments.Item(x).SaveAsFile strFile x = x - 1 Loop

Hi, I import XML attachments everyday from Outlook emails to an attachment folder in C. When I run the Rules in Outlook, which executes the Outlook macro to download the attachments, It comes in as Proc_ID_1111-Pam_WALT-11-18-24_13-41-15. I mimicked the same code in Access button action and it...

All the raw data is through .csv files which are archived on daily basis. Only the day to data is inputted to the database and the daily report is run. Since there was a need for a MTD report, I created two tables to which the daily data is appended everyday. The data has a lag of one day. At...

Hello, I have an application where data is appended to two tables everyday. Every month, on the first working day a automated job runs at 10.00 pm to create a MTD report using the data from these two tables. How do I identify the first working day of the month so that I can write a module to...