Search results

I'm implementing an Access database to catalogue a load of old slides. I know there are other products out there which will do that, but a) I'm too tight to buy anything for this and b) I want the learning experience. One of my main drivers here is that I want to store RAW files only (not...

I'm in the process of changing the way I distribute the FE of a database to many users. Rather than having them download it every time it's updated, I have created a command script to copy the latest version every time they run it. They only need to copy a shortcut to that script onto their...

One of my tables includes a pair of Yes/No fields : [SoldFlag] and [ReturnedFlag]. There are a number of queries which use these flags to search for items which are (Sold) or which are (Sold and not Returned) for example. I am not aware of any performance issues with these queries. Running...

For the last couple of days, all users have complained of poor system performance. Background : maximum 6 or 7 users, split FE from BE, persistent connections. C&R on the BE done weekly, usually knocks the BE file size down from about 95MB to about 75MB. FE set to C&R automatically on close...

This is an error which arises from time to time, but not consistently. Within a main form I have a continuous subform which displays a number of detailed records. The subform includes a number of fields whose contents are concatenations of other fields within the subform. Occasionally, one of...

I have a subform with many fields, most of which are not Enabled (and not Locked either). In Design view, these Disabled Unlocked fields are shown as greyed out. Most of these fields cannot be accessed by the user, as intended. However, one field in particular (ItemStatus) is accessible to...

I have the following code : Dim strBaseFileName As String . . MsgBox "Moving files for " & strBaseFileName & ", " & SaleEventID Call MoveImageFiles(FromStatus, 0, strBaseFileName, ToStatus, SaleEventID) And Public Sub MoveImageFiles(strOldStatus As String, _ lngOldID...

I want to leave my db as an Access desktop app, but make a relatively small part of it available over the web - mainly product data, which is fairly static. So I'm thinking I can export that data to some other format which can then be accessed via a browser. I have implemented web sites...

I have used Access off and on since the mid-90s for fairly trivial applications, but much more extensively over the last couple of years for the development of a system with significant complexity. Everything I have learnt has been self-taught based on a sound background of software development...

I get an intermittent "Run-time error '-2147417848 (80010108)': Method 'Bookmark' of object 'Recordset2' failed" at the Bookmark assignment indicated below. Private Sub SearchForItemID_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(SearchForItemID) Then Set rs = Me.RecordsetClone...

The following snippet works fine : strSQL = "SELECT Customers.CustomerName & ', ' & Customers.AddressLine1 & ', '" & _ " & Customers.Addressline2 & ', ' & Customers.City & ', ' & Customers.StateOrCounty & ', '" & _ " & Customers.ZipOrPostcode, SalesRecords.TrackingNumber...

I was browsing through a thread somewhere here when I came across an old discussion which set me thinking. The poster had a table design which contained a number of dates - let's say they were SaleDate, DespatchDate and DeliveredDate in a tPurchases table (I cannot remember exactly, but I...

For most tables, I use autonumbers as primary keys, always as Long Integers, with "New Values" set to Increment. While I have always been fully aware that the PK sequence could contain gaps (e.g. due to deleting records), I had assumed that "Increment" meant just that, i.e. issued numbers would...

I develop and maintain an operational Access database. To provide various support functions (such as analysis, importing, ad hoc reports, etc.) which are not available to the normal users, I have a separate Support database which links to the operational back-end. Consequently, I often have two...

I want to beef up the error handling and logging in an application. Currently most procedures which have any substance use the On Error GoTo ErrorHandler ... ExitProcedure technique, with individual MsgBoxes reporting the procedure name and relevant parameters. I would like to implement a...

An interesting situation : I was trying to append 1632 records from one table to another (which already had 6822 records in it). No Primary key in the new data table, but two foreign keys in it. The query is : INSERT INTO SalesRecords SELECT ImportJunAug15.* FROM ImportJunAug15; The first time...

This must be sooo obvious; why can I not find what's going on ? When I execute the following, I get a key violation error. strSQLString = "UPDATE OfferForSale " & _ "SET OfferForSale.SoldFlag = " & True & _ ", OfferForSale.fkSalesRecordID = " & SalesRecordID & _ "...

I have a summary form which includes about a dozen fields referencing domain aggregate functions. Only one table is involved, but the form is getting very slow as that table grows. Each domain aggregate function has different criteria. I would prefer to have the form bound to a query which...

If I import a form or report from an old version of my database, the command buttons seem to lose most - but not all - of their color values. "Use Theme" goes to No, while "Hover Color", "Pressed Color", "Hover Fore Color" and "Pressed Fore Color" all go to #FFFFFF, whereas on the old version of...

Access 2013 on Windows 7 .. I have a Main Switchboard form which is Pop-up and Modal. Everything on it is working as required, but if I am in Design View and try to switch directly to Form view, the form disappears and the Access screen freezes - the mouse moves, but no menus or objects can be...