Search results

Before you read too much of what I've written, do some searching on normalized databases. You should have a unique Customer ID in the customers table. You should also have that as a primary key. But this ID should exist in each of your other data tables as well. So for example, your...

I would do something like this. Need an array to store strings, and a counter to store how many strings we are putting in the array. Dim strWHERE() As String Dim intCount As Integer Dim sqlWHERE As String Name the text boxes identically, but change a number. So like this: txtBox1 txtBox2...

There is a way to do this, it's a bit involved. I am working on something.

Thanks so much for the help. I will work on this some more, and post back if I run into any issues. So far today, there have been no complaints of users getting the same record to work, so at least that is good. The multiple locked records is not really an issue, as I can just unlock them in...

Okay I understand the BeforeUpdate. So that will run before the actual save takes place via the buttons right? So in the save, it should just do the command to save the record, which will run through the BeforeUpdate first, unlock if okay, then save. And the get new will do the same, except...

You could use bmail.exe: http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm This is only if your email server will allow it to do this. Then you can email by calling bmail.exe as a shell command in Access with the proper options, etc.

I know this is a bit long winded, and thank you for the help you have provided so far, it is much appreciated. I am overall more of a hardware person than a programmer, so some of what you say I'm not totally sure on. I'm not sure if this would help. Do you mean lock them via the field (It's...

That's what I figured it did, but that won't help me at all. I only tried it as someone suggested it with regards to my issue. I didn't see how it would help though. Users simply cannot be allowed to have the same record selected at all. We are calling customers based off of this - and we...

I use a text field. A function will bring up a browse window, they find the folder and hit OK. It puts the folders full path in the text field. Then the code will just refer to, for example: Forms!frmImport.txtImport.Value There are free functions out there that can be used to browse for a...

Okay I enabled pessimistic locking. That's all well and good. Problem is that I can still select that locked record in a query. How can I prevent this?

I am aware. They all have different numbers. Initially I was using Randomize Timer, but the system times are set by the server on login so there could be identical seeds using that - I was still running into more issues so I went with the random seed per username route.

Well....I AM IT lol. Except we have a contracted lease agreement on the SQL server so I can't touch it unfortunately. It's basically a way for HP to extort all sorts of money from you. It does make sense, being a global company and they provide 24/7 monitoring, but it's frustrating at times...

Hmm..okay that must have been a fluke because now the speed is okay. I will try doing the acCmd - see if that works out better tomorrow. I have been pulling my hair out over this lol. The thing is that this process is very speed oriented and driven. We need to get as much done as possible as...

While this works, it introduces a huge slowdown. Took about 10 seconds to ge the next record. BTW, the DB currently has over 500,000 records in the table we're working with, and not all data is imported yet. I know....I still want it on the SQL server :(

Right it's possible based on query time that it's not yet locked, but by the time it loads things it is, but it's already selected. This is why I tried to introduce randomization. Because if you just did a SQL TOP 1 it would grab the same record for everyone that happened to query about the...

I thought I had this handled...however it seems that it's not quite 100%. I have a database that has a single user form. This form, upon loading, has a recordsource which selects only those records which have two fields marked as "No". The fields are named LOCKED and COMPLETED. They are just...

I figured it out! I can't believe I didn't think of this earlier: SELECT TOP 1 *, Rnd(tblMain.AcctNum) As Expr1 FROM (SELECT TOP 100 * FROM tblMain WHERE tblMain.COMPLETED = False AND tblMain.LOCKED = False) ORDER BY Rnd(tblMain.AcctNum) DESC; Simply limit the selection of records to 100 and...

This works, sort of. It is faster, but only sometimes returns a record. Maybe 3 or 4 times out of 10 times it runs does it return something.

Yeah I don't know any other way to take the date abbreviation and generate a number without that.

It may be possible to do it all at once, just use: Format(Date(), "ddd") Weekday(Date()) Depends on where the info is going though.