Search results for query: *

Hi, thanks for the replies and since I´m a newbie on both XML and programming I have to do some research :) I will se if the script would be a good way to go or if a dedicated program suits my needs better since I´m no expert in programming. The Project I´m doing this research for is a EDI...

Hi, I need to convert a XML file into a flatfile structure that I could use for importing into our business system (orderimport). Are there any good mapping Tools for doing this or whats the most common way of handling conversions like this? I´ve looked into Altova Mapforce but havent found...

Yea, your right BigRed. thats what I would do If I had the time to learn more about html and css. And I know that theres people out there that only wanna work with the design part of a project and thats a person I wanna find. The main problem is that my project has become bigger than just me...

Thanks, I´ve posted this post in the web site designers forum... //mike

Hello everyone, I have a new webproject that I´ve been working on during my spare time for about a year now. It´s a forum/community about interior design/house pictures. Since I´m doing everything by my self the part of design and structure of the site is really bad. I´m looking for Ideas of...

Hello everyone, I have a new webproject that I´ve been working on during my spare time for about a year now. It´s a forum/community about interior design/house pictures. Since I´m doing everything by my self the part of design and structure of the site is really bad. I´m looking for Ideas of...

I have a number of addresses in a memo field like this. John Doe Downer avenue Apt 4 90210 Beverly Hills USA how do I split each row into its own field? I have tried the (Len(MemoField) - Len(Replace(MemoField, Chr(13) & Chr(10), ""))) / 2) to get a number of how many enter/breaks there is in...

Thanks for the tip about pivot and I did manage to get it to work with one page but not if I have several pages.I Read somewhere that U cant use text (only numeric values and I have several fields with text like the description of the items etc.) in multible source Pivot? is that true? Any...

Thanks for the quick response, What I´m trying to do is copy a full row if a field is not null and display them on a nother page. ex Page 1 Art pcs 10 0 20 7 30 0 Page 2 Art pcs 60 1 70 0 80 0 SummaryPage (show the rows where the pcs is >0= Art pcs 20 7 60 1 I´m...

Where using excel as an orderbook where the items we sell are divided into different pages. Is there a way to copy only the items with >0 in the PCS (how many items) field (on alla pages) into a summery page? I could use a filter on every page showing only the items with something in the PCS...

Does anyone know if theres a fix out there for this problem? Just got noticed on this little nice bug and its a huge one for me, dont wanna do a vba fix for every report I´ve done and what I could tell theres problem with the papersize as well. Would love any "easy" fix or info on the status...

that code worked perfect, Thanks dhookom! Well worth a star

Hey everyone Is there anyone out there that knows how I could disable the error message that pops up when something goes wrong in vba code in a report. I´m using vba in a report that checks a value in a field and writes a message in another field. Everything works fine until my query doesnt...

I have a report that contains a number of pages, Now I have the pagenumber in "falling" order ex 7,6,5,4 ... my problem now is that I need to have the pagenumber in set of numbers ex if you write 2 in a box of some form I need 7,7,6,6,5,5,4,4 if you write a 3 you get 7,7,7,6,6,6 and soo on. I...

I mananged to get it to work when I changed the format on the table, another problem is that I´m testing on a database where I have imported the whole table from the main system but on the "real" database I´m going to have linked tables. And with linked tables theres no way for me to change the...

Thanks soo much for helping me but I still get the same message, isnt there a way of just disable the errormessages in vba? that would solve my problem, then I just put a messagebox in the error section of my button/field. Any ideas?

Sorry, the following part is highlighted (only when I dont get a match) If IsNull(DLookup("[Tillv_ordernr]", "1 Rapport Etikett urval", "[Tillv_ordernr] =" _ & Forms![huvudmeny]![TxtTONR])) Then the errormessage is in Swedish but It translates something like this: error nr 3464...

it works fine if a match exist but when it doesnt I get a error message, this is the code I was using. If IsNull(DLookup("[Tillv_ordernr]", "MyTable", "[Tillv_ordernr] =" _ & Forms![huvudmeny]![TxtTONR])) Then MsgBox ("does not exist") Else MsgBox ("Exist") End If any...

I know I can use Dlookup to show a record but how do I/Can I use it to display if the record exist?

Hello I have a form that´s not based on a query or table, on this form I have a field that I use to display a record in a subform. I need to check if I get a match before I use the subform query. if record exist messagebox("record exists") and if it does not get a match msgbox("record does...