Search results

Thanks Steve, I got it fixed..it was the quote " that I needed. DCount("*","Password ID","security id =" & "[UserId]" )=1 Then it works!!

Hi Steve, thanks for your reply. I have changed the syntax but i am still getting an error message. " Syntax errro( missing operator) in query expression 'security id = 22'. for the following statement. If ( DCount("*","Password ID","security id =" & [UserId])=1 ) then The macro is...

Hi, I couldn't figure out why I keep getting missing operator syntax error on my Dcount function within my macro. I believe the syntax is correct, could someone please help. I am using Access 2010. I tried both under the macro and both version have the same error!! If DCount("*","Password...

Okay!! I found a work around solution! Instead of using DCount() to check the return result set to determine if the employee is valid on the employee table. I just build a macro on the subform OnOpen event to check if the employeeId textbox is null. If IsNull then I just do a cancel event...

Okay!! I found a work around solution !!!! Instead of using DCount() to check the return result set to determine if the employee is valid on the employee table. I just build a macro on the subform OnOpen event to check if the employeeId textbox is null. If IsNull then I just do a cancel...

Hi Paul, Are you able to open my DB in 2007. I don't recall using any 2010 special features in the posted DB. Is there a way you can guide me through it or do you want me to save it as 2007 then post it again?

Yes, it is a 2010 file. I am running Access 2010. I thought 2010 can be downward compatible with 2007? Is it not?

Ok..This time I didn't zipped it. thanks

Hi Paul, Sorry for the late reply. I just got back to work today. I managed to play around and put the store procedure in the 'before insert' event and the error message finally come out. However the error message is still not coming out in the right sequence of event. I want it to come out...

Oh I see! yes I've changed the actual table name already. What do you mean by post the db?

Thanks Paul, What is "Me" in the Me.EmployeeID? Is that a system command? or object name ? I tried replacing 'Me' with my object name but it couldn't recognized it so I change it back to 'Me' and it seems to work better. I also copy some of other codes but when I test it out, the msg box...

Thanks for your reply. But is there another way, because I don't want the other employees to see the other person's id. Right now if the user entered an invalid id, the query result set would be empty. Is there a way I can capture that and send an error message without opening the input...

I am really stuck!! Can someone please help. I am using Access 2010. I have a simple employee timesheet input form with a subform. The main form just display the employee id and name and the subform display the timesheet detail. The form is based on a query with a criteria input parameter...

Thanks for your reply. Yes I know it is in 2007 but my application is in 2010 and I can't find it in 2010. Is there a way to modify it in 2010 or do I have to port it back to 2007 modify it and then port it back to 2010?

I have recently moved my Access 03 application to Access 2010. I wanted to modify my switchboard page however in Access 2010 I don't see the switchboard manager anymore. What are my options? Can I still modify my switchboard or do I have to create a custom Navigation Pane to run the database...

Hi Jeff, I got it to work after I converted the database from .mdb to .accdb format. Thanks a million!

Hi Jeff, Thanks for your reply. None of the tables work in my database, I even tried to create a new table and it still did'nt work. However when I created a brand new Database with a new table, those options become available to me. There must be something that is locking me from creating...

I am very new to Access especially 2010. I am trying to do a data macro. I followed the instruction from help menu. I open my table as per instruction and then try to click on the before and after event however the toolbar for the before and after event under the table toolbar is grey out and I...

Hi Bob, just read your link on how to do data collection via email, very informative however I still have a few questions. 1. Can we have a single user (email recipient) insert multiple records via email. Just like how it will work in Access via a form to add records? 2. Does it support...

Opps! You are right no Windows 2010. What was I thinking! sorry! thanks for being such a great help.