Search results

It's ages since I did something like that, but I don't think it's impossible to use "multi-field PKs" with combos or lists, neither very difficult. Isn't it just setting the bound column to 0, then do some smallish code in the forms on current event and the combo/list after update event?

If this is a theoretical question, about foreign keys and Null, you'll probably find some people finding that quite OK, and others thinking the concept of Null violates the purity of the relational model. There should be plenty of amusing discussions in the "Theory and practice..." category...

Rabbie, =FunctionName() in the event property, no event procedure. At one point of time, that was discussed and suggested as method to speed up forms etc, but one doesn't often hear about it anymore.

.Type is supposed to give you that (last property in the code).

Two comments on the FileSearch approach 1 - I think the .FileType returns or set the type of file to look for during the search, for the .FileSearch object, I don't think it applies per each file. 2 - the .FileSearch object is removed in the 2007 version, you may want to look into other methods...

missinglinq I learn shortcuts from my users ;) QuietRiot (warning, opinions) one of the points of teaching them such shortcuts, is that they are standard windows/office shortcuts that should work everywhere. For instance, in the browser, hit F6 to enter the URL field of the browser, hit F4 or...

Hm, yes, Access 2000... Microsoft used a lot of time and money marketing ADO for Access/Jet. Perhaps if they had used a bit more time on the products it would have been more succesfull? Access 2000 wasn't ready for dynamic resolving of parameters from forms with ADO. There's a bit more info...

Heisann, the criterion of the domain aggregate functions are really a string, and it's also the same as an SQL WHERE clause, without the keyword WHERE, so perhaps DCount("AnimeFansubberEpisodeID";"AnimeFansubberEp isode";"[AnimeFansubberID]=" & [AnimeFansubberID] & " And...

You could also teach your users one of the standard Windows shortcuts for "opening" combos, F4 or Alt+DownArrow.

air codedim MyPk as long MyPk = Me!txtMyPk.Value ' save the PK from form control Me.Requery With Me.RecordsetClone .FindFirst "ThePkField = " & MyPk ' use saved PK to find record If Not .Nomatch Then Me.Bookmark = .Bookmark ' assign/move to if found End With

Do you have to store that text? Or is it just for display purposes? If it's only for display purposes, you could enter something like this into the format property of the control where you need it displayed or into the format property of the table field...

You're fetching the results of an SP from SQL server in a ADO recordset, then per each row in that recordset, you're adding a record to a local (Jet?) table through using DAO execute? Yes, the error probably occurs on the dbsBillSysDB.Execute strSQL, dbSeeChanges line, so if if you could do a...

I don't think you need static, it should be enough with forwardonly. If you do as suggested by petehilljnr and have a persistant connection, you could dodim rs as adodb.recordset set rs = cn.Execute(szSQL, , adcmdtext) if rs.eof or rs.bof then ' no record... end ifor open a connection, and...

The split function returns a "standard" array, so just declare as dynamic array, say Dim TableNames() As String TableNames = Split("tblMain,tblPartStatus,tblPartTypes,tblSystemVars,tblUsers", ",") debug.print Join(TableNames, " -@- ") then maintenance will be easier when the amount of data...

I seldom use ADOX, but the few times I do, I'll late bind it. I eDim cat as object ' adox.catalog Set cat = CreateObject("ADOX.catalog") With cat Set .ActiveConnection = CurrentProject.Connection ' or some connection ...Note, I think there are some situations where ADOX can't late bind...

Validation rules are an "Access" thingie, and, as far as I know, they can't be written through DDL. Now the "trickiness" begins. Access is really the front end, which can use several different databases. The native, or default, database is Jet. The Jet database supports a lot of features that...

Perhaps this discussion in one of the public Access NGs, can give some inputs? http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_frm/thread/d52ff0f20df3510d/ Most of the replies discusses using either a function or a property to keep a persistent pointer to the...

Thread is http://www.access-programmers.co.uk/forums/showthread.php?t=136599, a couple more links there now, too. Gist of it is - Jet will only transfer the whole table if you don't know what you're doing (indices). While SQL server executes the query on the server, Jet will (from the client)...

To add a bit of info, David W. Fenton did a very good explanation here http://groups.google.com/group/comp.databases.ms-access/msg/8eb30fbefdd05f96 where he even speaks about the retrieval of indices (suspecting Jet might be smart enough to not load the whole index) - that reply is probably...

I don't know. Sounds logical, though, but at least it isn't pulling the whole table.