Search results

:) I already have the first table named as the record source. So, I gather that I am able to add the second table as well? Would I just use a comma? or semi colon?

Hello All, I have a form that has several textboxes on it. The form is populated from 2 tables: CellPhoneData and UnitName The main form is bound to the CellPhoneData table. 2 of the textboxes on the form are to receive their data from the UnitName; these are the ones not populating. In...

Hello all, I am trying to populate my subform from a listbox selection. The problem is that I can see where there are 10 records in the subform navigation bar, but no records are visible. Here is the code from the listbox on click event: Dim db as DAO.Database Dim rs as DAO.Recordset Dim...

Thanks for the response MSAccessRookie!

Isskint, Thanks for the replies. I ended up taking the strWhereCriteria out of the sql statement and replace it with the criteria and it now gets by that hiccup.

I am trying to pull the email addresses from the table Lightduty with the criteria of where the email address is = to the email sent field is = false and the Drs Excuse Exp date is = to 14 days or less. I pulled this statement directly from my access query and it works just fine in the query...

Hello All, I am glad I am not trying to make Access vba a career, because I really suck at it, lol. Anyways, I am hoping someone can see where I am going wrong (yet again) with my wrapping of my sql statement. I have tried for about an hour trying different configurations, but to no avail...

Yes, the code is working now. What was hanging the code up was the " was on the outside of the ) and I moved it in and now it works great! I already "Thanked" your post. Thanks again! Until next time, lol!

Yes, it is vba. And the datatype is date.

Ok, now it is working. I had to take the last part <=14)" and changed it to this <=14") and that did the trick. Thanks so much for the help boblarson!!

Darn, still not working. Same error message "Syntax"

Now I get syntax error

Hi all, I have a problem with my DCount criteria. intStore = DCount("FDID", "LightDuty", "[Email Sent] = 0" AND "[Drs Excuse Exp] = DateDiff("d",Date(),[Drs Excuse Exp])<=14")" I am getting an error at the "d"; the error states "Expected: list separator or )". I have tried different ways...

You nailed it Rainlover! The sneaky little &*%$ was clear down at the bottom. As you can see, I am a Access newbie, lol. Thanks for all of the responses; they are greatly appreciated!

Pat, Thanks for the reply. I am beginning to think it is a glitch. I created another project with only one form and tried to place a subform onto it and it does the same thing.

Newbie question here: In design view when I try to add a subform to my main form, I just get a blank control. I cant get to the form properties of the subform. Is this a glitch? this has not happened in my other projects. Or am I missing something (which is not unusual or uncommon for...

Create a function with this code and name it something like "LockControls", then call it when you need it (like the On Load event of the form). To unlock the controls, then just create another function "UnlockControls" and change the = True to = False: For Each txtbx In Me.Controls 'locks...

pr2-eugin, Ok, it is working now. When I looked over the change that you wanted me to make, I noticed that I left the minus in front of the 14 and you did not include it. When I removed this, then the query now works! Thanks so very much for your help! Just curious as to why the first...

The "Email Sent" is yes/no and the query still shows no results or errors when I remove this. The query also did not show any results when the "Email Sent" is in (or errors)

pr2-eugin, I am trying to have a query (which will populate a form) to let me know when someones doctors excuse will expire 14 days before the actual expiration date. eg.. if the expiration date is 11/01/2012, then I want an alert to let me know that this doctors excuse will expire 14 days...