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

I'm sure I've downloaded a sample database from here that does exactly what you're after. Do a search for 'multiselect' & 'listbox' and you should be able to find it. P

Thanks for that Seth, That's a simpler solution, the only prop is that this doesn't allow the user to turn certain options off. But it's put me on the right track so thanks for that. I'm going to look at using a toggle buttons. Cheers, Peter

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

Thanks for the reply Terp, I didn't think that I would be able to do all the formatting that I needed to do in Access but looking at it now, I just might. All the best, Pete

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

Thanks Bert, That worked a treat. I found out some more info on the whole integrating thing here: http://www.sunny-beach.net/manual/306.htm#o306 Cheers, Peter

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

Doh! I figured out number 2) I was trying to export a number of queries and one of the Fields (column headings) was different in each. I set up the export specs based on the first one so the rest didnae work. As the field names didn't need to be different I just changed my queries giving...

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

I would really appreciate a copy of that db / code if you could email it or post it here it would be great. cheers, P

Weeeellllll, I've managed to get through the whole day without having to do any rekeying or renaming. In fact to be perfectly honest I've done bugger all work all day. So I'm a happy bunny. Thanks for the suggestions for the renaming thing by the way. Have a good weekend! ~Pete

I think you can sort this out by creating two UPDATE queries. As far as I understand it you have two table. One has all the serial numbers with all the different types of sales. I'll call this table "tblALLRECs". The other table is what comes from the text file. I'll call this "tblText". The...

Hi XKIMBAL, Are you trying to update a field table 1 where a similar record exists in table 2? What are the names of the fields? Can you give a bit more detail please? Cheers, ~Pete

Sorry to interrupt the motorcycling postman debate but which version of access allows you to change field names through-out a database? I work with Access 2000. Is there any add-ons that I could avail of that would do this for me? Ps. It appears US postal workers have it easy. They've no...

All right, all right. This is me waving the white flag on this one (even though I did have to do the renaming thing on 24 fields once!!!). I probably shouldn't mention that I find creating forms a bit finicky and that I don't like the way the number format in queries defaults to general...

Hi Tess, Thanks for the reply. I'm glad you at least can find some comedy in my tragedy. :) . I can't believe this doesn't bug other access users though. I suppose I should just resign myself to having to retype the names of fields that are already there. I'll just have to take lots of...

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