Hi guys wonder if anyone can help me. I have tasked with putting together a website that will require me to get stocks and share information daily(and possibly real time). I have no idea where to start on this topic. I orginally thought i could use an rss feed but i have searched unsuccessfully.
If any one could help it would be greatly apprieciated. This would be regarding any relevant links or possibly what language i may need to...
tmh86
Last Activity: Jun 18 '08, 01:43 PM
Joined: Dec 23 '07
Location:
-
Personal feed, Stocks and Shares
-
Problems printing forms/subforms
I am currently building a database within Access 2007. I have a form that is populated via vba coding and thereform is not stored in a specific table.
I have created a button that essentially runs through all objects on the form and changes their formatting settings to that of an access report(Making the text blue etc). I did this because i have many different forms that i would like to able to print and thought this would be a quicker... -
Currently using the standard sql database within access. I want to be able to export this preferably to excel to put back into later versions of my programme.
I am a new comer to this so any light you could shed on the advans of the different formats would be apprieciated.
T -
Import / Export From Access
Hi guys,
Wonder if you can help me at all been searchng the web to see how to export a database and then import it. I am not bothered about the format (*.csv) or (*.txt).
If any one could help or point me in the right direction it would be appreciaited. Cheers,
T -
Cheers,
I actually ended up using
MyRec.Fields(fi eldName)
Thanks for the helpLeave a comment:
-
Getting data from SQL Select Via VBA
I currently have no Problems with the following code;
1. Dim MyRec As DAO.Recordset
2. Set db = CurrentDb
3. Set MyRec = db.OpenRecordse t("SELECT * FROM Table")
4.
5. Text1.Value = MyRec![Field1]
This works fine when the field name on line 5 is written manually in the code. I am however trying to make this a variable. However when i do i get the error
"Item... -
Thankyou for your help,
I have now figured out what i needed to do. For all those interested after executing the sql i put in the data values to the controls on the form,
Text1.Value = MyRec![Field1]
Then used MyRec.Movenext to move onto the next recordsetLeave a comment:
-
Brilliant,
One more q though. How do i then translate that onto the form.
Previously i have been using MyRec = db.RecordSet(Sq l)
And the Text1.Value = MyRec![VisitID]
how do offset the Record to move onto the next one without putting it into a loop?Leave a comment:
-
Cheers,
In the first table i have Client=>ClientI D, ClientName, DOB
In the second Visit=> VisitID, ClientID, Date
Do you need any more. Thanks for your speedy responseLeave a comment:
-
Referencing the queries
Hi,
I am currently building a database. The basic relationship is that one client has multiple visits. I am however having trouble showing the multiple visits on one form. I need to show the very first visit and then the previous 4. Any help would be great please guys.
I am aware i can view all th visits on a form from one of the options on the form wizard('Tabular Version) but i need to build it to my requirements,...
No activity results to display
Leave a comment: