Search results for query: *

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...

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...

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...

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...

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...

Is there anyone that has heard of a pdf patch converting tool that lets you convert only the first page from a file? I have a customer that has thousands of pdf files that all has a "bad" second page and those doesnt need to be there. Would love some ideas //Micke Sweden

How do I put a progressbar on a form while I´m running one or several queries in the background. I´ve been looking at activeX components without much luck. //Mikael Nilsson Sweden

The user chooses a Order.no in a form to get all the rows concerning that order, the result (of the query) would be something like this. Order.No Order.Row Copies InfoText 4049 10 2 Text for row1 4049 20 1...

I´m importing some data to access. One field is a datefield which is formatted as text like this: 2005064. I need this datefield to be formatted as yyyywwd (year, weeknr, daynr of the week) 2005064 2005 = year 06 = weeknr 4 = Day of week "thursday" I need the date in this format so I could...

I did a booking system using a bookingtable that looks like this Date time0700 time0800 time0900 time1000 day time0700 time0800 time0900 time1000 20050110 750712 780523 670914 870210 I´m putting the personID in the field of the date and time. That...

Does anyone know where I can find an example database for a booking system. a program where I can book an apointment in 15minutes blocks and be able to see what apointmentslots is available for a specific date. If anyone out there has done any similar stuff I would be glad to get some example...

I´m running some queries using linked tables, the customer complains about that it takes to long to run the different reports, therefor I´m planning on importing the tables and then run the reports(the update needs to be done every morning or ones every two days). Theres no problem importing...

I´m doing a report which the query gets a value from a field in a form. there is no problem using one value for example, if I type a number ex 350 in the field the query/report will show only the records with the number 350! the problems comes when I want to choose more than one number for...

I have a datefield formatted as text that I would like to group by the first 6 numbers. example 20040101 20040112 20040115 20040201 the result should be two groups with the first three in the first group and the last number in the second. I want to do this in the query not in a report...

I have a field that gets a value from a business system. the value could be (BA12, or any other combination) I want this value to change to something else for example BA12 to 10% BA13 to 15% Is there an easy way of doing this? I would be glad for any ideas or suggestions. Mikael...

I have a form that prints out some labels, after the printout I want the focus to get back to the form (on a specific field, Artikelnr). My code (on the button in the form) is stDocName = "Etikett kundensartikelnr" DoCmd.OpenReport stDocName, acViewPreview DoCmd.PrintOut , ...

Hey, I have a simple application that prints out labels, the form that I use for this is not in focus after a printout. Is there any easy way of getting the focus back on the form without clicking with the mouse? I´m using some code to take away the shell on access so only the form itself is...