Search results for query: *

Im having an issue with one of my databases when trying to email, we now use Office365 which I cant autoemail from the database, how can I change this code to sens using SMTP Function Mcr_Send_New_Supplier _SendVendorRequest() On Error GoTo...

Hi There, I am trying to email a word document from a server, I wish to do this within Microsoft Access from a form with a button. Is there easy code for this?

Hi, I send out queries in excel format daily from access. The problem I am having some of the queries might return no data (Blank Sheets) How can I set up to auto send queries but only if there is data there (Non Blank)????????

Hi, I need to automatically print Access Reports to PDF and publish on a network server, I have Adobe Acrobat 6 Pro and I have it as my default printer. I am new to VB so can you go easy on me if you are giving me code.

Is there any way I can convert Access Reports to PDF and send them to a local Intranet Automatically?

I Have have a query being exported to microsoft excel, the problem I have is the decimal places are not the same as I have in access, I have the data fixed decimal places. Thanks

Hi There, how can I get a module to run automaticaly, can you have a look at my code and tell me what I need at the start. I will use the module with the Autexec Macro. Sub run() DoCmd.OpenReport "Rpt_GB01 Ex Pefc and Fsc", acViewPreview, "", "", acNormal DoCmd.SetWarnings (False)...

I have two tables in my database, one for customer details and one for products, when entering data into a form I have the customer data then a subform with users entering products. When I am in the query I want to copy and paste some rows of data then change a few details, the problem is when...

Tools, Startup is blank in my database. HELP!

Help! How can set up a parameter query, instead of the parameter box coming up asking for the parameter, I can bring up a combo box so the user can pick from a list to run the parameter?

Im trying to add and subtract months within text box,s just say I have a text box with the function =now() with mmmm format giving me January what I want is to be able to do another text box taking one month off but I dont want to use days like =now()-30

Is there a way to convert back a security database (bak file) to a normal database (mdb)

How can I set up a macro to send a report on the first day of each month?

I have a form with about eleven text boxes, how can I make it mandatory for every box to be filled in, I dont want to do it through the table as there is lots of data already there that is blank. Also I am not up to date in vb

Hi I have a main password form that users have to use to access the database, how can I change the text box to show stars as they enter the password.

I have an append query changing the starting number of a autonumber field in a table, the number goes into the table when i run the query, but the autonumber still follows on from the original autonumber.

I have a query working with the folowing, Start date ??/??/?? Finish date ??/??/?? Then a calculation returning number of days, how can I get it to return all the dates for the number of days? Example it returns 5 days I want to return 5 separate dates

Hi, I designed a database at work and they want to go group wide with it, the IT department put the tables onto sql and the database slowed down, then they used a citrix server now the speed is ok but I am getting a lot of duplicate autonumbers? HELP!!!!!