Search results

I am having trouble with using a #symbol in a field name. When i export the table to excel the # symbol is substituted with a . I know that the # symbol is a wildcard.... can it be used as a field name?

All, I am struggling hear novice "coder". I have pulled together some code that helps export many tables into one workbook in excel. see below. I would like to have it set up so that the user can select the path and file name for the export but do not know how to do it. Also for some reason...

I am trying to import an excel sheet into Access. The data that is in the excel table is going to go into 3 different tables. Two of the tables are a one to many relationship to the 3rd table. They are joined by primary keys and lookup tables. My question is how can i import the data into...

Yes you are correct about work arounds. I really didn't fix the problem. I just started exporting the data one query at a time. (wrote one query that i had to define a Parameter). Then export each query individually. Any sugestions?

Ignore question i found a work around. Thanks

I am trying to export data from a query that will export the data into multipal tables.......... so i want all information from variable a to be on its own table and then all information from variable b to be on its on table........ I was thinking that this could be done throught a macro.... but...

Can you explain what is happening line by line ... Select Case Me!txtControlName Case "AAA" Me!txtOtherControlName = "111" Case "BBB" Me!txtOtherControlName = "222" Case Else Me!txtOtherControlName = "I don't know." End Select

I am right now trying to acomplish this...... can you elaborate?

All, I am trying to increase the number of possible groupings that you can do in a report. Does anyone know how to do this?

Ok I am lost...... Where do i enter the code....... i guess you could say that i am out in left field.

Ok..... next issue i am buiding a form that has a field that the data in the field is always associated with data from another field. ex.... A B XYZ XXXXX ABC AAAAA XYZ XXXXX ABC AAAAA My question is how do i make them dependent of each other. So...

Thanks....... it was right in front of me..... its been a long week.

I am trying to add three different fileds to create a unique ID. Two of them are formated as text and the third is date. The issue that i am dealing with is that the date is formated as ex. 8/12/2008. What i would like is 8122008 so i want to remove the "/s". Does anyone know how to do this?

Nevermind i figured it out.

Hi all. I am trying to build a query that combines several fields. The situation is as follows.... 1. If a is > b then i need a 2. If b is > a then i need b 3. If a is null then b is not null 4. If b is null then a if a is not null 5. If a and b are null then '999999' I have everything taken...

I think i got it. I tried this and seems to have worked RBC: CDbl(Nz([RBC Soil Industrial mg/kg],'999999')) I really appreciate the help.

In the table it is defined as numeric.

I tried both the first returns the field in values but it places a #Error cint(Nz([RBC Soil Industrial mg/kg],'999999')) The second returns the proper values but converts them to a text. Nz([RBC Soil Industrial mg/kg],999999) I really appreciate your help. This stuff really gets me flusterd...

Sorry I tried in the SQL view of the query builder and in the expression builder.

I tried this in the expression builder and still returns the field as text. RBC: Nz([RBC Soil Industrial mg/kg],'999999')