Search results

It's not an issue of seeding the Rnd function. I get different results every time. That isn't the issue. But to be sure, I tested your code. And I got different results every time. I'm still trying to figure out the reason for this particular problem. Any ideas? If I manually set x1 and x2...

So I've written some code to generate random variables. (using the polar form of the Box-Muller method) My issue is that though the values make sense with few enough samples, once there are 10's or 100's of millions of values generated, it's not getting anywhere beyond 5.1 standard deviations...

I hope we get the time in the future to enhance our databases to be deployed properly. Maintaining other people's applications is so much worse than generating one from scratch. (When they're written poorly)

Again. I agree having one shared front end is not ideal. But having multiple users use the database was not the issue. I'm by no means an expert and when it comes to Access am far less knowledgeable than pretty much anyone on these forums. But there was just no reason for the shared use to...

I don't believe this is the case. We have dozens of databases that work this way. The backend and frontend are split into two databases. But the frontend is shared for multiple users to use at once. There are dozens of tables in this database and this is the only table that has this issue. I...

Yes it's a linked table. I can't move around the database objects since the database is currently in use and therefore not allowing me to make any changes. This is why I'm trying to figure out the problem so that when the users are not using the application I can make fixes that will stick...

There is a table in a database I'm maintaining. One of the fields is a Text field. When I look at the datasheet view, i see the value #Error for every entry When I select the field to try to edit it, I get the following error popup: "Reserved error (-1517); there is no message for this...

Yep I figured that out just before reading your response. I really dislike using globals, but I guess it's the easiest way here.

http://support.microsoft.com/kb/209871 I have tried to implement Microsoft's example here but there is one critical issue: the Orders form opens the frmPassword form like this: DoCmd.OpenForm "frmPassword", acNormal, , , , acDialog Then the frmPassword sets the value MyPassword to some value...

Thanks for the help. It's clear now.

I'm sorry that made no sense to me at all. I have a bunch of fields. Two of which are transactionID and transactionDate I want to return one record for every unique transactionID and that record be selected by being the one with the earliest transactionDate In Access query design view, I...

I've googled this and found several explanations on how to do this. But none of them seem to deal with the case where there are multiple fields. Example: I have a table with a dozen columns. One of them is a date field. One of them is a transaction ID. I want to return a record for each...

I'm trying to create a pivot table. I haven't had any trouble with pivot tables that have rows, columns, and data elements. But if I try to make one that has no row elements: pt.AddFields ColumnFields:=sColName I get an error and it fails. Googling has revealed nothing about using Addfields...

Yeah the primary difference between our two entity-universe instances was that Access asked me nothing upon closing the query. Just gave me the same two error messages you got. I suspect your locality may have a finer grain of simulation than mine.

Well I create about 100 queries a day against hundreds of tables in dozens of databases. The underlying issue is the network is flaky and a link will break temporarily. When I said "restored the table" I was really referring to simply waiting a second and trying again. Copying the SQL from...

I recently opened a query (in design view) that referenced a table whose link was not currently intact. The query gave an error message upon opening it in design view and then showed the query, with the table in question empty of any fields (normal) and all links between this table and the...

The record source of the form is a SELECT query that selects that data from the table, which is fine. But I'm trying to figure out why updating the fields then INSERTS the data into the table. There is no INSERT statement anywhere in the code.

I'm trying to make modifications to an existing Access application. The app currently has a form in which, when a user presses enter in one of the fields, it inserts all the current fields on the form into a table. I am trying to figure out why. I've looked in the form's properties, the...

Two tables: Purchases: -PurchaseID <-- Primary Key -PurchaserName -ProductID PurchaseActions: (this table has no primary key) -PurchaseID -PurchaseStage (can have several values like Ordering, Delivering, DeliveryConfirmed, Survey, Support, etc.) -PurchaseActionDate (the datetimestamp of when...

Using inline SQL was how I got this to work. Basically something like this: First query: select all documents where doctype = A2 second query: select everything with this criteria on the doctype: Not In (select doctype from [first table]) I didn't know you could use SQL in a criteria...