473,323 Members | 1,550 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Really need help with VBA

I have a problem with my access database, I have a table that has the column names (see below), and what I want to do is to change the columns into rows in chronological order with the first 7 columns staying the same, this would create a really large document. What is the best way in Access VB to do this.
unittra meas direction partner rep airport 2006a00 2005a00 2004a00 2003a00 2002a00 2001a00 2000a00 1999a00 1998a00 1997a00 1996a00 1995a00 1994a00 1993a00 2007q03 2007q02 2007q01 2006q04 2006q03 2006q02 2006q01 2005q04 2005q03 2005q02 2005q01 2004q04 2004q03 2004q02 2004q01 2003q04 2003q03 2003q02 2003q01 2002q04 2002q03 2002q02 2002q01 2001q04 2001q03 2001q02 2001q01 2000q04 2000q03 2000q02 2000q01 1999q04 1999q03 1999q02 1999q01 1998q04 1998q03 1998q02 1998q01 1997q04 1997q03 1997q02 1997q01 2007m10 2007m09 2007m08 2007m07 2007m06 2007m05 2007m04 2007m03 2007m02 2007m01 2006m12 2006m11 2006m10 2006m09 2006m08 2006m07 2006m06 2006m05 2006m04 2006m03 2006m02 2006m01 2005m12 2005m11 2005m10 2005m09 2005m08 2005m07 2005m06 2005m05 2005m04 2005m03 2005m02 2005m01 2004m12 2004m11 2004m10 2004m09 2004m08 2004m07 2004m06 2004m05 2004m04 2004m03 2004m02 2004m01 2003m12 2003m11 2003m10 2003m09 2003m08 2003m07 2003m06 2003m05 2003m04 2003m03 2003m02 2003m01 2002m12 2002m11 2002m10 2002m09 2002m08 2002m07 2002m06 2002m05 2002m04 2002m03 2002m02 2002m01 2001m12 2001m11 2001m10 2001m09 2001m08 2001m07 2001m06 2001m05 2001m04 2001m03 2001m02 2001m01 2000m12 2000m11 2000m10 2000m09 2000m08 2000m07 2000m06 2000m05 2000m04 2000m03 2000m02 2000m01 1999m12 1999m11 1999m10 1999m09 1999m08 1999m07 1999m06 1999m05 1999m04 1999m03 1999m02 1999m01 1998m12 1998m11 1998m10 1998m09 1998m08 1998m07 1998m06 1998m05 1998m04 1998m03 1998m02 1998m01

i have no clue how to go about doing this so any help would be apprecuated
Mar 12 '08 #1
2 1073
debasisdas
8,127 Expert 4TB
Kindly post what you have tried to solve it .
Mar 12 '08 #2
Joelle
6
Hi,
I am facing a problem now and am not that familiar with vba couls some hel pem?
i have a listbox named ProductList which contains all the products,and based on the selection i made i would like to have only the report of the product(s) i selected.the listbox is Multiselected
The report that i have to filter is" RequirementObjects_Report"
here is the code i wrote but whenever i click the command button to execute my codes the report gets printed
Am i making somewhere a mistake?Please help

Private Sub Command128_Click()

Dim var As Variant
Dim strF As String 'holds report filter

If Me.ProductList.ItemsSelected.Count > 0 Then
For Each var In Me.ProductList.ItemsSelected
strF = strF & Me.ProductList.Column(0, var)
Next
'it is time to call the report

DoCmd.OpenReport "RequirementObjects_Report", , , strF
Else: MsgBox "Please choose one product in the listBox before you press the key"

End If

End Sub
Mar 12 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

66
by: Darren Dale | last post by:
Hello, def test(data): i = ? This is the line I have trouble with if i==1: return data else: return data a,b,c,d = test()
5
by: Rob R. Ainscough | last post by:
This is more of a conceptual question: 1. More and more companies are using VPN's and locking out internet connectivity (for a host of reasons, security, productivity, etc.). 2. ASP.NET...
21
by: Hattuari | last post by:
I'm learning C++ after having spent several years in the computer industry doing both system administration and engineering. I've written code in Perl, Bash, Pascal, Ada, C, Mathematica (hundreds...
26
by: DeMarcus | last post by:
Let's say we're gonna make a system library and have a class with two prerequisites. * It will be used _a_lot_, and therefore need to be really efficient. * It can have two different...
15
by: Jeannie | last post by:
Hello group! I'm in Europe, traveling with my laptop, and I don't any compilers other than Borland C++ 5.5. available. I also don't have any manuals or help files available. Sadly, more...
3
by: Chris | last post by:
Wait.. before you flame.. If someone can program in Java, or Javascript, or C, or (insert your language here that uses basically the same syntax as C#), and that person knew how to program in...
131
by: pemo | last post by:
Is C really portable? And, apologies, but this is possibly a little OT? In c.l.c we often see 'not portable' comments, but I wonder just how portable C apps really are. I don't write...
22
by: SQACSharp | last post by:
I'm trying to get the control name of an editbox in another window. The following code set the value "MyPassword" in the password EditBox but it fail to return the control name of the EditBox. ...
23
by: mike3 | last post by:
Hi. I seem to have made some progress on finding that bug in my program. I deactivated everything in the bignum package that was used except for the returning of BigFloat objects. I even...
0
by: raylopez99 | last post by:
I ran afoul of this Compiler error CS1612 recently, when trying to modify a Point, which I had made have a property. It's pointless to do this (initially it will compile, but you'll run into...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.