Search results

Many thanks for your attempt at helping. As I understand each picture on a computer has an associated record which contains information on the picture. This includes the pixels, date and time taken etc. etc. It has also the directory path on how it can be assessed. What would be helpful...

Many thanks for replying. The information with the picture is like a record. It shows among other things the name of the picture e.g 001.jpg and the date ant time when taken as a single data bit. I cannot understand from the lead that you have given me how to get the date and time to...

Hi there. Happy Festive season to all access programmers. I am building a database to document and keep a track on a project. In one of the forms I have a text field that contains the path to a picture. An image control on the form has the latter text field as its control source and comes...

To Plog: Many thanks for your reply with the valuable information. Did not realise. Thought the ParseWord was an inbuilt function. I will incoporate it in my Code. Louis B. :)

I would like to get the first word from a field. I have made some research and found that the ParseWord () function is the best for this purpose. However when I include it in a query to get the first word I get an error message ' Undefined function'. Can I get some enlightenment please on...

I have a form with ten field objects that have dropdown entries. Each field has a specific color for its backcalor and white color format for the text. When I start to fill the fields using the drop-down list (combo-box type) the back color and text are maintained. However as soon as I start...

:confused: Dear plog, Thanks for your interest. BarthelIndex is a table with the following structure: Field Name Date Type Idcardno Text Bowels Number (0,1,2) Bladder Number (0,1,2) Grooming Number (0,1) Toilet_Use Number (0,1,2) Feeding Number (0,1,2) Transfers Number...

Basically I have a query called BarthelQuery based on table BarthelIndex. I would like to make a subquery based on BarthelQuery which will be a totals query. I want to group on idcardno. This will group on the idcard of residents. Then I would like to choose the maximum on the date field so...

I have tried uploading the whole database before. It is too big and wont upload. In addition for confidentiality's sake it is not advisable to do so. Is it possible to upload just the tables and the design of the report ? Many thanks again. LouisB

Is it possible to upload the structure of the table "BarthelIndex" and the design of the report in question ? If this is possible then I would like some assistance to do this ? I have tried to do this and agree with you that this is the correct way to solve this problem. LouisB

BarthelIndex is a table containing a number of numeric fields, a date field and two text fields. The date field contains the date on which an assessment of dependency is made. One text fields contains an id number of an elderly resident, and the other text field contains the name of the...

I do appreciate that you are an expert in access and I have benefitted from some points in this post. Many thanks for your reply. LouisB

Many thanks for your reply. I have learnt the following from this issue. If I remove the part of the SQL statement where the parameter value needs to be added, the code works and the report opens. So I do not understand why you say that the report does not return a recordset. What are...

I have made some finding out and found that the code probably breaks down like this as the SQL statement contains a parameter field requiring user entry. The whole point of this code was to pick all invoices of a certain year and report on them. In addition the code has to find out the year...

I have a code which runs as follows. Basically it opens up a Report containg invoices. The user is prompted to give a year so that only those invoices for that year come up for reporting. Private Sub Report_Open(Cancel As Integer) Dim StrSQL As String StrSQL = " SELECT Particulars.[First...

Hello all ye experts. Can you please tell me whether one can use VBA to change a label on a report ? I intend to use text and a variable to insert in the label. Many thanks. LouisB

I have found the reason for my problem. I have originally inserted code into the onl oad event of the form. This code automatically disabled controls on the toolbar. I have recently changed the code from 'enabled = false' to 'enabled = true' (accidentally) and the problem started then...

I am not new to access but I am having an unusual problem. When I press the property button to display the properties on the controls of a form it does not function. The form is in design mode. This has never happened to me. I must have changed some setting maybe in the startup form of...

Many thanks Sam for your patience. LouisB.

Both of you are fully correct. When I developed the db originally i did it with Access 2003. Apparently when I crossed over to 2007 either the program changed the settings automatically or I had done it myself. I did exactly as you suggested. I removed all openform commands form the autoexec...