Search results

Hi, if the setting of some form controls changes from one record to another you should use the Current event. As for settings differentiating between new and existing records I prefer using the NewRecord property, i.e. If Me.NewRecord Then ... Else ... Endif Best, Jiri

Not clear whether the corruption originates in the the Master FE or after distribution to users. If the latter, do they all get same errors relating to corruption ?

IIUC, to follow up the quantities of the products in two locations after each transaction then your "history table" has to indicate which location the transaction relates to. Then you can calculate the new balance of the product, in the Vault and the Cabinet separately by creating a field for...

This is one instance where I have to disagree with the majority opinion expressed here. Creating a "switchboard" that connects a single FEs to different BEs poses no added security issues (per se) that I can see. It can be gainfully used for managing multiple projects or business accounts (I...

I too am unsure why the "accounting period closing" would require data to be saved. Unlike manual systems which require a closing date for a month period to tabulate accounting data for reports and to manage later corrections, an electronic accounting database is an open book which assigns items...

Good work, arnel. I made two small adds: 1) a form to get the exchange on any two currencies using USD as reference. 2) a column in the table that converts the date string for updates for sorting on dates.

Public variables are accessible from the subform via Parent.varname. Jiri I am with you on this. What's more is that the tenant data is not dependent on the tenancy data so the requirement the two should be updated at the same time is suspect. The main-sub setup allows reassignment of the...

Look guys, you may gang up on me all you want, but you are just shooting the messenger. Much experience as you might have you don't get to decide what is what in "databases". If you want to argue that "real/true" one-to-one relationship exists only where two tables have the same PK, you better...

All I am saying is that it is the "rule" that decides what relationship he have between data entities in any given situation. . The examples you are giving do not address the 1-1 rule. Obviously you can reassign a desk, or write a new lease for an empty apartment. But you cannot assign them to...

Dave, I am not accepting the new semantics that MajP and you are introducing here. They are over the top and only confuse matters. Two tables should never "share" the same PK. That's just bad practice. Even where you partition a single table with a single identifying entity into several...

I beg to differ. The one-one relationship is not called for by some abstract nature of "data" but by business or social rules. I don't care if someone wants to call it "assignment" or whatever. If a company assigns one desk to one person, one can philosophize that it really is just an instance...

What is the error number?

Thanks, Colin. Guys, I made no claim to a historical discovery in the OP. It's just that a number of posters at AWF seem unaware that this coding style is available and very effective for a task like creating an event calendar. Take e.g. the collection of calendars and date pickers that MajP...

Hi everyone, Every so often I see requests on Access boards inquiring about a way to streamline events for multiple controls of the same kind, so they are executed as a single function. Surprisingly, most answers are negative in the sense that VBA (unlike VB) doesn't know control arrays...

strCriteria = "EmployeeID=" & Me.EmployeeID & " AND Year = '2021'" & " AND Quarter = '2nd Qrtr'"

You should always test for an empty recordset and move to first record before moving to next, e.g. If Not rs.EOF Then rs.MoveFirst Do While Not rs.EOF : rs.MoveNext Loop Best, Jiri

Assuming that the network mapping is the same for the developer and the users, then after the BE has been relocated to a new location, the new FE at the individual stations will not have to be re-linked. Most larger organizations have a network share dedicated to corporate data, and use a...

FYI, you could have used the DMin domain aggregate function and save yourself unnecessary coding: Nz(DMin("ID", "tblNewNames", "ID >= " & Me.NumberID)) would give you the requisitioned or the next record number in sequence. Best, Jiri

Closing a recordset will release whatever system resources it holds. Only the object itself will remain. Jiri

Doc, I am aware that dbForceOSFlush is used normally in transactions. Now whether it has effect on dynamic buffering is somethinbg I don't know but it wouldn't hurt to try. At any rate you could easily flush the allocated ADO space by closing and reopening the ADODB connection in the loop...