Search results

Hey everyone. I've moved industries but am thankful to work on a new db project. I'm looking to take about 500 pictures and display them in a report with some associated info/comments. Working with attachments, i already have an idea going... forms, tables, reports etc. But i'm now...

its been a long time. i'm glad to see the site is doing well and is alive. i no longer write software for a living but recently found a reason to get back into access. though i knew access 98 and 2000 inside and out, access from office 365 seems very different. though to be fair maybe its...

Hi, using Ac2000 can anyone suggest a way to get more info about a report than what the AccessObject object provides? (background... i'm automating access from vb6 and am looking for a way to get the record source to build a where clause) thanks much, norm

Anyone know how to determine the jet version currently installed?

Seems like it would be pretty easy to get an application's title from an automation session but i can't figure it out. Anybody know where it is? starting with the Access.Application object..... thanks for any help. norm

Has anyone an idea how to fairly easily have a line or colored control grow vertically to match a section? I can see there being a way in the print event of the section to get the size of the section?? Have never done it though. But then again if it's already in the print section, i can't...

SubReport property procedures Can user defined property procedures be used in a subreport (be set from the main report)? I'm trying to pass a value to a subreport so it can then be used as a variable in the report module. Thanks for any help :)

i'm opening a 3 section report from a form... and setting the section's visible property onopen. in the following example: 1 [off] 2 [on] 3 [off] section 1 header & footer is not visible. why would it still group by section 1?? any ideas?????? thx, norm

I'm trying to display the number of months contained within a report grouping. I have a typical date field to work with where dates can range over years. Is there an easy function for this that has eluded me?? Or/Also, is there a way to use user defined functions in text boxes?? I have a...

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

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

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?

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

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

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've tried simply changing the embedded charts rowsource at run-time but get one of two errors: 1) cannot change rowsource after printing has begun. 2) something like cannot find object (when i try to change the property before opening the report) Then I tried creating an XL workbook on the fly...