Search results

There is no code running other than setting the global variables on After Update. As I mentioned, the Combo Box performs perfectly when scrolling down through the list with either the arrow button or mouse and pressing enter. It only occurs when the value is typed into the combo box. There...

I have not done this. I will try it.

I have an NDA on the DB so I cannot show it in any fashion. There is no code other than the After_Update Event that sets the Global Variables for the Filters on the Subform that is in focus on the Navigation Control. The Parent Form is not bound to anything record source. It only acts as a...

Hey Folks, I am a seasoned Access Developer, and I ran into a situation that I have never encountered before. I have an Access App that is connected to a relatively small SQL Server Database hosted by [blank] in the cloud. I have a View that is linked to the DB with the respective Columns for...

No. the "...less" part of the "DSN-less" implies that it does not require a DSN File.

This is just my 1 1/2 cents… I do use TempVars frequently. I have created shortened functions and they work great. As for the phantom record, I would use the After Insert or After Update as opposed to the the Before events. The Before Events are cancellable and that is a problem. Glad you...

Or apply the True Filter Criteria in the Query itself.

Do not use a Sub Query in the Where Clause. Add the [CopyTimeEntry] into your query with the proper joins and then you can refer to any Column within that table. Joins work very similar to where clauses for the purpose of limiting recordsets.

Are you setting the "CallingForm" as a Form Variable or as a String Variable (See Line 30). If a String Variable, this should be fine, but if a Form Variable, you will need to express "Select Case CallingForm.Name" It makes good practice to preface your varaibles with their object tyoe. For...

I don't see where you are defining the Data Connection. The SQL Statement does not know where the data lives. Define the DC and I think you will be good,

Ok.

And that is about the only time I will ever use a Tab Control. I will never use it to host a sub form but for maybe a limited number of exceptions. I prefer the Navigation Control for a variety of reasons, but that is just my preference. I know a lot of people stay away from them, that is...

It is not a problem, per se, but by opting for the Navigation Control, which is already a sub form, it also accomplishes the same purpose as a Tab Control. You get the best of both worlds in one control and eliminate one layer of confusion.

That is where I am at now. Just knowing that it can happen and having a solution in place is how I have proceeded with it as well. There are likely many other quirks that we will never know the exact reason for them.

Yes, any index on a linked table is a psuedo index. I don't think that is of concern here, but it is good to know that is how it is described. As for losing the PK when the Table is refreshed, as I stated in my first comment on the topic, not when the Refresh method is used from the Popup menu...

I never said that. I simply stated that a PK must be created on the linked Table (Access TDF), because in Access they are all called Tables even though we know the Link is to a View, before it can be update from Access, I affirmed your statement that the PK is lost when the Table is refreshed...

Not at all. You told me that "Perhaps you should have tried the code in my link before making your comment." I was merely pointing out that you did not provide a link to your code until after I made my comment about the PK. As I mentioned, your code does create the PK, but only for linked...

Perhaps not. Furthermore, the code in your link will only create a PK in a linked Table/View, not a local Table. The Object knows that a PK is necessary, and it is solving the other half of the riddle for you. I prefer to keep all my methods uniform. I create PKs for intended reasons, and I...

It was, indeed, it was!

I believe it was rather impromptu and that is why they did not see it. Why impromptu? Why not exploit the US Government when they are at their lowest point! The just ousted the speaker and cannot really broker a peace deal until there is a speaker voted in. It is kind of like when the cat is...