Search results for query: *

Hi, I want to link a crystal report to a database. Is it possible? Thanks in advance Ismail

I created a hyperlink that opens a PDF file which contains 5 pages. I would like to print only the first page. I put this code on "On Click": DoCmd.PrintOut acPrintAll, 1, 1, acHigh, 1, True But it's not working. Can anyone help. thanks in advance Ismail

Hi, Does anybody know how to import a PDF file (form W-9) to a database? Thanks in advance. Ismail

Hi, If I have the following table, How do I get the total of: 5/31/05 Minus 05/04/05 and 05/03/05 Minus 05/03/05 Period MEMBID ADMITDT DISCHDT Current 00927771301 05/31/05 Current 00927771301 05/03/05 05/04/05 Current 00927771301 05/01/05 05/03/05 Thanks in advance Ismail

Hi, I have the following table. What I would like to show in the interval column is this: If current then: 5/26/05 Minus 5/20/05 5/13/05 Minus 04/29/05 If Prior then I Only Wish To See Max Of Prior DISCHDT in this case I would like to see 4/29/05. Table MEMBID ADMITDT...

I am getting this error message on this code: Compile error invalid or unqualified reference It does not like the word: .Requery Can anyone help Thanks in advance Private Sub Form_Timer() 'update the data so multiple users get latest data Dim CurrRecord As Variant CurrRecord =...

how can I convert a 97 excel macro to 2000 thanks in advance Ismail

Hi, I have a Macro that run 8 Make Table Queries. Once the macro is done it leaves all 8 queries open. How do I make Macro close all queries when completed? Thanks in advance Ismail

Hi, I have a macro to export 5 queries to an excel sheet. When I ran the Macro it exports the first 4 queries but get stuck on the last one. I ran the query by itself and copy it but can't paste it to an excel sheet. I am not getting an error message it just takes forever. Does anybody knows...

Hi again, Sorry I forgot to include the table I have this table where I am trying to compare ChgDt. I want to see a record that is higher than the one on top of it. example: the only one I want to see in the case below is srn3 because its ChgDt is higher than srno2 ChgDt. mbrrecid srno ChgDt...

Hi, I have this table where I am trying to compare ChgDt. I want to see a record that is higher than the one on top of it. example: the only one I want to see in the case below is srn3 because its ChgDt is higher than srno2 ChgDt. srno1 ChgDt is higher than 2 (Skip) srno2 ChgDt is lower than...

Hi, How can I save an access report in PDF file? Thanks in advance Ismail

Hi, We have a database that's used by 3 people. There is no Security in it. The problem we're having is: if user1 is using it user2 or user3 can't access it. They have to wait until user1 is out of it. How can I make the database allow all users to log in to it and (update, add or delete...

Hi everyone, I want to add # 50 to a field in a table. table1 has one field called MemberContact. the field MemberContact has 50 or blank like this: MemberContact 50 blank blank blank 50 blank blank blank I want to put 50 where there is a blank? Thanks in advance Ismail

Hi, Does anybody know of a code I can use to companct and repair a database once a week. Let's say every Friday at 8PM? Thanks in advance Ismail

Hi, Does anyone know a code to make a report print 2 copies instead of one. thanks in advance Ismail

Hi, I am trying to get the date. I put this: Date() and I get 05/13/2005 9:46:15 AM. All I want to see is 5/13/2005. How do I do that? Thanks in advance

Hi, A user generate a letter from a report, the user needs to put a member ID to view and print the letter. I would like the member id to be stored in a table. Let's say the user generated 10 letter I should have 10 Member id in my table.. How can do this. Thanks Ismail Stop Analyzing life...

Hi all, I need a user to run a macro no more than once a day. if the use try to run the macro the second time, a message box pops up telling the user that he/she already ran the macro once. How do I do this? Thanks Ismail

Is there a way to record the last time a user run a macro? Let say a form with a text box and a button. When I click on the button the text box show me the last "date and time" the macro was ran. Thanks. Ismail