I have a combo box (forms!report!SearchS) with 3 choices.
0 = All (Created by a Union Query in the combo box)
1 = Open
2 = Closed
I have the IIF statement in the criteria of the query that looks at the combo box. The problem arises is the values in the database only includes 1 or 2. I want to...
I'm using the .hyperlinkaddress to call up a web page. However there seems to be a limitation to the sixe to the link for the URL. I truncates the URL. The URL I am using is quite long. I works if i just cut and paste it into the browser but the .hyperlinkadress doesn't work and only patrially...
I want to be able to directly access a data source without having to add a control like a combo box to a form. I have been sucessful in accessing tables with the following code.
Dim rst as ADODB.Recordset
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection...
I have two tables. One is Calls and one is WhatWeDid. They are linked by a CallID with primary nad foriegn keys. The structure of the tables follows.
Calls Table
CallID etc...
WhatWeDid Table
ID CallID WhatWeDidID TimeIndex
The WhatWeDid Table has a one to many relationship to the Calls...
'm using hyperlinks in a command button but the ".hyperlink.follow" extra controls do not behave as designed. I want link to go to a current open window and use the "ExtraInfo" however the link is opening an extra window. When I try to use the extra controls it give me...
I'm using hyperlinks in a command button but the ".hyperlink.follow" extra controls do not behave as designed. I want link to go to a current open window and use the "ExtraInfo" however the link is opening an extra window. When I try to use the extra controls it give me...
I have a form where I enter various data, some combo boxes, one check box and a memo field. I have a command button on this form that will change the check box to "true". However sometimes when I click the button I get a "runtime error 7878 data has changed" error. It usually...
Hello All:
I need to create an outlook task through automation in access. I have been successful in doing so with the code below HOWEVER I want to create the task in a public folder and assign the appropriate owner. I can't figure how to naigate to the following folder:
Public folders \ All...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.