Search results

  1. H

    Some string error in function, object no defined.

    Why am I getting the error in this function: CustomSplit Please see attached database. Try to query [query_dt_volume1] It is simple query, calling the function in module: CustomSplit. Output should be: Tower Records [USA] = Tower Records Deutsche Bank [Hong Kong] = Deutsche Bank HongKong Fund...
  2. H

    Create a table from two tables

    If I have one table like this: PRODUCT VOLUME NK 200 CN 180 CY 220 and another table: REGION SHARE AUSTRALIA 0.45 CHINA 0.55 Want output: PRODUCT REGION VOLUME NK AUSTRALIA 90 NK CHINA 110 CN AUSTRALIA 81 CN CHINA 99 CY AUSTRALIA 99 CY CHINA 121 Volume for each product...
  3. H

    Bound Columns: Are they a drain on network traffic?

    I have a form bounded to a table in a back-end MDB. The OnTimer is set to auto save every 5 minutes. Question: How fast does an update in the form gets saved in the database table? I've tested that it is saved instantly: I make a change and quickly exit access, and when I reopen the update is...
  4. H

    When I open a table, how do I sort by multiple columns?

    Office 2003 When I open a table in datasheet view, how do I sort by multiple columns? In other words, I want to achieve the same effect as "Select * From [Table] Order By Column1, Column2, Column3 ASC"
  5. H

    Select Case statement, question about inclusive

    Function Score2Grade(dScore As Double) As Double MsgBox dScore Select Case dScore Case Is < 283.2 Score2Grade = 5 Case 283.21 To 307.8 Score2Grade = 4 Case 307.81 To 332.2 Score2Grade = 3 Case 332.21 To 380...
  6. H

    Bounded textbox not saved yet. Msgbox(textbox) returns the older value from the table

    I have a bounded textbox to a field. The value I see on the textbox is "MSACCESS". The value in the field is "MS" because it is not yet saved to the table. MsgBox(Me.TextBox) Returns "MS". It returns the value from the table. How do I return the value from the text-box? I don't want to save...
  7. H

    Cursor reset to start position in a textbox on OnTimer DoCmd.Save

    I have OnTimer set to 60 seconds to run Docmd.Save. When the user is typing on the textbox entering information, on the 60th second the forms save, and the cursor position reset to the start of the textbox. It's a nuisance that repeats every 60 seconds. How do I prevent the cursor in a...
  8. H

    Question Securing the backend in a shared folder

    Hello, Introduction As would be expected, most people have designed their Ms Access Application by splitting the database, forms, queries, reports in the Front-end, while the tables that holds the data are in the back-end. The Frontend is distributed to users on their desktops, while the...
  9. H

    How to get the RDN name

    Hello, GetNetworkUsername() function is readily availabled on the web. It returns the logon name, which is my lan_id. But each of these lan_id have a RDN (full name). How do I get this full name? e.g. My Lan ID is FGSCF2331, I would prefer to get the Full Name so that I know who is...
Back
Top Bottom