Search results

Hi I created a form and a subform with the same record source. The reason for that is that I have a tab in a tab, and the only way to get that to work is to create a subform. So my Form has an ID field and mu Subform also has an ID field, which essentially is the same field. Now if I try to save...

Hi, I have got a database with linked tables to SQL Server. I would like to use below string to connect to my tables without DSN. I know the string works as if I make a test using the ADODB.Recordset, it connects and returns the result of my test query. But I use it to connect to tables, I get...

Something like this? SELECT tblSupplierContact.ID, [tblSupplierContact].[FullName] & " - " & [tblSupplier].[CompanyName] AS NameCompany, tblSupplierContact.FullName, tblSupplier.CompanyName FROM tblSupplier INNER JOIN tblSupplierContact ON tblSupplier.ID = tblSupplierContact.SupplierID...

Just did it! It works awesomely well. Exactly what I needed. Thank you vbaInet! Here is with my initial SQL for those who might have the same need: I created a table called tblMisc. Created 3 fields (fldLabel1, fldLabel2, fldLabel3). Wrote the text I wanted to appear in the first record of...

It does... Now I need to apply this to my query. I'll try and get back to you. Thank you!

Sorry, I thought I would simplify to focus on the issue at stake. I will try again then. I guess I need to add fields in tblMisc and add them in the UNION query then?

I think I am missing something here. The combo box is blank. I created tblMisc, created one filed called fldLabel and added one record in ("Contractor Name..."). I have not removed the AutoNumber primary key field ID - Should I remove it? Here is the SQL: SELECT tblContractorContact.ID...

That looks pretty cool. I'll try and get back to you. Thanks!

I don't know if I have used UNION to its full extent but I have already built some.

It relates to nothing. For example I have a text box for the company name, I want the mention "Company name..." to appear inside. Then the user has to over-write this text with a selection of the combo box (which lists all the company names)

Yes correct... But since my field is a number, I guess the default value should be a number as well, right?

Hi, Is there a way to create a text default value for a control box that is bound to a number field? I have a combo box that is bound to an auto number ID but displays text. Bound column = 1, Number of column = 2, Column width = 0; 4cm I want to use sample text in all my controls (and I know...

Gina, Since the current record is locked, I can still update it separately through the form... So here is the new code. It works well. Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim db As Database Dim strSql As String Dim dblRate As Double Set db =...

Ok since the current record is locked, I can still update it separately through the form... So here is the new code. It works well: Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim db As Database Dim strSql As String Dim dblRate As Double Set db = CurrentDb...

How to replicate in VBA exactly what the "Synchronize" button in External Data tab of the ribbon does?

It's Saturday night here in HK... Nobody is on our SP. I have no crash. It all works fine. Except that the initial problem I had of record being locked has not been resolved. Whether I use an UPDATE query or the recordsetclone, the result is the same. What I need is to find a way to unlock that...

My fears were correct: When trying this on the Sharepoint linked tables and amending one of the records I get the error message: Could not update; currently locked So I did not gain anything from this compared to the UPDATE query

Ok. This is the code I am running now and it works in the light version. Haven't tried it with SP though but when I add a new record in the continuous form and run the below coed again I get the error message: There record source '|' specified for this form or report does not exist. Is that...

Ok, you are right... It's copy and paste error. dblOPriceR should actually be dblOCostR

Yes the UPDATE query was my first and logical choice. The problem is that those tables are linked to Sharepoint and somehow the current record gets locked. I have tried numerous things to exit from the current record (like subform.form.dirty = false) but nothing helped. The result is that the...