Recent content by CraigDolphin

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

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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