Search results

Yeah, pretty confusing. Thanks much for your response. I'll check out those url's you mentioned. Did you mean to say 'Access' and VBA in your 2nd response instead of 'DAO' and VBA? My install marks 'Access' and 'VBA' as Builtin, required references while not marking DAO.? thanks again, norm

I'm pretty sure there is no easy way to do what you're talking about. Look into the listbox control's 'selected' property. You'll have to loop through all of the items in the listbox & check the selected property of each(if it's highlighted it'll be = true). Good luck. i'm sure you'll find...

I read somewhere that DAO is a required reference for access to operate. Can anyone explain the .BuiltIn property i printed out below? Can anyone explain why my (checked) references dialog box reads DAO 3.5 while it prints out version 4.0? Thanks for any help! norm .Name: VBA .Major.Minor...

try looking into creating table definitions on the fly (setting connect string property etc)...

Hi Tina, Not quite sure what you need but in any case, it sounds like you need enough help that your best bet would be to pick up a book. You can probably get something going in a week or two with the right book. In the beginning you'll be able to do quite a bit without writing any macros and...

I wrote a patch-like sub that brings in another module, runs the subs/function within and moves on. I can't compile what i have b/c there's a undefined sub (native to module that is imported). Any suggestions? I've already tried calling the sub from a macro which produced the same error...

Not that I know of but, i'd be glad to show you what i've done. For a routine that imports 50 or so DB's into one, it displays 1) databases completed 2) current database 3) current table email me if you'd like me to send the modules.

Does anyone know why some text will shift in a label when specialeffect = 1? ie. i'm using labels as buttons. code changes the special effect at run time. some of them have text that shifts left when the button is raised while others do not. there are no blank spaces or strange characters...

Seem pretty basic but, i can't find an explanation anywhere... Why does a vertical scrollbar reach from top to bottom of a form if only a small portion is scrolling (ie. continuous forms)? Are subforms the only way to make this 'wierd' scrollbar look normal?

Hi Pat, I appreciate you taking the time to help. My question was more specifically about setting references than setting properties. If you can point me the right direction, i would appreciate it. thanks, norm

Yeatmanj, You're right. My apolgies if I threw you off. It's a lot easier to travel in a straight line!! Read 'When can I update data from a query?' in the help files. You should find some answers there regarding validation rule errors. The sample was from me but it's pretty generic. You...

A delete query will delete the entire record as your question suggests. In order to work with a single field, create a recordset by using the OpenRecordSet method of the docmd object which will allow you to access individual fields. (There may also be ways to fudge it ie. go to the correct...

I'm trying to set a reference to a report from a form module but getting Run-time error 424: Object Required Is there a way to do this other than explicitly? Thank you for any help. ... Dim rpt As Report Dim YO As Variant YO = "Reports!" & strReportName Set rpt = YO 'HERE IS WHERE I WOULD...

here is something in use below. It may help also. Function isOpen(strName As String, Optional intObjectType As Integer = acForm) 'Returns True if strName is open, False otherwise. 'Assume the caller wants to know about a form. isOpen = (SysCmd(acSysCmdGetObjectState, intObjectType...

I don't think you're going to be able to print 20 different reports into one pdf document right off the bat. You're probably going to have to build the full pdf from the parts (each report) when they're all finished. Look into the Adobe reference libraries that ship with acrobat writer. As...

Any suggestions on how to print the first page of a report programmatically? I'm trying to print the first page of each report in the project. I can bring up each report but cannot print the first page of each. Any help would be appreciated. norm

Can i restore a form after it's been deleted???? I haven't compacted the DB, or closed it down even. Please help if you have any ideas on how to restore from the project maybe... otherwise i need to put in the request to restore from tape WHICH WILL TAKE DAYS.. UGH. thx, norm

Christie, Another possibility and also admitted 'bug' (i think) with Access 97 is that #Error message when a control has the same name as the underlying data control source. for example,the control: NJ_CEILING with a control source of: =2*([NJ_CEILING]) yields: #Error ...in a report. I...

I'm driving myself crazy trying to work with embedded charts in reports. I've looked around for good books/help docs but have found nothing 'good'. An example of what i'm having trouble with: How to control the space around a chart?? Right now i need the entire width of a report and even...

I recently just worked on something like this & it worked out great. I read the article mentioned by Pat and figured I could still add to it. In addition to a list box i used a dropdown to select a field. The listbox was then populated with a distinct selection from that field. So, given...