Search results

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

Hey Randix, rather open another Access-session and there open that database with DoCmd.OpenForm: dim oAcc2 AS Access.Application set oAcc2=createObject(,"Access.Application") oAcc2.DoCmd.OpenForm(...) This is the only way starting code in another database. Mic

This is really difficult, because when calling something like "...compact..." Access always asks for a new file name. We've solved this by calling Sendkeys ..., although cursor and mouse get locked. Yet it's still better than doing RunCommand or DoCmd. Mic

Hey wjessen, much more comfortable but a bit more work to programme is doing like this: Dim oXL as Excel.Application set oXL=createObject("Excel.Application") oXL.Worksheets.Add..... For this you only need to make a reference to Microsoft Excel in "References" (available in any code-area)...

Hey, welcome in the Access-programmers world! That's why most of us don't drive crazy or get lost at seeking thousands of pages or hours in vain: Those troubles you can't get in Access, but in that lousy VBxx.... Try help on datagrid-properties like an event called datagrid_OnClick() or...

Hey Paul, choose: 1st: Just use the sub-form wizard: It automatically connects one field in the main form to another in the sub form. 2nd: Enter valid field names in the properties of the sub form at "connect from/to" (or similar since I use a non-English version). The sub form only shows...