Search results

Hmmm - I'm sure I tried that combination, but .......... :) Do U also happen to know how to "break" a looooong SQL line in VBA?¿?¿¿?¿?¿ :D Thanks so much, Travis. Soren

Hi there. None of my books describes how to "breake" a SQL statement which is more than 255 char. long?? Following statement gives me some trouble...: Sum(IIf([divisa]="PTS",([Importe Neto]/[Cambio]),[Importe Neto])) AS FactSin I've tried with #, &, ', and a lot of other char but I can't find...

Jeff, sorry to disturb you again, but could you give me a hint, how to install extra filetypes? I've been searching the help of Access and the ValuePack, but everything here is in spanish, and I'm not fluent in spanish ... yet so I'm still missing a lot of technically terms. Best regards Soren...

Hello Jeff. THAT's sounds like a good idea. I've downloaded and installed the SnapShot program but when I'm trying to export a report I don't have this type *.snp in the list of formats. I'm running Win98 rel.2 and Access -97 Any suggestions? Best regards Soren p.s. Yes, I have restarted my...

Hi again Doc_Man I've tried your solution and technically wise it works, but my company here don't want to accept the "new" design of the packinglist . . . soooooo I'm back to point zero :mad: Thanks for your time and help. Soren

Hi Doc_man. Don't apologize, I guess once long time ago, you were in the same situation as me ;) so you know how much you value a helping hand !!! I haven't tried that solution yet, but where do I find the *.RTF file with my report - in the Access lib?? Maybe you can tell me if what I want to...

Hi Col. No - unfortunately :( My first idea was to create a report in the acounting system and just e-mail that report directly to the trans.comp. but the e-mail function in this acounting system is very poor, and when I tried to e-mail a packinglist on more than one page the result was awful...

Hi there. I need some wise words regarding how to "attack/solve" this task. - I got a acounting system, based on Access -97. - I got a logistick company which is taking care of sending out our books. - I got every day an amount of packinglists from the acounting system, which I'm sending to...

Hi CharityG... Yes, I think this is it - problems with circular references - thanks. Now I just have to "play a little" with the parametres so I get the right numbers in my fiels. Sorry that I expressed myself a little clumsy. I've been here in spain one year now and it's amasing how fast you...

Q: Is it not possible to use IIF to "modify" the same field as it's testing? Exampel: In a report I want a 0 if the field is empty. I'm using this syntax in the source-property-field: =IIF(ISNULL([field1]),0,[field1]) Field1 is of the type: Currency Pls. tell me where I'm doing wrong :-)...

Hi there. I've been working with a Q in Access -97 on my pc which is a Windows 2000 Adv.Svr. and everything is working fine. Then today I was going to exe the same Q from a Win 98 (800Mhz, 128Mb) and I get the error '3071: Q is too complex..." I've checked that all the same tools, drivers...

Hmm - U asked for a thought and that's all I got 4 U right now :-/ Something about the size of the fields or maybe some of the letteres is equal some controle codes in Word ...?!?!?!? It's a wild shoot I know, but maybe...:rolleyes: Don Herman

Hi Harry. Yep - I guess I have to do something like that. Right now I'm "playing" with a solution where I add the name of the Province to the table that hold my output-data. Trying to make an IF - ENDIF statement in SQL but I'm not quiet sure howto, something with an IIF I thing, no? :-)...

If you copy the same "total-field" from the end of the report to the top, doesn't it then solve your problem?? It's a little funny that U R developing an account system in Access because at the moment I'm working with a system called Visual Factu & Visual Conta from GoldenSoft...

Hi there. Now I've been searching the web for days, without any luck hope U can help me. I have 20 different regions and 53 different provinces. Each province has it's own group of zip-code. ex: COMUNIDAD VALENCIANA 03 Alicante 12 Castellon 46 Valencia As you can see there is no connection...

Thanks - I was a little quick I think - sorry :-( , 'cause the problem is only in this database so I have to find the ghost here and not in the system. Best regards Soren Herman Krebs

Thanks - I was a little quick I think - sorry :-( , 'cause the problem is only in this database so I have to find the ghost here and not in the system. Best regards Soren Herman Krebs

I've must have turned blind because I can't see what's wrong... The field C Postal is an textfield. SELECT DISTINCTROW Left([C postal],2) AS zip, [Ventas de postales].[C postal] FROM [Ventas de postales]; Best regards El Vikingo

Hi there. I need a little help to get started. I'm working with a financial program (Visual Factu) based on MS-Access tables, and I have to create some new reports. The report I'm fighting with right now is suppose to make a list of how many bookes there has been sold and for what price -...

How to "attack" this problem...??? Hi there. I need a little help to get started. I have a financial system based on Access (Visual Factu) and I have to create some new reports. The one I'm fighting with right now is suppose to make a list of how many books there has been sold, and for what...