Search results

I want to be able to distribute an Access 2010 database to people who don't have Access. I suppose the only real way is to use MS Access 2010 Runtime. As I have never used this can some kind person point me to a good tutorial (preferably video) on how to use Microsoft Access 2010 runtime please.

I used to be able to set up a text box that allowed the user to view each file or record as a loop search was called. I suppose a bit like when using a registry cleaner it shows each entry as it searches and checks. Can anyone point me to a tutorial that shows this or can advise how I can do...

I am currently using MS Access 2010 (Beta) which I am assuming is similar to the 2007 version. In earlier versions I could re-size forms for the final release version by dragging the form to the size I want or manually changing the width, height etc properties. In the newer versions there soes...

On my form the User needs to input a new Job_Reference (typically something like SMI09_1) where the SMI is the client code, 09 the year and the _1 the reference number for that year. As the user can't necessariy know the clients last reference number I want the form to show a message if a...

I have a form based on a table where some fields are required to be filled by the user. If the user moves on to another record the default MS error message box is shown. What I would like is a friendlier message box that shows the field name (by its label name) that needs to be filled and...

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

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

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

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

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