Search results

Please see below my code so far. I just need to figure out how the data can be displayed in pipe delimited format in text file. At the moment it is showing each text in new line which is not quite right . Sub Extract() On Error Resume Next Set myOlApp = Outlook.Application Set...

Hi guy, I want to read the email body contents and also there is change of requirement so I need outlook vba code so the extract will create a .txt file per email rather than collate and .txt files need to be saved down in a particular folder on network. Can anyone please help me in this ...

Yes that's correct

Hi, sorry the body of the email stores all the details like .. Customer Name, contact number , Address etc... The data in the email is structured in table.

Hi guys, We got a request from client to built something that can read data from email attachment and save the data down in the database . Can you please shed any light on this ? How this can be achieved ? Thanks

Hi guys, I have migrated tables from MS Access to sql server and when I tried to run the forms (which are on MS Access) then they work fine most of the times but where there is date filter in the code it fails . Please see below the code (I had to format the date to make it working otherwise it...

Hi guys, I have a word document which is password protected by someone . I want to copy it and make changes in it . But if I use SaveAs then again it is open as read only . Any help will be much appreciated . Thanks

Hi guys, the following code checks if the laptop is connected to the network but Can I add something in this so it will check Wifi and RAS too? Option Explicit Enum COMPUTER_NAME_FORMAT ComputerNameNetBIOS ComputerNameDnsHostname ComputerNameDnsDomain...

Gasman, I can't access the following link because of security restrictions at work. Please can you help me with the code ? Thanks

Thanks for this. Can anyone please share the code that will check if laptop is connected to 'Wifi','RAS' or 'LAN'?

Hi guys, My database is built in Access and it's been used by about 200 users . The users are aware of not using the system on Wifi or remotely but sometimes they still use wifi (sometimes they don't realize that their laptop is connected to Wifi at work ) so I want to build the functionality...

Hi guys , I’m talking about access backend . Thanks

Hi guys , I have been using ms access for years and for any small change requests from clients like adding value in lookup table etc.. I never made test environment ready and added values in production lookup tables straightaway. But in my company they want test , dev and production...

Hi guys, Are 50000 records too many for MS Access table? Will the performance increase if I delete the old records ? Many Thanks,

Hi guys, I have done data migration from ms access to sql server (in test environment) . The users have tested it ans it works fine. Now we are planning to migrate to production so I want to make sure all works fine in production with no issues . Can anyone please help me with implementation...

You are a star Minty !!!! It worked a treat. Thanks a million .

CJ_London, in sql server , the ID has int datatype and seed and increment are set for tat field. ID is important in this case because sometimes the users partially complete the form and close it down so in this it doesn't give any record id to the users so they can go back in to complete the...

I used upsizing wizard for data migration and followed the steps. All seems to be working fine for unbound forms. It's just bound forms which are not generating unique ref by default when first control value is input. With MS Access backend, whenever we type something in the first control on...

I can't see identity increment and identity seed in primary key field . I scrolled down the properties. Please see attached the screenshot.

Yes there is primary key defined in the table. Please see attached the screenshot. I have written the following function to generate primary key for the record in the form. SO whenever a user types in first control then it calls this function . And also when Save button or Exit button is...