Search results for query: *

Fantastic! Thanks!

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

Sorry about that.

When they click on an item, I want it to appear like it is not doing anything as if it is waiting for the user to select more items. But actually it is running the AfterUpdate code that was written for a list box that has the mutli-select feature set to "none." If I select MultiSelect=Simple...

I want it to appear like they are multi-selecting, but in reality, I want it to behave like it is not multi-selecting. So, in appearance, I want it to multi-select... But for how it behaves code-wise, I want it to not behave like it is multi-selecting.. I understand that this is confusing...

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

Hi, I had that checked already so that was not the problem. I did, however, figure out what the problem was: I didn't have Microsoft Word Object Library checked and when I checked it, it didn't give me the error anymore. Thanks for your help anyways.

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

Can somebody please help me? Thank you

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

Oh, TheAceMan1 That is what I was doing wrong! Thank you for clarifying!

Thank you PHV! I didn't think of that for some reason. FancyPrairie, It still didn't work! I don't know what's wrong. Thank you all

I have another question: Using this code: Application.Echo False DoCmd.Hourglass True DoCmd.OpenForm "Formname", acNormal DoCmd.Minimize Application.Echo True DoCmd.Hourglass False How can I alter it to make the form be invisible instead of minimize? I tried changing...

Sorry for the LONG delay, but do you know how I can do this or do you know a site that will show me how to do this? Thank you

PHV, I am not sure how to use Application.Echo method. I tried Access help but it didn't help me. FancyPrairie, I tried that code but when the form opened, it did not become invisible at all, it just stayed visible in the background! What might the problem be? Thank you

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

Private Sub ListBox1_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Item ID] = " & str(Nz(Me![ListBox1], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark Dim l As Long, X As Long, a$ Dim Strg As String Dim StrgArray() As String Dim...

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

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

ManicMark, I tried using tables but that did not fix the problem!:( fumei, What program would you recommend I use then? Thank you