Search results

hello thank you i could find it but when i chnage the report to landscape i have the following error: runtime error 2501 the open report action was canceled can you help me please? what is my error? i didn't change the code?

Hi i wrote the below code but i don't know where is my error? can you help me please? If Me.Combo3.Value = "" Or IsNull(Me.Combo3.Value) Then MsgBox "Please enter order number!", vbExclamation, "Order number required" ' ElseIf Me.cmb_AuftragNummer.Value Like "*[a-z]*" Or...

Hi sorry but i am new to ms access i can't understand exactly how should i set it to date? or a unique number?

ps: and also with the same name i mean the name is the same

hi, thank you for the reply i tried it out but it doesn't work and each time the new one will be overwritten in the last file. can you help me please?

Hello Thank you for your reply What do you mean with concatenate the path? I searched but I couldn't find a proper one.

Hi, i have the following code to make the pdf form a report. but i want to make the pdf in landscape mode and also each time with a new name. can you help me please? how can i change it? If Me.Combo3.Value = "" Or IsNull(Me.Combo3.Value) Then MsgBox "Please enter order number!"...

Hello i have a form that i attached it. when i select a number from this combobox a report is opened that i want to print it and auftragnummer in this report should be equal to the value of this combobox. i wrote the below code for the report opening but i get this error: run time error 3464...

Hello i have a form and i want to export it to excel file the form will be updated someties and the data will be changed here is my code, but there is a problem with it Private Sub Command0_Click() Dim xlApp As Object Dim xlBook As Object Dim rs As ADODB.Recordset Dim sql As String Dim i...

hello thank you very much for the answer it helped but for the first part: Assuming you have the chart on a form, you should make some room on the form for an option group box where you can click on one, two, three or all four data types. Put a go button next to the options that would delete...

sometimes i have the below error message, can you help me please? what is wrong here ? i can't understand it? i attached the error message

Hello when i want to filter my query based on the following code i have runtime error 2169, you can 't save this record at this time but it worked fine before. can you help me? what is the problem? when i for example want to filter based on febriary i have the following error: here is my...

Hi i have another question do you know it? i have a chart with four fields in data area and i want that the scale would be set based on the most value of these four fields do you know how to do this? and also can i have a dropdown to choose just one of these fields to show? i mean i want to see...

Hi i have another question do you know it? i have a chart with four fields in data area and i want that the scale would be set based on the most value of these four fields do you know how to do this? and also can i have a dropdown to choose just one of these fields to show? thank you i...

what is your signature?

thank you i found it thank you very very much for your help

hi thank you for the answer it works now do you know how i can make totals parameters invisible like you becuase in totals my parameters are visible and i don't want to seee them thank you

hi did you see the data that i attached? do you have any ideas?

hi did you see my data?

and this data comes from a linked table in sql server