Search results

  1. A

    Seperating 2 values in one column

    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.
  2. A

    VB3 vs VB + Access

    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.
  3. A

    Advanced Conditional Formating

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

    Advanced Conditional Formating

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

    Advanced Conditional Formating

    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).
  6. A

    Seperating 2 values in one column

    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...
  7. A

    Advanced Conditional Formating

    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).
  8. A

    Seperating 2 values in one column

    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.
  9. A

    Capture Network Userid as Access Login

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

    Threads locked

    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.
  11. A

    Sorting integers across columns

    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...
  12. A

    Thread disappeared - no notice 2

    Please, DNFTT!
  13. A

    Capture Network Userid as Access Login

    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.
  14. A

    where in query misbehaving

    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.
  15. A

    Parameter Values?

    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...
  16. A

    Parameter Values?

    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...
  17. A

    Threads locked

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

    Capture Network Userid as Access Login

    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.
  19. A

    mySQL hosting

    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.
  20. A

    Bingo Office Database

    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...
Back
Top Bottom