Search results

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 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 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 =...

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...

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...

Hi, Here's the issue. The Form Caption is changed programatically when the form is first opened. Using the OpenArgs the caption is passed Me.Captions = strFormCaption. This is always worked until recently. Now whenever I create a new form it doesn't work. All I see this the app name. Is...

Hi all, I have a main form sub form. However I do not populate the subform until the main form is open. i.e. in the Form Load (of the Main Form) I set 'RecordSource' of the subform. I would like to open the form and have the subform go to a specific record. I have tried: Dim rs As Object...

Hi, I have a local and remote table. What I'm trying to accomplish is deleting anything from the local table that doesn't exist in the remote table. Of course the easy way is to delete the entire local table and re-insert. But I have data attached in other tables that I need to leave intact...

I have a traditional Main-Form sub-Form. On the Main-Form I have enabled the mouse wheel for scrolling and of course there's the traditional navigation buttons as well as a combobox. All normal ways of moving between records. However, this time if any data has changed (deleted, added...

We are slowly switching from office 2003 to 2007. Our db applications are still 2003, but I am using 2007 for continue to modify them. We use passwords on all of our databases (mde). This open though another mde (not password protected) that calls the correct database witht the corosponding...

Hi, I have this query that sort of works. If vw_Type is a linked table to MSSQL it works fine. If it is an MSSQL View I get an error saying the query must be updatable. vw_Type should be a view not a table for various resons. I would like to change this query UPDATE vw_Type RIGHT...

I have a main form with two sub forms. Main Form - Single Form Subform 1 - Datasheet Subform 2 - Datasheet I have the Main Form parent to Subform 1 child. Subform 2 is also on the Main Form. Can I, and how, make subform 2 a child of subform 1? I appreciate your help, Thanks, Ken

I have a table with the following fields: Employee_ID; Job_ID; Emp_Task_ID; Weekday_1; Weekday_2; Weekday_3; Weekday_4; Weekday_5; Weekday_6; Weekday_7 Each row basically records which Employee on which job preformed what task on which days (via hours). But!!! Let's say that I would like to...

I thought you could not run more than one instance of and Access db at a time. However, just a few minutes ago I opened two different dbs multiple times. The only difference with these two dbs are that they are Access 2000, and yes I still have a couple of them lying around, upgrading isn't a...

I just posted this in the Excel forum, But if any VB person can help I would really, really appreciate it. Thank you, http://www.access-programmers.co.uk/forums/showthread.php?p=899951#post899951

I am using an Excel app that is being used in Office 2005 and 2007. It works fine in Office 05 but 09 it crashed with I found this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319832 which I thought would solve my problem but... I guess I don't understand the problem enough. Can...

I do not mean to ask a foolish question. However are there any clear reasons to use VB over Access? I am using MSSQL Server as our backend and tend to have A LOT of views, tables and sometimes even stored procedures. However I also tend to have local tables and queries for speed. I...

Is there a way to control Conditional Formating in code? I have a Form (DataSheet), when a check box is unchecked two other fields have a yellow background. Works fine. However I would like to delete, turn off, not use Conditional Formating sometimes. I have gotten disable to work but it...

I have several sub-forms on a main form. I can combine a few but there will still be at a minimum two. If I edit the records on any of the sub-forms no problem. When I navigate to another sub-form no problem. When I edit date on a different sub-form I get a message saying that someone else...