Recent content by Kenln

PS, what I replace wasn't actually linked tables but was linked views which appears as tables. I'm still trying to figure out how to link to a function as a table. That would be my goal.

I changed to a Pass-Through queries (actually Table Valued Functions) to replace direct Access to Tables and because I wanted to write one function that could accept variables. I actually do create queries on the fly, BTW. Essentially I was/am doing exactly what you suggested except I changed...

I have a form based on a query that used this subroutine Public Function fCboSearch(vCboSearch As Variant) If IsNull(vCboSearch) Or vCboSearch = "" Or vCboSearch = "<Select All>" Then fCboSearch = "*" Else fCboSearch = vCboSearch End If End Function When a user...

You know this probably isn't the right place but most everything I've done have been VBA and the users are so helpful I thought I'd at least start here. And besides I'm not fond of cross-posting. There is a push here to switch to PHP and Java Script. We are already using SQL as the back end...

I found the answer and oddly enough it isn't in the connection string. After I create the query and before I close the Query Definition I can set a time out 'qdfdef.ODBCTimeout = xxx' If anyone needs it.

I create Pass-Through queries dynamically. The string I use when I create them is "ODBC;Driver={Sql Server};Server=Apollo;Database=TimeCard;Trusted_Connection=Yes" I tried "ODBC;Driver={Sql Server};Server=Apollo;Database=TimeCard;Trusted_Connection=Yes;Timeout=300" but when I looked at the...

I thought Access had a limit on how many times an object could be edited. This query will be changed often. Is there a way to create a temp query as a variable (in memory) that I can point the form record source to?

I would like to create a temporary query that a form can use when it opens. Of course the reason it is temporary is that the query can change each time the form opens. I found this code in here (this forum). Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strMySQL As String Set db =...

Bob, thanks again. Took a little manipulation but it works fine.

Is there a way to programatically change the number of columns when a form is opened? I have a standard form/subform. With the subform (datasheet) I change it's record set, the order of the columns, which columns are hidden when the form is opened. I depends on the users initial request. It...

As part of the example you gave me I copied and pasted. Part of the Function is: Dim cmb As CommandBar But when I compile I get: "User-defined type not defined" Am I missing a reference?

We are upgrading our Access apps from Office 2003 to 2007, yep we're behind the curve. We tend to hide the standard menus and tool bars. This give us more control of the app and the user experience. For reports we created a menu bar that displays when has print preview a report. Now... in...

I just created a new form, Copied and pasted the controls. change the properties and record source. And same result. I'm going to stick with changing the caption after it is opened. I have no idea what's happening...

Even If I do I'm not sure how to isolate it.

For now I'm going to change after the form opens i.e. Forms.Form_Name.Caption = "blah, blah, blah". That seems to work. I was mistaken, even steping through the code as the form opens (F8) I never see the caption which should be: 1.5. - Setup - 'App Name'. Very odd, it's only on newly created...