Search results

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...

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...

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...

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 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...

Hi All I am having a problem with below and getting a run-time error 3134 LastOrderNumber = DMax("Order", "Model_types") NewOrderNumber = CLng(LastOrderNumber + 1) CurrentDb.Execute "INSERT INTO Model_types (Order) " _ & "VALUES (" & NewOrderNumber & ")" The field 'Order' in...

Hi I use the following as a time stamp: DateStamp = Format(Now, "dd.mm.yyyy hh-nn-ss") Quite sensibly, every single time I refer to (in different time intervals) the 'DateStamp', it uses current time therefore every time stamp is different. Is there any way to "save" the time stamp so on...

Hi I'm struggling with the logical check in my other code and have created small If statement to check values returned in MsgBox. The problem is whenever Adviser is blank I get VBA returning the Else part of the code. Also when the IFA's name is entered it does work properly with returning...

Hi I have got some basic code that creates an email in which body text depends on a value od my Combobox. I have created a small table with pre-defined Email messages and their descriptions. The comboox on a form referrs to description of an email message and a dlookup returns an appropriate...

Hi I am trying to figure out the way to export results of my query to Excel. The trick is that in the ideal world there would be a new Excel file created every time a value changes in one of the columns. My query is pretty simple: SELECT [Scheduler Trades].ClientCode, [Scheduler...

Hi I have created a database which is turning to quite a complex project (based on my Access skills). I kind of know where the error is coming from but have no idea how to get rid of it... I have tabs which contain subforms which are linked to a form containing tabs with ClientID. The idea...

Hello everybody It's my first on this forum which I have been following for some time now and have always been able to find solutions to my problems. This particular issue is driving me mad. It's even worse that I have managed to sort it today and then changed something and can't get it back...