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

    Form freezes first time Access in opened

    Does anybody has any ideas to this? Ever since I got a new machine here at work, I am having problems with a database that I didn't have before and I'm clueless what could be causing it. This db has forms and when you open the database the first time you click on any of the forms it seems like...
  2. ziwacky

    List rowsource at runtime

    Hi, Is there a way I can know or see the rowsource of a list or drop down list at runtime. I have two drop down lists. One with names and the second ones have records attached to those names. I have set a rowsource for the second list at design time that will change depending on the selection...
  3. ziwacky

    Out of memory issue

    Hi guys, Thanks for your responses. Well, like I said before I know very little tech stuff. I'm only a programmer. Please bear with me here. If somebody tells me how to get info like RAM size and other info you may need, I'll get it for you. I can get the OS and Office version. This was a new...
  4. ziwacky

    Out of memory issue

    Hi, For some reason my system is running out of memory. I'm a very non-techie person and I am not even sure where to start looking. What is happening is that when I run Word if I try to do anything like Print... or Page Setup... or Format Picture... it tells me that "System is out of...
  5. ziwacky

    Clock/Time Active Control

    Hi, Does anybody know if there is out there any clock/time active control. What I'm thinking is something similar to the calendar activex.
  6. ziwacky

    Help! I am trying to split 1 field into 2 using an update query

    Kate, Don't be sorry. We've all been there. We've all started from scratch. In your database window go to the Query tab. Create a new query and select the table you want to update. In your query window right click and mouse over Query Type and select "Update Query". Assuming that...
  7. ziwacky

    Help! I am trying to split 1 field into 2 using an update query

    Is this what you're looking for to do? Update TeamTable Set HomeTeam = Mid(Match, 1, InStr(Match, " v ") - 1), AwayTeam = Mid(Match, InStr(Match, " v ") + 3, Len(Match)) Cheers! Z
  8. ziwacky

    Multiple record saves

    I'm not sure why you'll like to do so, but one way could be using a For..Next statement. Saying that your text box for number of times is called txtNmbTm, Dim i as integer For i = 1 to txtNmbTm 'Save your data Next i Hope that helps. Z
  9. ziwacky

    a newbie question-continued

    Ooops, sorry, didn't see the rest of the posts. Z
  10. ziwacky

    a newbie question-continued

    Have you tried setting the "Can Grow" and "Can Shrink" in the DETAILS properties as opposed to the Text field properties. I haven't tried it, but I think that may work. Z
  11. ziwacky

    Need to check if a record is locked in onCurrent()

    Hi, Found this routine that may help. Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim boolLocked As Boolean Set cnn = New ADODB.Connection cnn.ConnectionString = " your connection " cnn.Open Set rst = New ADODB.Recordset rst.ActiveConnection = cnn rst.CursorType =...
  12. ziwacky

    Dim Explanation Please

    Hi gunnie, The Dim statement is one way of declaring variables in modules and procedures. Variables do not have to be declared beforehand (that is by omitting the "Option Explicit" statement at the beginning of the module), but if you're not careful enough not declaring a variable...
  13. ziwacky

    Text validation/Input mask help

    There are several ways of doing so, the more simplistic being the following. Call your text box "txtDesc". In the "After Update" event select "Event Procedure". Click on the ellipsis and type the following inside the txtDesc_AfterUpdate() procedure. If...
  14. ziwacky

    looking for a table in the tabledefs collection

    Will someone know the why of this one. I am importing a table using docmd.transferdatabase. If I loop through all the tabledef in my tabledefs collection, sometimes I can see the new table included in the list, and sometimes I don't. Mostly I don't and I need to see for what I'm trying to do...
  15. ziwacky

    open a database programatically

    Can I open another database programatically so that user will have two instances of Access open. What my program does is that it executes some changes in another database and I want to avoid the user to have to go and open the new database to see the changes reflected. Can I write my code so...
  16. ziwacky

    Exporting excel sheets

    Thx, jitter. That sure made it.
  17. ziwacky

    Exporting excel sheets

    I'm trying to automate an import from an excel worksheet and got to the following. You know when you use the import wizard for an excel workbook, that if you have more than one worksheet on your file it gives you the option to select which worksheet is the one you want to use. Cool. That is the...
  18. ziwacky

    Function that tells if string entry is a file

    Hi there, Is there any function that will tell me if the user entry (to a textbox, so it is a string) is a file. Maybe something like IsFile(txtFile). Thanks, Z
  19. ziwacky

    User not seeing search result

    Was someone able to follow on this!
  20. ziwacky

    Grouping problem...

    Well, let's see if this is what you need. First, you mention that you're getting multiple values. Do you mean more than one record are the same. If this is the case you should include another word (DISTINCT) in your query that will return only one of the duplicated records. CFQUERY...

Part and Inventory Search

Back
Top