Recent content by wricoasolutions

The code below works for an AfterUpdate combo box lookup that I am using currently. The query used by the current code uses only one copy of the table referenced by this lookup, the “Client” table. Private Sub ClientNameLookUp_AfterUpdate() Dim cnl As Object Set cnl =...

It a Jet backend. Sorry, it's a Jet backend. Have been searching the forum and have found that the Jet backend will not do what I thought it would, (process server side code). By the way there were some good responses from you Pat in my searches. Thanks for the info.. Problem I have is that...

Clarification! I Have in the past worked in an Oracle environment and have had code that is left on the server for various reasons. I was/am not sure how or if Access can handle server side coding. From what I am reading and hearing it would appear that it does not. It also appears that...

Thanks Ken, Kind of was leaning that way myself, but am new to Access and did not know how it handled the different coding methods. Again, thanks for the reply. Bill

I have split my database, the data is in a DB on the server and the forms, reports, etc is on the client desktop. My question is "Is there an advantage to having all of my combo box queries (Lookups) on the server side (defined in the table as a combo lookup) or should I put the all on the form...

Searched and Found I have done a search and found some code (yours and others) and it has been helpful, problem is I am not a VB programmer so not sure why the code that I tried does not work. Will check the VB manual and see what I can find. Thanks for the help, the search worked great. Bill

I am using Access 2000 and need to open a separate complete database. I am trying to pass control from the database that the switchboard is in to a separate database. I may be approaching this wrong. What I may need is a shell to control which database is being used. I have 6 different...

Is it possible to access "Database B" (an Access Database) from a switchboard in "Database B" (A separate Access Database)? And, if so, how? This is the third question I have asked on this forum and with each of the previous question the answers have been very helpful. Just want to say thanks...

Thanks Pat, will be sure to check all overlaps and am most interested in ensuring that referential integrity is intact through out the design. Again, Thanks. Bill

I am combining 12 Databases. I have split all 12 between the server and the desktop. My question is “Should I combing all of the data table on the server into one database or should I leave all of the individual application data tables in separate Databases on the server”. Additionally, is...

Wayne, Thanks for the additional information. Will give it a try. Looks like the type of functionality that I am used to. Bill

Understand what is happening, will give it a shot, should get me where I need to go. Thanks.

I am new to Access, I know how to access the data within a field by using the field name as a variable. (Variable1 = (value(fieldname1)) or syntax similar to this. My question is, is this type of function available in Access and if so where is it in the text/manual. Or, could someone give me an...

Makes good sense. Thanks, am new to Access, thought there must be a way to do this. Again, Thanks. :)

Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.