Search results

Hi I am getting this error on this code. it happens on the CurrentDb.Execute Error 3211 (The database engine could not lock table 'tbl_Names' because it is already in use by another person or process) Private Sub P2_Combo_NotInList(NewData As String, Response As Integer) On Error GoTo...

Hope we all learned something. I did

Thanks all for your help. i got fixed. With CodeContextObject If IsNull(SearchBox) Or [SearchBox] = """" Then ' Clear Filter when search box empty DoCmd.ApplyFilter "", """""", "" DoCmd.GoToControl "SearchBox" DoCmd.SetProperty...

It is a Function in the forms vba

Hi I used "Convert form's Macros to Visual Basic" but i am getting errors in the If(eval) line. I have a text field called SearchBox on a form called Suppliers Function Search() On Error GoTo Search_Err With CodeContextObject If (Eval("[Form]![SearchBox] Is Null Or...

That worked. Thanks so much

I thought this might be a common problem and have a easy fix

Yes it still works, but on some pages it is useful to have

In some reports i do, others i have already taken them out

Hi all How do you stop the Page Header and GroupHeader being repeated at top of page. I have attached screen views to show what happens and how i have the form. Thanks

Hi I am trying to resize a form, but Me.WindowWidth but gives me a negative number on a 28 inch screen but it is ok on my 17 inch laptop i am using Abs(Me.WindowWidth) as a fix but only use's 3/4 of the screen Using access 2010 Does any one know why. :confused:

Yes i get a 1 to 1

One table is called Exhibitors with a field called ExhibitorID, AutoNumber another is called Finance with a field called Fin_ExhibitorID, Number Both are primary keys

Hi i am using the following code to create a relationship. But it creates a one to many, and i need a one to one Public Function CreateRelation(primaryTableName As String, primaryFieldName As String, foreignTableName As String, foreignFieldName As String, RelationshipName As String) As Boolean...

not to me.

yes SectionID does exist in both tables Both tables are the same except some of the data is different. I need to keep the judges names before the data is removed from [Sections] and replaced with the data from [Section_new]

This code won't work ether. Cannot find input table db.Execute "INSERT INTO Sections SELECT Sections_New.* FROM Sections_New;" is it because Sections_new is in the current DB and sections is a linked table what code should i use to tell the difference between the 2 db's and table's

Yes this works CurrentDb.QueryDefs("qryKeepJudges").Execute But how do i do it with the code strsql = "UPDATE Sections_New INNER JOIN Sections ON Sections_New.SectionID = Sections.SectionID SET Sections_New.Judge = [Sections]![Judge];" db.Execute strsql

This Works DoCmd.SetWarnings False: DoCmd.OpenQuery "qryKeepJudges" DoCmd.SetWarnings True But i am trying to learn how to do it with db.execute

I haven't done that before. I will try