Search results

Thanks Adrianna. That is exactly what I was looking for. I made one change. I added a yes/no field to the forms table and the forms group table. Using these "Flags", I am able to avoid the scratchpad table. I have found it helpfull to have one or two "Flags" in all my tables. Thanks again...

(Been a while since I had a question.) I have a table that stores a list of paper forms. the fields are ID#, display name, doccument name, and a code to determine if its a Word or Excel doccument, or an access report. Works fine; the user can click a form name (on the Forms/Reports tab on the...

Thanks for the tip and the education RuralGuy. There is no ambiguity issue and viewing the code in my computer, I found no missing references. It will be tomorrow before I can look at it in the lap top.

This application uses ADODB. At the risk of appearing even more confused, I do not know what disambiguate means. It sounds like I need to know though. Any idea what reference I could be missing? Thanks.

I have a database (split) I developed using Access 2000 (Office Professional). I installed it in a lap top that has Office Prosessional 2002 and am encountering several problems: 1) The shift-key bypass does not work; 2) My application uses an access wizzard switchboard. With the lap top, when...

What next? Well Modest, I have removed Office and renamed those files and reinstalled Office. I still have the same problem. Thanks for your continued support and concern. I am open to any other ideas.

Thanks Modest - I delted the key. Help is still the same. I really do appreciate your help and patience.

Tried it. Hi Modest. I tried it. No change that I can see. The index function will search and find results. If i click on any access topic in the results, I get nothing.

Yes Modest, I have several references checked. This is a relatively old application I am modifying. IE DAO

Wayne, the index appears to work - in that it will appear to perform a search. Clicking on the search result yeilds nothing. Modest, how can I check to see if it is enabled and if not, how do i enable it? Told you folks this was a dumb one.

I am trying to use Help while in the VB editor.

Version etc I am using Access2000 (Office Professional2000); Windows XP, visual basic is 6.0 I have tried reinstalling, adnauseum

This has to be a dumb question. My visual basic help seems to be gone. I get the help dialog box but if I look for a specific topic, I get nothing. Example: I can enter "Openrecordset" in the search index window. It appears to search for the method, etc - but, if i click on it there is...

Form Properties red, open your form in design view and look at the form's properties. You can turn record selectors, scroll bars, etc on/off from the properties page.

mkelly, check the attached sample1a. I threw out the function and created a subquery (summary type). In the format event for employee name, I set text97 to a dlookup result from the subquery. If the looked up value needs additional formating or calculations, set a variable equal to the lookup...

Your database didn't attach.

What is "dup -1 <= 0" supposed to accomplish? If its just a typo, try this. I don't see any reference to something named "dup". Function dup1() If ([Report_Operator production report]![Work Type] = "Dup-1") Then dup1 = Int(Sum([job completed time] - [job start time] - CDate("0:0:" &...

I looked at your db. The 3 cbos on your form were not bound to their respective fields. They are now (see attached). Observations/hints: I would not use spaces, special characters, or punctuation in the name of any object (tables, forms, queries, controls, etc). I would suggest you add an ID...

Here ya are A couple of notes. I have modified the (*) new record button to lock the form in a continuous data entry mode. This is not a change in the form properties, I just force .NewRecord. I attached, BillsUtils module which includes utilities to: correct the punctuation of an address...

Dave, I have your form. Its a modified "Smart Form". I will isolate the table and form into a new DB and attach it to another reply. Hold On.