Search results

Hello Access Legends! One of the directors of the company I work for would like to have a large screen display the current status of jobs that my database stores. To cut a long story short the table he is interested in is called tblJobsLogging and is updated manually by our laboratory on a...

THANK YOU VERY MUCH! No idea why I didn't think of that. Works a treat!!! :)

Hello Access World I hope you can help me! I am new to VBA and want to have one command button execute multiple commands. I wont bore you with all of the code I have but basically what I want to happen is this. Click Button Execute If Statement 1 Then Execute If Statement 2 etc... I...

Works like a charm! Thanks Cotty.

Hi all, Does anyone know an easy way to use the enter key to automatically run a macro? I have a login form which works fine. However, at the moment the user needs to type in username and password and then manually click on a 'log in' button. What I would like to happen is that if the user...

Actually I just sorted it. I pasted the text in wrong! Thank you for your help!!!! Kevin.

Hi Pr2, thank you for you assistance. I pasted the code and now it highlights the first *end with* and tells me I have a syntax error. Any ideas?

Hello everyone, can someone please point out what I am doing wrong? I have some VBA which I have attached to a button. When the button is clicked the VBA should look to see if a specific text box on a form contains "None" and if so it should open an email which pulls fields from the open form...

Hi Access World, I didn't know which one to put this in so went with general. I work for a company where the directors want a new way of dealing with scheduling. The large database I have created for them is capable of storing holidays and offshore dates. They would like MS Project to pull...

Hi guys, I am using the transfer spreadsheet command in Access to export a query I have to my desktop. Here is the code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qrySampleSubExport", "C:\Users\kevin.field\Desktop\Test.xls" It all works perfectly, but now I need you...

Sorry, fixed it now. It was the fact that the MaxDate wasn't setting as a date. I used CDate( in front of it to force the result to format as a date and this fixed the issue. Thanks!

Hi all, hoping you can help me here. I have a query which has a calculated field called MaxDate. This field is the max value of three other fields in the query, showing the maximum of those dates. It works fine but this field doesn't have any format set for it. I want to then create another...

Hi everyone, Does anyone know how I can get the max of 5 textboxes I have on a form? The textboxes are bound. For e.g. I have 5 textboxes (just call them text1 - 5) and each has a date in it. I want another textbox (unbound) to calculate the maximum date of the other 5. Is this...

Actually ignore the above. Managed to work it out using is error functions to supplements the NZ's. =IIf(IsError([rptSubReportInvoiceAdditionalCostsVAT].[Report]![Total]),"0",Nz([rptSubReportInvoiceAdditionalCostsVAT].[Report]![Total],"0")+...

Hi all, im wondering if you can provide a little help on this probably trivial matter. I am struggling to get a total box on an invoice I have built to function correctly. The invoice total is a sum of four seperate total fields which are located at the footers of four sub reports in the...

Sorry bud, all out of ideas then :( it looks very much like VBA is to blame here and my knowledge is limited...

Hi bestofthelousy, Just a suggestion as i am no VBA expert. Cant you simply tell the query that the report it based on to reference the form? That way you wont need to clever code the VBA? All you will have to do is create the VBA to send the report? I have used this technique more than once...

pbaldy you are a legend amongst men. Thankyou very much, the code is now working sweetly!!! :)

Thanks pbaldy, I am trying to figure this out as well I promise! I made the changes you suggested. When I click on the button it comes up with an error in the VBA editor: Compile Error Expected End Sub It then highlights the top script of the VBA code in the debugger which is: Private...

Hi all, First up let me thank everyone who is on this forum for thier total commitment to hepling novices myself create functional databases. You have all been a great help over and over again. However, I now need to ask for assitance again from someone who has the time to help me. I am...