Search results

hello i want to check if a field in a query is empty or not but it is not working as i wrote it. i attached the pic. thank you for you help

hello, i want to make a criteria in my query in a column as belowL: <[Forms]![Projects]![Real_date] projects is the name of my form and real_date is the name of my field in my form. but i have this error message you have attempted to use an undeclared parameter. what should i do to have...

hello i wrote the below filter in a query in ms access but it doesn't work can you help me please? thank you Between Format([Forms]![frm_Charts]![Text109];"yyyy-mm-dd") And Format([Forms]![frm_Charts]![Text111];"yyyy-mm-dd")

they enter it via outlook

hello thank you for your help but i want to fill out the email address manually and without message is it possible in this way as well?

Hello i want to make an excel file from a query and then export it to mail. can you guide me please how to do this? i want to make an excel and then send it as an attachhment. also i want to insert the mail address to manually because each time it is sent to a different person. thank you

thank you for your reply but i want that the user enters the email address in this link i found how to create a new message but i don't know how to use it with creating the excel file and put this excel file in attachment, do you know this? can you help us please?

i also got this warning i uploaded it

yes i had this message run time error 2295 unknown message recipient the message was not sent

hello i found this but it wasn't ok for me DoCmd.SendObject acQuery, stDocName, "MicrosoftExcelBiff5(*.xls)", "C:\TEMP\Misc.xls", "", "", "Query in XL Format", "This is the Body Text", False, ""

hello, i have a query in ms access i want to makew an excel file from that and then send it via email can you help me please? thank you

but this is not a web query and it is in windows access. so the group bys are enabled. but i need group bys in a web access database. do you know how ?

Hello i work with access web database. in access web aggregate functions are disabled in query design. so i made a query in client and i thought then i can insert this data to another web table. but i don't know how to update this table. because the source tbale of the query is also updated...

i also don't inderstand your solution can you explain more please? also group by is not active in ms access web database how can i active group by in ms access web database?

hello but this is web access and group by is not enabled in creating a query the attachment is my database i want to have based on checkpoints table: Number of checkpoints for each area and creation date

hello i want to make a query in ms access web , to count the numbe of ids of a table group by two other fields. but in ms access web it is impossible to work with count function. can you help me please how i can do this. in addition group by symbol is also disabled and i don't know how it...

Hello i have a form in a web database when i work within a monitor it works fine and i can see all of the columns in it but when i work within a labtop it doesn't work and i need a scroll bar to see all of the fields but when i change the status of the scroll bar to both it doesn't work can...

helllo, thank you very much but is there a way to work with macro? i mean to make the pdf file with macro?

I mean how is it possible to make this form like a PDF file? I mean how to send this form to a PDF file Thank you

thank you do you know how can i show each of rows of a datasheet in a pdf format?