Search results

I thought this was a 'destroy the post above' thread at first. God fun. :)

I haven't tried this but I think you could use a case select in the combo box after update event to determine which entry was selected and then use this as the stDocName in the run report command. Dim stDocName As String ... Case "your report name" stDocName = "your report name" ...

When you are viewing the report in design mode, does the little square at the top left corner have a green triangle in it? If yes, there is a problem and Access will tell you what is. In this case, I would expect it to say something like "your report is wider than the printable space. This may...

Hi statsman, An article on Orbit News yesterday insisted that she would be on the sex offender's register for life. Don't know if it is right though. I think there is a fundamental difference between a girl being seduced by an older man and a boy being seduced by an older woman. I don't know...

Fascinating: http://en.wikipedia.org/wiki/Every_time_you_masturbate%E2%80%A6_God_kills_a_kitten Keep up the good work - this thread has me like a cheap soap opera. :D

Kabir, This isn't quite what you are asking for but I have something similar on one of my forms. Hide the combo boxes (format them visible = no) and in the case select of your option buttons use me.yourcombobox.visible = true to show the appropriate box. In the after update of the combobox...

FoFa, that does sound much easier. I will try it right now and post back if it works.

Hear Hear! :)

I am trying to improve the performance (loading time) of my main form. The big tip seems to be use SQL in VBA to populate subforms and comboboxes when needed, rather than when the main form loads. I have a combobox configured for 2 columns, bound column = 1 and column widths set at 2cm each...

mtahir, I use AutoCAD in my work but am no expert. I do know, however, that there are user-groups all over the place so there must be associated websites. Have you tried a google search for your problem or even the AutoDesk home page?

Thanks pbaldy. I haven't needed either of those things yet which is probably why I haven't ended up using alist box. It seems like I'm not missing anything by avoidng the list box. :)

Thanks Vas, The solution to Kerries problem was beyond my (very) limited scope.

This might be a silly question - I appologize in advance if it is. - let me know! :) I have searched a bit and found nothing quite along the same lines. I have realized that I only use Combo boxes, avoiding List boxes entirely. I had some early difficulties with List Boxes that I can't recall...

Hi WtFudgE, Without having thought about this too deeply, it sounds like a referential integrity problem. First up, I'd check the links between tables. It may be that you have a cascade delete that isn't required. Mirriad posts on the subject on this forum. Use "Referential Integrity" in a...

f Disk, Do you mean a msgbox or a form you created that is popup? If it is the latter, you should be able to set it to pop-up, & modal = no. Private Sub Command296_Click() DoCmd.OpenForm "tblService", acNormal, , , , acHidden End Sub The code shown opens a form in hidden mode. You can...

MsLady, Without wishing to be personal, I am surprised you have such Friends! :D :D :eek: :confused: Please don't be offended - a light-hearted jape.:) My link is for something fairly pedestrian compared to the other nominated software, but I have found it invaluable all the same...

(anybody got a) Stock Market Portfolio database sample Hi Folks, A friend intends to build a database for his portfolio as a learning exercise with Access. He is pretty much starting from scratch. Does anybody know of/have a sample DB that would be a useful guide to him on his journey? I...

Hi Kerrie, Welcome. What is the messge? Try searching with the text of the message or post it here.

|Paul, A couple of hops of links from RG and I found this snippet: Maybe your saving technique has a similar effect?

Great tip. Thanks. Is there a way to check the status of the Name Autocorrect features when the DB loads and, if checked, uncheck them? I suppose, to be polite, they should be reset to whatever they were when the DB loaded. This is already sounding complicated. :eek: Maybe the best solution...