Hello
I’m quite fresh by using Tab control in Access. I want to use Access for a tournament, with one page for each competition with 1 to hundred competitors in each run. I have done this manually, and it works fine. However I would do it dynamic by reading the competitions from a table since it differs from each tournament.
Bombus
Bombus
Last Activity: Mar 15 '08, 04:13 PM
Joined: Sep 6 '06
Location: Norway
-
Dynamic Tab control in Access
-
Combine tables in a single form
Hello.
I have MS Access 2003 and Visual Basic 6.0.
In the Access database and two tables tblA and tblB that have a common field fldPN (Personal Number). I use ADO connection.
From tblA I have selected a few columns that I show in VB Form1, and a datagrid showing all rows with the same fldPN value in both tables. This works perfect, and was not to hard to code.
However, instead of the datagrid... -
Thanks a lot.
Bombus -
How to access fields in different forms and subform
I have a form frmA with two subform frmAA and frmAB. Subform frmAA has its own subform frmAAA. What is the right syntax for pointing to fields in other subframes and subsubframes?
In my case, I want to update varAB on frmAB with varAAA on frmAAA from command button on frmAB
Something like
varAB = Forms!frmA!frmA A.Form!frmAAA.F orm.varAAA ?????
What is the right syntax for this? Where do we find... -
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessHello PEB.
I just want to inform you I have solved part of my problem by using ASP and WINHTTP. I just had to mark Microsoft WINHTTP 5.1 under reference. Than I could use WINHTTP to run the ASP on my server. Then I got all the information I needed to do the update in the Client Access :-) It worked just perfect!
Most info I needed I found on http://msdn.microsoft. com/library/default.asp?url =/library/en-us/winhttp/http/winhttprequest. asp...Leave a comment:
-
Thank You jkantner.
That was a good link. Exact what I was looking for. Thanks a lot. I thought I had to do a lot of programming, but this was quite easy.
BombusLeave a comment:
-
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessI suppose you are right. However I found this:
ADO URL Connections
ADO 2.5+ allows you to open up a Recordset based on XML returned from an ASP file over HTTP. This feature doesn't use RDS at all.
ADO Recordset
To get records from a remote database
oRs.Open "http://myServer/AuthorsGetBySta te.asp?state=CA ",, _
adOpenStatic, adLockBatchOpti mistic
...Leave a comment:
-
How to do numbering on a result list in a report
I have a result list from a sport arrangement. This is shown in a report. To show the placement I have a textbox with the expression "=1". That result in first records from my query get the number 1 in the textbox, second record get 2 third get 3 and so on. However, sometime this is fault.
Imagine record just contain NAME and the result TIME. If two results have the same (time(3)=time(4 )), I still will get 1, 2, 3, 4,... -
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessHello.
I haven't succeeded yet. But I'm working with it when times allow. So still I do not have any good news.
However I have a close related question.
1) From my server on the web, I have an ASP script, creating records. Is it possible to import this records table directly by the URL without manually saving them to a file first.
2) I have a MS Access 2003 Form with a Microsoft Web Browser...Leave a comment:
-
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessThanks a lot for the help.
I have found some samples and descriptions that I will try. Somebody said it was hard or even impossible with MS Access, but works find with MySQL. But I am not sure since I found some god information on Microsoft telling how to do it. I will try to test this on my own MS Access databases now, and hopefully it will work:-)Leave a comment:
-
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessI can´t see how I can connect a remote MS Access database on the WEB by using ODBC and IP. Any good suggestions for how to do that? If possible, do somebody know how to do it? May be I need a database server???
How can I solve this. I suppose it should be possible to find some smart trick?Leave a comment:
-
Bombus replied to How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessHello.
It is not Virtual Private Network, just ordinary WEB. As I said, I have no experience with this ahead, only using ASP script on server. That works fine for a WEB browser. But I want to update my tables from the client MS Access database. In some way I want to run a query (or??) against A.mdb and use the result to update the right table in B.mdb.
I want to start the query (or?) form B.mdb, and receive the result...Leave a comment:
-
Bombus started a topic How to receive data extract from server (A.mdb) directly to a table on client (B.mdb)in AccessHow to receive data extract from server (A.mdb) directly to a table on client (B.mdb)
Hello.
I have two different types of MS Access databases (A.mdb). One is on a server, and several databases at clients (B.mdb).
Now I want to develop some code that can extract data from the server (A.mdb) table directly to a client (B.mdb) table through internet just by pressing buttons.
I also want the clients (B.mdb) to update the server (A.mdb) table.
I have no experience with this,...
No activity results to display
Leave a comment: