Search results

Currently, I can print one month (in calendar style) per page with events (sick, discretionry day off, vacation, etc) here is the table. tblWork ItemID - AutoNumber UserID - Text EntryDate - Date DateWord - Date WorkType - Text WorkItem - Text Hours - Number Comments - Memo Ga_Number - Text...

I used to be able to create PDFs, automatically save them to a file, and mail them out to people. This was on Access 97 with Windows NT. We've changed to Windows XP and Access 2003. Doesn't work anymore. Part of the problem is that the users have no access to the registry and can only save files...

Access seems to read the code below. If QueryKey("Software\Adobe\Adobe Acrobat\5.0\InstallPath", "") <> "" Or QueryKey("Software\Adobe\Acrobat Distiller\6.0\InstallPath", "") <> "" Or QueryKey("Software\Adobe\Acrobat Distiller\7.0\InstallPath", "") <> "" Then Me.cmdSaveReportAsPDF.Visible...

The code below does not give me any error. I do get a file save dialog box and i put the file name and a message saying export is done. but in reality there is no pdf file saved under what ever directory i told the system to save... Public Sub Print2PDF(strReportName As String, Optional...

dont want to create 36 different query. There are 9 queries for the 9 sub reports embeded in one main report. I want to use some kinda iif command if form # 1 is loaded then used filter # 1. But following code is asking me for start and end date for each form.. I guess i need to use switch. I...

Below is the working version of the code works for single report filtering. say a report called "rptduedate_census2" and i can filter out using form instead of hard coding query of that report (say lastname=form!frmsample!txtlastname). I dont want to hard code query and there are reasons for...

Hi, I am keep on getting Write Conflict whenever I check a check box called chkHCE. There are over 3000 records and it's happening for every records. I would understand if it's happening once in a while but it's happening for every records. Please suggest. I attached the error print shot. The...

How do I search for some help on calcation based on formula table? I inherited this database from an ex employee. The table looks like following. I am sure I have to change it to something legible table name = tblVesting Year 100Immed 1YrCliff 5Graded 3Cliff 0 100...

Hi, Let me start with little backgroud. We are in a retirement or pension business. For example, we are 401(k) provider for ABC, LLL and XYZ companies. Every year we collect census from these clients (participants name, ssn, birth date, hire date, rehire, term and other financial data). Our...

Hi, I am using following code to export PDF and it's working fine. See Sample Database for reference. 1. How do I prompt for location ? (like what drive or directory to save, end user will nagivate this). I tried http://www.mvps.org/access/api/api0001.htm but it's way over my head. Feel free...

Hi, I am using following code to export PDF and it's working fine. 1. How do I prompt for location ? (like what drive or directory to save, end user will nagivate this) 2. How do I prompt a Msgbox "No data to print" if there is nothing to print. Thanks = = = = Working Code = = = = Private...

How can I detect if end user has PDF writer installed or not? I can then hide or unhide my pdf button.

1. I have a Total Query by category 2. I have a report using the same query so I can put the category on the 1st column and the total on the second column. 3. I would like to see % on the third column on my report. How do I achieve that? I tried everything... See my sample from Excel...

Background: ======= 1. My directory Name is N:\ASCDATA\ 2. File name will vary but all with have same txt extension (there are 1400 text files) 3. They will all be fixed delimited and same format (which i can write a function and call the function) My Goal: ===== 1. Click a Button 2. After...

Hi, I have about 1400 text files (fixed text delimited) and all have same layout and they are all in same folder. How can I shot a command in access to import all those 1400 text files information in one table? I dont want to import them manually. I already have the fixed width import design...

I have a field on a Subform and that subform has 4 tabs. I just want to reference one field call chkCensusRequired from this subform. All I want to do on my main form is to read a check box thats on a subform's tab. HELP PLEEEEEAAAASSSSSEEEEEEE chkCensusRequired is a check box in the my...

Hi, I am using following code when the form opens so I can set the my combo box row source according to user access. Any idea, why it's not working. Thanks ===== code starts here ===== Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If User.AccessID = 1 Then...

Hi, Open the Database so you can be on the same page. (Access 97 version) http://www.southernselectbeer.com/database/Log On Cmplx.zip I have a form where I have about 50 buttons (frmReports) Some of the button needs to be password protected. So I created security Table with User ID, password...

I am using a query for a report. But the query is total and memo field is not allowed in the total query. Method1: NOT WORKING I used left function on memo field. Notes: Left([note],255), even if i change the 255 to 99999 it only picks up first 255 characters. Method2: NOT WORKING I can't even...

Hi, Here is the MS Access database where I am trying to implement COM version of send mail. 1. http://www.southernselectbeer.com/database/FE-DV_QA_4 20MIN.zip (try this http://www.southernselectbeer.com/database and download the zip file) 2. Go to "frmSearch" 3. Select "Search" 4. Select...