Type: Posts; User: swoozie
Search took 0.02 seconds.
I am looking for reference material on how to design a .NET application which interacts with a database which is housed in the Cloud.
I am specifically concerned with the interaction with the...
I am using Access 2003 to generate letters. I need to be able to access a footer and update text to a date. I am unable to do this.
I have tried variations of this
i dont want to call it directly. let me try to explain it better.
I have several word templates that are set up slightly differently for the letter type. I want to beable to write one little...
No, that is backwards. I want to dynamically read the value of varname.
i.e., we dim the variables ToAddress, CCAddress
we set the variables
toAddress = Mark
CCAddress = George
Okay, let me see if I understand the concept.
I would "store" the values of the variables in a scripting dictionary object?
then grab the values based on the variable name from the scripting...
This may sound odd, but I want to be able to dynamically access a variable value.
I have a bunch of variables that correspond to bookmarks in word templates. Not all bookmarks are in all of the...
How do you check if a file is already open and locked for editing before going to open it again via VBA code in Access 2003, opening a word document?
that is what I orignally tried however that throws an error that the property cannot be used for that.
Any other suggestions?
I have a list where users select the items they want to do an action with. To do the action the items selected need to meet certain criteria. If the item does not meet the criteria I want the list...
It sends the email with out the attachment.
When I debug, it assigned the file name to the variable but nothing happens after that with regards to the attachment
I am trying to send an email via Groupwise from Access 2000 adding an attachment of an Access report in rtf format. It is not recognizing or locating the attachment.
I am using the following...
I created a user form called it Report.
It opens on workbook open.
On the initialize event it poopulates a combobox.
Then I have a button that hides that form and shows a new form.
I am looking to create a report that looks like this
For some reason VBA did not capture the err when receiving and ODBC call fail, I had to use dbengine.err to identify the error and set a work around/response for when it happens.
I wish it did, my problem is that I do not need any vb/.net help pertaining to crystal. in fact I think it would be easier to build this report via a vb app, but then I would have just build an...
I have not worked in Crystal since 8 came out years ago. I am way behind the ball on a project I was assigned. I took the project because I thought it was an excel report then I was told I had to...
Is there anyway to capture an ODBC error and manage it through an error handler?
I am using Access 2000 VBA
I have a database that manipulates a word template and then merges data into it. I am trying to speed up the processing and I am not sure what else I can do.
I have turned screen updating off, I...
I want to capture the run-time error 3265, item not found in this collection, but I have been un successful.
I have 2 tables and the items with column names alike I want to update from one tot...
Public Function FixZipCode(ByVal Zip As String) As String
Dim Lenth As Integer
Dim i As Integer
Dim Temp As String
Zip = Trim(Zip)
If Zip Like "*-*" Then
I have an access 2003 database and I am receiving a type conversion failure error on a zip code field.
I have a function that inserts the "-" in the zipcode.
The field is Text(15) Zero...
I have an Access 2000 database writing to a word document. The issue I am running into is that the database doesn't always open the file but it was coded to always close the file. I need to check...
I want to write a vb script to be run on a schedule to call macro and a procedure in an access database.
I do not know how to do this.
'I am sure you need to create and object
Here is what I have come up with so far and it isnt working. I noted the location if fails. any ideas?
Public Function AccessLDAP()
Dim con As ADODB.Connection
Dim cmd As...
How do you authenticate a login against the LDAP/ACtive directory via VBA, in Access 2003?
I know how in .net but I can not seem to organize it in a manner acceptable by access.
Is there a way to install both version 9 and 11 on the same PC?
I need to have 2 fields that calculate the display, based on a look up (I think)
I have 2 diffent ID fields that link to the same 'look up' fields. These field can be null so I wanted to do...
I have created a simple user form template using Word 2003. You know the ones with the grey fields that you leave unsecure and the rest you secure. Anyways I wanted to do 3 things.
Close, I guess i am just not quite clear enough.
I want to populate 1 listbox that has 13 columns (if possible)
Then I want the user to be able to click on the item in the list box to populate...
To populate the listbox yes, but After the list box is populated I need to populate test boxes with the selected records.
just with one workbook. I have full read write access to the server it reside on, and I was able to copy the contents into another file and make it shared, but I couldn't share that file.
I want to share my workbook with other users so I went to Tools, and the Share Workbook option is greyed out.
Any idea as to why or how to change it?
All code is in the form, frmMain.
There is only one form, everythign is on one form.
The listindex is really "odd" it has ranged from 0 to 244, which shouldn't be an issue since there are...
You guys, hate to interject but I think we are getting ahead of ourselves here and need to get a response from the actual user. For all we know from the original post is that he may need to add a...
No, I can not upload :(, but the last code item I used using the rowsource was
Private Sub UserForm_Initialize()
'populate all listboxes
Dim c As Control
'this is just code I got from a...
That was the last thing I said I tried, but when I would click on the list box it would not populate the textboxes I had associated with columns.
here is the line of code I use to populate the...
Start with the Tutorials with in the forum.
If you are using VBA, record macros and see what the code look like. VBA can be learned by trial and...
Why don't you try it and see if it works, and let the rest of us know. :)
Where is the code coming into play at? do you have to incorporate "Result" into that code or something?
Okay, I give up, does someone have a piece of VBA code that handles list boxes?
I have a spreadsheet with 244 rows (this fluctuates) and 13 columns, this does not fluctuate.
I want to populate...
Click Here to Expand Forum to Full Width