Search results

  1. L

    Happy Birthday Bob

    Happy Birthday Bob. Hope your day is awesome!
  2. L

    Packaged Access 2007 DB with Runtime

    I'm not getting any error messages and the location and file names are correct. I can't see where I would have the install create the trusted location for the folder. How would I do this please? Thanks for your advice.
  3. L

    Packaged Access 2007 DB with Runtime

    Hi, I have linked my database to the backend which resides in a specific location on C: then packaged the database with the 2007 runtime and the backend file. When I install the DB on another computer, I place the backend file in the same location on C: as per the original link location...
  4. L

    2007 ADE distribution guide

    Sounds like an association problem. Your computer does not know which program is associated with the file so you need to tell it. Maybe try this... From Windows Explorer Tools Folder Options Make an association here between the file extension and Access and it might recognise it. Cheers
  5. L

    Trouble Deploying Access 2007

    Hi, I'm having some trouble with the packaging wizard in Access 2007. I'm going through the wizard and on the page which has the EULA field, the NEXT button does not become active. The only thing I can think of is I'm putting the wrong location in this field. Any advice please? Thank you
  6. L

    Trouble Deploying Access 2007 Database

    To create a certificate:- In Microsoft Windows, click the Start button, point to All Programs, point to Microsoft Office, point to Microsoft Office Tools, and then click Digital Certificate for VBA Projects.
  7. L

    Sum in Query

    Hi, I've done this a thousand time but must be missing something here. I have just changed to 2007, trying to find the value of the sum of one field in a query. SQL is as follows:- Sum(tbl_Variations.[Approved Variations]) AS Total FROM tbl_Variations The result is the individual...
  8. L

    Subform based on query

    Thanks guys! I was referencing the object not the form itself. FormName.Form.RecordSource = "qry_Project" :)
  9. L

    Subform based on query

    Hi, Can anyone see something wrong here? I've done this plenty of times before but for some reason I haved overlooked something and I'm sure it's staring me in the face. I have a form with a combo box named cbo_ProjectName. The subform should populate according to the selection from the combo...
  10. L

    Update Table With Input From User

    Yes that part I understand, I am just wondering about the upate. Thanks for your help
  11. L

    Update Table With Input From User

    Hi, I have a user input form from which the data entered is appended to a table when they click the save button. I would like to call up certain records based on a specific field where the value is equal to 'down' The user needs to check the form and make some changes to that field, then...
  12. L

    Nz returns incorrect total where one value is null

    Hi, Would someone be abe to advise me on this please. I have a query which brings together values of a number of other queries. I then have a field which totals and displays as below. Criteria 1: Total Criteria 2: Total Criteria 3: Total Criteria 4: Total My problem is that where a...
  13. L

    Default value "the previous value +1"

    Could this not be data type autonumber? What is it based on?
  14. L

    Adding Date into Table Title via Make Table

    In your make table query put Now() into a blank field. This will give you the date and time.
  15. L

    Inserting data from Excel?

    Tables - New - Link OR Import depending on what you need. Select the Excel file. Select the worksheet. Just delete what you don't need in the table.
  16. L

    Replicate Only Parts Of A Table

    Thanks for your reply. I ended up solving this by creating a union query with just the necessary fields from the tables (turned out there were five tables with the same fields containing information from different sections of the business) I then created a make table query based on the union...
  17. L

    Replicate Only Parts Of A Table

    In the HR database, I need to replicate parts of a table to a central backend which feeds other databases. The information I need to replicate is in a table which also contains the sensitive information. Due to privacy laws, I don't have access to the full database therefore splitting the table...
  18. L

    What is wrong with this?

    If I do this.. Private Sub JobNo_AfterUpdate() If Me!JobNo = 4999 Then MsgBox "Is 4999" If Forms("frm_Vehicle").Controls("Vehicle_SubFrm").Form.Controls("Driver").Value = "Noddy" Then MsgBox "This is Noddy" Else MsgBox "Yeah it works" End If End If End Sub It will now compile. I...
  19. L

    What is wrong with this?

    Wayne, There are two sub forms. In a control on subform 2 in the after update event, I'm saying if the value is 4999 then check subform 1 to see if the driver is equal to "Name" in the field named Driver. If it is, then give the message. Lady
  20. L

    What is wrong with this?

    Thank you for your suggestions. If Me!JobNo = 4999 I know this part works. I have tried your suggestions with the following but still having a problem And Forms![frm_Vehicle]![VehicleTimesheetSubFrm]![Driver] = "Person's Name" Then .... "Person's Name" is the name of a peson displayed in...
Top Bottom