Search results

I've been trying to get an answer to this everywhere but with no success. I can't specify Chinese characters in WHERE clause of SQL Statement. See attached file.

Hi, I'm using the following: 1. English Windows XP Home edition 2. MS Access 2000 Issue: In the form coding (visual basic) i want to be able to match for Chinese characters. I'm able to view and edit Chinese in the table. But when i try to program a button in the form to search for a chinese...

I had searched several forums but could not find any Inut Mask question similar to mine. Here is what's happening. When I enter data in the text box with Input Mask the cursor stays at the same position all the time, every digit I entered replaces previous digits. I have to press the Right...

Hi, I tried to post this in the ASP forum but got no replies so i'll try here. Database: MS Access 2000 (English) ISP hosting: Envisage Windows site hosted on a full IIS Virtual Server running on an Windows Server 2003 Objective: Screendumps provided in word doc I want to be able to...

Hi All, I have two fields on a form that I want to use in a query: First Field : used to specify operator (i.e. >, >=, <, =<, =) Second Field : used to specify number I want user to enter values in form so that I can run query using these combination of values, i.e. >6 or >=6. How can I do...

Hi, I have a form that the asks the user to enter "a book id". When he presses the OK button the "book id" is inserted in another open form. But now I want to trigger the AfterUpdate event without any user intervention. How can I do that?

Hi All, Scenario: Want to sent access report in HTML format in the body of the message and not as an attachment. Basically, I want to create a form where I complete all the sending information and specify a HTML format, but instead of attaching it as file in the email, I want to be able to...

Hi All, Is there anyway to check for the correct format for a valid email address. I think I've seen a solution somewhere using regular expressions but don't seem to be able to see it anymore. I would appreciate it if somebody can point me in the right direction. Thanks

Hi All, I get the error "Run-time error -2147467259 (80004005) Outlook does not recognize one or more names" when I try to run myitem.send - myitem is defined as an object. Any help would be appreciated. Thanks. Situation: Basically I am getting the email address from my membership table and...

Hi, Does anyone know how to reset a unbound field? Situation: I have a unbound field (default value "0") - when the user enter some invalid I will trap by using: Private Sub Text73_BeforeUpdate(Cancel As Integer) If Me.Text73 > Me.Text69 Then Me.Text73 = 0 Cancel = True Exit Sub...

I get "#error" in a field with control source .. =[sfmHireReturn].Form![HireTotBooks]. sfmHireReturn is a subform and the "#error" message is produced if I don't have anything in the subform. I have tried trapping for ISNull ([sfmHireReturn].Form![HireTotBooks]) but it doen't get rid of the...

Anyone! How does the date criteria work for the DSum function?? I can't get it to Sum using the following methods. Thanks in advance. First Method: sSQL1 = "[ReturnDate] = #" & Format(Text31, "dd/mm/yyyy") & "#" nRevenue = DSum("[LateCharge]", "tblHireTransaction", sSQL1) Second Method...

I have a combo box with the following properties: Row Source Type: Value List Row Source: Item A;Item B;Item C Can I program a button on the form so that the user can add "item D" without switching to design mode. Thanks.

Hi All, I have a form that allows the user to select various criteria for report. With this I will set the recordsource for the report. My question is: Can I pass some parameters to a report because I have some field's calculation that rely on this?

Is there a limit to the number of Text box or labels you can have in the Report Footer section? I found that I can only display about 60. I am doing a customer profile report i.e that show age group distribution, Marital status and etc. One solution would be to split up the report - not nice.

Hi All, How can I reprogram the action of the return key in a subform datasheet? When I press the return key it move to the next key. I would like it to move down and set focus on the new record. Thanks in advance.

Hi All, I am using a query form to get the criteria to run my report. I want the report for a certain date. My syntax is : DoCmd.OpenReport "rptIssue", acViewPreview, , "[Date_ Raised] = " & Forms![IssueReportSearch]![Text5] where [Text5] is the unbounded field to hold the date. I find that...

Is it possible to have wordwrap for a cell if it being displayed as a datasheet on the screen?? This would be the same functionality as Excel. Thanks in advance.

I am using a subform for data entry. After I enter book number the due date is calculated (see below)- this works fine. However the due date also depends on the total number of books. As this increases, the due date should be recalculated for the whole subform. This means that a person...

I have a subform that displays a book list. I want to allow the user to key in a book id through a dialog box and the application to highlight it in the book list.