Search results

I am working at a company that has installed Access 2000 from Disc 19 of the Office Test Platform & Development Tools CDs, date June 1999. Debugging does not work here - that is to say, either I haven't done something to turn it on, or it is missing from the CD. The company, ahem, does not...

A random and mysterious error 2486 "You can't carry out that action at the present time" appears, sort of freezes people's machines, and makes them angry at me. I can find no documentation on this error whatsoever anywhere. If anyone has ever seen it before, please at least reply that it...

Networked, single source program, accessed by many users, SOME people have greyed out textboxes on some reports they print out. Why? Why? Tell me while I still have some hair.

I am the sole designer of a multiuser ordertaking system for a small company. When I put it on the network, numerous surreal messages began to appear, such as the one above, Error 2486. I also get alot, for NO apparant reason, Message 0, whose description is blank! Has anyone seen these...

Yes, this seems inordinately complex. Is there some way to simply say if currentuser ?is a member of group? Admins or ...[2nd group] then cmdAdminfunction.visible = true else cmdAdminfunciton.visible = false end if Anyone have any suggestions? It would be nice if currentuser had some...

I just solved it myself. I had in the AfterUdate code to set a field TimeUpdated to Date, which triggered the AfterUpdate again and had it stuck in a loop. Panic averted.

SOME of my forms are giving me the same error. When a user makes a change, the program "may have encountered an error while trying to save a record"...Informs me that changes will be lost, and do I want to close it. Note, however, that changes are NOT lost, they are saved. What is up? The...

docmd.RunSQL is for SQL. to run a query use cmd.OpenQuery. A query is based on SQL and you can see that SQL if you go to design window of the query and click on view SQL. You can even then copy that over to your code window, and Dim strSQLStuff as String strSQLStuff = "[Copied stuff]"...

How to log in from an outside application (such as Java) to enter a Jet Secured database? It tells us we don't have permission, even though we are (trying) to provide it with userID and password. Any idea how to do this? In desperation, I just exported the tables to a new unsecured database...

I want to set the Visible property on some buttons to False based on the CurrentUser()'s Group membership. Is there some way to determine this? Users cant get to the admin functions, etc. On Load, I could check by currentuser's name, but they will change. How to code it based on group...

Yes, I guess I need more details. You must run some sort of loop - put the tblBatchNum up by 1, set ID = tblBatchNum, back to loop? Do you have an example code handy? It would be much appreciated.

I need to add ID numbers (not autonumber) to a group of records, DMax() + 1. This works fine using a query when there is only one at a time, but records are appended in bunches and I need to make an easy function to add a non-unique identifier on. The user just wants to click a button to add...

Try editing the field's AfterUpdate property, adding code. The code would look something like Me![Field I want to update] = DLookup(field,domain,criteria) The criteria will look something like "[Field] = " & Me![Field2] If you need more clarification, ask! The Help menu can help you with...

Rather than =DLookUp("[EMPLOYEE NAME]","[tbl_sbcuid]","sbcuid") try =DLookUp("[EMPLOYEE NAME]","[tbl_sbcuid]","[Employee ID] = " & [sbcuid]) I am guessing that the last is an ID code, so instead of [Employee ID] use whatever field works there.

Similarly, you could try DLookup("[Foreman]", "LabourNormalRate", "[CompanyName] = """ & ContractorName(X)) & """" as i would assume ContracterName is a text field, it needs quotes around it. The double quotes is treated as a literal single quote, rather than a funcitonal quote (which ends the...

When I try to use the 2000 Security Wizard, I get the cryptic message: "Object variable or With block variable not set" and I can't proceed any further. I am not using any class modules in the database - why does this come up? I also get error messages in some other wizards, such as "Only...

I solved it myself! OldValue can only be connected with the name of the control, not the name of the variable! (the two were slightly different in this case to allow a shortened version to appear on the datasheet view of the form) I am a happy man. Thanks again for your replies.

No, they are bounded. I think it is a problem with the way the Access 2000 is installed. I am going to have to uninstall it and reinstall it and try it all over again. I also have 97 up and runnable, and there may be some conflict over libraries available or something. -Thanks for your replies!

No, that doesn't do it. I've tried it with Me!, alone, no change. The strange thing is, when I type a period after the field name, it should give me a long list of things to choose from, (such as OldValue) but all it gives is Value. This is my first project after installing 2000 and perhaps...

How to add a method? Its there in the library, the library is activated, VB recognized OldValue (it capitalizes it correctly when I type "oldvalue". But when I run it, it gives me error 438 - "Object doesn't support this property or method." the code looks like this: Private Sub...