Recent content by MHM

Hay Annie, looks like a query question: Imagine you found the right kind of function for your query taking "other times" into consideration - would that solve the problem? The function may be found in the section "DomainFunctions" (in the expression editor). So one of the field contents of...

How to change the registry-properties ExclusiveAsyncDelay FlushTransactionTimeout ImplicitCommitSync Lock Delay LockRetry MaxBufferSize MaxLocksPerFile PageTimeout RecycleLVs SharedAsyncDelay Thread UserCommitSync in a way getting a maximum of...

Hi Haytham, ..really got into loads of work! Telephone functions are available at the CAPI-drivers commonly delivered with ISDN-equipment. Try looking at a Visual Basic newsgroup! Mic

Hey ibsmith, one query in your database or a certain code asks for that function - or one of the events in a certain form is not set to nothing/EventProcedure, but instead a function name, which the system is not capable to find. Check all functions in the modules or try to start the database...

Try to learn more about creating reports in MS-Access! (or ask your question there instead of using the Modules & VBA section)

At the Form_Open event data is not yet load. Maybe you use the Form_Load event. Or type me.Filter = "ID<100" ' e.g.: <100 me.FilterOn = True

Hi rasul, change to: ... (ID Autoincrement, ... Mic

Hi Bretti, probably you haven't set .Index to the right or an existing index. Escpecially be careful about using index-names: When changing a field name, the index is refered to with the old name, its name can't be changed is Access directly. Mic

Hey Anna, you've done it all right when working like this. I hope you declared doc as Word.Application. Then you can go on: doc.Selection.GoTo What:=wdGoToBookmark, Name:="NameOfBookmark" doc.Selection.InsertAfter Text:="myText" Mic

Your check must be changed: Set dbsTimesheet = CurrentDB ' referencing the DBEngine instead of opnening a new one and then: If .NoMatch Then rstMyUsers.AddNew ' UserId = Text10 Name = MyName Surname = MySurname rstMyUsers.Update You need (!) to leave rstMyUsers!UserID without value - it will...

or write any Autoexec-macro containing "RunCode..." calling any public function (like "configuration()" )in your database Mic

hey skip, probably there is only one way: Apply for changes in the tabCrl at Microsoft's! I suppose you insert a form_Load procedure storing the original value of the tabCrl (as class-variable in the header of the form's class module). After every change (tabCtl_OnChange()) you set it to the...

I'd look into the other db with DAO: set db=Workspaces(0).OpenDatabase("FileName") on error goto tableNotFound if isnull(db.TableDefs("TableNameToSearchFor").Fields(0)) then ' empty endif MsgBox "Table does exist." Exit sub tableNotFound: MsgBox "Table doesn't exist." Exit sub Mic

Do you need to create a "stored procedure" on an MS-SQL-server? Or do you just want to pass that SQL-string to a queryDef? Normally you use SQL to do: set RecordSet=myDatabase.OpenRecordset(strSQL) Does this help?

Hey Big Jim, if you've got enough Big experience with Access - as I assume, Jim - you never let customers or all-day-users get to tables. You'll always keep them at forms or reports - so set table column widths in your forms. Mic