Search results

I have Two Tables. 1. ELR Table ( ProductID, ProductName, Date of Expire) - Updates every day. 2. StoreData (ProductID, ProductName,Date of Manufacturing,DateofExpires,TotalProducts and Status) My Requirement is to get the New data from ELR Table to to StoreData. Example: ProductA is...

Hi All, I have a Issue System where user can open tickets and input their comments in it. The tables are SQL linked tables. I am trying to implement auto fetch emails by adding a Button. Basically, it will goes to a particular folder "Working" in Outlook and get all the emails which are not...

Greetings, I am by my TL to develop an Recruitment Tool in Access. I tried to make tables and other stuff. But, am not able to find a proper data model. Can any one suggest me a good data model or if any working recruitment sample if possible. Here are some basic needs: * When a Candidate...

Greetings, I am building a CRM for my internal team. I would like to look at the CRM's functionality and want to adopt into my crm. If any one has any sample of reference CRM, Please share. Thank you so much in advance,

Greetings, I am trying to build a small CRM Utility which will be using by 6 - 8 members. Basically, it has three tables, one form and few queries. tblemails (some fields will auto populates from outlook) emailsid vehicleno manufacturer receivedon from body subject tbllive This is linked...

Hi All, I have been trying to create a User Form, which has multiple Filters. But, no luck for me. Can any one guide me. Situation: I have Split Form, which user can add, update records. Table has following Fields, ID, Customer Name, Phone NO, Email, Purchase Enquiry Details, Sales Person...

Hi All, I have a table "Service_Information" with 6 Columns like ID, Part_No, Part_Name, Description, Morning_Records, Evening_Records. Up to Morning_Records, the User will populate the Data with the help of User Form. I would like to populate the Column "Evening_Records" from Other Table...

Hi Brothers, Can any one please guide me on this following Situation. I would like to have a Button "Files to FTP", So, the Macro should move the files from the Local Files from the Directory to the FTP Location. Is there any example available. I searched in Google but no luck. Thank you...

Hi All, I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form. I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is...

Hi All, Can anyone help me on this one. I am getting Syntax error when I am trying to assign the SQL Statement. Option Compare Database Private Sub Command6_Click() SearchResults.RowSource = "SELECT ECTM_ECTM_Computer.NAME, ECTM_ECTM_COMPANY.NAME, ECTM_ECTM_CPU.SERIALNUMBER...

Hi Brothers, Is it possible to populate a List box after clicking the Button? Ok. Here is my situation. 1. Data is on Server (remote location), I have that Access. 2. I built a Form in my local System, which has a Search Field, Button and a List Box. So, When I enter some string in...

Hi All, I have a Query, which is designed on linked Tables, the tables are located at remote servers. When I run the query (only), I am the getting the results very quickly but if I use the Query with a Form (as data source), I am getting the results after 5 - 10 minutes. Is there any way to...

Hi All, I have a Query, which is running on 2 tables and when I run the query I am getting the results like this. Name----------Position Rock----------1 Rock----------2 I want the Results like Name----------Position----------Position Rock----------1 ---------- 2 Is there any way to...

Hi All, I have form and the data source is linked with a Query, which is combination of 5 different tables[Joined with each other] which are located at SQL Server [remote location]. When I am trying to open the form, the form is taking nearly 10 Minutes to show up and some times I am getting...

Hello All, Good day, Thank you very much John for your awesome VBA Code. I have been using John Big Booty Script, which he provided here. [w w w dot]access-programmers[dot]co[dot]uk/forums/showthread.php?t=188663 Please replace[w w w with www] and [dot] with . Now, I am trying to put a...

Hi there, I am newbie in Access. Can any one please help me on this Situation. I have two Tables. TimeCalstble: FileType esttime Dzz 0.15 Dui 1.25 Zui 1.52 Dailydeliverablestble: Name FileType Processed overalltime ramiz Dzz 10...