Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SeeJane

    Insert Field Contents Based on Previous Field

    Let's try a slightly different format Me.[YourRateBoxName].Value = Me.[YourComboName].Column(index) Hopefully this should work CJ
  2. SeeJane

    Insert Field Contents Based on Previous Field

    Hi, Sorry - I guesss that wasn't too helpful. Before you do anything, I suggest making a copy of your database as a backup. That way you can fool around without needing to worry about the safety of your data. This is the safest way to work on your database, I'd reccomend it as general...
  3. SeeJane

    Insert Field Contents Based on Previous Field

    Hi - You can get the value of any column in a combo box like this. Note that indexes start at zero, so the 1st column will be 0, second 1, and so forth. [Forms]![YourForm].[ComboBoxName].[Column](index number) For the AfterUpdate on your combo box just enter Me.[Ratetextbox].Value =...
  4. SeeJane

    Calling a query

    Hi - In what context do you need the query - do you want it to appear when a user hits a button, open as a recordset, etc? Somebody should be able to help. - CJ
  5. SeeJane

    How to get current user folder in Windows XP?

    Try this - Dim strUser as String Dim strpath as String 'Get Windows username strUser = Environ("USERNAME") 'create string for path strPath = "C:\Documents and Settings\" & strUser & "\My documents" 'do whatever with strPath Good luck, CJ
  6. SeeJane

    Formatting forms/sbf for maximum friendliness

    Hi - If you have a 1:1 relationship between members and schools, you could write a SQL statement pulling all the data from the different tables together, and then paste that SQL into the form's Record source (you do need to use the SQL rather than an actual query). You can then design a...
  7. SeeJane

    How do you determine LogonID for WIN2000/NT User?

    Environ("USERNAME") This will (as the name implies) get you the username as a string. - Good luck, CJ
  8. SeeJane

    Loop Question

    Hi - A for...next loop sould do the trick. I'd suggest fooling around a bit with loops before using this to reach all users, but here's the general idea... This does assume your send command is OK... Good luck - CJ '--------------------------------------------------- Function Send Dim...
  9. SeeJane

    Remove spaces, but not all, from within a string

    Hi - You could use the InStr function to look for instances of " " (double space) and then the Replace function replace them with " " (single space). Something like this (I haven't tested it, but you get the general idea)... Function RemoveExtraSpace(YourString as String)...
  10. SeeJane

    Very Tough Question

    Yikes - I agree this is a very scary way to do things. If you have absolutely no choice, you can use a For...Next loop like this cmdYourButton_OnClick Dim intReplicate As integer Dim i As integer 'Get total times to repeat process intReplicate = Me.<TextBox with number>.Value 'Add new...
  11. SeeJane

    CONTROL TIP TEXT

    Put this line in the form's OnOpen event and again in the box's AfterUpdate event. There may be a way to get it into a single event, but I don't know what it is. Me.YourComboBox.ControlTipText = Me.YourComboBox.Column(index for whichever column has the description you want to use) 'remember...
  12. SeeJane

    How do I separate query data in Expression Builder?

    Now I am truly stumped...sorry! Fooled around a bit with the InStr function and couldn't produce an error. You could try submitting another post with a desperate-sounding title. Good luck, CJ
  13. SeeJane

    Opening Access 2000 database in Access97

    Hi, Access has a conversion utility in Tools -> Database Utilities -> Convert Database. You have the option of going to either a newer or older version, although I've only used it going from older to newer. One problem with conversions is that an error or inconsistancy in a single form...
  14. SeeJane

    How do I separate query data in Expression Builder?

    Not sure, it looks OK to me...I'm stumped. There are a few functions (in theory, at least) acting in concert here, so you might be able to pin down the souce if you try slowly building the statement. In other wirds, try InStr(1,[NAM1],&quot;, &quot;) and if that works, try...
  15. SeeJane

    How do I separate query data in Expression Builder?

    Hi The quick explanation of how to do this is to concatenate everything to the left of &quot;, &quot; with everything to the right of &quot;, &quot;. One way to do it is use the InStr function to get the character position of &quot;, &quot; then the left/right functions to get everything to...
  16. SeeJane

    ExportingFromMultipleFormsToSingleExcelFile

    Could you use a SQL to pull all the desired data together into a single source, then export that?. You could either do the work as a stand alone query or use VB to program a new Query Def then export it using the transfer spreadsheet method. Good luck, CJ
  17. SeeJane

    Importing spreadsheets into an existing table/form?

    Hi, If the fields are different, or if a field has one data type in Excel and another in Access that can screw up the works. For what its worth, I've found that you get a bit more control over the whole thing if you import excel as a new table (play with any field names/data types, etc)...
  18. SeeJane

    How to save user preferences?

    The easiest way I know is: Environ(&quot;USERNAME&quot;) It give you the name as string, no scary security details... Good luck, CJ
  19. SeeJane

    How to save user preferences?

    Hmm, Have you experimented with using the user's windows logon to detect who's in the db (you can get it without any user input)? You could set up a table where the user's last set of parameters get written to a record with the user's logon upon exiting the db (each user could have 1 record...
  20. SeeJane

    yes/no button

    Access will gray them all out if you don't have a default value set (aggravating, yes) even if it appears unlocked, enabled, and ready to go. Could that be it? CJ

Part and Inventory Search

Back
Top