Search results

I've hit a road block in doing it the way that the document says. I've written the following code: Option Compare Database Public StartDate As Date Public EndDate As Date Public Function SearchStartDate() As Date SearchStartDate = StartDate End Function Public Function SearchEndDate() As...

I hate to tag onto your original post but I followed the video that you referenced earlier and I seem to be stuck. I've setup my text boxes so that they default to null values and written the following statement for my Run Query Button: Private Sub btnRunQuery_Click() DoCmd.OpenQuery...

Okay.. So I figured out my own problem. :) For those who are interested my problem was because the columns were lookup columns. So, I was typing "pending" which is what is displayed, but the actual value is "1".

Actually, I've officalled decided that my problem is not related to item #1 on my list above. I've removed the calculated fields and I am still recieving the error.

Hello, I'm trying to write a query that does a few things. They are: 1. Holds two calculated fields. One calculates the 15th day from the effective date and the other calculates the 21st day after the effective date. 2. Displays records that fill in the following criteria: A. LifeForm =...

Ahh I see! Thank you everyone. :)

Oh interesting. So i take it I could modify: =DateAdd("d", 15, [EffectiveDate]) to say =DateAdd("y", 15, [EffectiveDate]) to update the year? or "m" to update the month? Does anyone have a good site for these functions? I'd love to find a place to read about them all.

Hehe! :) What is the difference between DateSerial and DateAdd?

Oh, it seemed to work when I removed the table information. :) Thanks!

Oh, I have a Hire form and this is on a sub form (BenefitHires)

Hello, I’m not sure if this belongs in the general section.. so I apologize ahead of time if it does not. I am trying to calculate a date field based on an EffectiveDate in another table. This is the expression that I have...

Nope :( I still have not figured it out.

Okay first let me explain what I am trying to accomplish: I have two forms: Requisitions Applicants I need to copy text over from the requisitions table to the applicants table. This is done based on when the user types the Req# in on the applicant form. Basically, the requisition is...

That is exactly what I want to do. :0)

Hello! I would like to accomplish two things. (I"ll be happy if I can at least figure out one of them!) ;) 1. I would like to change the view of the built in attachment to display the list of documents instead of a picture. 2. I would like to build a 'preview' screen of the items attached...

Wait.. I had a filter on that's why :)

I'm having the same problem: SELECT Requisitions.[Requisition #], Requisitions.[New Hire DeptID], Requisitions.[Requisition Type], Requisitions.Dated, Requisitions.Status, Requisitions.[VMC Job Title], Requisitions.Manager, Requisitions.Director, Requisitions.Budgeted, Requisitions.Candidate...

Red Box - Top Line: "WHERE [conversion].EmployeeID" Bottom Line: [Employee_Info].[Employee_ID] It changed my code to this and moved iti nto another box. So, I added this form to my employee file and it pops up a box asking me for the Employee ID#. Then when I type the number in, it doesn't...

Thank you - Just one question... Okay, so I figured out how to setup a record source - but I'm not sure how to do the query. Do I put the WHERE under the employeeID COlumn on the query screen?

I have no idea - I haven't made it that far. :0)