Code:
Public Sub PasteData()
ckrows
Last Activity: Jan 20 '09, 06:10 PM
Joined: Jan 23 '08
Location:
-
Clipboard to table question
I am working with a Reflections HP session and i created a macro within the VBA editor in Reflections where i copy to the clipboard the information i need. Now the issue is that i do not know how to get it from the clipbaord to either the table i need or on the form i have, either one will work really, Form would probably be easiest. Any assistance on this topic would be great and appreciated.
... -
Dialog Box Centering
I am running a validation function and i call a msgbox at the end to let the user know their information was valid.
The problem is that the words are left justified, besides adding spaces to the front of the msg box is there a better way to center the text?
...Code:Public Function ValidatePW(password As String, Username As String, DomainName As String) As Boolean ' Start by retrieving the user's name Dim
-
Query By Form (QBF) Questions
This is my first QBF and i am following along with the Microsoft Example but it does not answer this question.
I hve a 2checkbox,2labe l, & 2unbound cbo. I want to pass the value from the unbounds to the query for the 2 fields. How is this done?
I have tried editing the SQL statement with the criteria pointing to the unbound box and it is not working.
CBO1 SQL
...Code:SELECT tblRISK.PKNumber_WorkFlow,
-
How to unlock a table?
I am using the code below,
In one of the sections i am running a query to delete all records in the db,
then a short while later i import the records intothe
DoCmd.OpenQuery "qryDelConfirma tionTable", acViewNormal
DoCmd.TransferT ext acImportFixed, "alCouponSpecsI mport2", "tblALConfirmFi le", Filename
After that i attempt to build a new table wiht... -
That worked great!
Thank you! Thank you! Thank you!...Leave a comment:
-
SetFocus to Main form from Subform
I have a main form with a button that makes a subform visible.
I added a button in the form footer of the subform that is supposed to hide the subform. This does not work because the focus is on that form.
I tried moving the focus back to the main form and it fails because it says it does not recongize the entered form.
I tried a docmd.close of the subform also nothing is working
Please help!
Here... -
OK Follow up to the original question.
I have put together some code that is almost working.
a couple of problems, i get a invalid use of null on this code when i add the stDollaramt to the subject line. Why?
Also this code is opening the email window, how would i get the email to automatically go and not have the user see the email form?
Thanks I really appreciate your help.
...Code:Private Sub Command54_Click()
Leave a comment:
-
Sending a Email from Access if condition is met
I have worked with Access for awhile but never had to send any emails out as a result of a field.
The situation I have is as follows, if a dollar amount [amount] is over $1000.00 an email generates to a specific email address. The address is static, I would like to include the name of the client[clientname] and the dollar amount in the email.
I read through a couple of threads and added the Outlook.Applica tion library... -
Case or IIF?
I want to show certain text depending on the date/date range.
Example if date is between 1/1/08 and 3/31/08, text on a report would reflect as "First Quarter"
4/1/08 - 6/30/08 would show text Second Quarter.
I tried using >=, i tried building into the query as a temp field, but it does not seem to work like i thought it would.
'If [quarter] >= "01/01/2008" or =< "03/31/2008"... -
I would love some code examples. Opening the file at the end was just for me to check the output. Once it is coded it should run and no need to open....Leave a comment:
-
Exporting Tables/Queries into csv files
I am working with large text files.
I have a request to break up 1 large text file into indiviudal files.
My data example is, i have more fields, but in hopes of keeping it simple this is what i have.
CustID, CustName.
The large file currently has over 100 different CustID's. The request is to create a csv file at each change in the custID and to name the file "CustName". csv
i was... -
Subform Update on Load/Open of Parent form
Hi guys,
I have a parent form that displays the subform.
The subform query has a link back to the original ID.
I was having issues keepign them in sync, since every parent may not need a subform. So i am trying to create an entry in the subtable whenever the parent is opened. This way it is always in sync and has it ready. VBA is not recognizing the field i want to upodate (tbldashlink) and i get a compile error each... -
Thanks Linq, it worked like a charm, this is my new standard now.Leave a comment:
-
Screen Scraping
I have been trying to find a sample of this on the internet and i cannot.
Scenario: I have an Oracle program, it has a logon screen with username and password, 2nd screen i need to enter a "1" to get to the screen i am looking for.
From there, i just want to scrape all or some of the information from that screen into my Access. I won't get access to the tables directly otherwise that is the route i would have... -
Multiple Option Groups, only reporting when a specific value.
I am attempting to create a report off of 6 option groups. Each option group is a Y or N response, populating a 1 or 2 in the tables.
i want to report the number a word on the report, I chose the nested IIF statement below and placed this in my query, but now it opens a dialog box for all except the last choice, is there a way to bypass the dialog boxes or at least not prompt the user with them? There is no values in the table for the ones... -
How to return a value if results equal a number?
i am new to the VBA world.
I am using a option group to give the user checkboxes.
1 = Blue
2 = Red
3 = Black
4 = Green
However using the option group it only stores the values as numbers.
I am creating a report, i cannot place the optikon group on the report because the user wants to see it as a word not a checkbox.
So i am trying to place on the report, if value =1...
No activity results to display
Leave a comment: