Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ryanku

    #Error message

    If the field FUNDCODE has Text data type, you have to change that expression, from: DLookUp("descrip","cash descriptions","FUNDCODE=" & [cashnycashitemsdetail]![FundCode]) become: DLookUp("descrip","cash descriptions","FUNDCODE='" &...
  2. ryanku

    Hard disk serial number detection

    I use Access97. The first function (without API) that I tested works just fine. I really don't know if it'll work with 16-bit application. This function needs "Microsoft Scripting Runtime" reference (vba332.dll, usually in folder C:\Program Files\Common Files\Microsoft Shared\VBA)...
  3. ryanku

    Print Preview Form

    1. Create a command button, name that button 'cmdCurrentFormPreview' 2. Set 'Display When' property to 'Screen Only' 3. Inside cmdCurrentFormPreview's 'On Click' event, put this line: DoCmd.OpenForm Me.Form.Name, acPreview 4. To print preview this current form, just click this...
  4. ryanku

    Hard disk serial number detection

    This is Remedy's answered remedy (Programmer) Jul 27, 2001 It's easy using FileSystemObject: Private Function GetSerialNum(ByVal DriveName As String) As Long Dim loFSO As FileSystemObject Dim loDrive As Drive Set loFSO = New FileSystemObject Set loDrive =...
  5. ryanku

    HighLite Data on a report

    If I'm not too late Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Const vbLightGrey = 12632256 If Me.CurrentRecord Mod 2 = 0 Then Me.Section(acDetail).BackColor = vbLightGrey Else Me.Section(acDetail).BackColor = vbWhite End If End Sub
  6. ryanku

    VB Printer Help for single pages

    The error number (Err.Num) for that error is 2501. So for the simple way to avoid that message being show, just add 'If Err.Num <> 2501 then' before 'MsgBox Err.Description'. If you want to know the error message, just put the Err.Num in the Msgbox: Err_Test_Print: If Err.Num <> 2501 then...
  7. ryanku

    convert mdb files to exe

    Really?? As fas as I know, Microsoft Access will never ever able to do that (.exe file).
  8. ryanku

    How to 'gather' the records up

    I'm not renumbering the records, the 'counter' field contain fixed data that I'm not allowed to add/deleted/edit. The only field that I'm allowed to edit is 'item' field. It doesn't has to sorts 'Asc' or 'Desc'. The result must be in the same table. Thanks for the responses
  9. ryanku

    How to 'gather' the records up

    Hi, Does anyone how to code my 'little' problem: my table, before: Counter Item 1 <null> or &quot;&quot; 2 XYZ 3 <null> or &quot;&quot; 4 ABC 5 JKL ... need to became: Counter Item 1 XYZ 2 ABC 3 JKL 4...
  10. ryanku

    combo box not allowing selection

    striker, i like to see you combo box if your don't mind. Maybe we can fix it. ryanku@hotmail.com
  11. ryanku

    Make A Report that Prints Specifically

    Maybe this link can solve the problem http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM#List
  12. ryanku

    Any Way to SAVE Print - Page Setup in Access Runtime?

    It can be done if we use MDB file, not MDE. Please visit this site: http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM#Setup
  13. ryanku

    Playing a music file

    Try to change this line: stAppName = &quot;C:\Program Files\Windows Media Player\wmplayer.exe /play &quot; & Me![Filename] become: stAppName = &quot;C:\Program Files\Windows Media Player\wmplayer.exe /play &quot; & &quot;&quot;&quot;&quot; & Me![Filename] & &quot;&quot;&quot;&quot;
  14. ryanku

    Printing Page Setup Problem in Access Runtime

    It can be done if we use MDB file, not MDE. Please visit this site: http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM#Setup
  15. ryanku

    Credit Card encryption

    Perhaps for some reason you need to check if the Credit Card number is in a valid format or not? http://www.allapi.net/tips/tip47.php ryan, ryanku@hotmail.com
  16. ryanku

    New to Access 97, have to make mileage database

    Go to http://support.microsoft.com/support/kb/articles/Q182/5/68.ASP Download the QRYSMP97.exe (The queries sample database) Run the database then open qryNextRec_Dlookup or qryNextRec_VBA Query. hope that's the answer for your problem. ^_^ ryan ryanku@hotmail.com
  17. ryanku

    Problem concerning continuous forms.

    Dear Peter, me too, me too...^_^ ryan ryanku@hotmail.com
  18. ryanku

    Vertically rotate fields/labels?

    Try this link http://www.lebans.com/rotatetext.htm But it's only rotate the texts/labels.

Part and Inventory Search

Back
Top