Search results for query: *

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...

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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

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...