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!

Register Log in
  • Congratulations derfloh 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: *

  1. dcanfield

    Possible to write a field next to each record in a table?

    Hi Spyder1000, I had a similar problem where I needed to "copy down" a value to blank cell under it, to complete the record. Below is the code that a friend of mine assisted me with to solve this problem. I then built a macro to run this module. Works great. Option Explicit Option Compare...
  2. dcanfield

    Assign a macro in a Data Access Page.

    Hi Matt, Since I posted my message to your thread, I have found the following tech paper in the Microsoft Library. See the URL below. It has not solved all of my problems, mostly due to my novice ability in programming, but it has gotten me started. I have also found other info by just going...
  3. dcanfield

    Data Access Page - SQL SELECT / INSERT

    I have a form in Access that displays a record from a Data Entry table. I created a module that would select the record from the Data Entry table (as displayed in the form), and append it the Master Data table. I created a macro to run this module, and linked it to a button on the form where...
  4. dcanfield

    Assign a macro in a Data Access Page.

    I am trying to do the same think in ACCESS 2003. I created a Data Access Page, with an OnClick Macro, to do data entry into a table. I want the macro to append the record just created to a master table in the database. When I run it as a form within Access, it works fine. I then converted...
  5. dcanfield

    CommandButton Control activate a macro in Personal Worksheet?

    Hi Tony, I used your suggestion to have my local macro call a macro on my Personal Workbook. It worked just great. Thanks! As that worked so well, and so easily, I didn't persue PHV's suggestion. David
  6. dcanfield

    CommandButton Control activate a macro in Personal Worksheet?

    My manual states that a macro linked to a CommandButton control is located in the code module for the spreadsheet that the Commandbutton is located in. I want my CommandButton Control to activate a macro in my personal Worksheet (as the macro moves data between several different spreadsheets...
  7. dcanfield

    Why can't I change the field format? - Crosstab Report

    Hi, I have a crosstab report. It is breaking down the groups by sales regions. It is then reporting for each sales region the total (SUM) of the outstanding Accounts Receivable balances for that region, and the number (COUNT) of the number of accounts per region. I have also included the...
  8. dcanfield

    Need Macro (or VBA) to Auto_Fill Blank cells

    Hi Ascentient, What I want to do is find all Null (blank) records of a particular field, and then fill in that field with the contents of the same field from the record right above it. (This is done manually by using the CTRL-' key combination). Thanks, David
  9. dcanfield

    importing data from excel

    I have sometimes received this error message, especially when I am trying to import into an existing table. I checked, and all of the column headers in Excel matched the field names in Access, field types matched, so it looked like it should work, but I got the same error message. What I...
  10. dcanfield

    Fill Down Empty Records

    Looks like I need to clarify my original post... I only have ONE table...that has all of the above fields. A better way to describe what I needed might be: I currently have a MS Access table that gives a field value when it occurs for the first time but not subsequent occurrences - ie. the...
  11. dcanfield

    Need Macro (or VBA) to Auto_Fill Blank cells

    Hi, I currently have a MS Access table that gives a field value when it occurs for the first time but not subsequent occurrences - ie. the blank cells underneath, in the subsequent rows/records are assumed to have the same value as above. In essence I'm looking for a macro/global way of...
  12. dcanfield

    Fill Down Empty Records

    I have a situation where I want to find the first record that has a blank (or null) value (in a certain field), and then copy the value of the record right above it. Here is a sample type of data file: Order number Item Number Date Sold 1234 A 05/09/05 1234 B...
  13. dcanfield

    Crosstab Formatting - Summary Fields

    Hi, I have a Crosstab report that I created. It currently shows the following field in the shown sequence $ Total Count % of Total % of Count I would like it to display as: $ Total - % of Total Count - % of Count I have tried to manually move the fields, but that does not work. I...
  14. dcanfield

    Summarize Percents

    Hi, I have a report that groups and summarizes sales by region. Sample data looks like this: Percent of Total Region $ Sales Sales Region A $ 1000 20% Region B...
  15. dcanfield

    Crosstab Formatting of Summary Fields

    Hi, I have a Crosstab report that I created. It currently shows the following field in the shown sequence $ Total Count % of Total % of Count I would like it to display as: $ Total - % of Total Count - % of Count I have tried to manually move the fields, but that does not work. I...
  16. dcanfield

    CROSSTAB REPORT - GROUPING BY "DAYS OUTSTANDING" BUCKETS

    Sorry....more info: CR10 Access DB.
  17. dcanfield

    CROSSTAB REPORT - GROUPING BY "DAYS OUTSTANDING" BUCKETS

    I am trying to create an Accounts Receivable crosstab report, where the columns are set on the number of days outstanding. For each record, I have a field that already displays the number of days outstanding for that record. I want to be able to group my columns into the following days ranges...
  18. dcanfield

    Record Selection Problem and IsNull formula

    Hi synapsevampire, thanks for the feedback.... I tried this, but for PC= X, there is still no results from my IsNull formula....still blank. And just as an additional bit of info, I have made sure the "Suppress Zero" is turned OFF in field format, and in Report Options, the "Convert Database...
  19. dcanfield

    InNull formula not working

    Hi Turkbear, I have tried that, but it did NOT make any difference. I have posted a more detailed inquiry as a new thread, titled: "Record Selection Problem and IsNull formula", that does a better (I hope) job of discussing what I am trying to do. Thanks, David
  20. dcanfield

    Record Selection Problem and IsNull formula

    Record Selection Problem and IsNull formula I have a report that I am trying to create, but am not having any luck getting the Record Selection formula to work properly. The scenario (CR10 – Access Database) : My company has several different divisions, and each division sells the same...

Part and Inventory Search

Back
Top