Search results

Yes, by stamping the month on each row I believe I'll be able to reproduce their report using a SELECT query. I'm still curious, though, as to whether you can change the labels on crosstab columns ;)

Unfortunately, I have to design this to identically match a report that used to come out of their old unix database system. 1 rep per report, no names, multiple columns being summed and compared. I believe I'll take the easy way out and use SELECT queries to compile, sum, compare the data, and...

Why the Crosstab Users want the months displayed as the first column, and sales for each rep summed by month of sales. The data is coming from invoices, each of which contains an individual date (ie, 1/1/05, etc.).

Is it possible to create a custom label for a column header in a crosstab query? My crosstab query displays sales totals for a particular sales rep number (rep # 102 in this case), by month. For example: Month....102 1..........$500 2..........$300 3..........$450 etc. I would like...

Follow Up I had to create a workaround for this... I created a barebones version of each database that required scheduled importing, all the tables linked to their originals, and attached the import code to a form set as the Start Up form. When these versions are opened up, the import code...

Thanks!!! That syntax was exactly what I needed and my form is doing precisely what I'd hoped for. Thanks again :)

I have a form with 25 related sets of text-box controls: Product1, ProdDescr1, ProdQty1 Product2, ProdDescr2, ProdQty2 ... Product25, ProdDescr25, ProdQty25 I need to loop through all 25 to check that the ProdQty for each is correct, and if any of them are incorrect, I'd like to set the...

You're absolutely right, Pat! I'll be the first to admit that my coding in Access is neanderthal at best. I'm developing applications that are more sophisticated than my abilities, and doing so on a deadline. In this case, I'm developing an application for people to take product orders as...

Results... First, thank you very much for your input on this. I found that the problem was my syntax. Instead of using: If IsNull("Product1")... I changed it to: IsNull([Forms]![Order Form]![ProdDescr1])... The code worked perfectly after that. Again, thanks for your help! :)

I am having problems getting Access to evaluate whether a textbox is empty using VBA behind my form. I'm currently using Access 2000 on a Windows98 machine, but I also tested this in Access 2003 on an XP machine and got identical results. The way I’d like the code to operate is if the...

Thanks again! As always, you've been very helpful :)

Thanks. :) I'd hoped there was something that could be used within the report-design GUI, similar to &[Page].

I know I can use Date() to display the current system date on a report. Is there a similar command to display either the name of the current file or the name of the current database? Thanks!!

Thanks so much!! 2nd expression worked perfectly. :)

Problem: Need to compare one table's MemberName (single text field) that contains first and last name together (eg. Boris Badanoff) with another table's MemberName that contains only first name (eg. Boris). Names in 1st table are separated by a space. All first names in both tables are...

Tried that too I tried that both from the task scheduler and the windows Run dialogue box and again got the same results. We continue to be thoroughly perplexed. By the way, if the macros are run from within their databases, they all execute properly.

Correct I did not alter any of the macros or the scheduled tasks.

I have developed a number of databases for a client over the last few years, many of which are automatically maintained through the Windows Task Scheduler by utilizing the /x Macro switch. All of my scheduled tasks worked perfectly for a long time, but now a problem has mysteriously developed...

Can I use the field value from one form Or from a different form (whichever is open at the time) as a criteria for one of the fields in a query? I'd like to set the criteria for one of the query fields as follows: Forms![FormA]![TheField] Or Forms![FormB]![FieldName] I've already tried it that...

I've created a report with a chart that includes a data table at the bottom of the chart. I would like the data table entries to be in Currency format with no decimals. I've opened the datasheet for the chart in chart design view, selected the appropriate cells, and changed the number...