ielamrani
Last Activity: Mar 26 '10, 02:28 PM
Joined: Feb 14 '07
Location: New York
-
I forgot to mention that I am using Access 2003. Thanks -
Funny characters
Hi,
I have a form that's linked to a query. when I run the form, one of the text boxes shows funny character (%!,<!䬃!). All the other text boxes are fine except this one. When I run the query by itself it's fine. Does anyone have the answer to this? I did some search in the web but in vain. Thanks in advance. -
We'll do. Thank you so much.Leave a comment:
-
Autonumber issue.
Hi,
I have a subform (subform1) with several records. Each record in subform1 has a button next it. When I click on the button it show another form (form2) that contains the clients info. it works fine but the problem I am having is when I create a new record.
When I add a new record to the subform1 (I add just first name and last name) and then I click on the button that opens form2 (I add address, phone etc). I am able to add... -
Problem solved. ThanksLeave a comment:
-
Add a label in excel?
Hi,
This is an excel question and I am using excel 2003.
I have an excel sheet that I import, look like this:
NUMBER
125
25
NUMBER
25
625
NUMBER
145
78
789
etc..
I would like to add labels on top of this cell name like this:
POLCIY
NUMBER ... -
I am sorry for not being clear. The data was imported from one excel sheet to another. the apos was used for an invoice number column to show the zeros. I was able to solve it.
Thank you all for your help.Leave a comment:
-
remove apostrophe?
I have imported data from another program, and I run into this problem where an apostrophe got added to the beginning of each Cell; because of this I can't format the cells. Anyone has a solution? I am using Excel 2003 Thanks in advance. -
Runtime Error 1004: Method ‘Cells’ of Object ‘_Global’ failed
Hi,
I am getting this error when I try to export to an excel sheet. When I click on a button to export the first time it's fine, I rename the exported excel sheet and I try to export it again and I get the error: Runtime Error 1004: Method ‘Cells’ of Object ‘_Global’ failed
It highlight this line:
sorry the code behind the button is long:Code:Range("A1:L1").Select
...Code:. Dim stDocName As String -
Export access form data to existing excel sheet
Hi,
I have the following code which works fine. It export current access form record to an excel sheet: DoCmd.OutputTo acOutputForm, "frmsubformtest ", acFormatXLS, "C:\Details.xls ", True
Is it posible to append data from this form to an existing template excel sheet that already have the same columns names.
thanks in advance. -
Rewrite Query
Hi,
is there a way to rewrite this code to make it short. The query won't run
because it max the # of characters allowed. sorry it's written in caps.
thanks in advance:
...Code:BASE ADMIN: IIf(CDPINC_ARIBD!IDACCTREV="5021-0PENSN-QTV" Or CDPINC_ARIBD! IDACCTREV="5021-0PENSN-SAV" Or CDPINC_ARIBD!IDACCTREV="5021-0PENSN-ANV" Or CDPINC_ARIBD!IDACCTREV="5021-0PENSN-RSA" Or CDPINC_ARIBD!IDACCTREV="5021-
-
Lookup table
Hi everyone,
I have a form with 2 text boxes linked to a table (table1). One is a drop
down box (DB1)to select user and one is text box (T1)to enter Department.
table1 has 2 fields: Name and Dept. I would like the department to be
entered based the name selected.
table1:
...Code:Name Dept Ish NB John
-
How to add an email attachment?
Hi,
I searched everywhere for a similar issue but in vain...
I have a form used to enter computer issues. I would like to add to it a
text box that will store emails. It could be a button that opens a link to
the email. I hope this is clear. thanks.
Ismail -
Problem solved. thanksLeave a comment:
-
Combine text boxes
Hi,
This sounds simple but it's not working for me.
I have a form with 3 text boxes.
Text1 = John Lerch
Text2 = Joe Lerch
Text3 = Jim Lerch
i want to put all three names in one text box Like this:
Text4 = John Lerch Joe Lerch Jim Lerch
I know how to do this in a query: [Text1] & " " & [Text2] & " " &[Text3]
How do... -
Thank you so much. It worked.Leave a comment:
-
Adding columns in a query
Hi,
this is very strange. I am trying to add 2 columns in a query but it does not come out right.
Column1 Column2 Column3
$15.00 $30.00 $15.00$30.00
Column3 should equal $45.00.
When I subtract, divide or multiply it's fine. It does not work when i tried to add. this is the code behind Column3: Format(nz([Column1])+nz(Column2)," Currency")
Thanks... -
thank you very much.Leave a comment:
-
Sorry, but it's still sending to one email only. also, I want to know if it's possible not to show the recipient's email address. I am sending this to 206 clients and we don't want to show everyone address.
thanksLeave a comment:
-
Perfect. Thank you so much and have a happy HolidaysLeave a comment:
No activity results to display
Leave a comment: