Recent content by alicejwz

Re: Set caption to bold in code Hi all, I want to set the caption on the button to bold in code but I can't get syntax right. I'm using AC2K. I tried the following Me!cmdwo_shipping_sched.FontWeight = Bold Variable not defined Me!cmdwo_shipping_sched.FontBold Object doesn’t support this...

Re: set caption to bold in code Hi all, I want to set the caption on the button to bold in code but I can't get syntax right. I'm using AC2K. I tried the following Me!cmdwo_shipping_sched.FontWeight = Bold Variable not defined Me!cmdwo_shipping_sched.FontBold Object doesn’t support this...

Hi, After copying FE on four more computers two are XP and two are W2K. They all hang when running the on change event w/ setfocus of the controls in the form. But on my machine it ran fine. Is there some of settings I need change on other machines?Where should I look to find the possible...

Hi Brian & Wayne, Thanks for your reply. I'm not sure what is going on. The two user's machines both having the same problem. For now I'll check something else before I get back to the code. Hope you'll around for me to ask more questions. Thanks! Alice

Re: Setfocus in on change event hangs Hi everyone, I was wondering if anyone could some insight on my problem. I'm using AC2K and SQL Server 2K. I copied my FE onto the user's machine. The user's machine has similiar storage space & RAM and configuration as mine. There are two text boxes on...

Re: on change/setfocus hangs I will not be able to use AfterUpdate event, I need to move to the next field after user types the first and second field. Thanks!

Re: on change event/setfocus hangs Hi RuralGuy, Thanks for quick reply. I don't think the rest of the code will run including setfocus in the change event unless the If statement is true If Len(Trim(Me!msp_barcode.Text)) = CInt(work_ord_num_length) + CInt(work_ord_line_num_length) Then I...

Hi RuralGuy, Thanks for your reply. I just found out is the setfocus method causing the application to hang. I don't understand why or how I can fix this. I would appreciate your help. Thanks! Here is my code: Private Sub msp_barcode_Change() On Error GoTo Err_msp_barcode_Change Dim bag_n As...

Re: on change event hang Hi everyone, I was wondering if anyone could some insight on my problem. I'm using AC2K and SQL Server 2K. I copied my FE onto the user's machine. The user's machine has similiar storage space & RAM and configuration as mine. There are two text boxes on the form w/...

Re: Syntax problem Thanks, RuralGuy! That works

Re: Syntax problem Hi all, I have a query updates the table in code it will only works if I have one criteria. str = "UPDATE EquipMaintenance Set NextSchedMaint = #" & next_dt & "# Where [MaintTasksID] = " & rst![MaintTasksID] & "" or str = "UPDATE EquipMaintenance Set NextSchedMaint =...

Re: Read only db Hi all, I have a ACC 2K FE and SQL Server 2K BE. I like to create a copy of this database as READ ONLY, FE and BE. That means a user can click on different buttons to open different forms for viewing but no editing, no changes to the tables. I don't believe creating ade...

Re: how to truncate a field in vba? Hi, is there a cast function in vba? I need to truncate a field pass in from a function. Also what if this field has less than say 10 characters what would happen using truncate? Thanks!

Re: Trouble in sending email Thanks for testing it. Did you test it w/ vbCRLF in the body of the message? I'm using AC2K, SQL Server 2K & Outlook 2K. Thanks!

Re: trouble in sending email Hi all, Why won’t Outlook sent from the code below? It opens to MS Outlook window and after clicking “yes” to send email. Sometimes it hangs. But when trying to open Outlook to check the email, it won’t open Outlook program and in Windows Task Manager you can see...