Recent content by andrewsmith

I have tried to implement a compact every 10 imports but it is telling me the linked file is opened. How does one go about closing a linked file?

I'd still need to know when to call the compact function. It looks like the file size doesn't refresh properly while the code is active

I have an Access DB with a whole load of file imports coded in VBA. The files are a mixture of CSV and Excel. The system was originally coded in access but we are in the process of migrating to SQL server due to file size issues. However, the imports are still in Access and they write the...

It was bound to a query but I needed to query the query! Thanks for your help!!

Just sorted it! Turns out all I needed to do was change the subform data source to a query with the filter in its where clause and hey presto.

Just for clarification - if I open the frm_searchCandidates form for the same search record but from the navigation pane and not the form the erroneous subform rows are not there.

I have just taken a couple of screen grabs to help describe whats going on. The first form is pouplated with job details (no 1 in zip file). On here the Roles subform displays correctly. When the user clicks "Candidate Search" the code posted above is run and the frm_SearchCandidates (no 2...

The database allows a user to create searches that can be saved. The search criteria basically build a query on the fly. They can be a combination of matched attributes, matched search words, salary ranges etc... all of which can be and/or ie it could be a job which is in liverpool or...

OK - I'll try and explain this better as reading through my posts I haven't done a very good job. The database is a contact management system for a recruitment consultant. My DB holds an attributes table. This holds an Attribute_ID(autonumber), Attribute_Type(text, limited to 3 options)...

Both are autonumber fields. as are all _ID fields in my DB. For clarification if I open the form frm_SearchCandidates - it shows the correct search ie it is for the correct Job_ID and search_name. The three subforms on frm_SearchCandidates are on a tabbed control and show records for the...

OK - I have just written some code which opens a new form with similar issues. The code is as follows Private Sub cmd_CandidateSearch_Click() Dim strSQL As String DoCmd.SetWarnings False 'clear existing searches strSQL = "DELETE * FROM tbl_Searches WHERE...

Create a combo box bound to the ID. Set the row source type to Table/Query Set the row source to SELECT ID, Name FROM table1 ORDER BY Name; Set Bound column to 1 Set Column count to 2 Set the Column widths to 0cm,6cm (second width can be anything but first must be 0)

Unfortunately as its an autogenerated macro I can't convert. The macro is as follows RunMenuCommand Command: SaveRecord OpenForm Form Name: frm_ClientContacts View: Form Filter Name: Where Condition=: ="[ClientContact_ID]=" & [ClientContact_ID] Data Mode: Window Mode: Normal

Anyone? This is really doing my head in!

Hello, I have an access 2010 db with several forms with multiple subforms. The subforms are based on the same query and are filtered by one of the fields to show subsets of this query data. Basically the query holds 4 fields, a Parent Record ID, attribute ID, attribute type and attribute...