Search results

  1. alvingenius

    Solved cascading context menu in form

    Hello I have seen a couple of posts on this forum about shortcut menus and context menus and I wanna make it deeper I have a form with 3 cascading combo boxes, getting data from 3 tables, with a one to many relationships between them so, I wanna just create a button when I click it opens a...
  2. alvingenius

    Issue doing update queries over local network

    Hello We have a db splitted into FE/BE, and the backend is in a server machine and regarding the front end... First, it was In Server too and users have a shortcut from it on local machines and everything was good except a button that execute 3 update queries, and I've put a msgbox that appears...
  3. alvingenius

    Solved Setting a Recordset to a query Criteria expression issue

    Hello I'm trying to build a module with a recordset to a query and it working as screenshot but if i tried to but a criteria into the query, for example getting the date from the form1 and opened the form and entered a date for example 16/01/2022, then should only get 1 value in...
  4. alvingenius

    Building a complex cascading tables in access

    Hello I have this idea about a new project we are doing at my work I'll try to describe it and I hope you get the idea So at first lets say we have a main table called : Topics Topics table have about 20 records and i've another table that have a one to many relation with it called ...
  5. alvingenius

    Solved open mainform with vba using where condition to filter the subform inside the mainform

    Hello I've a main form with subform inside it main form have only a combobox to filter the subfrm and i wanna open this main form from a button on another form using vba code: DoCmd.OpenForm "mainform", acNormal, , "xYear= "& me.txtYear but i wanna use where condition too to filter the...
  6. alvingenius

    Solved Convert/extract multivalue field to one value field

    Hello I've a table with a multivalue field and i wanna extract it into one value fields because there's other fields related to specific value on this multivalue field to show you what i mean i've this primary table with data and multivalue field So, for example: Pop have English , French and...
  7. alvingenius

    Detailed Query based on Multiple tables

    Hello For All I hope you doing good in this quarantine Since I'm Home, I'm trying to learn more about Access because I like it and I've got a new idea for an app. So I need your help building it the right way I'll explain what's the output from this idea to help me get it - I'm working on a...
  8. alvingenius

    Solved Print Multiple file paths saved in table

    Hello Guys, I've 2 tables Table for User Profile ( Name, Date of birth, address, phone, email,...etc ) and table named " Files " that saves file paths of ID Photo, Passport image, Certificates images ( i know its local file paths !) - All Files in PDF extention and report only showing user...
  9. alvingenius

    Solved Replicate Text Box in Continuous Form

    Hello Guys, I have a simple problem I guess :unsure: let's say I have a table with Names | TimeIn | TimeOut | WorkingHours Fields i've a form with a query in Record source, and I built a new field in a query to calculate the working hours with a name: Hours and I have a calculated field in...
  10. alvingenius

    Mouse Hover textbox boarder color change

    Hello I have a form with many fields to fill and I'm using this code to make specific textbox to change border color on mouse hover Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.txtUsername.BorderColor = 15197669 End Sub Private Sub...
  11. alvingenius

    image attachment Dlookup in report

    Hello I have a table with an attachment field having a jpg image and I wanna retrieve it in a report like retrieving a text or number using lookup I can't use this table as the record source, it has to be same as using dlookup statment in the same report, i use this...
  12. alvingenius

    Solved Like Operator in VBA

    Hello I wanna change a record source of a form using VBA. Form Record source is SQL statement SELECT tbl_Names.ALC_ID, tbl_Names.ALC_Number, tbl_Names.OrderID, tbl_Names.Cat1 FROM tbl_Names WHERE (((tbl_Names.ALC_Number)=[Forms]![frm_Intro]![cboSession]) AND ((tbl_Names.Cat1) Like "*" &...
  13. alvingenius

    Question Embedding fonts in Access DB

    Hello Good day to all, i'm using a custom fonts from windows in Forms and Reports and i wanna embed them to access front end instead of making a package and attach fonts files , i want it to go through access it self, like creating a table with fonts and attach fonts on the table and with a...
  14. alvingenius

    Solved Select All Checkboxes in continuous subform

    Hello I've a main form Called "frm_Main" and i'm using it as Form Heading to filter records in subforms in Navigation form all subforms view as continuous form this subform is getting data from a query based on filters i use in main form so in this main form i wanna create checkbox field or...
  15. alvingenius

    Auto Grow text box horizontally based on content

    Hello Fam, i know about format property ( Can grow / Can shrink ) and Can grow is good but it only grow vertically while i need to grow horizontally like i have 2 text boxes lets say First Name and Last Name and i put them in stacked layout horizontally Width for both boxes = 1" if we...
  16. alvingenius

    SubReport in Report layout issue

    Hello, i've this main report named : "Formations" that have about 10 subreports all this subreports have the same query criteria, and there's no link between main report and all subreports on it, i'm only using this main form to preview all this sup reports in one report combined. here's a...
  17. alvingenius

    Solved Splitting 1 field in table to 2 text boxes in report

    Hello, I dont't know exactly how to write my issue in title :banghead: but i hope you understand it from screen shots i made a sample DB to match my same issue but in a simple db i've this table and i wanna generate a report from it with (USA & London ) as labels in Header and showing...
  18. alvingenius

    Solved Getting Permissions form worked by control multiple controls by Tags

    Hello, This Post is following this post to know how to control a group of controls I have a users table with permissions of accessing forms/reports and in this table 2 more checkboxes as rules Manger / Custom ( later maybe i convert it to combo box ) in permission form i've set record...
  19. alvingenius

    Solved Button icons align in Nav. form tabs

    Hello i'm creating a Navigation form with Vertical Tab Left and in button caption and icon it's automatically centered align and the form with 5 or 6 buttons wont look nicely i want to make icons and captions in specific locations in every button like all icons in the left aligned in column...
  20. alvingenius

    Hide all Access Windows and Ribbons

    Hello I wanna open db forms as in popup window in all forms and i don't wanna see Access window at all + ribbons + nav pan i've managed to hide nav panel from access options in CURRENT DATABASE and managed to hide ribbon with this code Now i want to hide Access Window Check this photo...
Top Bottom