Recent content by ansar.abdulhai

Hi Paul, I tried opening new table and all that stuff. Please see my code below: Private Sub Generate_Ticket_Click() Dim olapp As Outlook.Application Dim olNamespace As Outlook.Namespace Dim olfolder As Outlook.MAPIFolder Dim olMailItem As Outlook.MailItem Dim olattach As Object Dim...

I will give it a try Paul. I am trying now!

Is there anyone who can solve my issue????????????? Please!!!!!!!!!!!

That's right Paul. My software would not be implemented if there are skipped autonumbers coz it is frequently audited. Is there any way around?

I am having trouble to do this error trapping. How can I lock the table and let the other user wait until the first user completes his operation and populates the table and then let the second user generate another ticket number and close the form. Please see my code below: Private Sub...

Hello All, Don't know this is the right spot to ask multiple user access issue. I have a multiple user access database in access 2007. I did created back end and front end. Made accde format of front end and copied it on everyones desktop. Every thing works fine. Problem: I have a form...

Hello Rabbie, Thanks a lot for the reply..... I understood how I should prepare my forms. But, as I am a beginner and I don't know the programming, can I get a sample code of searching a particular record and if present editing it and if a record is not present in the table then creating a new...

I agree with that..... But both of my forms will be data entry forms.... and not editing forms......... I am splitting one half section of the table fields and including those into form1 and the other set of fields into form2. But, form1 and form2 will be filled at different timings. I wanted...

Hello ALL, I have a table which has several fields. Data into these fields are entered by two separate forms at different times. Data from form1 will be stored and saved say in one record and form2 which is filled at different time should save its values into the same table within the same...

Wow Missinglinq! Thanks a lot. That did it. I also need help about creating login forms. My database works in this fashion! I have created database for accomplishing an engineering project. Say a new project comes to my company. The project manager enters details of the project in one table...

Sorry for being so confusing!!!!!!! Let me put it in clear manner. I am using Access 2007 to create database for a certain project. I have created the tables and also given the relationships between each table. I now want to create input methodology. For that I have to create forms. But if I...

I have seen in the references that I have Microsoft OLE DB simple Provider 1.5, Microsoft OLE DB for OLAP. Basically I am very new to Access and programming VB. But I am learning fast. Do I need to select any of these as reference in VB Editor? OH! By the way I am using Access 2007. How do I...

Thanks Bob and Baldy. Bob: I don't want to let users view all the records from the table by using a bound form. Every time a user opens a form it should be blank and the user should not be able to view any record from the back end table. After entering data in the form then the user should...

Hello all, I want to use unbound form and when after every field is filled out in the form I want to now add that data in the table at backend. I am using Access 2007. How do I populate tables by using a button on unbound form? Please help me!!!!!!!:confused:

Hello All, I have a form1 linked to a table1 in back end. What I wanted with that form1 is to enter data into the table1. But, I don't want to enter it spontaneously. The user should first get another small form asking to enter a certain field value. Now after entering value in the field, the...