Search results

Your way would probably be faster. You'd have to run a million rows through it as a test to see. If you don't have that many rows, whatever works is usually good enough.

You didn't mention what the problem is. You might want to check and make sure you have the right references. You'll probably need to include references to Access and/or DAO.

Yes. Now returns the date and time. Date returns today's date (I think at midnight).

Ok. In your original post, you show the word "And" at the beginning of your code. What comes before that?

Sorry, I wasn't paying very close attention to exactly what you're doing. Does this work: And IsNull([tbArrTime]) And [tbSchTime] < Date Please note that IsNull() does not use the syntax in your original sample (it only takes 1 argument).

InStr finds the nth occurrence of a string within another string and returns a number. What I was thinking was that if the word "from" always precedes the string you're interested in, you could use InStr along with Right (or Mid) to find your string. Something like this...

Not sure exactly what you're trying to do, but I believe you want: And [tbArrTime] is null And [tbSchTime] < Date With the assumption that "Date" refers to the VBA function Date() (aka the current system date).

Are the words "Order" and "from" always in the string in the places you've indicated? If so, you can use InStr to find those strings and then use the Right function to get the rest of the string.

Look up global variable in help. You can get/set a global variable anywhere in your system, not just the "main form".

LOL, I was totally jesting. I fit the mold Ouma described perfectly. I'm a mish-mash of this DB, that DB, and even Access. It all depends on who is paying for what.

That really didn't answer Bob's question. Storing data in a relational database like you would store it in Excel causes exactly this sort of problem. Access is not Excel. You could look into using a union query and sorting the results. You would have a separate "select" statement in the...

Please, DNFTT!

Do you already have the Windows user name? How about: MyVariable = Environ("USERNAME") Maybe you can get a little farther along using the results of that.

Use either Debug.Print or MsgBox to get the text of your query. I prefer Debug.Print because the entire string appears in the Immediate window of your VB editor and is easy to cut and paste.

Yes, if you'll re-read my previous post, you'll see that's what I expected (I commented out the update statement). Did you check the SQL in the immediate window? Did you put that SQL into a query window and run it? Did you do further troubleshooting based on the results of that? Did you post...

Change this: If chkmssql.Value = True Then InsertSQL = "INSERT INTO [Staff: Database connection] ( [Staff ID], [DBID] ) VALUES ( ['" & PerminantStaffID & "'], ['" & DBID & "'] )" DoCmd.RunSQL (InsertSQL) End If to this: If chkmssql.Value = True Then InsertSQL = "INSERT INTO [Staff: Database...

Bite your tongue! How dare you cast aspersions on my chosen profession! I would never be like one of THEM! (LOL)

It depends on your backend. If you're using SQL Server, you can just use Windows authentication. If you are using an Access backend, just limit access to the file/folder via Windows security.

No experience with hosting but I'm TOLD that hostdepartment.com is inexpensive and flexible and has MySQL built in. Also, I'm TOLD that amazon.com developer tools allows you to rent virtual servers from amazon.com which are pre-configured. The price on both are quite reasonable, I'm told.

As a first draft ONLY, you could start by identifying all the nouns/events in your description as potential tables. For instance, with the little bit of information you've given us, I might create the tables named: Sessions Organizations (includes Halls) Games GameTypes FinancialStructures...