Search results

Instead of requerying an empty table you should set the form for a new record: DoCmd.GoToRecord , , acNewRec Best, Jiri

I would recommend the standard process of generating a random sequence of allowed characters to get into the database initially. Then make the user create his/her own password based on rules.

The qualifying test cannot be written like that. Your "c" will always be positive if there is a record with a PositionID of that value irrespective of the CourseID, and vice versa. So you will always get the message if column(3) ListCourse is not Null. Try this: c = DCount("positionid"...

Any retail commercial db app has sophisticated inventory control such as you mention, and in some businesses handling perishables more than in others. The need to move goods before expiry date is an absolute priority. Also, systems that I am familiar with have "sales & shelf contribution"...

I think you always get the "values" message because the statement does not protect against null string. Try If Nz("Select".....

Me.Refresh will not help. Use Me.Requery after the Delete command. Jiri

"vcy" is a variable. If it is a string it should be written as, aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt" & " AND [Incyy] = '" & vcy & "'") Best, Jiri

I doubt either of the two statements work. The apostrophes are badly placed. Should be: aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = " & vt) and aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = " & vt & " AND [Incyy] = " & vcy) Cheers, Jiri

I noted that your "requsition" setup reads: Me.Parent.txtExchange = ToUGX(Me.Parent.txtDate, Me.Parent.Currency) while arnel's code (that works) is: Me.Parent!txtExchange = ToUGX(Me.Parent!txtDate, Me.Parent!Currency) See the difference? Best, Jiri

Hi, I suspect the performance issue has to do with the server configuration. This is because you get two dramatically different response times by two different addressing methods. It could be that the softlink hits the i-node directly, bypassing a firewall or a load-balancer or some such. This...

You live in a parallel universe, Minty. Have you ever heard the expression "balancing the books"? You simply don't understand the basic concepts at work in the double-entry system. I have not yet seen a viable commercial accounting system that would do away with the principle. The double-entry...

It's the same thing. Previously, Among experts, the transfer of goods or funds from one location / account to another is a single transaction. Whether in a manual or automated system, transaction is a resource transfer event recorded in a way that identifies both the source and receiver. The...

Look, this is so basic that I am not about to debate it. Obviously, when you build an inventory system it will have not just internal transfers of finished goods but purchases, production, sales. You are trying to change the conversation. You have been advocating split transactions, which I...

No. Each transaction definitely needs to record source of the goods and their destination as a pair. To have any control over the operation you need to do this (and do that explicitly), so your inventory does not get out of balance. Whether that is done the way the OP does it or through a...

Hi, I recall reading about issues with 365 MSACCESS remaining open (and related issues) after closing it. Do not recall the details but it had a simple solution: adding a trusted location for the file. You might want to check that out. Best, Jiri

The suggestion of a "kit" table came from Pat. But the OP only speaks of "Products", not of "components", "subassemblies", "support structures" or "knick-knacks". Then, no-one has yet asked if the "kits" would be "external" i.e. sold as separate SKUs or internal bundling of components to...

Dave, my comments were not concerning "kits" or "kitting" but the level of abstraction in the OP which makes me strongly suspect that this is a fictitious exercise. I have worked in my time on more than a dozen order management/manufacturing production control/inventory management systems as...

Am I the only one here who thinks this all has no relation to real life and the problem is purely a figment of someone who has never been a mile from a real manufacturing process and posts here riddles for people eager to flash their expertise? Maybe I am. Jiri

For my purposes, I see no value in distinguishing between assuring unique index, non-Null, or a required value for a field. It's all part of a data validation process. ?? I am not sure why you are telling me this. I use all the Access tools available to me, forms bound to tables, queries...

Yeah, sure Pat.