Search results

Hi all, I have a continuous bound form based on a query (designed to look a little like a spreadsheet). When the user clicks on a check box, I would like the date to be written to the table for the corresponding record. I have this code - Dim ADOrs As ADODB.Recordset Dim strSQL As String...

Hi all, I am now enabling these commandbars (not sure if it is one or all that needs to be enabled at this stage). CommandBars("Function Pivot Table Popup").Enabled = True CommandBars("Function Pivot Chart Popup").Enabled = True CommandBars("PivotTable PopUp").Enabled = True...

Try importing it into a new table instead of an existing table. This will identify if the problem relates to the formatting of the table fields. If the import to the new table works without error, then you need to look closely at how the fields are formatted in each table as I would hazard a...

Hi all, My database has right click disabled (for obvious reasons). I have added a new form which contains a pivotchart. The intention is for the user to be able to build custom charts. Because the right-click is disabled (I assume) - the user is unable to access the 'Field Properties' box to...

Hi redBo, Sorry if this reponse is a bit light on with specifics - I'm at work and not much time to write a reply! Probably the best way to do this is through the use of a command button that firstly imports the data from a specified location to a temp table, then uses an append query to join...

I was reading something, somewhere about using SysCmd to show a progress meter. I'm not sure if this helps or is relevant - but maybe worth a mention. Unfortunately, I have not used it and know nothing about it other than it exists!

Hi all, My apologies first for making another thread on this issue. I have tried all solutions I have managed to locate with no success. I am developing in Access 11. A small percentage of my users are using Access 9. When the Access 9 users attempts to open the database, the 'Outlook'...

Hi & thanks The_Doc_Man, I believe you are pretty much spot on. I have two sets of users - Access 9 and Access 11. I am also using the Outlook Reference - so unload references (& missing) at startup, then reload the correct reference depending on which access version. I now realise that those...

Hi Wayne and all, Sorry about that - was a bit of a panicked post when searching the forum did'nt give me the answer I needed. The issue still remains unresolved. The DB is a split F/E writing to B/E x2. F/E is stored locally, B/E on a networked drive. Basically, when some users click on a...

Hi all, Today some of my users (primarily Access 9 users from what I can tell) have started experiencing weird Crash to Desktop issues. The issue occurs when the user clicks a command button, which in turn should open an unbound form. All other database functionality is working correctly...

A huge thanks The_Doc_Man for the comprehensive response. This has been my first serious database - so a learn as I go project and much rework along the way as I have researched and developed better methods for getting from point A to point B. I have taken some reasonable measures in that -...

So obvious. Thanks Wayne!

Hi all, Hoping for a little help. I am trying to DCount all records in a tblMail where field 'Date_Received' is empty/null. I am using - Me.txtMOustanding = DCount("*", "tblMail", "[Date_Completed]" = Null) This seems to count all records in the table, and not those where Date_Completed...

Check out this thread - http://www.access-programmers.co.uk/forums/showthread.php?t=28669&highlight=sendmail I use Russell's method with the Outlook Object library to send out application 'Admin' messages - such as usernames/passwords, etc. Cheers, Rob

Thanks both for the advice. :)

Hi all, I am work in a medium sized (80-100 people) Government Contact Centre. As some people may know from previous posts, for several months on and off I have been developing a database which could be best described as a 'ticket of work' system for many of our transaction channels. I am...

Hi KyleT, Adding the service is quite simple. Search on either ADO or DAO methods for adding records in this forum. You will find heaps of examples of how to add a record to a table. Something like - Dim ADOrs As ADODB.Recordset Set ADOrs = New ADODB.Recordset ADOrs.ActiveConnection =...

Hi VegaLA, When I first starting importing from Excel I had similar problems. While I cannot recall exactly what I did, I do recall that the problem solution for me definately related to changing the formatting of the excel column. Just an obvious one...if the excel column is formatted as...

Someone may correct me here...but from my experience Access has no native support for scrollbar properties. The closest you will probably get it to build a custom scrollbar - there are a couple of examples floating around on the forum. You could try playing with this as a starting point -...

Hi all, One thing that infuriates me about access (perhaps a lot do with my own limitations as a designer) is that chunky 8-bit feel it has to it. I'm trying to achieve something a little special with some of my forms, perhaps along the lines of the look and feel that you get when using a...