Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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