Search results for query: *

That sounds like it might work, I will give it a try and let you know. This is another minor issue but another chart I have does not change in size when I change the width and height. The chart is a subreport placed in another report and it works but sometimes I have too much data columns to...

No how do you do that? Thanks for the suggestion!

Hello, I have tried about everything and am completely at loss as to what to do next. I hope you can help :) Here is the issue- I had a report which worked fine up until recently, The report has a chart and displays the data table with the chart. The issue is the column headings are no longer...

RoyVidar, That did it! Thanks! Avenuw

TheAceMan1, Its funny you should suggest VBA :) I do program in VBA and like you said its a lot more flexibile and it can be a lot more powerful! But I'm making some slight changes to a legacy system and was trying to take some shortcuts! Somehow shortcuts always take more time!!! For what I...

PHV , Thanks for your post. I did try your suggestion and am still having the same problem. It seems whatever I try to put in the message field below for MSGBOX in the macro appears as is. This is what I put in the message field : hello & Chr(13)&Chr(10)& world and it appeared exactly...

hello, I know to start a new line in a MSGBOX you can write MSGBOX("Hello" & vbCRLF & "World") and it should display World on a separate line. But I am trying to do this in a macro when I select the action to MSGBOX and insert the comment below, I am finding I cannot insert any new line...

Does anyone have any suggestions at all? Both my graphs work fine when the link Child field control source property and the link master fields control source property are empty. But when I add the field names from the report record source, they display nothing except the title of the graph. I...

Hello I am not sure what I am doing, but I am creating a report with 2 line charts. The charts work just fine when the property control source ( LINK CHILD FIELD & LINK MASTER FIELDS) is empty. However when I add the fields: <b> employeeName;Category </b> for each control source, the charts...

Thanks Hap, I was logging in with Administrator user access however found the only way to delete the user is not in the work group information file (the security wizard) but through the User and Group Accounts interface under security. GG

Hello, I am trying to remove a user from my workgroup information file. How can I do that? When I click on the user, the Delete this user button is disabled and I am the adminsitrator! Thanks, GG

Thanks for all your suggestions. What i did eventually was instead of tryng to get monthNumber from query2, I went to the previous query1 ( which query2 gets its info from) and used the month() method on the original date. Much easier than using the month method on the abbreviated month name...

Hi Golom, I tried the following code and gave me an #Error for the entire column select month(abbMon) from myTable order by month(abbMon) abbMon contains abbreviated month names ( that I got using format(mydate,"MMM")previous query called myTable. Any ideas ?

Hello, i am trying to get the month number to order the months in my sql query from an column (abbMon) with abbreviated month names in the format MMM. this is what i have select month(abbMon,T) from myTable order by month(abbMon,T) But I get an error indicating wrong number of arguments used...

Thank you, I think that is the only way!!

Hello, I have a report with a chart inside and I am also displaying the data table information.I am trying to display the commas for the data inside the table. I did the follwoing but none worked: 1) Changed the field property FORMAT to Standard in the table where the data comes from 2)Have...

Well, Thanks fneily for setting me straight. I have been thinking too hard and getting lost among all my queries at this point-- Time for a break!!! Thanks For the responses, appreciate it GG

I might not be following you correctly but my original table contains the following name date_created purchase_num item_num So I have many rows with the same name, date_created,purchase_num but with a different item_num. But What I want is to move it into a new table with the following name...

I am trying to update several columns in a table with rows from the same table. You see, the data as I receive it is not normalized. Basically I have a table with the following columns name date_created purchase_num item_num ... So I might have many rows with the same name...

Your right Remou although I did not exceed 255 columns in a table, because I was updating the datatypes for the 160 columns, it looks like the internal column counter reached the limit of 255. Makes sense because it copies the original record and the updates that I made, so it quite easily...