Search results

Thanks. I made all of the changes you suggested. I'm still having problems, but I've narrowed it down to the following two sections (specific lines in red): With wks.Range("A1").Resize(1, iNumCols) .Font.Bold = True .EntireColumn.AutoFit End With And With wks .Cells.EntireColumn.AutoFit...

I don't have any more records than previously. It's just as slow if my list has 12 records or 12,000 (and anywhere from 2 to 20 fields).

Hi, I have an Access 2010 database which has very suddenly become very slow when either exporting to excel or outputting reports. The two common places where this happens are below (this code hasn't been changed any time recently). Any thoughts would be much appreciated! Example 1 - Printing...

So, sometimes it helps just to write out the problem. While I still have no idea why the above problem was happening, and wouldn't mind knowing the answer in case it comes up again, I rethought the setup and have avoided the problem entirely by creating a subreport for the body of the letter...

I have a report which is basically a form letter. The text of the letter is in a memo field, which is set to "can grow". This works fine - on all pages except the first page. On the first page of the report the text displayed in the memo field is limited by the actual height of the text box...

In case anyone else comes across the same problem, here's the solution I just discovered (I have a vague understanding of why this works, but it does). My original syntax was: qdfLastName.SQL = "usp_Lkp_LastName " & Me!cbo_LastName.Text Which worked fine until the last name had a space or a...

When I don't use ".Text" in my IF statement, the combo box doesn't fill at all (no matter how many characters the user types in). The data format (which originates in a SQL Server table) is Varchar(50).

Thanks for the quick response. I had initially read that ".Text" was a potential issue, but when I try my If statement using either Len(Me!cbo_Lastname) > 2 or Len(Me!cbo_Lastname.Value) > 2 my IF statement stops working!

Hi All, I have an unbound combo box on a form called cbo_LastName. Because the row source for this combo box contains almost 100,000 distinct values, I have set it up to only load the row source after the first three characters has been entered. So when the user starts typing, the combo box...

Thank you - I'll give this a try! What I seem to have figured out re: binding a form to a stored procedure is that I can set the recordsource of the form to a pass-through query which executes the stored procedure. Does anyone know if there is a reason not to use this method?

I am using SQL Server as a back end to Access for the first time, and I am having difficulty understanding how the two work together. Using Access VBA, I am able to open a connection to SQL Server, and I am able to execute a basic stored procedure (which accepts no parameters, just creates a...

Figured it out! Just in case someone else stumbles across this and needs the answer... I was just missing:

Thanks for the tip! I feel like I'm heading in the right direction, but there's something wrong - maybe you can help identify where I've gone wrong? Private Sub cbo_Start_AfterUpdate() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection 'set the active connection Dim rstStart...

I have two comboboxes on a form (cbo_Start and cbo_End). The record source of both is currently set to the same query: qry_StartEnd. qry_StartEnd contains the following fields: StartEnd_Name (Text, example - "08/2010") StartEnd_Start (Date, example - "08/01/2010") StartEnd_End (Date, example...

Hi All, I have a procedure which allows the user to export a filtered recordset from an Access subform to Excel (using the CopyFromRecordset method). I am in the process of making sure the resulting excel worksheet is formatted appropriately. I would like to add borders to the exported...

You're right, it only looked like it was working:) I haven't used Dlookup, so I'm not entirely clear how to use it, but I appreciate the point in the right direction - thank you!

Thanks to everyone for their help! Finally got it to work with the following: Dim myImportMonth As String Dim myExistingMonth As String myImportMonth = "[tbl_ImportMonths].[ImportMonth]" myExistingMonth = "Month([tbl_Time].[Time_Date])" If myImportMonth = myExistingMonth Then MsgBox...

They don't appear on my form. My form simply contains one button. The user is asked to select a file to import (from a file dialog) and then the file is imported and appended to various tables. I'm trying to figure out a way to notify the user that they have already imported the month they...

Thanks. The code I have above actually works, I was just using it as an example of what I'm trying to do. It's the following code (first line) that I'm having trouble with (sorry, can't figure out how to post this as code) : If [tbl_ImportedMonths].[ImportMonth] =...

Thanks, that helps with the If Then error message I was getting. But now I get: Run-time error '2465': Microsoft Access can't field the field '|1' referred to in your expression. I definitely think my issue is with the syntax in the first line.