Search results for query: *

Fixed it. I needed to Requery the main form to get all db changes by other users updated. I thought as the Autonumber field was incrementing without error that I didn't need to do this. Cheers.

The title of this post should be CAN'T goto new record. Sorry!

Hi all, I have a split Access2007 db with ACCDE front-end. With one user all is good. With 2 users it's almost all good...I wonder if you can help with this scenario: Both users create a new record at the same time. The db assigns IDs OK and both records create OK. There is a combo box on...

You are not going to believe this! I'm really sorry guys but I'm still getting used to Access 2007. I was happily pressing what I thought was the Preview Button but it was the Report View button! Do a print preview and it is working after all!! Sorry guys - thanks for your efforts though...

Nope - doesn't work either. This is really weird! Just in case there was something strange happening inside my db I have created a new one - single table, 2 fields only and tried again, Still doesn't work. I'm sure it should - anything new in Ac2007 that might be different?

Tried that too - doesn't work either!

Hi guys, I have a really basic table of team players (ID, PlayerName). I have built a report with tbl_Players.PlayerName in the detail section. When I run the report I get the full list - as expected. Now, I add the following code to the OnFormat property of the detail section: Private Sub...

Hi all, I am using a function in MS Access to send a fax via Microsoft Fax on a 2003 server with Exchange 2003 SP2, XP Pro SP2 client using Outlook 2007: Public Function SendFax(strTo As String, strPath As String) Dim MyOutlook As Outlook.Application Dim MyMail As...

Thie single best solution to this for me was to define all control sources in the OnLoad event of the form. Couldn't believe how much this sped everything up!!

Thanks John - will do.

Hi all, I can't seem to find a soultion to this! I know it's an Exchange issue and probably simple... I have been sucessfully using CDO to send SMTP email from my db for some time. Server died recently and I rebuilt it. Now the db won't send to external addresses. No errors at all, just...

Did you get this resolved? I have recently rebuilt my Exchange server and I cannot now use the CDO method to send to external addresses. Internal is fine and I get no errors on external ones, but the email never arrives...

Sorry mate but not being in English doesn't help! Maybe post the SQL in this thread?

Hi mate, I have just done this for my own db yesterday..!! Create a variable for you basic query SQL and another one for the WHERE clause: Dim vSQL As String Dim vWHEREClause As String vSQL = "<your code>" vWHEREClause = " <your code>" 'NOTE THE LEADING SPACE - THIS IS NECESSARY...

Simple as that eh? Thanks PHV - I'll give it a try.

Hiya Max, It's the opening that is sped up and it's pretty noticeable. In the OnLoad if I type ctl_DeliveryStatus.ControlSource = "IIf([TotalQuantity]>[DeliveriesReceived],"DELIVERIES STILL OUTSTANDING","ALL DELIVERIES RECEIVED")" it will error due to the "" screwing up the string. So how can...

Hi all, I am trying to speed up the performance of my db. One way is to define the source of controls in the OnLoad event of a form. I've hit a snag though. One of my controls is a textbox (ctl_DeliveryStatus) with the following CountrolSource...

PHV - you are a genius! Thank you so much. Seems very odd though...ah well it worked - thanks!

Hi all, I have an unbound form that contains a combo box. This combo box has a rowsource set OnOpen: Me.Combo_Suppliers.RowSource = "SELECT DISTINCT qry_rpt_BaseData2.SupplierID, qry_rpt_BaseData2.Supplier FROM qry_rpt_BaseData2 ORDER BY [Supplier]" On 1st run this works fine. However...

How did you get this working in the end? If you used my code be careful of January! vCurrentMonth = Month(Now())-1 will equal -1!! If Month(Now()) = 1 THEN vCurrentMonth = 12 Else vCurrentMonth = Month(Now())-1 should do the trick...