Search results

Thanks very much guys, great answers, problem solved. Regards Melt

Download the attachment in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=47651 Regards Melt

Hi all, How would I pull the first occurance of a number from a string, the string is variable length. Regards Melt

Thanks very much Paul. Regards Melt

Hi all, I want to run some code in response to a new record being added. Behind what Event should I put my code: If Me.NewRecord then 'some other update code End if Thanks Regards Melt

Hi, thanks for the replies. From the ASCII chart it looks like Oct077 which is a question mark, except mine has a box around it. I'm using Tahoma font, I've tried changing it, it's still there using different fonts. Does anyone know how this has been created in the table? Regards Melt

Hi all, I have a report where question mark symbols have started to appear in a report (see attachment). In the Sql Server table I can also see a square symbol character, and I don' know where that is coming from either, anyone seen this before? Regards Melt

I just wanted to update thread with a fix to this problem. On an unbound form, I'm creating dynamic sql/query through code and then setting the recordsource of the form, when no records were returned all the combos go blank. The fix: Add a textbox to the form and set it's controlsource to...

I think the quickest way to do this is to make two identical subforms which have the different queries, then set the source object of the subform on the Master form like this: Click button A code: Me.mySubFormName.SourceObject = "subFormA" Click button B code: Me.mySubFormName.SourceObject =...

This might help. You could put four hidden controls on the main report and check if each of the sub reports 'has data' using the following snippet for each sub report =IIf([mySubReportName].[Report].[HasData],1,0) So, you have 4 control with 4 values, either 1 or 0, write an if statement that...

Thanks Uncle Gizmo, that's a workable solution.

Thanks for the reply, I know how to add my own custom ribbon, but I still need to be able to enable/disable some buttons for certain security groups through code. Anyone else got any suggestions?

Hi, I need to be able to disable buttons on the Access 2007 rippon, can anyone tell me how to do that please? This is a secured database so depending on the group I want to enable/disable some buttons, thanks. Regards Melt

You hit the nail right on the head Dave --- the printer selected was marked as 'offline', setting to a new default printer sorted it. Thanks very much, never would have got that. Regards Melt

Hi all, I have an app running on a Terminal Server. A problem has cropped up recently where none of the the reports will open in design view or normal view, with no error messages. These did work so I'm thinking it might be some type of windows permissions error. I've also noticed I can't make...

Hi Bob, thanks for the reply. The problem with that is, this form stays open all day and user are constantly filtering for data using a number of unbound combo boxes at the top of the form. Regards Melt

Hi jal, Thanks for the reply, made some progress with your reply. If I comment out: 'rstRecords.Close 'dbs.Close 'Set rstRecords = Nothing ' Set dbs = Nothing ...then my recordset is applied to the form and the data displays, however is this not going to cause memory leak...

Hi Pat, I do want to change the forms recordsource, but I need to check if records are being returned. If there are none I run a qryNoResults query instead. I thought that since I've opened a recordset to check for records, I should then be able to apply it to the form and save the overhead of...

Hi all, Can anyone tell me how to assign a recordset as a data source for a continuous form? I'm using Set Forms("frm_OrdersSummary").Recordset = rstRecords, the screen flashes but then the data disappears from the screen for some reason. Regards Melt Dim dbs As DAO.Database Dim rstRecords...

OK I got this coded myself, not to difficult after all. Dim qdf As dao.QueryDef Dim dbs As dao.Database Set dbs = CurrentDb ' create connection string Dim strConnect As String strConnect = "ODBC;DRIVER={SQL Native Client}" _ & ";SERVER=server_name" _...