Search results

Hi, I've been trialling Crystal Reports Distributor, which I've seen mentioned on this forum. I was just wondering if there's anyone else using it and what do you think? I should mention for others reading this that CRD is an app that sits on the server and automates the running of crystal...

Hi, I think there may be a very simple solution to this but I've done a bit of searching on the forum and haven't come up with anything similar. So... I'm using the Cdate function in a query: nCloseDate: CDate(Right([ClosedDate],2) & "/" & Mid([ClosedDate],6,2) & "/" & Left([ClosedDate],4))...

Hi All, Just wondered if anyone can help me with this. I have a form based on a query that has 16 options for values in one of the fields. I wanted to put an option button for each value on a form that would allow the user to view the records based on which option buttons were selected and...

I'm pretty sure there must be an easy answer to this but I've searched the archives and can't find anything. I'm setting up an import spec to help me import a text file. The trouble is that in the text file negative numbers have brackets ()around them and they are being thrown out because...

Hi All, I just want to get your opinion as to whether this process seems overly complicated, or do any of you have similar issues? I press a button on an access form, this sets off a macro that opens a new excel application, opens an existing spreadsheet, runs a macro within this spreadsheet...

Hello All, Could anyone help me with this...? I made a macro in excel which copy a range of cells and pastes values (rather than formulas) onto the same range. I then took the code and put it into access like this: Set XL = CreateObject("Excel.Application") With XL.Application...

Hello Boffins, Can you help? I have a database which exports a query with the transfertext method: DoCmd.TransferText acExportDelim, Xspec, "qry" & myarray(X), _ strFolderName & "\" & myarray(X) & ".csv" and it comes out like this: "1403","731210",-560.00 "1403","731880",-150.00...

Hello, I was just wondering is there a way to stop Access prefixing column headings with "Sumof" or "AvgOf" when creating queries that sum / average certain columns. I know you get around this by (say the field is called "Sales") typing Sales:Sales but I find this a bit tedious. Do I ask...

Is there a way to prompt the user for the name of the table to be created in a make table query? TIA, Pete

Can anyone help? I want to filter a form with a number of check boxes. I've got two checkboxes for a field called Market, (UK & Europe), four more for ShopType and another for ShopStatus. I've started out using the following code behind the after update property of the checkbox... If...