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

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

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

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

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

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

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

Hi all, hoping you can give me some advice on a combo box issue I have. I have places a combo box on a form to allow a user to select a well which has been assigned to a project. The table the combo box refers back to is tblWellsAssigned. The table has a project ID field, a well ID field and...

Hi all, I am looking for some advice if possible on a project management database. I am currently speccing this out at the moment and getting some tables built. My big issue comes when I get to billing and invoicing. To give you a headsup, the company I am building this for does well site...