Search results

Thanks Richard! I'll check your function. I searched a few MS Access books and help files but could not find anything. Where did you get this function? Igor.

Is there a way to create DSN (Data Source Name) on local computer programmatically using MS Access? In my case DSN will read SQL Server2000 database. Thanks in advance.

Hi again I do not understand when ID value has increased (when you type it or timer increase itself)?

Just in case did you set TimerInterval=1000 on form property?

If checkcontrolname.Value=True then text1.Visible=True Else text1.Visible=False end if

Select [Bureau],[Section],[Unit], [Bureau] & " " & [Section] & " " & [Unit] As MyMerge from yourtable then follow what I proposed.

Create a command button "Delete Record" and include VBA code behind it which prompt input box. If inputbox equal password then delete record. But first I agree you should set manually or programatically on form_load event: Me.AllowDeletion=False

You forgot to type in your query Select [Bureau] & " " & [Section] & " " & [Unit] As MyMerge and only then there is a way to bound a new virtual filed "MyMerge" to a textbox which must be bound to "MyMerge".

Your combox now should based on Union type query which will contain value "All". Then in VBA code in report describe cases of combobox and change report recordsource on fly.

Use DLookUp function.

I quess on Form_Timer() you need: txtHiddenCount.Requery

Create query UPDATE YourTableName SET PersonName = UCase(PersonName)

Maybe you better of to think of migration data from MS Access db to SQL Server database. You will not care of your db size anymore.

In addition I preffer to set database owner password for every local machine(user), then there is no conflict when you generate reports in Access based on SQL Server. Also I used sql pass through query type to link table or view. Link table or linked view could be attached manually or even...

Query: SELECT DonorID, Count(DonorId) AS TotalDonors FROM YourTableName WHERE YourMoney between 1 and 1000 GROUP BY DonorID Igor Best regards from Russia.

Create textbox Text1 on form bounded to your table field which contains some data. Private Function Encrypt(sData As String) As String Dim sTemp, sTemp1, tt As String Dim ii As Integer For ii = 1 To Len(sData) sTemp = Mid(sData, ii, 1) tt = Asc(sTemp) * 2 sTemp1 = sTemp1 & Chr(tt)...

1) Left(Right([Field],4),2) or 2) Right(Left([Field],4),2) Mid Function is definitly better!! Best Regard. Igor.

When you create each query just include some field which describes your summary. Then in final query merge 3 queries, use this field as joint field and select each summary; select in the same final query virtual filed=Sum1 + Sum2 + Sum3.

How about using the unmatched query from Wizard!!!!!!!! Igor.

Problem 2: Use combination of built-in functions InStr and Len.