Search results

  1. Babycat

    Store and manipulate a Control on form

    Hi all. I have forms A1, A2, A3... that contains subforms, and on these subforms I have textbox named Txt_ProductName It could be located at: "Forms!FrmA1.Form.Level1subA1.Form.Level2subA1.Txt_ProductName" (I assigned this string to Arg_str1) or "Forms!FrmA2.Txt_ProductName (assigned to...
  2. Babycat

    #Delete msg on form's fields

    Hi everyone My customer is evaluating my small Access project. Splited BE is on a network folder "\\data\accessDb\BE.accdb", Two users have their own FE on their desktop PC. These desktop PCs are joined to domain. Most of time, the system works fine as expected. About my app: + FE has...
  3. Babycat

    Solved Max user to a LAN shared folder (BE)

    Hi all I am using shared folder on LAN to store BE file, but i saw this setting limit to 20 users only. My customer wants about 50-70 users install my Access app. What if there are 30 users opening Access app at same time? Is that possible to increase simultaneous users to around 50-70 user...
  4. Babycat

    Solved Clear a numeric field to Null

    Hi all, I want to clear CurrentID (long) to null (nothing) in table current logged User I thought it was simple SQL. UPDATE L_TBLUSER_CURRENT SET L_TBLUSER_CURRENT.CurrentID = Null; But I got error: "You tried to assign the NULL value to a variable that is not a Variant data type" My purpose...
  5. Babycat

    Detect BE connection lost and handle it

    Dear all I have an Access app which splited BE abd FE within LAN. User1: FE + BE User2: FE only When user1 turns off his PC, therefore User2 FE has no BE and sometimes it causes Access app on User2 hang up. What could be the proper way to approach and handle this issue? I used to deal with...
  6. Babycat

    Solved Autoexec Macro works on A10 (accde) but not A365 (accde) - Error #2425

    Hi Everyone I have a Access project (Sampledb.accdb) on my PC win10 - Office365 (64bits) A virtual machine (on same PC) i have win10 Office10 (Pro-64 bits) On my PC: -Run accdb: Working well On Virtual Machine (win10 Office10): -Run accdb: Working well -Save as...
  7. Babycat

    Way to know form name that opens a particular form

    Dear all I have formA and formB that both contain combobox Cbx_Footprint. User can click on "Edit item list" to open other form (formC) for adding new Items. When closing formC, I would like to requery Cbx_Footprint to have latest Items likely: Forms!FormA.Cbx_Footprint.requery However I dont...
  8. Babycat

    Solved Move a control to other section with vba

    Dear all Can anyone help to move control Txt_ID from Header to Footer section with VBA code of button Btn_MoveCtrl? I tried with Move method but it is only moving within a section Private Sub Btn_MoveCtrl_Click() Txt_ID.Move End Sub Thank you
  9. Babycat

    Solved Very weird behavior- Error '3709': The search key not found in any record

    Dear everyone I have been struggling for 3 days to debug but only narrow down some clues... I have a mainform and a continous subform, they act like split form. Main form has button to filter out records on subform, and when user click on a record in subform the main form will show current...
  10. Babycat

    Replace (Ctrl + H) with Newline character in VBE

    Hi all I have many forms and modules in VBA code. My code usually has a line in comment mode like 'On Error GoTo ErrorHandler thus, this error handler is temporary disabled during the code development. Now, I want to replace above line by using a compiler switch such as #If DEVMODE Then #Else...
  11. Babycat

    VBA/ Declare and initialize a array of structure

    Dear all. I have structure (type) in VBA and an array Private Type Item_property Itemname As String ItemMaterial As String End Type Dim ItemArray() As Item_property And I expect to init ItemArray like: ItemArray = { ("Knife", "Steel"); ("Ruler", "Plastic"); ("Ring", "Gold")} but It...
  12. Babycat

    Error 2185 - Strange behaviour of textbox

    Dear all I have an unbound textbox names: Txt_FnameFilter, it functions a search for each character keyed in via function: User_FnameFilterParameter (Txt_FnameFilter.text) This error occurs when no search result found. I have read about Error 2185, i understand that I can not access...
  13. Babycat

    Group value Query

    Hi Everyone I want to build a query that group data as the attached picture. Can anyone please help me?
  14. Babycat

    Reuse default search box on Form

    Dear everyone. Is that possible to re-use the search box that appears on record navigation bar at botton of form? It is great as it jumps to fields on current record, and jump to next record that search criteria is met. Thank you!
  15. Babycat

    Mouse Drag to change textbox position on fly

    Hi all I know it is weird but I would like to know if any example or solution that able to change position of a form's control by mouse click and drag in form view mode? I studied about on mousemove event and try to set new position when event fired, but it seems to be exhausted... My end-user...
  16. Babycat

    Solved Query to show number of student not pass the exam

    Hi everyone I have the tables and relationship showed as below. I want to have query that shows number of student not pass (point <5) first round of exam per class Can anyone please help me? The db is attached. It is prefer to not use more than 1 query.
  17. Babycat

    Solved Save textbox control properties on form

    Hi Everyone, I have simple task but I have not configured how to do it efficient. I make color picker box for end-user to change a textbox color in any color they want by vba code Textbox1.ForeColor = 'somevalue' This color should be kept on next time the form open, so I tried to save it...
  18. Babycat

    Form flickering with background image

    Hi everyone My friend is asking me to help him making small Access project for luckydraw like this vid: Virtual Digital Lucky Draw System - YouTube I have built a similar one (attached db), however i got issue with form flickering. It is actually textboxes flashing when new values are writen...
  19. Babycat

    Access 365 Runtime: Click and Run offline Installer

    Hi Everyone. Do you know where to get this offline installer? I am distributing .accde file, but I am not sure if end-user has/dont have MSA, so I want them to install Access 365 runtime. Some of their PC dont have internet access. So I wish I could send them offline installer file via USB...
  20. Babycat

    Solved Retrieve Image.Picture path

    Hi Everyone. I am using unbound image (linked type) to display a product photo. To display, I set it to photo path such as: Image.Picture = "C:\Users\Admin\Desktop\1.jpg" But when I try to read the path back: Pathstr = Image.Picture I always get result: Pathstr = "(none)" How can I get the...
Top Bottom