Search results

Ye thanks statsman. I know what Runtime is for it is just I have not used it before and I wondered if there was a good video tutorial for it. Thanks anyway for replying.

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.

Thank you. This looks something like what I am trying to do. I have modified this to: Public Function fShowJobReference(lngJob_Reference As Long) As String On Error GoTo Err_fShowJobReference 'This function shows Job References in a string format Dim dbs As DAO.Database Dim snp As...

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

Thanks for that - also helpful info.

Your welcome

I suppose the first thing to say (admit) is that until trying 2010 (Beta) the latest version of Access I have used was 2002. On the negative side: - The new layout is therefore quite a challenge in terms of the learning curve. Personally I don't like Microsoft's new ribbons. I think they are...

Dear Mr B This is exactly what I was looking for. Much appreciated thank you. For your information and future reference the large round office button no longer is a default view. Instead in 2010 it seems to have changed to a tabbed option alonside other ribbons - called file, with the options...

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

Thanks but I have worked this one out now. No reply needed

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

Thank you Sos.

Thanks SOS, By Value I am assuming you mean the actual name of the text box such as "txtIssueDate". If that is the case how will it pick up any other fields that require the user to place an input? Or am I just being thick?

Thanks gemma-the-husky. Actually it is not so much an error message but a message that states the field must be filled because it is a requied field as set up in the table. As a temporary fix I am using : [Code] Private Sub Form_BeforeUpdate(Cancel As Integer) If Nz(txtIssueDate, vbNullString)...

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

Enjoy, maybe get back tomorrow.

I think I am going to try this again. Thanks for your help but I think my brain needs a break for tonight.

No I originally tried to develop through a query but it din't work. The relationships were unhappy with what I was trying to do. Unfortunately when creating a dataset in the Express Edittion of VB anyway you don't have the options. You select a table and the fields you want to use but as I...

Sorry I am really not explaining myself very well. The form is a VB form. The fields are based on a dataset. The dataset is built from two tables - tblWorkRecord and tblWorkDetails. The work record (Details from dataset) simply has a client ID, Invoice no and a field for the date an invoice is...

No The trouble is that I really don't understand how this VB Express Edition permits changes to columns in datasheet view for subforms in the main form. I have been trying things like "Me.TotalMinutes = DateDiff("n", [Start], [Finish])" but I know this is wrong.