Search results for query: *

Molby, try this: I found this code in tek-tips forum (Thanks to all) and I'm working with it It works fine if you know the cell you want .If you look for last cell the code works but you must close access before open excel.I don't know why!!! Dim objXL As Excel.Application Dim objWKB...

I use this code to syncro 3 databases and it works fine. with scheduled tasks I make this form open at night to run the code. I hope it helps you Dim dbs As DATABASE Private Sub Form_Open(Cancel As Integer) Dim strdbname As String Dim strsynctargetdb As String strdbname =...

Hi I have been tring your code and I have adapted it, so this one works fine. however it don't work if we hqve a msg were we have pasted some excel cells. Let me know if it works for you. Dim ns As Outlook.NameSpace Dim objApp As Outlook.Application Dim ffldinbox As Object Dim emailBody As...

I think better way is the function I use (that I learn in tek-tips forum - Thanks to every body) Function LastOfMonth(InputDate As Date) Dim d As Integer, m As Integer, y As Integer If IsNull(InputDate) Then LastOfMonth = Null Else d = Day(InputDate) m = Month(InputDate) y = Year(InputDate)...

Herb, thanks for interest. I do compact twice my DB. Ten minutes ago I made again what I told before. 1 -Compact twice the DB - 20996KB 2 -Made a regular DB (non replicated) - 6124KB 3 -From that one made again two replicas:The MASTER -10.885 KB and one replica 12686KB. That's what I do not...

I use a replicated DB for 3 years and so far with no problem.However there are one thing I would like to nkow. My DB is 20MB size. From this DB I made a non replicated DB - 4MB Then, from this one I made again a replicated DB an the size is just 10MB. Why this change of size?? Garrido

And don't you have a table named "TableName_Conflicts"?

I'm not a expert but I work with replicated DB. You must have a table named MSysError.Take a look to it and may be it have a record. Hope this helps Garrido

I have this and it works If fOSUserName() = 378950 Then Allow_ByPass_Key (-1) Else Allow_ByPass_Key (0) End If I can use the shift key the others users don't I hope it helps Antonio Garrido

Yes you can. Just like another DB. The problem must be another one, even with replicated DB when you right click on the toolbar area or goto View, Toolbars you can do what you want.

I don't like to give up but sometimes.... as you see in the example I give and in the example of Craig0201 the problem is I have no records for some columns headings!For 2001 I have I have x records in column heading1 and none for column heading2. Any way I must keep trying Thanks a lot. tatarrila

To Ghubbell As LarryDeLaruelle says nz don't replace nulls with zeros. unfortunally I must stop-I can't do what I want. Thanks every body anyway Garrido

to ghubbel: I can´t do what you sugest. in this case - crosstab query - I have no record for some columns headings: column heading1 column heading2 2000 20 30 2001 2 (empty) Is clear the problem? To Craig0201 (is your problem too?)...

to ghubbel: I can´t do what you sugest. in this case - crosstab query - I have no record for some columns headings: column heading1 column heading2 2000 20 30 2001 2 (empty) Is clear the problem? Garrido togarrido@hotmail.com

It´s a problem! To Larry De Laruelle: it works if there is any value in ALL column heading for some row heading. In my case, in one Row heading (year 2001), I have one value just for one column heading.The others columns headings for year 2001 are empty. So in my graphic for years 1999,2000 I...