Home » Developer & Programmer » Forms » Manually Display data on form (Form Builder)
Manually Display data on form [message #449701] Wed, 31 March 2010 09:00 Go to next message
jack01
Messages: 8
Registered: March 2010
Location: Qatar
Junior Member
Hi All,
How to retrieve data manually to the text fields from the EMP database.what are the main properties ?
Re: Manually Display data on form [message #449704 is a reply to message #449701] Wed, 31 March 2010 09:07 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Write a select statement.
But why are you trying to do it manually?
Re: Manually Display data on form [message #449725 is a reply to message #449704] Wed, 31 March 2010 10:08 Go to previous messageGo to next message
jack01
Messages: 8
Registered: March 2010
Location: Qatar
Junior Member
I have placed Text fields over the form on that i want the records. Record group is required for this ?
can you please provide help ?
Re: Manually Display data on form [message #449729 is a reply to message #449701] Wed, 31 March 2010 10:14 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'm going to need more details here:
what's wrong with using execute query?
Assuming there really is a reason why you can't use it are you trying to populate one record or many?
Is the data you need coming from one table or many?
How are you specifying which records you want?
Re: Manually Display data on form [message #449732 is a reply to message #449729] Wed, 31 March 2010 10:19 Go to previous messageGo to next message
jack01
Messages: 8
Registered: March 2010
Location: Qatar
Junior Member
Dear, I just want to retrive all the data from EMP table and display it in appropriate text fields in the Form. Just guide me.
Thx for your help.

[Updated on: Wed, 31 March 2010 10:21]

Report message to a moderator

Re: Manually Display data on form [message #449735 is a reply to message #449701] Wed, 31 March 2010 10:23 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Create datablock based on emp table using datablock wizard and layout wizard.
Re-arrange layout to your liking.
Run form.
Click on execute query button.
Done.

If that's not what you want then it's a case of coding a select statement yourself to populate the items.
If you want more help than that then you need to answer my questions.
Previous Topic: nondatabase item problem
Next Topic: forms updating multiple records
Goto Forum:
  


Current Time: Fri Sep 20 10:45:44 CDT 2024