Search results

Can you outline the table structure, cut&paste query which is used for the form. Describe or give a screen shot of the form?

Works GREAT! Thanks! Better response/no screen flicker vs. the requery I was using before. Attached is a word doc with screen shot. Sorry not a jpg, the image editing software I have installed clips the jpg and it is taking too long to figure out vs. paste in word. Notes on pic: Barney Rubble...

Check out these: [URL=http://www.rogersaccesslibrary.com/download2k.asp?SampleName='Pictures2k.mdb'[/URL] [URL=http://www.rogersaccesslibrary.com/download2k.asp?SampleName='Snapshot2k.mdb'[/URL]

No problem... Watch for spaces in field names. If it is Prem*SPACE*State then make sure the default property = [Prem Name] and not [Prem_Name] When you are in table design view what is the name of the field? With underscore or with space?

need some brackets. Also- If the ID is numeric, no need for the single quotes around the InstructorID. Try: DoCmd.OpenForm "Enter930", , , "[InstructorID] = '" & Me![InstructorID] & "'"

Sorry didn't see the db attached. Can you upload it again.

How bout this: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55438&highlight=OpenForm

Sounds like you have an unbound object (image) on a continuous form. So when you added it to the form it will be the same for every detail record. Try setting the control source equal to the text of image you want to display. This way as the text changes the control source will change for that...

Why not set the default property of the field and remove all the code? ex: [Contact_State] Default Value= [Prem_State]

I am getting a "delay" in calculating a sum because the dsum is performing the requery before the new data is stored in the database. Is there a way to get the requery to run AFTER the data is written to the DB? Should I throw in another requery on the form, not just the field level...

I was a bit worried on those color combos :confused: But it does look sharp. Nice Mile-o-phile! I agree with keep it simple. And not use too many different controls or cluster like controls - otherwise you drive the user crazy with jumping back & forth between the keyboard and mouse.

I don't agree about natural. I took over an access DB which clearly did not align fields in a natural thought process. In other words...related fields were not next to each other or underneath one another. The developer probably plopped them on the screen because they were defined in the DB that...

Pat- In an Access97 database converted to 2000, a button allowed the user to toggle between edit mode and R/O mode -- the code behind the button loops through each control on a form and sets the AllowEdits/Deletions/Additions to false. :o If I wish to duplicate this feature I'll follow your...

Perfect for me! My users were just asking for this yesterday!! You must be psychic!

BEAUTIFUL! That is perfect. You must be wearing your superhero outfit today Pat ;) Some reason I always thought the switchboard was doing some other tricks and didn't want to dive deep into code. But I can handle your suggestion. Thanks! You should write a book PAT! -norm.

Thanks for the tips Pat! GREATLY appreciated! The certificate issue will be MAJOR! What a pain in the ASS! I am tempted to first test drive it on a 6GB drive thats just sittin' around. Just to find the time.....

Did you mess with the colors or making fields transparent, etc..?

I want to have my switchboard menu open a popup selection form which then opens the data entry form. switchboard choice1 --> pop form ---> formA switchboard choice2 --> pop form ---> formB etc.. The way it could work is with open args where the openarg parameter contains the name of the form...

How 'bout top preferences on User Interface design books? or windows tricks for the UI?

Is anyone running both 2003 and 2000 on the same machine? What is the install order? I want to install MS-Office 2003 (complete), visio, ms project and access 2000 on my laptop. Also- Any preference on XP Professional vs. Windows 2000 Pro on a laptop? THANKS!!!