Recent content by china99boy

Hi....I was able to find out what my problem. I was using the name of the form but, the expression was looking for "ENTRY FORM" which I had as the caption for the form. But I still couldn't do it without your help "arnelgp" Thanks for your time.

I was able to create a new dummy dba and tried it out and it works great with what you provided. But it doesn't work on my existing forms. Not sure what you mean by a "Navigation form"

That was just a typo. But it is correct and still producing the same results. Sorry for the confusion

After making the recommended changes, my query now looks like this and still get the same error. SELECT DISTINCT tblMtgType.mtgType, tblMtgType.ltv, tblMtgType.ltvDescription FROM tblMtgType WHERE tblMtgType.mtgType =[forms]![frmMain]![frmTracking].Form![cmbType];

Thank you so much for your reply. I tried that before and just did it again but go similar error. Forms!frmMain!frmTracking.Form!cmbTracking.Value

hello... I have a form with 2 combo box. The second combo box items are limited based on the selection in the first. Everything works great on the form, except when I embed this form on another. As soon as I make a choice in the first combo box, and then try to select something in the second...

Hi I have a button that once click will send emails and should enter the date/ time the email was sent to record. But i cant get it to update the field because it states that is read only. The emails are sent with no problems. How can I get around this? Thanks in advance.

Thanks...I got it with your detail explanation. :D

Hi guys...I can't figure this out after trying for several hours. I have table A with fields "date" "AgentID" and "Msg" Table B with has several fields, which also includes "Msg" "date" "AgentID" among others. I am trying to add the data from table A "Msg" to the matching record in table B...

Hi guys, Not sure what I am doing wrong, I have an Access dba that stores records. I create an Excel spreadsheet that pulls the data from access. This works great,but I am having problem updating the record. I have a sample that works great and I simply added the coding to my application but...

Thanks for you input. Would just leave it the way it is for simplicity.

LOL, your right, very simple. Thanks. Will it be possible for the user to just click on the number or will that be to complicated?

Here is a couple of tracking # 795171133672 and 797501491177 to test. Thanks again for taking the time to look at this.

Thanks your reply. I was able to add a command button that when click will go to the fedex site and check the status. My problem is, I am trying to be able to add multiple tracking number in the FedExTracking field. Currently it only works when I enter one tracking number. I was hoping the user...

Hi Guys, Not sure if this is possible, but would like some help or suggestions. I have an Access dba that employees enter data in daily and one of the fields require a FedEx tracking number(s) be added. Is it possible to code the field that holds the fedex number that once clicked it can link...