Search results for query: *

Last post is not completely accurate... It's Access 97 databases that cannot be opened in Access 2007 to current version 2016.

From your description it sounds like you have repeating groups in your table - where Category is repeated in multiple fields with a variation in the name, such as a numbered index or additional text at the end. The correct way to do this is have a child table to your primary table, adding a...

Correct - no reference needed if using Late Binding. Cheers, John.

After you setup to use Late Binding per that web link, remove the reference to Microsoft Outlook 16.0 object library - Open the VB Editor, Menu at top Tools / References. Locate the aforementioned reference and remove it. Then you should be fine. If distributing a database to others that may...

Having a situation where the number of files to be selected is unknown and can be 1,000 or so (or more? Ack!), I would ditch any File Dialog method and instead look how to use the Dir() command. Allen Browne has an excellent example of how to pull a list of files (by specific name or wildcard...

Skip's example adds a day to the value of [StartDate] no matter what day of the week it is. Use the WeekDay function with vbSunday to determine if it is Sunday and then run his code if it is.

Here is a great example: http://hitechcoach.com/index.php/downloads-mainmenu-28/document-links-2

It is very relevant and DateSerial() is recommended over the other options herein - use what you choose. Cheers.

DateSerial() automatically adjusts when the final date based on the three values which may or may not fall into the range of the parts - like Month argument could be 0 or 34, Days 0 or 388.

Late to the thread, but the easiest/most accurate way is: DateSerial(Year([date]),Month([date])-1,1). Instead of trying to put it as a control default value, I would put it in the OnCurrent Event - If the control is null then set the control to the value.

The proper way is to store the Code Description alongside the Code -- and store the PK of the selected Code in the Main Table... I understand you have constraints against how the data is stored, and it sounds like the data is not normalized. Also, it sounds like the Code is literally being...

I'll assume that your codes and code descriptions are stored in a different table, and for the code selected, the Primary Key of that record is stored in the Main Table as a Foreign Key. If correct, all you need to do is create a query joining the Main Table and the Codes Table, joined on the...

I'm with vgiesbrecht on this one! I would like to know why too. I've been in Support for a long time and never came across this as a solution for this case!

Is it .MDE? If so, it's compiled -- no can do... If an .MDB, try create a new .MDB file and with the new file open, import from the .MDB you cannot access.

The subform (a continous form) lists all of the projects in the table, one per line. In the ComboBox, which is in the subform, the purpose of the OnClick event is to move the row pointer to the selected project within the subform - like acLast/acNext, but pointing to the specific row. Making...

Visit this Tek-Tip thread: http://www.tek-tips.com/viewthread.cfm?qid=1128183&page=6 Call a function within the first-opened form that will set the global variables to the values you desire. Hope that helps.

Have a subform: Name: frmProjectSub1 Default View: Continuous Forms A combo box within the subform: Name: cboProjectName Control Source: Nothing Row Source Type: Table/Query Row Source: SELECT ProjectName FROM tblProjects WHERE tblProjects.Status LIKE "*" ORDER BY ProjectName...

AutoNumber is just that - automatically generated. Therefore, including the field name in the APPEND statement is in error.

Thank you, Remou, for not giving me the full answer! :-) In your suggested reference I found the key, and then common sense kicked in telling me the report has to be open to receive the data, so I moved the lines to the OnOpen event of the report. Works like a charm now. Thanks...

I have a subform within a form that displays filtered data based on dynamic selection criteria which is assigned to the RecordSource/OrderBy of the subform. On this form, I have a "Print Results" button -- OnClick, I would like the RecordSource/OrderBy of the subform to be copied to the Report...