Search results

Try this: Change the function to just return ('a','b','c') as a string. In the query criteria cell, enter In SomeCriteria() I think that will work. Second idea: make a table of criteria values, insert rows from whatever source you want, join the criteria table to whatever field you want in a...

Yes, you can create a Class module with a "Public" sub to set a value on and off. Something like this: Public Sub VisibleOnOff(myControl As Control, mySetting As Boolean) myControl.Visible = mySetting End Sub In a form you would write VisibleOnOff(btnSave, True) or...

Something like this will probably work: 1) Make a query with *two* copies of tblUser, Access will prefix the second copy with "1" or something. DO NOT join the 2 copies. 2) Select UserID from tblUser As ForID, select UserID from tblUser1 As ToID. 3) Add a Where clause ForID <> ToID This...

Create a module and make "Property" procedures. Then you don't have to know or care about form names. (don't mean to insult any posters, but any other approach is dumb) RichM

Agree with those who don't use spaces. I inherited an app from someone who did. This nameless person was not a careful typist. A few field names had 2 spaces between some words. My old eyes had big problems with that. RichM

In general, an Access 2000 front end will work fine with Access 97 back end tables. RichM

Like this "SELECT TblComplianceLine.ComplianceNo, TblComplianceLine.Description, TblComplianceLine.Comments, TblComplianceLine.AuditDate, TblComplianceLine.PointsLost FROM TblComplianceLine WHERE (((TblComplianceLine.AuditDate)=" & "#" & selectdate() & "#" & ") AND...

Pat Hartman wrote << I'm not sure why you would want to do this. How are you planning on managing changes? >> I do this a lot for reporting applications with many "group by" reports *and* large-volume Oracle transaction data on a mainframe. I copy the Oracle data to an Access table using ADO...

Maybe I have misread your post .... Each and every user is a member of the **group** named "Users". Try and remove someone from the group "Users" and see what happens. The **user** named "Admin" should be: 1) removed from the **group** "Admins". 2) given a password. That's how you secure a...

Here is my best advice: Start from the start and describe the business process in (drumroll + cymbal crash) well-organized *E*n*g*l*i*s*h*. Don't start with a list of tables, fields, and keys. Define any special terms you use. After several posts, you have not explained what "density" means...

You wrote << My question lies in the MsgBox statement. Instead of getting the control name, I want to get the caption displayed in the attached label for that particular control. Can I? >> Not as far as I know. The label is just another control on the form and is not linked to any specific...

Tess, Buy "Speed Ferret". It is a search utility for Access databases. RichM

Sounds like the menu is static, once published it does not change for the week. If so, storing in an Access table and publishing to a web page is overkill. Sounds like Word is a better choice. You will still have to work out the mechanics of publishing a new menu each week. RichM

Rob, I don't think that's what SammyL meant by "is Access installed locally". If you install Access on a desktop then MSACCESS.EXE and a lot of DLLs are stored and registered on the desktop. You can also launch an instance MSACCESS.EXE stored on a network server. If you do then MSACCESS.EXE...

Paul, You wrote << The user does not have this level of permission. We're talking about deleting the table, not records in the table. >> Yes that's what you wrote and what I wrote the first time around. You said you **CREATE** and **DELETE** tabledefs with "code". I take that to mean a...

Olie, You wrote << It allows for multiple database usage, with multiple MDW Secuirty files. >> I think it is best to use only one MDW for all applications on your network. That way all shared MDBs on your network refer to a common MDW with all groups and users. This is much easier to...

Try a search using "network", "shared", "multi user" There have been several threads on this topic. That will be better for you than my solo response. RichM

Paul, Maybe I am missing something here. If you create and delete tabledefs with VBA code, then the users don't need "modify" rights to table design. The users just need basic read, write, delete, etc for the tables. RichM

You wrote << I just want to know if they will be able to use it without a username and password (or the default username Admin). >> Yes, you can put an MDB on a network drive and open it without username and password. This requires a System.MDW where the user "Admin" has a blank password...

See Help for "property procedures". RichM