sanniep
Last Activity: Dec 5 '18, 11:59 AM
Joined: Aug 22 '06
Location: Netherlands
-
Hi mbizup, and thanks for your response. Code was almost done, only had to add the recordset and change the fieldnames. Turned out to be simple thanks to your start. Thanks again! -
Insert years based on first and last year
Hi guys,
Hope you can help out. I would like to create a query or piece of code to create records based on a start and end value. So I got this data:
Name Value Start End
DF334 ABC 2004 2007
DF335 DEF 1998 2001
DF336 DEF 2013 2016
And I want to make it like this:
DF334 ABC 2004
DF334 ABC 2005
DF334 ABC 2006
DF334 ABC 2007
DF335 DEF ... -
Another row value to columns question
Hello!
I have an access table filled with 10k records that look like this:
Product Car
601945 Vauxhall Astra
602117 Peugeot 806
602117 Peugeot Expert
602117 Citroen Dispatch
602227 Vauxhall Vectra B
602227 Opel Vectra B
I want it to look like this:
Product Car
601945 Vauxhall Astra
602117 Peugeot 806, Peugeot Expert, Citroen Dispatch
... -
In this case there will be 40 columns. But for each ID, I don't know how many columns have a value. It could be 0, it could be 40.
If I use Unions, how will I have the ID copied to the necessary number of rows?Leave a comment:
-
Column values to rows
Hello,
I have a table like this:
ID Value1 Value2 Value3 Value4
124422 ABC HGV HGB
213441 HGB KJU
324523 HJU YGH JHU JHY
345523 YGF
There are about 4000 rows with unique ID's and a maximum of 40 value columns.
I want the result to be like this:
ID Value
124422 ABC
124422 HGV
... -
Hey rsmccli,
Excuse me for responding this late, I was defragmenting my brain on a 2 week vacation... Anyway, thanks very much for your perfect explanation!! I am going to figure this one out, I'm sure!
Thanks to Stewart Ross Inverness too for adressing the normalisation issues! Although that's my latest concern, I will definitely take make sure to solve this the right way.
Regards and thanks again, ...Leave a comment:
-
Hey rsmccli,
Thanks for your reply but I still can't seem to figure this one out.... Sorry.. I don't understand how having 2 tables (personal info and activities) would help me solve this.
I can add a PK to the existing table but I would still need a script which does the looping and filling. Can you help me out with the VB script?
I'm such an VB-noob...
Hope you, or someone else, can help...Leave a comment:
-
Format scattered information in Access table
Hi guys and girls,
I am trying to format a table with scattered information to the right format. The table looks like
this.
As you can see their are a, per user, different number of rows containing activities and time. Between the username and activities is an empty row. I would like to fill the Name & Tel in the empty cells in the activity & time rows. It should look like this.
How do... -
Thanks for the input guys! That Allen Browne has some bright ideas!
Jim, would you mind sending the database in a zip-file to my hotmail (piekedasse@hot mail.com)?
Thanks again!
SanderLeave a comment:
-
Search a choicelist
Hello,
I've got a table containing customerspecifi c records (names, adresses, ID's, etc). I want to search this table using a form with a choicelist on it. This choicelist displays several columns (Name, adress, zipcode, customerno and several others).
Now comes the tricky part, what I want is:
- a textbox where a value is entered
- all the data in the columns must be searched simultaneously on every entry... -
Create a textbox and use a dlookup expression, something like
Dlookup("[Value]","[Query]")...Leave a comment:
-
Program to schedule Access reports
Dear Expert,
I've been searching the web for a program which can be installed on a workstation/server and executes predefined tasks for exporting/e-mailing Access reports from different databases.
I came across MARS which would do the job perfectly but I don't think the $18.000 for a usage license will meet up with any ROI.. Can anyone suggest me alternate software which has a more acceptable price?
Thanks... -
Exporting Access Pivotchart to Excel
Dear Expert,
I would like to program a button to export an Access pivotchart to Excel. The predefined button works ok but I would like to automate it.
Thanks, Sander -
Thanks Killer and PEB for your input!! I've got PEB's functions to work, result works as a charm!
Thanks again! SanderLeave a comment:
-
Man, I don't get this to work!! Whaooaoaoaoao!!
Peb, can I sent you a sample database? It will contain 2 tables, a sample table and a table how I want it to be. Could you applicate your solution to this database?
Hope to hear from you mate! Grtz, SanderLeave a comment:
-
Hi Peb,
Priorities shifted so I didn't look into this problem since now.. Thanks for you september reply!!
I will try your function, thanks for the effort!
SanderLeave a comment:
-
Hello mmccarthy,
Thanks for your advise. I'm applying the expressions from the Access Query designwindow, not from SQL or VB. In this rookie 'can't function wihout a GUI' interface I have to use semi colans, commas aren't accepted..
But I've tried your iif(Not IsNull([Forms]![Form1]![txt_item]);[Forms]![Form1]![txt_item]). After a run Access modifies the iif to:
iif(Not([Item])=IsNull([Forms]![Form1]![txt_item]);[Forms]![Form1]![txt_item])...Leave a comment:
-
On a correctly formatted date/time field your expression should definitely work.. It even works on text when it's correctly formatted.. Do you use other criteria or are you filtering the wrong field?...Leave a comment:
-
Hi PEB,
Thanks for your help again!
When I leave the textbox empty and put a msgbox to the button with the value of the textbox as messageboxtext Access says "Invalid use of Null-data" so the value of the textbox when I leave it blanc is Null..
The question is how to let the query know that if I leave the textbox blanc it has to show everything instead of nothing..
I've tried...Leave a comment:
-
That's little information.. What do you mean exactly? Latest record in a table? What do you mean with parsing a database?...Leave a comment:
No activity results to display
Leave a comment: