Search results

Hello, I have a continious form containing data from the table "tblToernament". On that form there is a combobox containing teams that are stores in the table "tblTeams". The table looks like this: ID | TeamName 1 | Team01 2 | Team02 3 | Team03 4 | Team04 When I select, for example, Team02...

Hello, I have a very complex issue. First of all there is a table called "tblParTeam" wich contain the teamname and ID of teams partissepating in a certain Tournament. The tournemant data is kept in the table tblTournament. Each tournament contains a couple of variables: "Number of teams per...

Hello, I have a query containing a tekstfield called 'page' Here are some values of the field 'page': Page ----- no page 33 2.2 2.1 5.6 no page no page when I sort my query on page it looks like this:" Page ----- 2.1 2.2 33 5.6 no page no page no page However...it should look like this...

Hello, I have a form containing a combobox with the values yes (1) and no (2). In my query I have a date field. When the value of the combo is yes only the dates should be displayed. is the value no the the empty fields should be shown. I nothing is selected all fields should be displayed. I...

Thank you very very much. I will test that right away.

When I open MyReport using the following code: DoCmd.OpenReport "MyReport", acViewPreview, "", "", acDialog Access 2007 nicely shows me the report but I cant print it. When I use: DoCmd.OpenReport "MyReport", acViewPreview, "", "", acWindowNormal I can print it but I cant display it in...

Hello, I have the following row: Name ------- Zack Peter Quintin John Brad As you see it is possible to have a blank space When I do order by name it looks like this: Name ---- (blank) (blank) (blank) (blank) Brad John Peter Quintin Zack How can I get this: Name ---- Brad John Peter...

I solved the problem with this: http://office.microsoft.com/en-us/access/HA101749121033.aspx Thanks everybody

I cant create anything. I have made a package with the access 2007 developer extensions. So the user doesnt have access 2007 installed. He only has the access 2007 runtime and the .net framework 2.0 installed. I hope this info clarifies the situation.

I installed .net framework 2.0 on the clients pc and still the buttons look plain ugly. I used this link to download the framework: http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en What else can I try?

I am gonna try it the first thing on monday. Thanks bro...

Thanks for the quick reply. I am developing in access 2007. when my app is finisched I deploy it with de developer extensions. On the pc where I install the package the buttons look old and gray and very square. Om my pc they look very rounded and nicely colored.

Why do the buttons and other features on my computer look nicely rounded en very proffesional but when I pachage the application and install it on an other pc the buttons look gray and very oldschool (not wel rounded, etc). Both of the pc's run on windows XP. Does anybody have an idea?

Hello, When I open a report from a form (dialog) I want to close the form as soon as the data is displayed on the report. I know "docmd.close" doesnt work. What will?

It works.. I added an update to the statement. Now it looks like this and it works: Option Compare Database Option Explicit Public Sub IllustratieVerantwoording() Dim cn As ADODB.Connection Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Set cn =...

This is what I found out so far: Using the following code: Option Compare Database Option Explicit Public Sub IllustratieVerantwoording() Dim cn As ADODB.Connection Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Set cn = CurrentProject.Connection Set rs1 = New...

The example of ken works perfectly. But not with my data (see 1st post) when I run the code it shows only one record but there is nothing in the description field (where the data should be consolidated)

The example of ken works perfectly. But not with my data (see 1st post) when I run the code it shows only one record but there is nothing in the description field (where the data should be consolidated)

I just cant get it to work. Is there really no way to do this in sql?

Is there a way to do this in sql?