Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

Thx, jitter. That sure made it.

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

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

Was someone able to follow on this!

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