Search results

I am trying to change a nested subforms recordsource in vba from the main form. Many online sources give me this solution, but when I run this I get an error: Me.Subform1.Form.Subform2.Form.RecordSource = "SourceTable" I get the error: You entered an expression that has an invalid reference...

I need to duplicate a record in a table. I have been successful in duplicating the parent record with this code: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord DoEvents...

When trying to move textboxes around the form, many times, particularly if I have overlapping elements, the textbox wants to enter a Layout (red line or box inside a Layout table). Is there a way to prevent this from happening? For example, I am trying to move a set of option buttons over top...

I am trying to display HTML code inside a Access Web Browser Control. I have been successful in making an html document and setting the control source to the file in the Web Browser Control. This isn't an ideal solution. I have been searching how to solve this for a while. Someone said this...

I have a pretty simple question.... I need to trigger a refresh on a form when I move the "focus" (i.e. click on one from and then another) from one form to another. I have tried putting Me.Refresh in the: 1. On Activate 2. On Got Focus 3. On Current .....but these don't seem to work. I...

I need to disable the "already exists" warning when selecting a file that is to be overwritten. I have tried DoCmd.SetWarnings False but doesn't seem to work. I have also tried Application.DisplayAlerts = False but I think that is for Excel only. Any help? DoCmd.SetWarnings False Set Window...

I am trying to implement some simple code that seems to work fine from within a module, but cannot get it to work from within a form sub. Dim db As DAO.Database Dim SVUnfiltered As DAO.Recordset Dim SV As DAO.Recordset Set db = CurrentDb Set SVUnfiltered = db.OpenRecordset("SELECT * FROM DAT"...

In Access 2010, I've used the status bar SysCmd functions acSysCmdInitMeter, acSysCmdUpdateMeter, and acSysCmdClearStatus. While looping through commands and displaying the status bar, at some point Access seems to lose focus and the status bar stops updating (or freezes) until the job is done...

I am trying to export values in an Access Table to Word. Some of the items are headers and some are body paragraphs. The code: 'Code is located in a loop but simplified for this post 'Code to insert the Header Cursor = wdDoc.ComputeStatistics(wdStatisticCharactersWithSpaces) + _...

I need to add a value a the form field Notes from a public function... the issue is that the form I add it to can varry (and I have about 100 forms). Public Function FormAdd(FormName As String) DoCmd.OpenForm FormName, OpenArgs:=0 DoCmd.GoToRecord , , acNewRec FName = "[FormName]"...

To put it very simply, I have created a form with a subform. The only reason I am using a subform is because I have too many fields and I need a "scroll box" within a set of tabs. I have found no other way to do it. This method works great except for one scenario: adding records. I have...

I have a pretty simple question I can't see to find the answer to. The user has the ablity to write notes on many lines (memo) that are stored in a table. When I output to a text file I need a "**" to be placed before each line of the notes. I have succeeded with the first line easily by...

I have a query issue. I have a data-set that is somewhat tree-like. My data looks something like this: # | ID | NEXT 01 | Leaf1 | Twig1 02 | Leaf2 | Twig2 03 | Leaf3 | Twig2 04 | Twig1 | Branch1 05 | Twig2 | Branch1 06 | Branch1 | Trunk1 I would like to...

I am utlizing the Command Button Wizard to create a Duplicate Record button. The macro is created automatically by the wizard. It looks like this: I am getting the error "The command or action 'Paste' isn't available now' Can someone tell me why I am getting this? The form control...

I have a very simple form where I would like the user to have the option of accepting all the default values on the form. This is causing me a problem because if the user wants to accept the default values, he will hit "OK" however the record is not saved because the form was not dirty...

At a point within my code I need to requery a subform. When I do-so, the subform jumps to the top record. I have tried the below code to remedy the problem, but can't seem to figure out why it doesn't work. ID = Forms![MainForm]![Subform]![ID] 'Get the ID the subform is currently on...

When I close a form I would like to refresh all open forms. I am using the code below, however I am getting the error message "Object Doesn't support this property or method" Error: 438 on the line dbs.AllForms(i).Refresh. The isloaded and count work fine. Public Function FormRefresh() As...