Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 "*" &...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. alvingenius

    Solved VBA code to Disable multiple selection of commands

    Hello i'm having a form with alot of Buttons and i've a group of buttons i wanna enable/disable them via VBA based on userID logged i can use if ******* then Me.command1.enabled=false else Me.command1.enabled=true end if but i'll have to repeat it with the number of buttons a simple...
  16. alvingenius

    Question Building Security system for Access Database

    Hello I'm building Archiving app with Access and in work we using it as FE/BE - BE in Local PC in local network and we are happy with that i want to add security system to the FE or BE to not allow it working outside users PCs and disable shift open and hiding tables and pasword protect...
  17. alvingenius

    Disable Editing Subform in navigation form

    Hello i've main form named "frmMaster" and it have Navigation form with tabs and a tab button named "Profile" to open subform named "subProfile" inside navigation form this subform is opened directly when i open "frmMaster" because it's in the first tab and i'm trying to do a permissions...
  18. alvingenius

    Rearrange Report Fields after hidden some other fields

    Hello this is my first post here in this great forum any my question is : i have a DB for employees data and i want to create a printed report to tell the employee to complete the missing fields on his profile and i want to mention this specific fields to fill only on this report my way...
Top Bottom