Search results

  1. CraigDolphin

    This time goodbye is for good

    Well drat. Late to the party as usual. In case you ever revisit this thread Bob, I'm sorry to see you go but wish you all the very best in your new journey. You've always been an incredible asset to this community, and I've learned a bunch from reading your very many posts on Access development...
  2. CraigDolphin

    Access onto Sharepoint?

    My impression is that there are definitely some traps for novice players in Access/Sharepoint integration. I researched this a while back but haven't yet got any first hand experience with it. You may find these videos helpful...
  3. CraigDolphin

    Help with a form vba code

    There are potentially many ways of handling this. One would be to use a random number generator function to randomly select which WreckerID was 'selected' and used to populate the WreckerID control/field when you start filling in your accident form. 'Air Code assumes the table name is...
  4. CraigDolphin

    i need a access form design

    Table design is definitely the right place to spend a lot of time thinking and planning and failure to properly normalize your table structure is the biggest problem for database design. But I also think that table design can be informed by expected outputs, such as reports and graphs and...
  5. CraigDolphin

    Relationships and referential integrity in linked/imported data DB's

    Thanks for clarifying your situation. Sadly, the fish was live-exported to Japan and went under the sushi auction this morning. If your original data source is a database, and those tables with 50 columns are fully normalized then you're hosed considering Jet's limitations IMO. I agree with...
  6. CraigDolphin

    er diagram

    If you open the relationships view you can add the tables and setup the relationships between the pk/fks of the various tables. Then you should be able to generate a relationships report for the database that will allow you to print off the ERD.
  7. CraigDolphin

    Relationships and referential integrity in linked/imported data DB's

    Responding to this could be like opening a right-royal can of worms. But here are my general thoughts. What are you doing storing massive amounts of historical data in Excel? The remedy for this involves a slapping and a large, wet fish. After that you ought to be in a place where you are open...
  8. CraigDolphin

    If statements to set parameters in a QUERY

    This would be one simplistic VBA approach...this assumes you have the DAO reference set in the VBA editor. Private Sub Check0_AfterUpdate() Dim strSQL as String Dim qdf As DAO.QueryDef If Me.CheckBoxName Then 'use a criteria strSQL="Select * from...
  9. CraigDolphin

    Database on iPad and Cloud help?

    For the benefit of anyone else with the same issue: there actually is one way to run a standard Access application on an iPad besides the browser. But it still requires internet connectivity and for access to be available via a citrix application gateway that you have available to you. Then...
  10. CraigDolphin

    Formatting in Number Field

    Set the format property of the field to fixed, and specify the number of decimal places you want in the Decimal Places property of the field.
  11. CraigDolphin

    Floundering!

    You would ordinarily put the list of choices into a separate lookup/entity table, and only store the key value from that lookup/entity table in the main data table. Recall that the rowsource for a combo can refer to the lookup table, while storing the value in the field of the main table to...
  12. CraigDolphin

    How do I add records using a form ?

    But M$ does permit you to add data to related tables, you just need to use forms/subforms. Because the pk of the main form gets copies to any data in the related tables, it actually makes life a lot easier than programmatically adding data. That said, there's nothing to stop you using vba and...
  13. CraigDolphin

    Question access error messages

    Yep...set a trap in your error handling routine. Something like... On Error GoTo Err_Image85_DblClick <Your VBA here> Exit_Image85_DblClick: Exit Sub Err_Image85_DblClick: If Err.Number = 12345 then Msgbox "Your Custom Message here",vbinformation Else MsgBox...
  14. CraigDolphin

    How do I add records using a form ?

    Hard to comment without seeing the SQL of your query....and even then, my ability to cold read SQL is shaky :P Thankfully there are much cleverer chaps and chap-esses here who are better than me at that. However, if I were to take a guess, you've either got a totals query (using group by, sum...
  15. CraigDolphin

    Formatting in Number Field

    Make sure the numeric fieldsize property of the field in the table is set to either single, double, or decimal, not integer or long.
  16. CraigDolphin

    Function works - except with a criteria!

    Glad you got a solution that works for you. :)
  17. CraigDolphin

    Function works - except with a criteria!

    My mistake...I thought test was a global variable or something...on reflection i see it is more likely to be string within your value. In which case: Set rsSubmissions = CurrentDb.OpenRecordset("SELECT employee_submissions.employee, employee_submissions.submission_type...
  18. CraigDolphin

    RoundUP in a control with DateDiff

    Well, there is a simple rounding function (http://www.techonthenet.com/access/functions/numeric/round.php) available in access. However, this rounds up or down to the nearest number of specified decimal places. Thus =Round(DateDiff("y",[txtIssueDate],[txtIncomeStartDate])/365.242199,0)...
  19. CraigDolphin

    Function works - except with a criteria!

    Quotes do look iffy. But I'm surprised the function works at all, with or without a parameter, if that's the problem. I try to use single quotes nested within the double quotes to try to keep things straight. Set rsSubmissions = CurrentDb.OpenRecordset("SELECT employee_submissions.employee...
  20. CraigDolphin

    Function works - except with a criteria!

    That where part looks wrong to me. When I referred to using the Eval function I thought you were using a value from a form as your parameter. But if you are using a simple value of 0 as your criteria, then the eval function won't help. Although I'm not a great native reader of SQL, to my eye...
Top Bottom