Search results

Thanks for all the help, Peter and gemma :). One last issue I'm having is when I initially run this report, even though it sets the printer properly and I'm specifying tabloid paper, it still displays the report in letter because it's still gathering paper sizes from my Windows default printer...

Thanks for all the help, fellow husky! :) It works awesome, just need to take it one step further... could I make it set the paper size to tabloid after selecting the appropriate printer as default?

After a bit of searching, I eventually went with the following code found on this forum post Dim db As DAO.Database Dim tb As DAO.TableDef Set db = CurrentDb For Each tb In db.TableDefs If Left(tb.Connect, 4) = "ODBC" Then tb.Connect = newConnectionString...

Is the adodbRS reference exclusive to Access 2010? We're currently running 2007 and, when I test this, I get an "object required" error (run-time 424). Is there anything additional I would need to declare first?

Hello, me again :rolleyes: Hoping this one isn't too tricky, just need to know how in VB I can refresh all my linked ODBC tables within my "Main Menu" form's OnOpen event. Any assistance is always welcome! :)

I already have a function to fetch the NetworkUserName as well, in case you were wondering.

Thanks Gemma and Peter, both of your answers will help get me on the right track. I would use a custom printer, but I have end users in different locations of our facilities that use this database and report. It's even trickier to set for global use when the report requires tabloid paper...

Good Friday afternoon everyone, Is it possible, within an OnOpen even of a specific report, to set the printer selection and page setup (size, margins, etc.) to certain things? If so, how would I go about accomplishing this? I would like to do this for specific users within our domain (this I...

I'm currently tweaking a report with three sub-reports; adding/changing a few fields and other simple tasks. One request has been given to make the sub-report's report header to appear in the main report's page header for the duration (multiple pages) of each sub-report. Is this even possible...

I thought it would have also... Does the use of tabbed windows within Access prohibit this? We use tabbed merely because it's more organized. But yes, until they stop the search or start a new one, I want the SetFocus to stay on the control the end user initiated the search in.

I tried making my popup search form model, but to no avail. If I initiate a search within one control on the popup form, click somewhere on the popup then back on the search window, it jumps to a control on my main form. This time, I'll go into further detail of how it should behave...

Setting my search form up as a popup form was what I originally ended up doing, just to solve this current issue... but then I ran into another form issue when performing a search, which I posted a while ago in another forum (can't post links yet, so this will have to do): This is when I...

Okay, that is doable for me. Would you have any sample code by any chance? I tried this method in the past, just was never able to position the search form properly. If so, that would be great :)

Good day everyone, me again... I have a main form, used for inputting information, as well as two associated (by associated, I mean linked master and child field(s)) subforms and one unassociated subform (used as a search form). Is it possible to not make the unassociated search form refresh...

Figured out a work-around, just made the pop-up form a subform to the form that the "Find" feature was jumping to.

Forget the buzzkill... was able to tweak it for my application. DoCmd.OpenForm "cttblDesignHours", acDesign Set frm = Forms!cttbldesignhours Set mdl = frm.Module lReturn = mdl.CreateEventProc("Close", "Form") mdl.InsertLines lReturn + 1, vbTab & "docmd.setwarnings false" mdl.InsertLines...

I don't know if this is a good title for this question I have... but what I'm trying to do is bring the focus to a pop-up form when an end user clicks out of Access (say, into Outlook or another software window) then back into Access. EDIT: What's happening is an end user performs utilizes...

This is just what I need, but I would like to take it further... Is there any way to create a form and add an "OnClose" event to this newly-created form automatically? I'm doing the following with a procedure (based on a button): Create temp table (based upon make-table query) Create form...

Good day all, I've been working with Access for about 2 years now (focusing on VB, other coding languages and SQL for the past year). Hopefully, my questions (someday, answers) will be of great help to you all :rolleyes:

Is it possible to create a form and vb procedure within that particular form (ie. an OnClose event)? Function CreateForm() Dim Form as Form set Form = CreateForm frm.Caption = "MyNewForm" frm.Recordsource = "Stuff" 'Do other stuff to form, save and close, open form again...