Search results

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.

Hi All, I am trying to figure out how to build my query that returns equipment reservations where "date out" OR "date In" are between 2 dates that are specified on my form using [Forms]![Myformname]![StartDate] and [Forms]![Myformname]![EndDate]. The purpose of the query is to find the amount...

Perfect, thanks for answering my stupid question!

I am just wondering if there is an advantage to using a currency field type in a table, vs. just using a number field? This is assuming that I am not working directly in the tables themselves and am using forms to display the data. Thanks