Recent content by darthcalis

I haven't posted here for a while so Hello World! My question is pretty much as in the title. I *thought* I was going to do something really easy in Access 2010. I have a generic list form that pops open when another form launches. It just reads a ComboBox on the main form of whichever form...

Hello All, I'm having a bit of trouble getting exactly what I want with regard to a custom menu bar which pops up on a continuous form when I right click. I may have to deploy the app I'm building with Access 2010 Runtime and I know you don't get the sort & filter menus by default which is why...

The message body was just a few words so it didn't exceed the limit. I didn't try another format, no, but when I did the same thing happened - weird. I have managed to see it work the first time on opening the database, but on subsequent attempts, it crashes. I do decompile the code on a...

Ah, ok. Odd thing is that I only created a test report with a single unbound control on it into which I wrote a bit of data. Seems unlikely it would be corrupt. Could it be that something else in the database is corrupt other than the object being sent? It wouldn't surprise me if something was...

Yep, exactly what it says in the heading. Anyone have a clue as to why this would happen? Not used SendObject before so all I wrote was a tiny bit of test code which runs from a command button. The send object line is: DoCmd.SendObject acSendReport, strSendObjectName, acFormatPDF...

Paul, it works brilliant! Finally, I can use the record selectors for something useful! :) It's a lot nicer than having to build a separate list using a control. I must thank you again though as your link provided me with the bit of SQL that I was missing. I didn't know the syntax for looking...

Hmm...spoke too soon. It works until I close the database and open it again. Then the logo bitmap no longer displays in the bound attachment field on the report. I have to go through the same process of deleting it from the table and adding it again, then the logo appears correctly in the...

I worked a way round it. I read the selected records on the form's MouseUp event. The last thing to happen on the form in the event of a mouse click will either be the record selection, in which case the selected records are identified, or something else will get clicked, in which case the...

Hi, Personally I would use the OnGotFocus event to add the date and then move the cursor to the end of the text with the following code: Of course, you can also substitute the actual control name for ActiveControl. Good luck. :)

Hi All, Is it possible to use the record selectors on a continuous form to do anything useful? I have a continuous form as a subform which displays a list of customer contracts and some related data and it would be nice if I could select multiple records and print them. However, I have noticed...

Thanks Ari. My God, what a pain! I thought there would be some simple way to do it. I didn't fancy the idea of having to save it just to get it back into the report, so I added a linking ID field between the main data table and the table that holds the logo, so now it's just a bound control in...

Hello, Just wondering if I'm missing something obvious. I have an unbound attachment field on a report which I use to display a company logo. The logo is a bmp file stored as an attachment in the database so that the client can change it any time they wish. The code fires in the OnFormat...

Howdoo! I'm new here myself and also only used Access about 10 years back, but I've already found these forums very useful and had some help myself. So welcome, and cool username! :o) Emilio

Yes, those values can vary by record, and that fixed my problem. I've been working solidly for the past 3 months with tables and forms and I only looked at reports for the first time a couple of days ago. I was thinking of events working in almost the exact same way as they do in forms, but I...

Paul, you're a lifesaver! Thanks very much, you managed to solve most of my problems in one hit. :) Oddly, I did try and use the report filter method first, but I put the code in the report's OnLoad event rather than OnOpen which I guess it where I went wrong. Anyway, I always only get a single...