Search results

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.

Hello, I am using John Big Booty's code for narrowing down the content of a listbox. It works beautifully, with the exception of when I type the character "i" into the search box it gives me a Runtime 2110, cannot setfocus error. I have run through the entire alphabet in lower and upper case...

Yes, I figured out how to do it. I am using a listbox like you suggested.

I have a table that lists all of the reports I have in my database. I created a form with a datasheet subform that uses this table as its record source. What I want to do is have a checkbox beside every record that I can check off if I want to print or export the report. What is the best way...

I figured out how to fix it. I moved the back end to ANY other directory on our network, or on my local drive. If it is at R:\Database Tables, it fails, if it's at R:\Database Tables\New folder, or any other directory, it works fine. I have also moved the front end all over the place, and as...

Hey All, I have some Dsum's that calculate some metrics values and output them to a textbox on my form. The procedure that runs is behind a "refresh" command button and a select case statement that determines if I want metrics for the entire country, or just a specific province by looking at...

That criteria should work just fine. Is there supposed to be a space after gppstart? =[forms]![main]![gppstart ]

I actually just noticed that for a numerical value, it needs to be like this: TotalSMECount = Nz(DSum("WorkingDays", "qryTotalUsageForDashboardNew", "[CategoryID] = 1 " And "[State/Province]= " & Me.cboProvinceFilter.Column(2))) + Nz(DSum("UsageDays", "qryEquipmentDaysRapidProtoCumulative"...

Hello, I have a dsum statement with multiple criteria that I cant get to work. Basically it returns no records, when it should return records that have a CategoryID = 1 and a State/Province = 14. TotalSMECount = Nz(DSum("WorkingDays", "qryTotalUsageForDashboardNew", "CategoryID = 1" And...

Change this: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_TruRewards Web Registration", "R:\DEPT-BR\CONSUMER LENDING\VISA\Cardholder Activity\Web Registration_TruRewards.xls", True, "Web Registration!F8:R50000" to this DoCmd.TransferSpreadsheet acImport...

Well...It appears that I never fully understood linking ID fields. In my mind I was thinking it was only used for subforms that are for data entry (Think adding items to an invoice). This is going to save me a ton of headaches in the future! Thanks for putting up with my silly questions!

Yes, I understand that. This subform is not for data entry. The main form will show the details of a project, where the subform will show what other projects that the company is involved with.

I have a sub form that shows me a companies history. This subform is used on 2 different Parent forms. The record source for the sub form uses a criteria that looks at a companyID field on the parent to determine which records to return. My question is how do I have the query criteria depend...

Try: If Me.Gender.value = "Male" Then me.Reference.value = "Male" Me.ID = "ea13-02c" elseIf me.Gender.value = "Female" Then me.Reference.value = "Female" Me.ID = "ea13-01c" End If

I was thinking that would work for me...thanks!

I am trying to do something similar. I have 2 queries that have 2 fields, companyID and CompanyName. I want to combine the 2 to give me a resulting list with no duplicates. Sorry to hijack, I am just wanting to jump in on the answer here!

No Worries, I haven't posted much SQL on the forum so I wasn't sure how people like to see it. I am using US dates. This SQL was generated using design view in my query, as I am not well versed in writing SQL statements. Thanks for the feedback.

Figured it out. Needed to put criteria in the "or" section of the Date Out field.