Search results

Did some spring cleaning on my bathroom yesterday - tired and sore today :D ~RLG

Ah, bingo! I hadn't scrolled up to the top of the linked table list but just now discovered that sure 'nuf, there it was as a local table. I deleted it and then did the Import | link step and now have it linked without a 1 at the end of the name. Thanks so much for your help! :D ~RLG

Hey Beetle, Thanks for the quick reply. When I went to External Data | Import | Access, (and filled out the "Select the source..." screen) I selected from the list the table I need to link to. When that window closes and I look at the table list, it shows the table with a 1 appended to the...

I am working in Access 2007. I added a table in the be and now need to link it to the fe. When I launch the Linked Table Manager, it doesn't show up in the list. Am I missing a step? TIA! ~RLG

Oh, now that was way too easy :D. Thanks for pointing me in the right direction. (BTW - yes it was on an unbound text box in the report). ~RLG

How do you put the special character in the statement? I have a report that I would like to put a check mark if the tested field is a certain value: =IIf([EthnicityID]=1,Chr(252)," ") I looked up the Wingding value through Word but the character code is decimal and doesn't show up correctly...

I had thought that a cross-tab was the way to go but what Pat suggested produces the result that I need. Thanks for replying! ~RLG

FINALLY!!!! Got it to work. I took off the reference to the combobox name in the undo. From: Me.tdescription.Undo To: Me.Undo And it works like a charm! :D Thanks for all your help! ~RLG

I just tried setting up another subform in my db to do the same thing and got the same error. If it is caused by corruption on the other subform, I wouldn't think this subform would have the same issues. ~RLG

I did the compact and repair - no change. I did the decompile, compile, compact and repair the database and it still doesn't work. The document I found on this forum said that once the app is decompiled, it should be significantly smaller. Mine was insignificantly larger. ~RLG

I have been researching the Undo in VBA and am beginning to wonder if the problem lies in the fact that this field is on a subform. I haven't found a solution but have seen some posts where others are having a problem with the undo working in a subform. Unlinking the subform from the main form...

Hi Pat, Thanks for sticking it out with this thing. I changed the Cycle and it didn't make any difference. An interesting note, when I get the validation error, it says to "Click Undo to restore the previous value". When I click Ok and then click the Undo on the Access window, it does clear...

Yippee!!! It works. Thanks so much for all your help. Gratefully, ~RLG

Hi Pat, I think that's the problem. The .OldValue is nothing (null?). I am not trying to change an existing entry but add a new one. I have attached an image of the form to this post. The third one down is blank and when I click the down arrow and select an invalid option it displays the...

I have the Enforce Referential Integrity between the lookupTable and the tblEventTracking table. I wonder, is the undo trying to remove the record from the lookupTable (the source of the combobox)? I commended out the undo statement and it seems to work fine. The focus is on the field with the...

Hi Pat, Yes, I entered the commands just like you sent them making only the necessary changes to fit my program: Private Sub tdescription_BeforeUpdate(Cancel As Integer) If Me.tdescription.Column(3) = "X" Then MsgBox "This an inactive option. Please select an active one."...

Hi Pat, I am so sorry that I didn't not communicate well enough in my first post what I need to do. The sample output I posted is from the query I showed in the post previous to this one. That query needs to stay the way it is; it reports the data the user wants to see. I was asked if there...

Hi Pat, This works great with one exception. When I select an invalid option, it displays the message like it should but when I click ok, another message window come up: I do have an Enforce Referential Integrity between the lookupTable (where the records with the status field are stored) and...

Hi Pat, Thank you for your reply. I am not quite getting how to use your query. The query that generated the result I previously posted looks like this: SELECT tblEvent.startDate, tblEvent.EventName, lookupTable.Desc, lookupTable_1.Desc, lookupTable_1.Group...

Hi Alan, I added the count column to my query as you suggested in a previous post. My query consists of these fields: StartDate EventName Desc CancerType Count of CancerType 10/01/2011 Magic Valley Hospital Screening Colon 1 10/22/2011 Local...