Search results

Hello I know it sounds weird, but I'm trying to build a form to act as Messagebox; with it, it gives an excellent look instead of the standard message box window I've tried the formatted messagebox in AttentionSeek db of @isladogs, and it's not giving a look that a specific form gives! here's...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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 "*" &...

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...

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...

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...

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...

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...

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...

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...