Recent content by sfreeman

If you have a backup, just import the form from your backup db. Sam_F "90% of the problem is asking the right question.

You could place a master FE on the LAN, and create a batch file that would copy the FE to each user's work station. Sam_F "90% of the problem is asking the right question.

Check it out: http://databasejournal.com/features/msaccess/article.php/10895_3101941_4 Sam_F "90% of the problem is asking the right question.

I think you are focused in the wrong area. Instead of trying to make your query do the grouping, do it in your report. A simple query such as: SELECT APUnits.ID , APUnits.Unit FROM APUnits; works OK. Use the report wizard and be sure to group by the ID field. Your units would normally...

Might help with one of your questions... You can diplay the parameter information by adding a text field and setting its Control Source to the parameter prompt. For example, if your user is prompted in the query for a city parameter 'Enter City', then set the Control Source to "=[Enter...

Put the form in design view, click on the Insert menu, then Object, then New, then select Microsoft Word. HTH Sam_F "90% of the problem is asking the right question.

You can spell check with VBA: Private Sub Command0_Click() DoCmd.RunCommand acCmdSpelling End Sub To do it like Word, you may have to insert a Word object into your form instead of a text field. Sam_F "90% of the problem is asking the right question.

Any help here? http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20805034.html Sam_F "90% of the problem is asking the right question.

You say you are seting the height and width via VBA. Did you try to manually set these properties? Then save the form? I tested this, and seemes to be no problem... not sure what the issue might be on your system. Sam_F "90% of the problem is asking the right question.

Shouldn't be a problem. Put the chart into design view, select the chart. Select the format tab of properties, and set the width and heigth [say 12" X 8"]. Click on File menu then Page Setup. Select papaer size = legal, and orientation [I presume] as landscape. Done. Sam_F "90% of the...

Cancel my last e-mail.... thanks, pretty cool :-B Sam_F "90% of the problem is asking the right question.

VB.... Should this form display only 'other' users in the db, or will it also show myself in the db? Sam_F "90% of the problem is asking the right question.

Try this: http://www.mvps.org/access/modules/mdl0055.htm Sam_F "90% of the problem is asking the right question.

Easiest way is to use the database splitter wizard. Tools, Database Utilities, Database Splitter Read up on it in the help file first. Sam_F "90% of the problem is asking the right question.

CREATE TABLE Employees ( EmpID Counter Not Null Constraint EmpID primary key , First_Name TEXT(20) , Last_Name TEXT(25) , dob DATETIME ); Sam_F "90% of the problem is asking the right question.