Search results

Hello everyone I have a simple question I have a table containing Code , description , qty and sum columns I need to make sum of qty in sum column I try to use subquery instead of dsum to get better performance as I read on this forum but it does not work is any way to do that specially my...

Hi everyone i have a problem i face it for first time I have a database with queries layers for 8 levels when DB in single file all queries working perfect when i split it open only 7 queries then error message appear " cannot open any more databases" i researched this issue all results says...

Hello everyone I have a problem and try many times to solve it but i failed i build StartUp form to disable startup properties in screen splash on load event i wrote below code Private Sub Form_Load () ' Go Modal to Lock Navigation Pane Me.Form.Modal = True ' Hide Navigation...

Hi everyone I notice most of my vba experience needs is around DAO So can any body recommend websites or pdf files for DAO learning or tutorials Thanks

Hello everyone I face a problem I don't know if there a solution to it or not I have some reports based on layers of queries. I mean I create a query1 then creat query2 based on query1 then query3 based on query2 ....etc Each query created based on item type in pervious query for more detail...

Hi there Greetings My question for Pbaldy and anybody can help I use your method to filter reports using multiselect listbox from this link http://www.baldyweb.com/ImmediateWindow.htm My question is how to improve this code to print pdf reports individually using multiselect listbox and give...

Hi everybody I have a problem make me crazy and i don't how to fix it i have a database file is working fine all command buttons, navigations forms, reports working fine when i save this database as a template file ACCDT and try to use this template again i found every thing corrupted command...

Hi everybody I face a problem that don't understand it I create unbound form as a navigation form with command buttons in load event i use only docmd.maximize code to maximize this form full screen the problem is when open this form i got error as attached file can anybody help me thanks

Hi everyone I have a question I have main form FormA Contain suborm FormB This subform FormC I need to use command button Allows duplicate records in FormA, FormB and FormC I try to use Allen Brown code But it's works on FormA and FormB only How I can duplicate records in 3 forms at once...

Hello Great forum In my work i use many images those need to manage and printings in reports can i store those images on my google drive and print them on reports? if that possible how can i do that? Thanks in advance

Dears Have a good day Anyone have download link to demonstration database for Garry Robinson that attached with his book real world Microsoft access database protection and security - 2003 Thanks in advance

Hello everyone I need your help in this problem I need to create a combo box as a search box Search about item name and its serial no. I need when I write in combo box The item name or serial number Display item name in a text box All in data sheet view I hope found solution for this in this...

Hello everybody i have a question what i know the best practices 1 pk link to 1 fk can i link a primary key in a table with 2 foreign keys in two different tables and build queries and forms on that without any bugs in database after that thanks

Dears I am not experts in vba codes like most of you so i need help in below issue i need to create a form to perform the following 1- retrieve record set using ID from table A 2- edit this records 3- save edited record set to Table A with new ID I know its will need queries or vba codes but...

Hi every body please i need to know how i can use combo box to select a value and when i click command button open form based on combo box value using a macros because I DON'T KNOW VBA CODES THANKS

Hi everybody I'm trying to planning new database based on food recipes so i need to though with all of u about this database i divide tables to tbl1ItemData: ItemPK, Item Name, Item description, Client tbl2RecipeIngredients: ItemFK, Ingredients, Brand, Unit, Qty tbl3RecipeSteps: ItemFk...

Hello everybody I face a common problem for most of you but its first time for me I make a sub report but i have a problem there is a white space in the bottom of it when i make another sub report i got white space again when i search on this forum i found some solutions like make can shrink...

Hi everyone I'm new in this great forum I need to update my data using form by write item code in search text box then find the item then make update on data after that i need to save the item data with new code for example if the item code is 1 (coding by auto number field) , i want to save the...