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 Chriss Miller 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. randaj

    Access 2003 Query Issue

    No errors, just no data.
  2. randaj

    Access 2003 Query Issue

    I'm talking about Office 2003 versus Office XP and 200.
  3. randaj

    Access 2003 Query Issue

    Like [forms]![swbMain]![frmreports]![cboCompound] On XP and 2000 pulls the correct data, 2003 pulls nothing.
  4. randaj

    Access 2003 Query Issue

    Have a simple query that works on Access XP and 2000 but does not on 2003. Any known issues?
  5. randaj

    Missing rules wizard in Outlook XP

    Did you find a fix for this problem? I am running into the same problem. I ended up modifying the ECF file and got it to add in the AddIn Manager but the feature is still not in the drop down.
  6. randaj

    Moving data with commas in it

    I'm not loosing any data. The problem is is when I move the chemical name from one list box to the other, the comma makes the second list box think its receiving two values instead of one. For example: List Box A - 1,10 Dimetholone List Box B - 1 10 Dimentholane
  7. randaj

    Moving data with commas in it

    I am attempting to move a value in one list box to another. The problem is is that the value contains a comma in it. It's a chemical database so removing the comma is out of the question. Any suggestions?
  8. randaj

    Populating a List Box from a Combo Box

    Sweet! I was hoping it was something simple. Thanks.
  9. randaj

    Populating a List Box from a Combo Box

    The table is pretty simple. The fields are Name, Date, Idea 1,2,3, and 4. I want to setup a form that allows the end user to select the user and then select which record he wants. I figured the best way to choose the specific record was by date since the Idea fields are longs. After they...
  10. randaj

    Populating a List Box from a Combo Box

    So here is what I have. I setup a cbo that lists all the users and then a lbo that will be populated by dates. How should the query be setup? I setup two because when I Grouped the users I had multiple entries because of multiple dates. Then I setup another that looked for the cbo on the...
  11. randaj

    Populating a List Box from a Combo Box

    How is this done?
  12. randaj

    Moving data with commas in it

    First, I appreciate your help. 1. Using the ID might be an option, but it will be my last. 2. When I use string I get an error. It stops on the For statement. 3. lstCompoundAdd is the second listbox.
  13. randaj

    Moving data with commas in it

    Column Count is set to 1. This is the code I used: Private Sub cmdAdd1_Click() Dim itm As Variant For itm = 0 To lstCompound.ListCount - 1 If lstCompound.Selected(itm) Then lstCompoundAdd.AddItem lstCompound.ItemData(itm) End If Next itm End Sub Do this...
  14. randaj

    Moving data with commas in it

    I am building a reports form that needs to move data from one list box to another for reporting. The problem is is that it is a chemical database and some of the compounds have commas in there names. For example, 1,3 diaminopropane. When I try to move the data, the comma separates the name into...
  15. randaj

    Cross Tab Query with 2 Column Headings

    Is this possible? The data is fairly simple, A(compound) and B(compound) equal X(Value). I would like to have a query/report that would have all the A's on the X axis and the B's on the Y's axis ALONG with sum, avg, and stdev. Example: | A | B |...
  16. randaj

    Date Searching Query

    That's not it. The problem is that it is always asking for the [Start] and [End] dates. It seems to me that it's not recognizing the value in the frame.
  17. randaj

    Date Searching Query

    Why does this not work? I have a form the has two option/radio buttons, one Yes(optYes) and one No(optNo), in the same frame (fraDate). If No is selected I would like all values returned. If Yes is selected I would like to use the Between statement to input parameters. Here is what I have...
  18. randaj

    Option Button to search by date

    The Between [Start Date] And [End Date]) Is just a basic parameter that pops up.
  19. randaj

    Option Button to search by date

    Why doesn't this work; IIf([Forms]![frmAdvQry]![fraDate]='2',[tblNotebook_Sub]![Date],[Forms]![frmAdvQry]![fraDate]='1' Between [Start Date] And [End Date]) I setup a form with a frame (fraDate) and two option buttons inside it (optYes and optNo). I would like for the end user to be able to...
  20. randaj

    Null Values in a multi criteria query

    You are my hero. Thanks for all the tips, I really appreciate it.

Part and Inventory Search

Back
Top