Search results

  1. C

    Please Help - Urgent Issue

    Hi gurus Backgroud: I have built a very simple database which essentially has a form with buttons which shows the results of various queries based on a criteria entered in a text box at the top of the form on separate individual forms . I was having some issues in that some of the forms were...
  2. C

    View query results as a pop up

    Thanks mate. I feel kinda silly having asked now.
  3. C

    View query results as a pop up

    Hi I have a form which users complete to profile clients. I have set up a few queries which are run from clicking on the lables of the fields they complete to show various data to help them capture that information. The form is a pop up form so that when the queries run they sit behind the...
  4. C

    Open query with criteria on current form

    Hello learned ones, I have a form which staff will use to complete their client profiles. To assist them in this endeavour I want them to be able to pull up queries which I have built into the database and whose criteria would be the Client_ID on the form they are currently viewing/editing. (I...
  5. C

    Showing TempVar (User) later in Database ctions

    Hi I have written a database which creates TempVars for users when they login based on tblUsers. I now want to be able to call on this tempvar when, for example, a user completes a case or enters a comment on a particular case. The code used in the login form is as follows: Private Sub...
  6. C

    Autopopulating field on form based on the value of another field on that form

    Thanks I have got to the bottom of this Cheers
  7. C

    Autopopulating field on form based on the value of another field on that form

    Hi I have been playing around with dlookups over the weekend, but I am unable to figure this out. I have a form for entering new cases into my database (call it "Frm_New_Cases") whose control source is Tbl_Cases. One of the fields in this table is "Reference". Now when I fill in the Reference...
  8. C

    Autofill Form based on Static Table Dlookup

    Hi I have been playing around with dlookups over the weekend, but I am unable to figure this out. I have a form for entering new cases into my database (call it "Frm_New_Cases") whose control source is Tbl_Cases. One of the fields in this table is "Reference". Now when I fill in the Reference...
  9. C

    VBA Access - Input Box

    Hi Never mind. I have figured this last bit out. Many thanks for your assistance. :)
  10. C

    VBA Access - Input Box

    Thanks This has worked for the top section of code. The only problem I am having now is that when I enter an existing case ID I am getting a data mismatch error on the following line of code: If Answer = 0 Then The case ID takes the form of Year-Reference for example 2011-1111111111...
  11. C

    VBA Access - Input Box

    Thanks DCrake However the line: If Temp = "" Or Temp = 0 Then 'redirect to main switchboard if cancel is pressed on switchboard is giving a type-mismatch (error 13)
  12. C

    VBA Access - Input Box

    Thanks GlaxiomAtHome This is giving me a Run-time Error '424': Object required Any ideas?
  13. C

    VBA Access - Input Box

    Hi I have an input box which directs users to a Form (Frm_Risk_Profile) to update a Case ID specified in the input box. I only want this to happen if the case ID is present in Tbl_Profiling_Cases. If it is not then the user should be redirected to the Main Switchboard form...
View older results
Back
Top Bottom