Search results

Hi, Am planning a bit of an update on our client server front end, prior to switching the backend over to SQL server from access. I want to do this prior to starting the switch so that we don't have to revisit the backend after it's set up, a few tweaks of the front end will be much easier and...

Hi, I have this intermittent but highly irritating issue that causes access to crash - the untrappable and generic "Access has stopped working" I haven't found much on msdn forums or here. I was wondering if anyone else has had this and how they permanently fixed it. The system is set up using...

Hi, Anyone know if it is possible to automate some data management sub routines that are currently run daily by an administrator, I would like it to run each day at midnight. Basically it updates local cached copies of a master backend DB (tables and queries). I would like to do this from VBA in...

Hi, I am building an application for contract bridge bidding and hand evaluation training for our bridge club. What is the most efficient way to code vba to perform a random deal of a full 52 card deck to 4 different positions - 13 cards each. I will need this to be completed as a matrix of...

Hi, I have a user form bound to a query, there are a couple of date fields in the underlying table with no input mask specified - just date time field. at run time when using the built in pop up calendar, date picker, to enter the date it gives an error message that the data value is not valid...

I have this really irritating problem with access 2007: the following code causes access 2007 to crash every time and i have no idea why Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset With rs .ActiveConnection = CurrentProject.Connection .CursorType = adOpenKeyset .LockType...

Quick question on VBA Access 2003/07, I have a VBA class module that loads a single record from 1 of 4 tables (via a main form and datasheet subforms) to another form. Most of the fields are keys however 1 field is memo data type. What data type is best to use for the variable / property...

Hi not sure whether I should post this in XL or VBA forum I have attached an XL file, this shows a randomly ordered List of TAG Nos and the TAGS Parent TAG. This is in an MDB file in a single table. The two columns are PK_TAG - Unique index of TAG Nos and Primary Key of the Table. FLD_PARENT...

Hi, I need to use DAO (which I haven't used for years as all recent apps have been in SQL server or adp files) and can't remeber the syntax for creating a DAO recordset from a paramater query based upon 2 combo box string values on a form. I am absolutely fine with ADO but in this case I need to...

Hi, I have a recursively filled treeview control on a form that shows a concatenated ID and Description. The display is a variable varText nodCurrent = objTree.Nodes.Add(nodParent, tvwChild, strKey, varText) varText holds the display in the treeview Anyone know if there is anyway of adding 2...

Hi, The following code is used to loop through a table and populate a treeview control. (Ms treeview 6.0). There is a tree index field in the table 1 relates to top level. 2 etc. The code loops through adding 1 to the integer each time clearing the recordset and re opening it with up the maximum...

Hi, Does anyone know if there is a simple SQL aggregate fuction similar to SUM or COUNT to concatenate field values into a single field across a one to many join? At the moment I am using ADOX to create temp tables on the fly on the server and loop through two recordsets (one on the group by...

Hi, I have a combobox field on a control that shows a string and the start of a rich text memo field - the memo field then shows in full in an unbound text box. The problem is the div tags are shown in the combo and it is not possible to set this to rich text format. Anyone know an easy...

Can anyone help - I cannot seem to get the following ADO recordset to allow updates. I keep getting a run time error stating that the recordset does not allow updating. The recordset opens fine and I have tried changing the cursor types and lock types to no avail The code is as follows...

Can anyone help - I have to use unbound forms in app - for instances of single objects it's trivial I just set the text boxes values on a single form to properties of the class. The single class instance is populated via ADODB recordsets. methods are in place to reconnect to the db after edit /...

Tried the advanced search but no joy. I have a form that returns transactions between 2 dates using SQL - the 2 textbox controls are named txtStDte and txtFinDte, these are unbound and formatted dd-mmm-yyyy and it all works beautifully. The issue is when a user selects either control (Access...

Hi can any one recommend a good book or URL that documents the windows common controls object model, properties and methods. In particular I would like to use the tree view controls. If any one knows any good third party VB tree view active X controls that aren't too expensive I would be...