Search results

THe Former

I understand you have two combo boxes on a form, a Department Combo box and then a Function Combo Box. After the Department is selected in the Department Combo you want to display only the Functions linked to the Department. You need to add code on the the Department Combo's AfterUpdate event...

I have a database with embedded images (Word Documents, Excel Workbooks, or PDF Documents). The image is displayed on a form. I can double-click on the Image on the form to open it in it's native application. However I would like to open it from a button instead. I must have taken a "dumb...

I have just downloaded SQL Server 2005 and created a database using the Management Studio Express. I wanted to link an MS Access 2000 front end with my SQL Server Database. I tried creating an ODBC connection to the database using the ODBC Data Source Administrator. However, It doesn't seem...

This is easy to do if you know how to use Visual Basic. Do you?

Pat, I tried that and it doesn't work. I believe the % wild card is used for SQL Server but not for Access. I haven't had a chance to research this further but when I do I will post a resolution. Thanks.

I would like to change the SQL (commandtext) behind an ADO Query. Here's the code I use. Set cmd = MakeCommand(gbCnnUserDB, "MTDNewSales_2_SelQry", adCmdStoredProc) mySQL = "SELECT MTDNewSales_1_SelQry.IsMobileHome, MTDNewSales_1_SelQry.ActualClosingDate, MTDNewSales_1_SelQry.AssetId " _ &...

Well Shut down my computer and call me a newbie. I'm trying to run an append query with two parameters and a like "value*" in the where clause. When I run it in ADO it returns no values. When I run it in DAO is works just fine. WHen I delete the like condition it works just fine. When I...

Try this MondayNext: date() + (2 -Weekday(Date())) +7 MondayTwoWeeks: date() + (d-Weekday(Date())) + 14 As an alternative, you might want to put the date calculation in a function. Good Luck

When entering data direcdtly into a table there is no way to automatically trigger a macro or procedure to update the date. You could display the table in a form and then create a procedure on the Form_BeforeUpdate event. Another way to accomplish this that may be easier for you is to create...

How are the values in table B set?

What does your application connect to? On what drive is it located?

I need to set an ADO table based on a variable Name as shown below Set tbl = cat.Tables(strTableName) it works fine when I use a quoted string, as shown below. Set tbl = cat.Tables("MyTableName") This is different from other collections where these two alternatives are equivalent. Is...

I have developed a database in MSA 2003. It uses a System.mdw that was originally created somewhere in the dark ages (MSA 97 or 2000). Multiple users cannot seem to access it at the same time. This has never been a problem in past projects. I have created a new System.mdw in Access 2003...

I would like to call a control's BeforeUpdate Event from a button. Here's my problem, if the BeforeUpdate event is cancelled, I would like to bypass the rest of the code on the button, if not I would like to run the rest of the code. The BeforeUpdate is not a function so it doesn't return a...

COULDN'T WAIT Top is much faster

I'm doing a project in which I need to work with very large recordsets. I need to test the value of a field in the recordset. So I'm going to use a query. So far so good, but I really want to minimize network traffic and resources, so which is better? 1. A parameter Select Query with the...

Thanks for yourPosting. I really didn't explain what I needed. I have a ListBox that I have squeezed onto a form. The width of the ListBox is too narrow to display the full line of each option so I thought it would be real cool to hover over the listbox and see the line. I would like to...

Is there any way to set the ControlTip Text for a Text Box to be the value of the Text Box using a function? If so what event would you use? Thanks for your help. :cool:

I often use loops in code. Sometimes if things get hung up, I would like to be able to abort the Loop while its in the middle of processing. Often the loop is processing so fast that it will not stop with a {ctrl}{break} and requires a {ctrl}{alt}{delete]. Obviously this is usually ugly and...