Search results

There is nothing in the OrderBy or FilterBy properties of the form

I have a Problem that occurs between the time that a form opens ( no problem with the on open command) but before it actually loads (the on load command in which I place an "open argument" - bytBufferCurrent ). I consistently asks me for a parameter value - tblParticipant.ParticipantID - (this...

Just as a followup, I corrected the problem by simply forgetting about the report, and putting out a text file that had ALL the fields I needed including Me.dteDate. I still don't see why the issue though! Thanks for your help. Marty

its a BIG db ... so it will take a little while before I can post some thing representative of the problem !! as well I am bound by certain rules!

Gasman, the parameter is defined in the report's recordsource which is :

To: bob fitz and GasMan I think that since TDate is already specified as a date, then nothing is required... anyways have tried single right thru to triple quotes, and "#" nothing seems to work any better! Marty

To bob fitz: I have already attempted that... but still no "cigar"!!

TDate is the parameter which I am using ... Just before I call the report I am setting it to the date on the form (Me.dteDate) I am not sure what you are asking... PS thanks for the Instant response!!

Hi all, I have button on my form which does the following: Private Sub cmdPrintRollCall_Click() On Error GoTo Err_cmdPrintRollCall_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "rptRollCall1stXR-12" stLinkCriteria = "TDate = " & Me.dteDate 'the date on the Form...

I actually had the same problem and followed your steps to a Tee. Lo and behold I am free of the problem!!! I am SURE that ALL bridge players STILL know ALL the tricks :cool:

Hi Doc, Thanks for replying to this issue. I don't really understand the following... >> issue of "intermittent success" can sometimes be caused by permissions issues My understanding of permissions is that once they are set, only physically resetting them can change them. i.e. they are NOT...

Thanks for clarifying Issac and Pat!!! Marty

Hi Pat, You say "WiFi cuts out which it does frequently in many places" How will the FE-BE config, with say Citrix or Remote Desktop be able to better support remote users? How does Citrix (or Remote Desktop) prevent the WiFi cut out? Best Regards, Marty

No ... nothing fancy ... just an Access Backend (2013) I've done this at least 50 times before with success. However, COVID forced the people operate from home and there is the difference (i think). and i think that Pat intuition about being about the WIFI may be correct. I am trying to contact...

Hi Isaac, It is a linked table located in the backend. The front end only contains UI (forms, queries etc) ... in the last email I was speaking about the backend entirely ... and I was circumventing the front end entirely. Marty

No I am not using transactions to apply the update... this is just one table that I am trying to have updated. I think the problem may be in the permissions. But I've compared 2 DBs in the same directory (remote -- O:/ drive) and I can't seem to find a difference in the permissions, but the one...

Thanks pat and Arnel for your advice... Pat I think that your no 4 is going to get my attention first ... if the IT department agrees! Arnel, is the "whole table" locked or is it just portions of the record ie "pages" or even just a single record? I really have never understood the exact...

Hey J, Thanks for answering so soon... I'm going to check out the permissions and the file attributes. All the rest of the reasons by Browne have already been discounted. There is only 1 table involved and it is very straight forward with no fancy stuff... besides it works some of the time...

I got the "Error #3326 - Recordset Not Updateable” but there seems to be no reason. Where do I go next? - I'm looking for suggestions! Summary tried the app as a user on 2 different PCs in the office... one works OK although there are some long duration issues and 1 does not - got error "3326"...

All of this is good advice, especially the_doc_man. Allow me to add: My two cents: try to find an app or two that do many (all) of the things that you would like in a manner that you would like them done. there must be quite a few apps projects for repairs, renovations, and new construction even...