Search results

i was unable to get DAO to move on the priority list for my A2002 user

ChrisO~~~ it's not brushfire season is it? i have a couple of friends who live on yr side of the world! thanks for the advice... my editing user does have the DAO 3.6 library checked on his computer but it's about third in the list. i will try moving it up to the top. isn't it strange that i...

correction- it's A2002 not A2k sorry sorry, i made a mistake, it's not A2k, it's A2002. (i am using A97... there's no mistake in that one :) ) Also, i just checked to see which reference library the A2002 user has, it's DAO 3.6. Which should be able to read/interpet my DAO 3.51??

do you mean while on the computer that has A2k?, check the Tools<References<References Available<(choose Microsoft DAO 3.51 Object Library) wouldn't i get the same error/problem when using my A97 fe? i don't have the me.requery in my A97 fe and it works like a charm. i'm going to get on the...

could it be which DAO library i'm using i'm using DAO 3.51 Library in A'97... would that make a difference to my editing A2k users?

i have created a database using A'97. it's a split database with the be on a SQL server - used in a multi user environment. i'm set as the database owner on the server. however i have created a user group on the server that allows editing (create/delete/change records). i did two tests today...

i assume you mean two different databases? regardless of where your information may reside... you must create a unique identifier... maybe you can create an intermediate form to show the user a list of possible names for the name that they are looking for. (that sounds a little wordy...what i...

i believe you are going to have to create a primary key for your tables. even if you matched on part of the name example) table A: John Doe matching to table B: Doe, John there could be a case where there are two johns or two does... access needs something unique in the two to distinguish.

i agree... i'm pretty sure that the purpose of queries is to base them off of tables or other queries. my suggestion is that my coworker should go back to the original tables and run the formulas one at a time (or as needed). thanks for entertaining the question.

didn't see this reply earlier :) this is a raw material selection DB. and in order to select the appropriate material, you input finish material OD/ID info... with this input, this MEGA tableless query runs these formulas... this in turn gives a result that will eventually be fed to another set...

you can give this a try i assume that both tables have some sort of primary key (movie title or movieID number)... you could make a query from the two tables and join on this unique field. then change the join properties to give you all the movies from the video table and those only those from...

i've got a crazy question.. or at least i think so. i'm helping a fellow worker with his DB. he has built a query with about a dozen columns of formulas. there's no table - no query... just the formulas. (and they're nasty nested iifs at that) i'm pretty sure he's going in the wrong direction...

Pat, i'm trying two places for the Loop... the code below doesn't appear to terminate. I tried another spot by moving the Loop just after rs.MoveNext - suggestions? For Each ctrl1 In Me.sfrm_CToolInfo.Form ctrl1.ColumnHidden = True If ctrl1.ControlType = acTextBox Then...

give this a try if you want time and date, you can use now()

try looking into Requery

looping through recordset i've modified my code a bit but not having any luck. could someone please take a look and poiint me in the right direction. Private Sub Form_Current() On Error Resume Next Dim ctrl1 As Object Dim ctrl2 As Object Dim rs As Recordset Set rs...

I was afraid of that. And now I can't help but to ask you... is it possible to run through the recordset to test all the fields?

Pat, thanks for your response, but if i remove the 'end do' the decision to hide or not will only be based on the last record. essentially, it could toggle (for lack of a better word) back and forth between show/don't show and what ever the last column contains will dictate the result. i'm...

Any help with this would be appreciated:) Here's a bit of code i got from this site (ref this thread: ) which hides columns on a subform when there are no values present for a particular filter on the main form. well, all was fine and dandy until i realized IF there happens to be a a value in...

Howie~~ thanks for the info