Search results

  1. E

    Outlook email for data entry???

    I'm send out about 1,000 emails to employees via a VBA code. I need to find a way to have them reponed in a certain format so I can import the replys. They email will be a sarvay of employ info. I do know that the Outlook forms has been turn off as I can not use it. Is there any way for me...
  2. E

    Data Access Pages for Data Entry

    I need the basic of how to creat a single data entry DAP that populates into a single table. I have one day to do this and I have never used DAP. I used the wizard and it created the page (all 8 fields), and set the DataEntry property to True, but I can not enter data. What am I missing...
  3. E

    Execute a Command Button on Diff Form

    I have a main form that contains a sub form. On the main form I have a commad button that refreshes and requeries the sub form. I also have a command button that opens a popup form to add new contracts. What I would like to do is have the popup form execute the requery command button on the...
  4. E

    FindRecord

    I have a popup form that is opened by users to add a new record into the table. When the popup form is closed I have if saving the records. What I want it to do is requery the main form and find the new record just added to the table. Here is my code tha is not working. If Me.CompanyID <> ""...
  5. E

    WorkGroup

    :confused: I have a .mdb app that I want to set up to a workgroup. I have a workgroup in the same folder/network on the drive that has a different name then my system.mdw. I have added a new Admin to my .mdb app and removed all the rights of the old Admin. When I run Security Wizard, it does...
  6. E

    WorkGroup: Incorrect Password or UserName

    I have set up a workgroup for an Access 2K db. It is on a network server (NT 4.0 sp5 with Novell). I created the shortcut and put in the path to both the work group and db: "C:\Program File\Microsoft Office\Office\MSACCESS.EXE" "\\Path to .mdb" /WRKGRP "\\Same Path to .mdw" When I copy the...
  7. E

    Date() as default value is error #Name?

    I have a form in Access 2000 that was updated from Access97. The field Date in the table is set to Date/Time with ShortDate as the format. This table is link to an input form and the first field is Date. I have Date() set as the Defualt Value for this field. If works find on some of the...
  8. E

    Refreshing linked tables with password

    I have 2 mdb databases. One is the backend that hold all the information, while the second has the linked table in it and is the front-end. I'm trying to write a code that will relink to the back end if the link is lost for some reason. (The back in is on a cd.) All of this is read only...
  9. E

    Page size change on export

    I have a report that is in Legal Landscape. I export to a snapshot(to save the lines) and e-mail it to my client using a VB program. I have save the setting to Legal and most of the time it exports OK. Sometimes when I export the report it changes to Letter from Legal in Access. Is there a...
  10. E

    Import file from excel

    I have a Access DB and an Excel spread sheet. What I need to do is have the information, that is enter into the spread sheet, append to my DB. I did not design the spread sheet, and I know there is no table in the spread sheet. This is in a multi-user envoriment. When the user enters info to...
  11. E

    Help with recordset code

    This is my code. Private Function GetSum(GLORG as String) Dim rst as Recordset Dim stSQL as String stSQL = "Select MonthSum Form CMonthqry Where GLORG='" & GLORG & "'" Set rst = CurrentDB.Openrecordset(stSQL) Get GLORG = rst.Field("MonthSum") End Function GLORG is a six diget number and...
  12. E

    Tab to top of new form

    I have a data entry form. Sometimes the entry person gose to the next record in the middle of the form. When they get to the next record the cursor is in the the middle of the form. Is there a way to have the corsor goto the top of the form on each new record???
  13. E

    stSQL has to many parameters

    This is my code: Private Function Getpan_wt(id As String) On Error Resume Next Dim rst As Recordset Dim stSQL As String stSQL = "Select display_text From qryPC_BulkMois Where id='" & id & "' And res_name='" & pan_wt & "' And rep_num='" & Me.rep_num & "'" Set rst = Current...
  14. E

    #Error in text box

    I have a text box were the control source is =Getusrlbl1([sam_id]). When the VBA runs I get a #Error on my report. The code is: Private Function Getusrlbl1 (id As String) On Error Resume Next Dim rst As Recordset Dim stSQL AS String stSQL = "Select usrlbl1 form qurPCincompleteTest where...
  15. E

    Recordset Error?

    I'm developing a report and have this as a problem, can anyone help me??? I have 3 differant tables that I am using. One called test_def then sam_log and sam_res. I have a query called qryPC_IncompleteTest that has sam_res in it and primary key is sam_id. In another query2 called...
  16. E

    Find last months first and last date.

    I've developed a report for a company. In the header they want last months first and last date to print. When finished the report will generate itself on the 5th of each month for last month totals. How do I get last months first and last date to print automaticly in the header? What about...
  17. E

    Automaticly run report on 5th of month

    I have developed a report for a company. They would like to have it print out on the 5th of each month for the previous month. They do not want to even push a botton. How do I get the report to print and how dose it go from Jan. of one year to Dec. of the previous year?
  18. E

    Set Key command to copy text box.

    I have a form that is for data entry. The form is set on Continuous Form. Alot of the entry is redundent such as date and codes, but changes about every five to ten entries. When the info is entered it is about 100 entries at a time. I have a micro set up to copy the info in the provious text...
  19. E

    Autonumber on a report?

    I have a report that sorts stores by thier sales performance. Is report is ran daily and the rankings change from day to day. What I need to do is add in a textbox to the report that will autonumber the stores and they are sorted. The number of store will change monthly. Any ideas?
  20. E

    Auto number in a Report?

    How do I run an Auto Number on a Report? I need for the number to appear next to a name. This is for ranking purpose so I can tall how different items are rank when the report is ran.
Top Bottom