Search results

Sorry if i misunderstood you. So if i do this i should work. Is that what you are saying? Function Check_Permission(FrmName as Form) Dim x as Object x = FrmName If CurrentUser = "Viewer" Then Beep MsgBox "You do not have permission to this item.", vbCritical, "Access Denied" Exit Function...

I am trying call below function with either of these call routine, but without sucess. Instead of variable FrmName if i use hard coded form name then everything works like it supposed to. I would like to call this funcation from custom toolbar or also from other forms as well. Any thought...

Add a textbox to your form. Set the control source of the textbox to =DCount("[PK]","YourtblName") or =DCount("*","YourtblName") Hope this helps

Never mind - i got it working.

Hi All, I am having problem printing a label based upon newrecord. The report prints but has no information. I think it is because it is not save to the table yet since i have this event before update. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim stDocName As String stDocName =...

.. glad that you got it working again. Get into the root of the problem and don't let that happen agian. Check this link out. http://support.microsoft.com/default.aspx?scid=kb;EN-US;302525 KB talks about memo field indexes issue, i have that happened with simple text field (255) index as well.

I have a form called "form3" with tabbed form "Form1" with tabbed sub form objects within the "form1". All i am trying to do is, create a lookup form called "Form2" (click advanced option) and select the record in lookup form and return it to main form. See attach sample DB. If i open form1, it...

I need help wiAttath simple database query. Attached database has table with date, timeout, timein fields etc. I am trying to query a list of records where datediff <=0 and also TimeDiff < -15 and if datediff =0 (which is today) then timediff must be < -15. Actually, this is a resource...

I designed simple resource scheduling database. All the aspects of scheduling work, except duplicates (overlap) management. How do i prevent duplicate entry based upon TimeOUT and TimeIN values. Here is my table structure: Please advise this poor "STUCK" soul. Thanks in advance...

Thank you That is what i need. Thank you very much Jon K. You saved my day. thanks suresh

I have a table "tbl_attend", which looks like this. ListNum ID_num EventID Attend 1 23 1 Y 2 23 2 Y 3 23 3 Y 4 56 2 Y 5 56 3 Y 6 29 1 Y 7 56 1 Y I would like to query unique ID_num where eventid = 1 and 2 and 3 and Attend ='Y'. e.g: ID_Num 23 56 My ultimate goal is to find random five...

Teresa, This might help you Try this for me. Once you add the employee - set focus back to main form "Your_Combo_Control" and on the main form " On Got Focus Event" add following line. Me.[your_combo_control].Requery may not work but worth a try. sa

Similar issue i am also experiencing similar issue. I will be watching this post closely. Somebody, please help us.

Gizmo, Thanks for the reply. I have DAO 3.6 Library reference in the database - may be that is causing trouble for you to open this database. I have been doing a lot of "googling" to find the sample database - but no luck.

I have to run a lot of Sql scripts against .mde database. I am trying to create a custom form to run raw sql script either to update, select or even insert simple values into tables. I was wondering if any one one out there already have a sample database that does this. I have attached the...