Search results for query: *

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

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

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

I'm running the following code as part of a greater function: DoCmd.TransferText acExportDelim, StOutputSpec, StOutputTable, Stfilepath & StOutputFile, -1 When I get to this line I get the following error; "Cannot Update. Database or Object is Read Only" This makes no sense as thee is no...

Hi, I'm brining a txt file in via a simple import procedure, I have duplicate client ID's on the source file that I want to exclude. The primary key method won't do this, is there another way?

I can quite easily link in a xls spreadsheet into Access by using a print range, but the info I'm working with now is based on defined named ranges in xls, despite searching I cant find the correct code for the transfer spreadsheet command for the 'range' section. Any ideas?

I have an unusual problem, I'm continually getting an 'invalid argument' error when I attempt to run a query either based on or appending to a certain table. I've not come across this before and nothing seems to change this, any ideas??

I'm running a form where one list box is returning data from a query based on the selected variables of a second list box. This works fine on single variable selections, however if I change the variable's properties to either of the Multi Select options no information is returned. Is there a...

I'm running a HR database which draws its data from several Spreadsheets that are linked to SAP. I've created a code within excel that updates these (we're not allowed to ODBC unsupported software into main systems) and want to be able to activate this from access, I've seen this done once many...