Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: janerussel
  • Content: Threads
  • Order by date
  1. janerussel

    export comma delimited query to outlook email

    Can someone tell me how to export a query in a comma delimited format to an outlook email. I would want to do this programmatically using a button. Is Access capable of this.
  2. janerussel

    Additional parameter text box popping up

    I have a report based on a query that includes a filter value from a form text box. [forms]![frmMain]![frmSubMain]![frmReports]![txtDept] If I run the report from my PC, I type the value in the text box "txtDept" and click the button to run the report, it displays perfectly. If I run the...
  3. janerussel

    Pop Up form filters underlying form

    I have a modal pop up form for creating a new employee. The form requires FName, LName fields and has an auto number field for the unique record. When the record is saved and the form is closed, I want to go to the new record in the main form which is the last record in the dataset. How can I...
  4. janerussel

    Format text in Pie Chart Key

    I have a report based on a stored procedure from SQL. In the report I am including a pie chart. The chart key displays what the various colors in the chart represent. This is what the key displays. I have described the color where in the key it shows a color square. blue Sum of...
  5. janerussel

    Command using SQL statement

    I am using a SQL statement for my record selection and am including a pie chart graph in my report header. The key in the graph displays the following: Sum of command.Carpool 25% Sum of command.Bicycle 30% Sum of command.Walk 25% Sum of command.Vanpool 10% Sum of command.Transit 10%...
  6. janerussel

    Count mode values for pay period

    I have a table for tracking transportation mode to work for each pay period. There are five modes 1=Transit, 2=carpool, 3=bicycle, 4=walk, 5=vanpool The pay period database fields are below. A number is entered for each day representing the mode. I would like my report to count the modes for...
  7. janerussel

    Calculate current Pay Period on form

    On my form there is a "Pay Period" field. I want to look up the current pay period from a sql table "PayrollCalendar" When the form opens I want to populate the text field "PayPeriod" on the form with the current pay period using the StartDate and EndDate from the table. It can either be...
  8. janerussel

    Print Preview problems with various users

    Hello; I have a report that prints from a command button. The report is set like this. DoCmd.OpenReport "rptZeroHours", acViewPreview On my PC the report prints at a zoom 100 and I can click to zoom in and out the way it should normally work. On some of my other users PC's the report opens...
  9. janerussel

    Print Preview ZOOM

    I have a report that goes to print preview by default. One of my users gets a default zoom size of 25%. How do I get the report to always display at 100%
  10. janerussel

    Print Page Setup Not showing for one user

    I have a group who are using the same application. A report that they use regularly has been set to print preview. At the preview, the users will go into the page setup from File on the top menu. They will generally print a range of pages from the report. This one user tries to access page...
  11. janerussel

    Missing Linked Table Manager

    I have Access 03. I have reinstalled making sure all of the advanced features are selected and I still do not see any of the tables in my db when I use the linked table manager. If I select all and refresh, it processes as though all of the tables are refreshing and gives me a message saying...
  12. janerussel

    SQL table anomaly

    Hello; I have an Access 03 database front end with a SQL2k backend. The backend was previously Access. The odd thing is that one of the tables will only allow me to delete records that were entered in the database prior to upsizing to SQL. If I enter new records directly to the table, and...
  13. janerussel

    Navigation buttons that don't allow new records

    Hello; I want to use navigation buttons, but I don't want the new record button to be available because I have written my own procedure for adding new records, do I have to create my own custon buttons, and if so can someone direct me to some code to do this.
  14. janerussel

    Can't Delete Record in Subform, SQL backend

    Hello; I'm really struggling with this one. I have upsized my Access 03 backend to SQL 2k. My Access 03 front end has a main form with a subform. Records that are in the subform prior to the upsize can be deleted. Any new records that I add to the subform cannot be deleted. I get "The...
  15. janerussel

    Record Locking on File Share - HELP please

    Hello; I have an Access 2003 database used on XP that has a SQL server 2000 backend. I want to put the front end on a file server, but when I do my users are not able to save edits and sometimes second or third users are locked out by ADMIN (the first person who logs into the front end). When...
  16. janerussel

    Update Combo Box on Main form when record added to another form

    I have a utility form which is a modal popup form opened by a button on my main form. The user can update job titles, job descriptions, etc. by clicking a button on this popup form (these buttons open small popup forms based on individual tables) When a new record is added to one these...
  17. janerussel

    Upgrade to SPS2003 - migrating team svcs sites

    We are planning to upgrade to SPS2003. From documentation it will install SPServices. Will it seamlessly migrate our existing team services sites? I cannot find a definative answer on this. Does anyone know where I can find some good documentation on this subject? Thanks
  18. janerussel

    Pass number range values to table from form

    I am trying to pass these values to a field in the underlying table. This doesn't seem to be working. How would I write a CASE statement for this If Forms!frmSrScreen.Age.Value < 75 Then !VulnA = 0 ElseIf Forms!frmSrScreen.Age.Value > 84 Then...
  19. janerussel

    Use part of a text string to populate another text box

    On my form, I will be requiring a SSN (social security number). I have another text box that will contain the last four characters of the SSN (text field). How can I automatically populate the four character field from the text in the full SSN.
  20. janerussel

    Disable mouse scroller on form

    I have a data entry form with a list of questions. If I scroll with my mouse wheel I go from record to record on the form. I want to disable this action so that the user will stay on the current record. I have set the form cycle to current record or current page, but neither works. Any...

Part and Inventory Search

Back
Top