Search results

Try right-clicking on the empty space just outside of your form detail section, then click "properties". This should give you the form properties. If you want to add new fields to your form, you probably want to open the field list (View > Field List), then drag and drop the fields onto your...

Here are some links that might help: http://www.mvps.org/access/api/api0001.htm http://www.mvps.org/access/api/api0002.htm Regards,

Some users might not appreciate your application changing their screen resolution settings. There are third-party form rescaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...

The TransferText method is for importing and exporting text files. You might want to use TransferSpreadsheet instead. See Access help under TransferSpreadsheet for more information. Hope this helps,

Yes, it is possible, but some modifications to modules are required. A free example of how to do it is available here: A Better Switchboard http://www.peterssoftware.com/abs.htm Hope this helps,

dim dbs as database This requires either a reference to DAO or ADO. Check Tools > References from any module in design mode to see your references. To specifically declare a varaible as either an DAO database, or an ADO database, do this: dim dbs as DAO.database dim dbs as ADODB.database...

Yes, it's possible. One way to do this is to update the underlying recordsource sql for the continuous form - change the ORDER BY clause to include the field you want to sort on. Then requery the continuous form. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for...

Here are some links that might help: Who's logged in: http://www.mvps.org/access/general/gen0034.htm LDB Viewer: http://www.mvps.org/access/modules/mdl0055.htm Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

Colored Button Examples - http://www.peterssoftware.com/clrbtn.htm Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

1. In the AfterUpdate event of the check box, you need to examine the checkbox value and set the enabled property of your control accordingly. This should also occur in your form OnCurrent event procedure. 2. Use the code described above in your form OnCurrent event procedure. 3. 0. It's...

A source string is required in the OpenRecordset method. Try this: Set rst = qdf.OpenRecordset("qryCreateForm") Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

Try setting autoresize = yes, autocenter = yes, then put a Docmd.Restore in your form OnActivate event procedure. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

YES! Don't code without it. Option Explicit makes sure that any variable that you use must be defined (ex.: with a "dim" statement). If you don't explicitly declare your variables, you may mis-type the name of one somewhere in your code, it will compile just fine, but you will get unexpected...

Try this from your command button event procedure: DoCmd.OpenForm "MyMemoForm",,,"MyMemoFormID = " & me!MyStudentID Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

Here it is: http://www.peterssoftware.com/c_scrres.htm Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

>Several forms later, I need the users name >again. I assigned it to a string >called "username" but once I close that >first form it seems to lose it? Create a new module. Put the variable definition in the module declarations section: Ex.: Dim gstrUserName as string Use this module...

Try this: dim sngPct as single sngPct = Dsum("fldPct","MyFormRecordSourcName","<criteria, if needed>") Hope this gets you started Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

If Field1 is 0, you'll get an overflow. You may need special coding to account for this situation. Ex.: IIF(Field1=0,<do this>,<else do this> ) Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

Well, you'll need another field to keep track of your record order, and as a record is re-ordered, that field has to change to a value that is between the record above and below it. It's tricky. We've developed a tool that handles this problem and allows listbox re-sorting via drag and drop...

Are the top and left values too small for you to detect? There is not much difference between a top value of 1, and a top value of 6. You may want to try some larger values to see if the code is indeed working. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers...