Search results for query: *

I am new to Visio. I actually have a trial version for evaluation. I am interested in using it for database diagramming. There is a template in Visio for this very thing. I walked through the wizard and established a new DSN for the database, however, the database does not show up in the list...

I'm trying to use the AddAllToList function from microsoft's knowledge base article 210290. It does add 'all' to the combo box list. However, if I select 'all' from the list, the combo box does not display anything. It is just blank. If I make any other selection from this combo box, my...

I have a report that uses the count function in the footer of the report. At 1024x768, the results are displayed correctly. At 800x600, the results are displayed correctly on my machine, but not on other machines. On other machines, any total that is more than one character is displayed as...

I have a subform that has command buttons for going to the first record, previous record, next record, and last record. Each of these command buttons has a control tip. When the mouse hovers over any of these controls, the control tip flickers repeatedly--so quickly that it is a blur. If you...

I have a chart that is embedded in an MS Access report. At 1027 x 768 the entire graph is visible on the report. At 800 x 600 the page is full, but the graph cuts off before the margin, thereby not showing all of the x-axis. The SizeMode property of the chart object is set to zoom which is...

I have a form that has had several controls on it that have on change events and key up and key down events. It seems that after I put VBA code into these, the "[event procedure]" text disappears from the control's property list. Does anyone know why this would happen or how to fix it?

I have a combo box with the following as the rowsource: SELECT tblState.StateAb, tblState.StateName FROM tblState UNION SELECT "","(All States)" FROM tblState ORDER BY tblState.StateName; This rowsource takes the values that are in tblState and adds "(All States)" to the top of the list...

I have an excel workbook that is shared and when I open it and try to view the vba code, I get a message box stating that the project is locked and is not viewable. It does not list an error number. Does anyone know what could cause this and how to remedy the situation? Thanks!

Is it possible to run and MS Access module through a .bat file without creating a macro? If so what is the syntax? Thanks! Debra

I have the following code to obtain the number of records in a table and use that in the table name when it is exported to another database. It works except the record count is low by 5 records every time, even if new records are added. If the count should be 5075, it shows up as 5070. If...

I have some vba to log changes made to an Excel workbook. The changes are logged to a '.txt' file. Here is the code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range) Const LogFileName As String = "C:\MyFiles\Tracker.txt" Dim FileNum As Integer...