Search results

Where is it positioned, and where do you want it positioned? Can you upload an image of your screen?

The InsideHeight setting is in twips. There are 1440 twips per inch.

1440 * 4 = 4 inches.

You can use an SQL statement to insert a record in a table. Here is a VBA example for use in an event procedure, function or subroutine: currentdb().execute "Insert into MyTable (MyNumericField1, MyTextField2) Values (23, 'ABC');", dbseechanges + dbfailonerror

I think I will have to be a little more clear: Make sure AutoResize is set to no, then open the form in design mode, size the form WINDOW, and save the form. If this doesn't work use VBA to set the form InsideHeight property (you can't do this from the property sheet, it isn't available there)...

Set form AutoResize property to no. Open the form in design mode, size it, and SAVE it. When you open the form, you should see it opens at the desired size. Another thing you can do is manipulate the form.InsideHeight property at runtime.

Here's a good place to start: Fundamentals of Relational Database Design: http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

If tempvars.userID is a text string, try If DLookup("GroupID", "tblUser", "UserID = '" & TempVars.UserID & "'") = 1 Then (note the extra single quotes surrounding the tempvar variable)

... If DCount("*", "Select * from _Check2 Where MyField = " & chk1!OID) > 1 then ... ... is one possible way to do it.

Try putting the following code in your listbox AfterUpdate event procedure (replace the two lines that are there): Dim rsClone As dao.Recordset Set rsClone = Me.RecordsetClone rsClone.FindFirst "[ID] = " & Me.Lista5 If rsClone.NoMatch Then If Me.DataEntry Then...

There are third-party form scaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm There's a form resizer at http://www.jamiessoftware.tk/ . The Access...

There are third-party form scaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm There's a form resizer at http://www.jamiessoftware.tk/ . The Access...

You can put a Docmd.Restore in your form OnOpen or OnActivate event procedure. Hope this helps,

There are many alternatives to using Access Security when it comes to securing your database. A shareware version of a simplified user security add-in - LASsie (Light Application Security) for MS Access - is available for download here: http://www.peterssoftware.com/las.htm Also, there's the...

It sounds like you might need another field in your table for the weekly price.

Here's an example that may help with listbox sorting: http://www.peterssoftware.com/sl.htm Hope this helps,

Click Tools > Autocorrect Options and remove the line that has "(c)" in it. Hope this helps,

Try using the Internet Data Transfer Library download at http://www.mvps.org/access/resources/downloads.htm Hope this helps,

This sounds like a job for the ControlTipText property. I'm not sure I have all the details of your form down, but you can write some code to update each control's ControlTipText with the pertinent data for that control. Also, if I recall correctly what this tool does, it might help...

One way to do this is to allow users to drag and drop items between listboxes. We have a product to facilitate this: Drag-N-Dropper http://www.peterssoftware.com/dd.htm Another way is to have "Add", "Remove" buttons that simply use an SQL Update statement to modify the ProductID for the...