Search results

Thanks for your help chaps. Much appreciated.

Any ideas how to tackle it? just checked and it only happens with a continuous form, works OK in datasheet view

Now the interesting part- when the subform is opened as a standalone form, I only get one prompt... The prompt only shows once if you select 'Yes' in the first step

I am beginning to wonder whether I should run a repair of my Office package. Just to clarify - this is what I do and what happens: 1. Select the first record - direction Buy 2. Hit delete key 3. I get the first prompt at this point - 'You are about to delete 1 record' 4. Select No 5. The...

Hi I've got a continuous subform which is bound to a local table. The subform has record selectors which are used to delete individual records from the subform. I have noticed that if only one record is selected, the user is prompted to confirm deletion. If no is clicked, the prompt comes up...

Morning I am trying to remove both X & Y axes from the Access modern chart and failing miserably. I am trying to produce a bar chart which looks as follows: Alternatively, if the colour could be changed that would do the trick but I can't see that option either... Nothing on google to...

Ok thanks for the suggestion. Just uninstalled the Visual Studio and no joy. I guess I will have to convert them to modern charts which seem to work. I went with the old type because of formatting limitations of the new chart but I guess I need to start an entirely new topic on that issue...

I can see there was a cumulative update installed yesterday. This however, is on my work laptop and these are managed by the administrator. Just checked o one of my colleagues' laptop and it seems to work fine. The only thing that comes to my mind is Visual Studio which I have recently had...

Hi All of my charts are suddenly broken - all text is overlapping and none of the settings seem to be able to fix it. I have also tried Online repair but that doesn't seem to work either...

Right, I seem to have found a workaround - posting my code below just in case somebody has a similar problem. The solution involves pulling an existing note and appending a note via separate recordsets. Not the prettiest of solutions but does the job: Set conn = New ADODB.Connection...

Hi all I am trying to append text to a memo-style field which already holds some text and failing miserably. Here's extract from my code: Set conn = New ADODB.Connection Set rs = New ADODB.Recordset rs.CursorLocation = adUseClient conn.Open strConnection...

Morning all I've recently upsized my test Access db and are currently learning of various ways of making it running faster. I have got a number of scenarios where I add new records to various tables in VBA by using AddNew with DAO Recordset. My understanding is that currently, when I open a...

OK thanks for this. Basically I've switched from a datasheet view into a continuous form because it gives me a bit more flexibility. Can't really use a single form as I need a number of records to be displayed at the same time. THe underline setting seems to work fine but not how I'd like it...

Hi As mentioned above I've got a continuous form with a bunch of textboxes. What I am trying to achieve is to underline a value of a specific textbox with an on mouse move event. From what I can see the default is that all values of a specific fields are underlined if the mouse pointer...

Hi I have tried using the above but the cursor keep flickering when moved over a text field. is there any way to make it not to flicker?

Obviously I am being thick here... Can you explain how it's done properly?

Unfortunately the data comes from excel export from another in-house system and I can't really do anything about it.

thanks for getting back so quickly. I have created only two columns in above example (Bonds, equities) just to show what I need. In a real life scenario I have got a table with 16 columns and whilst creating 16 queries would work I am wondering whether there is better solution?

Hi all I have spent last hour trying to figure out how to transpose my table and giving up :banghead: My data looks as follows Client ref Bonds Equities Client1 41% 21% Client2 10% 80% I need it to look as below Client ref Asset Class Weight Client1 Bonds...

Hi I have got an existing query which is exported to excel through DoCmd.Transferspreadsheet. In simple terms the query looks like below: Group | Client Group1 Client1 Group1 Client2 Group1 Client3 Group2 Client4 Group2 Client5 Group2 Client6 etc. As some of the groups contain large...