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!

  • Congratulations TouchToneTommy 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: *

  • Users: alexbel
  • Content: Threads
  • Order by date
  1. alexbel

    Selecting Very Last Item in List Box

    Hi, I was wondering if it was possible that when the form is open, it automatically highlights the very last record that is displayed in a list box on that form? Thank you
  2. alexbel

    Appear to Multi-Select, but Behave like Multi-Select=None

    Hi, I have a list box on my form. It has a list of item IDs as such: 1 2 3 4 5 etc. I want the user to be able to select multiple item IDs and I want the list box to appear like the multi-select feature is set to "simple" but I want it to behave like it is set to "none." Did I explain that...
  3. alexbel

    Compile Error: Can't find project or library. Highlights "Mid"

    Hi, When I try to compile the program, I get the following error: Compile Error: Can't find project or library. It highlights the following word in the following line of code: strFilter = strFilter & Mid(strFilterIn, intLastPos, intPos - intLastPos) & vbNullChar As you can see, it...
  4. alexbel

    Automatically Change Link in Word with an Image

    Hi, When I export an item from access to word, this is how it looks like: 1. What is the angle in this picture? C:\Pictures\Angle.jpg A. 120 Degrees B. 90 Degrees C. 180 Degrees D. 150 Degrees I was wondering how I can replace C:\Pictures\Angle.jpg with the picture that it points to...
  5. alexbel

    Making Forms Invisible

    Hi, I use the following code to open a form and make it invisible: stDocName = "Formname" DoCmd.OpenForm stDocName, , , stLinkCriteria Form_Formname.Visible = False However, with this code, when the form opens, it is visible for a few seconds before it becomes invisible. My...
  6. alexbel

    Go to Top of Page after Item Selected in List Box

    Hi, I have a form that has a list box and multiple other fields. When I click to select an item from the list box, it always scrolls to the bottom of the form. I was wondering if it is possible to scroll it back to the top of the form after an item has been selected from the list box. Thank you
  7. alexbel

    Access on Mac

    Hi, Can an access program be formatted to run on a Mac? If I use access runtimes, would that work? Thank you
  8. alexbel

    Frontpage Created Website Problems

    Hi, I have created a frames website using Frontpage. I have uploaded it to the server. Here's my problem: Some people, when they try to view the website, see the text and the graphics scattered all over the place and the images are stretched. Others can see the website fine! What might be...
  9. alexbel

    Listing Drive Letters on Current Computer

    Hi, Is there a code I could use that would list all of the drive letters that are available on the current computer? Thank you
  10. alexbel

    Making Textbox Default Value Equal "

    Hi, I was wondering how I can set the default value of a textbox to ". If I put that in, it gives me an error. Even if I put """ it still gives me an error. How can I do this? Thank you
  11. alexbel

    Toolbar That Will Copy Text From Open Word Document to a Text Box

    Hi, How can I create a toolbar in access that would, when pressed, copy the text of the current word document (note: the word document is not saved) to a text box on a form in access? Thank you
  12. alexbel

    Default Folder for Dialog Box

    Hi, I was wondering how I can specify the default folder of a dialog box. The dialog box is a function. Thank you
  13. alexbel

    No Prompt When Deleting Records

    Hi, I use the following code to delete records from a table: DoCmd.RunSQL "Delete * from tblTable" Everytime this code runs, it prompts me if I am sure I want to delete all the records. How can I remove this prompt? Thank you
  14. alexbel

    Edit Combo Box Values and Save Changes

    Hi, I have a combo box on a form that lists Item Classifications: Math Science Writing I want to be able to select, say math, and be able to edit it and then save the changes. Here's the row source of the combo box: SELECT DISTINCT [tblICL 1].[ICL 1], [tblICL 1].ItemID2 FROM [tblICL 1]...
  15. alexbel

    Edit Combo Box Values and Save Changes

    Hi, I have a combo box on a form that lists Item Classifications: Math Science Writing I want to be able to select, say math, and be able to edit it and then save the changes. Here's the row source of the combo box: SELECT DISTINCT [tblICL 1].[ICL 1], [tblICL 1].ItemID2 FROM [tblICL 1]...
  16. alexbel

    Me.txtTextBox1 = Form_frmForm.txtTextBox2 Doesn't Work

    Hi, In the report OnOpen Event, I have the following code: Me.txtTextBox1 = Form_frmForm.txtTextBox2 For some reason it doesn't work. How can I make this work? Thank you
  17. alexbel

    Define Query Criteria Parameter Value from a List Box

    Hi, I have a query with the following values in it: Item ID Item Text Possible Answers Correct Answer Item Classification Under Item Classification, I have the following criteria: [Forms]![frmForm1]![Item Classification] Here's what I want to do: I have a list box on the form that lists...
  18. alexbel

    Changing Query Criteria

    Hi, How can I change the criteria of a query? For example, I have a Query called qryQuery1. It has the following fields: Item ID Item Author Item Question Item Classification I want the user to have the ability to limit the items by, say, Item Author and Item Classification so I would like to...
  19. alexbel

    Count How Many Items Contain Certain Value

    Hi, I have a form which is used to add items to the test. Here are the fields on the forms: Item Question Possible Answers Correct Answer Case Text Level 1 Classification Level 2 Classification When the user adds an item to the test, how can I have the program count how many level 1 of...
  20. alexbel

    Remove Case Text if Item Before Has Same Case Text

    Hi, I have a form which is used to add items to the test. The user clicks on Item ID's that are located in a list box of whatever items they want to appear on the test. When they click on the Item ID, the item question, possible answers, and case text are all added to one text box. There user...

Part and Inventory Search

Back
Top