Search results

No text whatsoever in the spreadsheet besides the entries I want. Removing the range caused it to import nothing but the field names.

The actual data starts at A2. No Hidden rows. Its just a really basic spreadsheet with a list of information. No formulas. Thought you might like that column name...lol

Ok, I lied. The data is in the newly created table....its just that the data in the table starts at row 1954 and ends at row 1999, previous to that, it is all blank. This is partially correct because the spreadsheet does only have 46 records currently in it. Any reason why the database is...

I am running this code to import an Excel sheet into a table in my database. This works fine if I set [HasFieldNames] to false. When [HasFieldNames] is set to true, I get the correct field names in the table, but don't get any data from the sheet. Has anyone heard of anything like this...

Do you have filter criteria in the underlying query? Do you have an incorrect join in your underlying query? Do you have the same data in the new record as you do in past records that are showing?

Oh for %^&$ sakes. I needed to refer to the reports name property, rather than the actual objects name. Thanks for getting me pointed in the right direction Uncle Giz!

Its interesting...if I type this: MsgBox " >>> " & Me.RptCompany_Projects_Brief.Name I get a popup saying ">>>Rptcompany_Projects_brief If I type this: MsgBox " >>> " & Me.RptCompany_Payback.Name I get a method or data member not found!?

I get a box popping up saying ">>> frmCompanyHIstory"

Hey ALl, I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company. For some strange reason, 2 of my reports requery with no problem...

Paul for the win! Totally overlooked the textbox name itself...normally I use the txtTextboxName convention, but this was a subreport so I overlooked it. Thanks for the help everyone.

I am trying to use this expression in my textbox to show when the textbox value is null: =IIf(IsNull([ContractStatus]),"Null",[ContractStatus]) It gives me a circular reference error (#error in the textbox). If I change it to this: =IIf(IsNull([ContractStatus]),"Null","ContractStatus"), it...

So I've gotten to this point and get a runtime erorr 13, data type mismatch. Dim sqlQry As String Dim Srchtext As String Srchtext = Nz(Me.Srchtext.Value) sqlQry = "SELECT tblPrograms_Reports.ProgramsReportID, tblPrograms_Reports.AssociatedProgram...

Come to think of it.... if I add the following code to the where clause of my listbox filter, the search box may still work. Select Case Me.OptionReportFilter Case 1 sqlQry = sqlQry & " WHERE AcceptedProjects = True" Case 2 sqlQry = sqlQry & "...

Im sure I am not posting this string in the correct format, but please forgive me because I can never remember the best way to do this. Thanks for taking a look. SELECT TblPrograms_Reports.ProgramsReportID, tblPrograms_Reports.AssociatedProgram, tblPrograms_Reports.Description...

I have no idea how to title this problem, and I hope I do a better job explaining it. I have a form containing a listbox based on a query that shows a list of reports that are in the database. Included on this form is a search textbox that filters the results in the listbox as you type. My...

Did you see a name come up in the immediate window? FYI: http://office.microsoft.com/en-ca/access-help/HV080205290.aspx

After this code: DoCmd.OpenReport "Report", acViewReport, "[First Name]= '" & Me.FName & "'" Add this: debug.print me.fname the first name of the person selected should appear in the immediate window. If it doesn't, there is a different problem.

Lets try something else: DoCmd.OpenReport "Report", acViewReport, "[First Name]= " & Me.FName

Try this: DoCmd.OpenReport "Report", acViewReport, "[First Name]='" & Me.FName.column(0) & "'" Change the column number if the data you want to use as criteria is not the primary key.

Looks like the problem was that Access was trying to autocorrect "i" to "I", which was giving an error on the Me.SearchResults.SetFocus line. I removed that autocorrect entry in Access options and the problem went away.