Recent content by mikew71

This was my previous understanding. This its not possible to conditionally restrict a combination of more than 1 field in a query. I've been working quite extensivly with BO where this is possible and was hoping that my Access knowledge was simply not up to scratch. Thanks

Hi, I'm building a query that needs to restrict on several fields, but only where the records match this exact combination of variables. I've done this in the past by building individual queries for each element of the extraction to avoid excluding more records than I want but would prefer...

thanks, thats it.

Hi, I know that its possible to force a format into a fields in query, I've just forgotton how to do it. I remember it being something along the lines of this; =(format([field])"#,###0.00") any ideas?

Hi, I''m looking for the code to print from Business Objects using VBA code. Currently I'm using VBA to save as PDF but this loses some key fonts in the process and I cant find the code for printing. Any ideas??

Apologies, this is a business objects request. I'll repost on the correct forum.

Hi, I''m looking for the code to print from Business Objects using VBA code. Currently I'm using VBA to save as PDF but this loses some key fonts in the process and I cant find the code for printing. Any ideas??

I've forgotton how to force a number to ten decimal places in SQL, I believe its =Format([format command],sqlstatememt) I cant use the 'properties' as its a make table query and properties do not carry over in to the table. Can anyone help?

I'm building a flat file to import into Access that has exceeded 255 rows, I have no other way around this and cannot split the data into seperate tables. Is there any way around this?

I use the wrox series, they can be quite technical at fist glace but once you get your head around the fundamentals of access they very quickly become much more useful than other 'basic' skills books.

Thanks, this locked the figures in as text format. BO upload appears to be sucessful. Thanks very much for this.

Thanks, if you mean when running the three queries that feed the export table then yes, I've been setting the format on these to standard with two decimal places. I'm not aware of anyway to format while exporting, is there a way besides export specifications (which I tried but could not declare...

I'm unable to maintain the 2 decimal places on records with whole numbers or rounding to one place while exporting a text file for an upload into a Business Objects report. So far I've tried without success, 1) Formatting export table as 'Standard' with 2 dec places 2) Using export specs (on...

thanks for all the help, but someone here pointed out that I had forgotten the .txt on the output file name..

Thanks, that file path is only there as an example, on the actual code it's correct.