Search results

Hello everyone, I have created a link table to 'Outlook' Inbox folder and I am interested to refresh 'Link table' to 'Outlook' folder 'Inbox' through VBA. This will be helpful to automatically refresh link to the Outlook Inbox folder when I will be using some different machine/computer. I can...

Hello everyone, Is there a way if I can check the status of 'Google Drive' sync with VBA, for-example if all of the files are sync, I can see a message box in my application that there is no pending Sync and all file Sync are successful? Thanks for your help. Mohsin

Hello All, I am using Stephan Lebans RTF2 ActiveX Control. I have managed some template based text into another table called 'TemplateText', what I would like is to append these template text into another 'RTF Control'. How can I append the template text (RTF text) into another existing RTF...

Hi, Is there a way to read the following 02 properties of files? I am using FileSystemObject to browse for folder location and then Search for Excel files that have 'Tag = "MohsinDone"'. Any help to read the excel file tag property? The folder may have 100's of Excel files and I am interested...

Hi Spikepl, Thanks for the message, I want to replace different URL's that exist in the memo field not the http:// etc. For instance if the Memo field have anywhere from 10 different urls, I want to have replace all of them with blank spaces? One thing I would know is that all of the urls start...

Hello, I would like to remove specific occurrence of text found in Memo field on the basis of Start and End Identifier. The Start Identifier is '<' and End Identifier is '>' and I want to remove anything found in the '<' and '>'? The text in start '<' and end '>' tag will always be different...

Hello All, Is there any way to 'Export' the selected column (user selected columns) as CSV. I have attached a mockup (screenshot) that gives a clear thought about the scenario. The 'User' will be able to select the 'Columns' for the export of 'tblInventory' and by clicking 'Export as CSV'...

Hello JHB, Thank you for the reply, I have done the compact and repair many times and its is not fixed, can you please review the database attached and do the compact/repair to see if it fixed and show the corrupted record Candidate # 10. Thanks Mohsin

Hello, I have developed a Microsoft Access 2010 database for my client and the database is split with Front-end/Back-end, the Back-end and the database is shared on Network, The client operating system and applications for all users are hosted and consistent and the service is delivered over...

Hi there, I have Microsoft Access Main report that has 3 sub reports on the main report, 2 reports orientation are setup as portrait and 1 report orientation as landscape, I would like the same setting for the report but it keep the main report setting and print all report as portrait and there...

Hello, I would need guidance in copying all the contents/text from word document and pasted that in the Memo Field, I have a Recruitment database where I have 02 fields on is CV Path (Text Field) that stores the CV Path (Word Document Path) and another text box content (Memo Field) where I...

Hello, I have a question that Do someone has build a Microsoft Access "Refresh backend tables" to a password protected backend. I am using Access 2007/2010 and want to build a form where the user input the "Password" for the backend database, browse the database and clicking the refresh button...

Thanks guys, I have tried to store the combobox values to TempVar and on report load event assigned the tempvar to Grouplevel control source and it works exactly what I needed. Cheers Mohsin

Hello, I have a question for Microsoft Access report, Is there any way that I would be able to Group the report based on combo box selection by the users. I have the combo box that has the "Row Source Type='Field List', I would simply want to add an express on the Group by report to group by...

Thanks that works perfect :)

Dear Cronk, Thank you for the reply can you please guide me further to get it worked, I have tried this in Microsoft Access query SQL View and it does not work. Is there any possibility that if I would run the Access report with command button click on form it would filter out the report result...

Hello, I am building a tracking database where we would be able to track information which field are null data and report them to our Administration to fill the null data. For this I have created a form name "Search" and I have a combo box control on that form which is bound to "Table =...

Thank you for your time and suggestion but without argument to notinlist event and calling it was not worked yet.

Hi EternalMyrtle, Thank you for the reply, Is there any way if I could first check if the value is not in the combo box list, if cmbSong.notinlist like that? Thank you Mohsin

This is the code for cmbSong combobox change event! Private Sub cmbSong_Change() Dim vSearchString As String vSearchString = cmbSong.Text Song.Value = vSearchString cmbSong.SetFocus cmbSong.SelStart = Nz(Len(cmbSong), 0) cmbSong.SelLength = Nz(Len(cmbSong), 0) Exit...