Search results

Thanks for your fast answer The problem is file size 5 mb I will try to upload needed tables only.

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

Dear arnel i did your modification on code and i delete this "C:\Users\Mina.Garas\Desktop\to costing" & ctl.Column(2, varItem) & ".PDF" part to allow access let me select path folder and i select 2 items from listbox the problem now is each pdf file contain 2 items data not one item as i need thanks

Numeric I use ms 365 if that will make difference

I did but same result

Dim strWhere As String Dim ctl As control Dim varItem As Variant 'make sure a selection has been made If Me.lstFProductSearch.ItemsSelected.Count = 0 Then MsgBox "Must select at least 1 Item" Exit Sub End If 'add selected values to string Set ctl = Me.lstFProductSearch For Each varItem...

Dear June7 I tried that but nothing happen no pdf reports created Private Sub Command14_Click() Dim strWhere As String Dim ctl As control Dim varItem As Variant 'make sure a selection has been made If Me.lstFProductSearch.ItemsSelected.Count = 0 Then MsgBox "Must select at least 1 Item" Exit...

You r right this is correct link http://www.baldyweb.com/multiselect.htm

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

Dear @Pat Hartman I read your code many times to understand the concept i wrote my code following your steps as i understood but when i click on command button nothing happen as below the code i wrote please guide me where i do mistakes On Error GoTo Err_Handler 'Purpose: Duplicate the...

Thanks Pat I will try it and inform you the result Thanks again

Here you are Thanks in advance

Dear Pat I try your ideas but I failed because my skills in VBA are limited I need to divide this case Firstly I try duplicate form a and b successfully But I need your help to duplicate certain record if Main form PK = 1 ,FK in form B contain many lines and form B has its PK I try to put...

Could you please explain that on Allen Brown example. Thanks alot in advance

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

Wooooooooooow Thank you very much Arnel Thank you all for your support

i checked site many times, unfortunately the problem this site not provides search tool or downloads section