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: *

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

    Data Table in Access Chart not displaying proper column headings

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

    Writing new line character in msgbox

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

    Chart goes blank when add link child & master fields!

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

    How to remove a user from Workgroup Information File

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

    Get MonthNumber from abbreviated month name

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

    How to display a comma in the data table of a CHART

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

    Normalizing table???

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

    What is the maximum number of columns allowed in table?

    Hello, I am trying to create a temp table to import some data into. I am currently doing so by linking to an excel sheet and then copying the structure of that excel table into my new table. This is because the excel sheet has soo many columns which I donot want to sit and retype out...
  9. avenuw

    Getting Error with DBEngine.Workspace(0) !

    Hello All, The code below is producing errors, specifically at the line Set db= DBEngine.OpenDatabase(dbName) I keep getting the following error: "You donot have necessary permissions to access \\xsystems\systems\series\yha\...Please contact security adminsistrator to get proper permissions"...
  10. avenuw

    Full outer join in Access

    Hello, I am using the following sql statment below in access to perform a full outer join. And although it runs and produces results, there is something really funny about the results. Some records values almost quadupled in amount! here is the code: SELECT A.x,A.z, Sum(a.y)...
  11. avenuw

    Linking Table in Access

    Hello, I am linking an excel sheet in my access database and one of the columns contains numbers in format 22222 or 22GT67,etc. When I link the table, only fields with numbers (ie format 22222) get imported, the other fields display #NUM!. I tried to change the format of the column in excel to...
  12. avenuw

    Whats wrong with my sql query?

    Hello, I am trying to runt the following query in access 2003, but I keep getting invalid procedure call. I checked everything and nothing seems wrong to me. Maybe someone can figure it out: SELECT A.[a_name],A.[a_Num], SUM(A.JUL) AS JUL, SUM(A.AUG) AS AUG, SUM(A.SEP) AS SEP, SUM(A.OCT) AS...
  13. avenuw

    What'w wrong with my sql query?

    Hello, I am trying to runt the following query in access 2003, but I keep getting invalid procedure call. I checked everything and nothing seems wrong to me. Maybe someone can figure it out: SELECT A.[a_name],A.[a_Num], SUM(A.JUL) AS JUL, SUM(A.AUG) AS AUG, SUM(A.SEP) AS SEP, SUM(A.OCT) AS...
  14. avenuw

    how to test if table has certain record and if not insert that record

    Hello all, I am trying to test if my table has certain values for each person (person is equavilant to several records in my table) and if not then insert a new record with that value. For example, in my db each person has several licenses 1-9. So ideally each person will have 9 rows ( each row...
  15. avenuw

    Invalid Procedure Call Error in SQL code!

    Hello, I am running the following query and keep getting Invalid procedure Call Error. I looked up the error but it seems to be related to packaging a database with Linked tables. But I am not packaging the database or using the package and deployment wizard, I do have a linked table but I...
  16. avenuw

    'Wrong data type in criteria expression' Error in Where clause

    Hello I am wondering if anyone has any ideas on what I am doing wrong. I am trying to select certian fields based on criteria that UCASE(last_name)=UCASE(last_name2), however I only have one field for name which includes first and last name. And name2 is another field with different names, also...
  17. avenuw

    Insert statment inside for loop in VBA

    Hello, I have spent the whole day trying to figure this out and I am not having any luck! Any help you provide will be GREATLY APPRECIATED. Ok the problem is quite simple, I am trying to insert 340 records automatically, so here is my code: Public Sub insert_row_sub() DoCmd.SetWarnings...

Part and Inventory Search

Back
Top