Search results

No sorry I think I have either entered the wrong forum or I have not explained myself well enough. I am using Visual Basic Express Edition 2008. Also I am not storing the calculations merely using them on the forms and later in a report.

Thanks but no I have tried to look for this and there is no option for setting the date picker to 0 or -1.

I have a form that uses a dataset based on two tables tblWorkRecords and tblWorkDetails. The work details part is a datasheed as I want a one to many form view and data entry. The form is fine but I want to calculate a number of fields derived from stored data. The first is calculating the...

I have a data entry form with an Invoice sent and payment received fields. These are gained from a fairly standard dataset. The date fields have automatically formed with the date picker option which shows todays date as default. How can I change this so that date fields display blank until a...

I created a database in Access 2010. It works fine but I want to be able to distribute it so I am trying to get to grips with VB 2008 Express Edition in the .NET series. I have created a new project and made a connection with my access tables and queries. Unfortunately I can't edit a table where...

Thank you. It looks like it is going to have to be VB Express which I was hoping to avoid.

Thank you for your inputs. I think I will have to do as you suggest and use one the the VB express editions. I was hoping I could get around the problem of distributing but obviously I can't.

Sorry but how do I compile it in Access.

I hope this is the right forum but please advise if not. I am using Microsofts new 2010 beta version of Access. I want to distribute a very simple database that records time spent ona job and calculates the invoice and prints an invoice report. I want to make an executable file of my database...

Thank you I will try your suggestion.

I have a report that shows work undertaken on different jobs and the time taken for all jobs in minutes. I want to convert the total minutes to hour and minutes to show overall time elapsed. I can do it so it shows hours and proportion of hours i.e. 6.333 where the .333 is one third but how...

Thanks pBaldy. I had made the same mistake and forgot that text acted differently. Appreciate your input thank you.

Sorry I will try again with smaller files. For completeness I show the SQL and record sources I am using The SQL for the frmWorkMain is: SELECT tblWorkRecord.InvoiceNo, tblWorkRecord.ClientCode, tblClients.ClientName, tblClients.ClientAddress, tblClients.ClientTel, tblClients.ClientEmail...

Thanks tried this: Private Sub lblOpenMileageForm_Click() DoCmd.OpenForm "frmMileageMain", , , "InvoiceNo = " & Me.InvoiceNo End Sub But does not work the frmMileageMain is the seconf form (with a subfrm that doesn't show at all). I want to link with InvoiceNo but no joy. Have a look at...

I have a main form called frmWorkMain that has a record source based on an SQL statement from three tables -("tblClients, tblWorkRecord and tblWorkDetails". There is a subfrm that shows (one-to-many) the details of work carried out for a specific job. So for example a Job record may have a...

Thanks to both of you - works a treat

Thanks JPauo I have created a new module and called it ModLoadCursorHand. Sorry to be thick but what do I do with it now. For example if this was an event proceedure for "On Mouse Move" I would simply place it in a sub for On Mouse Move. In other words how do I make it work and what else do I...

I used to be able to change the cursor to a hand shape in Access XP by using the code below in the On Mouse Move event property: Private Sub Label16_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Call MouseCursor(32649) 'Display hand cursor End Sub This no longer...

I have downloaded Access 2010 (Beta) but I suspect my query would equally relate to Access 2007. I have build a report based directly on data in a table. All works fine but in the report I have two labels - one is simply a label with a black background and white text the other is an image (logo...