Search results

Wit is educated insolence - Aristotle.

Also make sure that you have the correct references set for DAO. Look under Tools>References. It'll be something like DAO 3.6

Hi, Which line is the error occuring on? - Look up debugging either on here or in the VB help files if you are unsure how to find out.

Hi, This is the syntax for VBA, probably very similar for vb6 - you'll need a proper connection string to the db i guess. Any way hope it helps. K. Dim db As DAO.Database Dim tbldf As DAO.TableDef Dim idx As index Set db = CurrentDb Set tbldf = db.TableDefs("Table1") For Each idx In...

Well funny you should say that, i manually registered the dts dll and now rather than getting a broken reference error i get an invalid class string error :(. This really blows goats. Distributing a database really shouldn't be this much of a pain. The db is really just a reporting tool and i'm...

Hi, I'm slowly being driven insane by dll's. I have included a number of references in my app that i am trying to distribute to another test machine. A few of these are SQLServer dll's that allow access to use DTS packages stored on the server. These are found in C:\Program Files\Microsoft SQL...

MyMonthSearch:Month([Name of the date field here*]) * this is the name of the field you want to search on i.e. your field from your table like MyMonthSearch:Month([Employee_Start_Date]) HTH K.

There are probably a number of ways of doing this but this should work. In the query add a new field with this in - goes where the field from a table would normally be. MyMonthSearch:Month([Name of the date field here]) In the criteria. [Please enter the month - as a number] You should be...

try the repklace function. Replace the " with spaces and then use the trim function to remove them. Private Sub Command4_Click() Dim s As String s = Me.TXT_UserName s = Trim(Replace(s, """", " ", 1)) Me.TXT_ReplacedName = s End Sub HTH K.

Numbers don't require anything. Text fields need '

strcriteria = "[date]=#" & txtDay1 & "#" hth K PS date is a reserved word, if you have a field called date you should consider changing it.

Hi, I'm still not 100% certain what you mean however this may give you some ideas. It is a new query built on MASS test. It uses a second select query inside the first that counts the number of SP.Effect entries that match the number of Faction entries for every row. Paste this into the sql...

Hi, Spent some time yesterday configuring the package. I've managed to get it running so that in total the 34 packages run only 2 mins slower than it takes the longest package to finish if run on it's own - 1.3 million rows and 116 fields :eek: - It now takes 25 mins which is down from + 1hr if...

Hi, I've got a DTS in SS2000 that is a package of packages, 34 in all, that are importing data from an ERM. The idea being i can run 1 package individually if needs be and automate the main package for transfer at night and only have 1 chron job to worry about. The question is how many...

Hi, It's good to see someone taking an interest in how to do this properly :) It's obviously a large topic and not something i think i could cover myself but i can give you some pointers. The first thing to do is analyse your requirements. The purpose of a data base is usually to store...

Sorry try this.

Is this what you mean? Look at QRY_SP and QRY_SPX QRY_SPX uses values selected in QRY_SP. HTH K.

Depends which end ;) :D

Not a suggestion more a question. I posted a reply to a thread on Friday from a user i believe was named msaccessgirl. Subsequently i can't find the thread or the user. I've searched my posts and on key words i knew were in my reply. Nothing. Has this user been banned? Can users delete...

If the sibling is a subform of a subform-it is intended to store data in a related table not an extension of data in the same table- then you should link the sibling to the child in the same way as you would link the child to the parent. To get the correct syntax for the link -as access will...