Search results

Thanks for the suggestions. I have done quite a few google searches with no results. Everyone seems to indicate DoCmd.SetWarnings should do it, but doesn't seem to be working for me. What do you mean by .operator? Phil

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

FYI, just to avoid the hassle of the filter, I have just used a WHERE to do the trick. Dim db As DAO.Database Dim SV As DAO.Recordset Set db = CurrentDb Set SV = db.OpenRecordset("SELECT * FROM DAT WHERE DAT1='SV'", dbOpenDynaset)

Though I always love a good riddle and appreciate the feedback, you have left me more confused than before! I don't know what "expected parameters" are... so when "the thing yells for them", I don't know what they are yelling about. My thinking was that you were hinting at the names of my...

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) + _...

Brilliant!! Thanks!!!

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

Ok... so I have solved it from what I can tell. All I did was simply initiate the record upon AddNew. In other words, instead of waiting for the user to input the first data in god-knows-where, I just initiated the record for the user on a single field. This seems to work. Thanks CivilUser...

Attached is my access 2010 example file to which I am having the issues. This example does not implement the Query-type interface, but simply my original attempt. Phil

So I implemented the form like you said. I was aware that I could create a query that also ties to the same table and limit the display with Critera.... however, I thought I could "bypass" having to do this by simply linking up the Child and Master Fields. After implementing the forms in the...

This is a very inventive alternative, and I truly appreciate it, however I will not be able to utilize this method. I have about 100 forms, so the effort level is complicated. Does anyone here understand the OnUpdate or the OnEnter properties for subforms/forms. I have played around with...

Any chance you have an example of this? I am having the same issue, however, I am having a problem with the subform and form acting simultaneously when I want to create a new record. When I create a new record, the subform and form seem to be acting on different records. Phil

This is what I am trying to do, but getting the subform and form to act simultaneously is my problem! http://www.access-programmers.co.uk/forums/showthread.php?t=215948

I truly think this is a quick quick fix. I think the OnUpdate property or the OnCurrent property needs to refresh the subform or something like that. I essentially need the subform to act as if the fields were on the form..... Phil

Sorry. It is attached again. I also meant to add that it is Access 2010. Phil

I currently am utlizing tabs in my form. I guess I would say that I need even more "real-estate" than normal! Phil

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

Ah! I am using the form in single form view. It is not a datasheet form. I have not tested the query code, but I appreciate the response. I will keep it in my pocket!