Hi
Thanks for VBA code.If you find sql query and if you have time then do please post it....
ramdil
Last Activity: Jul 10 '08, 02:06 PM
Joined: Dec 5 '07
Location:
-
Update Statments
Hi All
Please help me .Hope i have described my problem clearly below.
I have a condition where i need to update some data in table from the value taken from another table.So basically i need to create a update statment to perform the data manipulation.bu t i am not able to write the update statments.I have two tables..Tab_Boo kings and tab_Booking_Far e_Lines .Both are joined by field Booking_ID.Now there is a column No_Passengers... -
Thanks for the adviceLeave a comment:
-
Hi
Thanks for the reply.Both Front end and Back end resides in central server and users are given the shortcut..So from the reply i also imagine it was due to some network problem.....Leave a comment:
-
#Error in all textboxes
Hi
I have a msaccess application with access forms and tables.I have seperated the front end and back end.My forms are directly bounded to tables.My problem is that some times users when while working on form will get #error in all fields and when they restart the applications it is working fine.I tried to find , but not able to find why this error occurs.Can any one help me by pointing why this error comes.What causes this error.Thanks in... -
Hi
Thanks for the information.I think it is the best idea...Leave a comment:
-
Hi
I had went through that link, but its not helping me in getting my result.I will just explain my scenario.My table has three columns,ID which is autonumber,Name which is text and date which is of type date.Now my duplicate data will be like this
100 TestName 23/01/2007
101 TestName 23/01/2007
102 Name2 24/01/2007
103 Name3 23/01/2007 and so on
Now i want a...Leave a comment:
-
Delete Duplicate Values
Hi All
I have table and it have around 90000 records.Its primary key is autonumber field and it has also have date column and name, then some other columns
Now i have problem with the table,as my table contains duplicate entries for a particular date.How can i delete the duplicate entries from the table for that particular column,Now i am doing manually with name column as it will be unique for that date.Can any one help me... -
Hi Thanks for you valuable help....Leave a comment:
-
Date Validation
Hi All
I have a small requirement.I have column called payment date in my system.Now i want a validation as follows.
when someone enters a payment date for over a weekend or bank holiday then it show a message its a holiday.How can it be done.I know some weekday functions are available but will it give me bank holidays or sat or sundays..Can any please give some idea on it.One idea in my mind is to create a table which stores all these... -
Hi
Thanks for the reply.Yes it has sorted out my problem.Leave a comment:
-
Form Set focus problems
Hi All
I have a form with section and multiple pages(tab sections) in the section.Now i have added a button in the form which when clicked will open a form.Now my problem is that when i click the button the new form is getting opened but the control is still in the first form only.i have added control.setfocu s in the form activate and form open method of second form but also control is not getting transfered to second form if i click... -
Hi
Thanks for the help.Leave a comment:
-
Hi
Checking your insert statments, i think parameter are also included as hardcoded values.Check the insert statments creation in your code.
for eg
"INSERT INTO simplesql (simple_id, simple_text) VALUES (" + param1 + ",'" + param2+ "')"
your insert statements also should be like this
Hope this helps youLeave a comment:
-
Hi
SELECT [Identity date info_2].Id, Max([Identity date info_2].Date) AS MaxOfDate, [Identity info_1].Nam,max([Identity date info_2].Nam)
FROM [Identity date info_2] INNER JOIN [Identity info_1] ON [Identity date info_2].Id = [Identity info_1].Id
GROUP BY [Identity date info_2].Id, [Identity info_1].Nam
Hope above query helps youLeave a comment:
-
Page which Displays data
Hi
This is my new post in this group.I always find good support in Access group.So hoping to get the same from this group also.I have a table with three columns in access table.Now i want to create a webpage which will ask input the serial no .When they press button, it should show in a table the related records in the table .Can any one help me by giving the code for doing this.or any good related links so that i can do it.My final... -
Page which Displays data
Hi
This is my new post in this group.I always find good support in Access group.So hoping to get the same from this group also.I have a table with three columns in access table.Now i want to create a webpage which will ask input the serial no .When they press button, it should show in a table the related records in the table .Can any one help me by giving the code for doing this.or any good related links so that i can do it.My final... -
Unique Number Creation
Hi All
I have got a lots of help from this forum and again i am in need of yours help.
I will briefly explain the scenario.I have a customer table.It was created 12 years ago and its Primary key is Text value..And users was entering the customercode in their own.But now they are asking me to autogenerate it.Since its datatype is text, i cant use autonumber as i cant change the datatype.
So what i am trying to do is to generate... -
Hi Thanks for the valid point
I have changed the logic and now i am updating the records based on the unique value and is working fine....Leave a comment:
-
Thanks for the replies.I will try and get back to you .Any thanks for all responses....Leave a comment:
No activity results to display
Leave a comment: