Search results

Not much information in that question.... Are you talking about Forms Design? If so, maybe you are refering to the "Arrange" tab in the Ribbon which has "Control Alignment", "Size", and "Position" menu groups. I guess you are talking about the Decrease/Increase Vertical/Horizontal spacing...

Adding "All" to a ListBox or ComboBox

Look into using the DMax() function to get the highest assigned value so far in your subform recordset (can be a query that hits the same table with criteria on your PK/FK fields), and then add 1 to the value returned.

Still don't completely understand, but by chance is this form like a Search form to then return matching records? If so, Query By Form is a good method to use. Here are some examples: Search criteria (QBF) Sample Search Form (QBF) Adding a (Dynamic) Search form to a database (QBF) SearchBox...

Pardon the intrusion, but I think one of these links will help you understand how to synchronize related Combo Boxes when one is changed: Cascading Combo Boxes Database (Ac2000) Cascading Combo Boxes Using 2 Tables (Ac2000) Create Cascading Combo Box Sets (Ac2000)

May I assume your structure is similar to: tblCompanies ------------------- CompanyID, AN PK CompanName, Text ... tblCompanyContacts ---------------------- CompanyContactID, AN PK CompanyID, Number FK ContactName, Text If not like the above, there lies your main issue. If done like the...

Agree with Missinglinq. Acces does have a command just for hourglass: DoCmd.Hourglass True DoCmd.RunCommand acCmdSaveRecord FollowHyperlink Me.txtWebsite DoCmd.Hourglass False If behavior is still like your initial post, put a line with DoEvents before the RunCommand.

Not certain what you are asking.... but: In a Combo Box, you set the RowSource Type to Table/Query, then in RowSource you put your SQL statement, set Columns to count of fields returned, set Column Widths for columns you want to show/hide (set to 0 to hide), and then set Bound Column to the one...

Maybe this will help: Referring to a Field in the Previous or Next Record

This will work nicely: Function fCardinalDate(Optional dtmDate As Date = 0) As String ' Immediate Window Test: fCardinalDate(Date) returns - December 13th, 2008 Dim strTemp As String 'Setting to 0 sets Date to the beginning - 12/30/1899 00:00:00 If dtmDate = #12:00:00 AM#...

It can be problematic when changing objects names. It cannot be assumed that if you change a table name, all references to that table name will be modified as well. An excellent tool for this is: Find and Replace (a development tool) for Microsoft Access

Does your data as the Row Headers contain periods? If so, Access will convert them to underscores in the resulting field headers.

If it is an Action Query (not SELECT), then you can use that method. But, if you don't want the screen-flashing: Running A Stored Action Query

CyberLynx, Many thanks for posting that code for the Font ListBox! I had scoured forever trying to find something like it for Access VBA! Am curious why the Wingding fonts (and a handful of others) do not show up. There are 292 font files in my Fonts folder, and the .ListCount = 271. My...

I have a not-completely-debugged routine to subtract lunches and breaks based on an 8-hour work day. I would post it, but not sure it would work with your requirements. Comments/Questions: 1. Employee Time is calculated based on punch-in and punch-out times. 2. That can be based on minutes or...

This may help also: Relationship Report with extended field information. And: Access 2007: While viewing the Relationships Diagram, click "Relationship Report" in the ribbon. Access 2003: While viewing the Relationships Diagram, click "File" - "Print Relationships" in the toolbar.

You would create an ADE file. This might help: About securing an Access project (ADP)

It's still on the Format Tab, but about half-way down with the same options. If it is set to "Neither", change it to Vertical Only or Both. Let us know what you find.

Hi adzi, It sounds possible that your database design is not "Normalized". Searching the web for "Microsoft Access Database Normalization" will get many good hits. In tblProduct, you should have a Primary Key (AutoNumber) named something like [ProductID]. This is not the Product Number, but...

How about investigating Volume Licensing with Microsoft for the version of Office you need (Professional)?