Search results

Can you simply build an identical form with a new unique name and avoid having to import everything? I noticed the error pops up after ten or so double click events performing the DoCmd.openform. Is there any issue with memory leak, where I have to perform a check: if form already open, then...

Can you disable the "SHIFT" at startup or other technique to keep users from ever getting out of the main menu?

I have run compact & repair in an attempt to fix a problem with a form freezing. I can't get into design view OR close the form. And then I get a runtime error 2486. frmSelect contains txtBox where you enter a portion of the student name, then listbox is populated with all the students. On...

I have a form with the following: student name, college id (what colleges the student previously attended) the subform contains the courses attended at the particular college. Each course is marked as 3 credits for english, or 3 credits for history, etc... In the footer section I total all...

Thanks. Good solution with minimal coding. This works perfect. -Stormin'

Set the input mask to: set input mask 000\-000\-000a or 000\-000\-000a;0;_ first one does not store dashes in the databse the ;0 property ensures you store the dashes in the database do a search on input mask in help.

Any best practice on populating a listbox based on which textbox is populated i.e. textboxes: customer name customer id listbox: w/ customer id, name, address Recordsource=qryCustomer qryCustomer where customername like txt customer name] & * or customerid=txtcustomerid When the...

This works great! Thanks for the tip. I'm now hunting through the OpenForm options. The key was the fourth parameter of the openform method: DoCmd.OpenForm "frmCustomer", , ,"[CustID] = " & Me.ListBoxName Quick add on question---> Is there a good way to use this more generic? Let's say you...

Link with query? Graham- Your example hits home for me! I'm trying to link to a query, not a table. How would the linkcriteria look for a query? in your example: stLinkCriteria = "[BookID]=" & Me![lstSearchList] DoCmd.OpenForm stDocName, , , stLinkCriteria I would think it is more...

I am building an application where one form (form1) will drive the data in the next form (form2). i.e. Have a form which looks up the customer, then pull up a detailed form based on the results of form1. Probably going to make it a popup. I have reviewed postings, and read a few books. I...

I have a simple form with text box and list box called frmCustSelect. User enters last name in text box, and the list box is populated with matching user records (using like [Forms]...&"*" in lookup query to get all jon* records when user keys in 'jon') This works great. Now user scrolls...

If you have access97, can you run the wizard and upload the mdb. Sorry, I don't want to load access97 on my pc. I have 2000 running now. OR- If anyone has an existing access2000 registrar mdb. thanks.

Curious if anyone knew of a url or sample student registrar system for a college. I remember seeing it somewhere-- was it access97? Thanks stormin' norm.

form/subform error: can't build a link between unbound forms Greetings! I have read using access 2000, the o'reilly access cookbook, and numerous online tutorials to figure out why I get an error when attempting to link a subform to a form. Funny thing: I opened the chapter1 example database...