Recent content by ajaymansata

data from excel Hi I have an access database with say three tables 1>Customer 2>vendor 3>Inventory Now customer and vendor table have an id field which is an autonumber field Now in the inventory table i have itemid , customerid, vendorid and quantity. Now i have an excel sheet with data in...

hi Well i have a database and tables with me.I have a spreadhseet which has data in it.I would like to import that data into my database and also maintaining the relationships. Can anyone tell me how can i do it. Can it be done using wizards or will i have to write some code. Thanks in advance...

Hi I appreciate the help but as i have never done VB before i am facing a problem. Well let me tell u exactly what i have with the right names and everything I have a form named search form with three text fields and one search button names of text fields are lastname,SSN,studid, Name of...

Hi I appreciate the help but as i have never done VB before i am facing a problem. Well let me tell u exactly what i have with the right names and everything I have a form named search form with three text fields and one search button names of text fields are lastname,SSN,studid, Name of...

Hi Well i am firing a query to search records and then using a form to display those results.Now is it possible without any VB Script code to display a dialogue box which says no records present. Actually I have never worked with VB so i do not know anything about it. My search form name is...

Hi all Well Actually i have a problem What I have is a search form. When i enter lastname i have fired a query which retrieves records corresponding to that last name.Then i am using a form to display results of the query. However what i want is that when no records are present i should display...

hi I have created a form in the datasheet view. It shows only one record at a time. What i want is that the form should show 6 records at a time. How can i do this

I am taking the name to search from a form in a field called name. I am firing a query select * from table where lastname like "[forms]![formname]![name]*" but still the query does not give me the desired result. could anyone please suggest me

Hi I would like to fire a query which would give me records having 'm' as first character in the name field I fired a query Select * from table where name like "m%"; But it does not seem to work Now i am not sure if % works in access.From help file i felt it does not.Could someone tell me how...

is it possible that i open a form and on clicking a button another form is opened.how do i do it

hi I would like to delete a record based on studid from all the tables which has an entry of that id. When i create the query i am specifiying all the tables which are involved. but still while running the query it gives me "specify the tables to delete from." Why is this error message popping...

hi I have some tables listed as below personaltable,education,employment history. Now i have a search form.I am trying to search by studid;which connects all the tables. Now i would like to search the tables using stud id such that when the particular record is retrieved the user should be able...

Hi Well i have a search from.Say i enter the last name as the search criteria. Now i have some tables called personaltable,edu table,employment table. All the tables are linked with a common field studid. Now i have created a form which has personal table in the main form and subforms based on...

Hi. I have some 3-4 tables all linked with an id field and having different types of information.I also have a search form.Say i want to search by last name.is there a eay way where i can search a record in table 1 based on the lastname entered in the search form.Also if there are 3 entries...

hi.I have a problem and do not know how to go about. Actually i have 3 tables. Personal table,employment information and edu table. i have a search form which has 3 fields last name id SSn what i want to do is that when user enters the 3 fields i want to fire a query which retrieves data from...