|
Changing names of columns and tables
I have a database with many tables, many forms with many programs and some
complex queries. When I change one column name from one table, I have to go
to each form and fix it, as well as the queries that has formulas, and so
forth.
I need to change so names, that I won't be able to finish in one week. Is
there any way of contolling names that are easy to use?
Thanks a lot, Lina...
|
3 |
16.08.2006 02:56:53 |
|
|
Displaying PDF document
I'm trying to display a PDF document from one of my Access forms. I have the
path where the PDF document resides . I've put this location in one of my
Access tables. I've tried various VBA code options, but can't get it to
display the PDF document.
Any suggestions would be appreciated.
Thanks,
Tom
...
|
4 |
15.08.2006 23:06:08 |
|
|
Replace certain characters in a string
Hello!
I am working with a string of known length. I wish to replace any occurance
of characters with ASCII values below 32 with a single character (say a
dollar sign...). Could someone please suggest an efficient method to do
this?
Thank you!
Fred Boer
...
|
4 |
15.08.2006 22:06:45 |
|
|
Formatting a query field using code?
Hi,
I need to set the format property of a field in a query using VBA but I'm
not sure how to do it? I've tried this....
CurrentDb().QueryDefs("Custom_Sales_Query").Fields("Downloads").Properties("Format").Value = "Standard"
....but it doesn't seem to do anything? As you can see, the field
"Downloads" is the field I am trying to change. I want it to be displayed as
standard and no...
|
4 |
15.08.2006 21:11:11 |
|
|
looping through form to clear textboxes
I tried using the following two methods to code this and get error messages
as noted in comments.
Private Sub btnClearForm_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If (Me.ctl.ControlType = acTextBox) Then 'error method or data
member error cont. not found, highlights (.ctl)
If Me.ctl.DefaultValue <> "" Then 'if have defa...
|
7 |
15.08.2006 18:52:02 |
|
|
Use FrontPage Bookmarks in association with Access Database Result
Hi--
Do you know if its possible to use FrontPage Bookmarks in association with
Access Database Results Column Values to create hyperlink targets .. i.e., to
permit linking from Results page to another? Hope this question makes sense
to someone out there ..
Thanks,
Best,
8web
Aug 15, 2006
--...
|
1 |
15.08.2006 18:52:02 |
|
|
Position Announcement, FT Permanent
The University of Tennessee is searching for a person with solid VBA
experience in Access or whose programming background will enable them to
come up to speed quickly. This is a pemanent, full-time position with
generous benefits. The link appears below.
I am retiring from this position in February, and I will not answer
questions about the job. Those should be directed to the chair ...
|
1 |
15.08.2006 18:51:25 |
|
|
How do I get Access to identify that a table has no records
I have a form that relies on another table having data before any data can be
put in the original form. (Can't create a patient record unless the doctors
table has some records in it.)
How can I stop a user from trying to create a patient record? What I want to
happen is, that if a user tries to enter a patient's details while the
doctor's table is empty, a message box is displayed and,...
|
3 |
15.08.2006 18:25:01 |
|
|
Timing Issues
Hi All,
I'm running into a weird problem, and hoping someone can help.
Using ADO, I'm appending part of Table1 into Table2. Table2 needs to
be empty before I start or else I get multiple copies of the records.
If I do a delete query (ADO) on Table2 first, and then do the append
part. The delete code hasn't finished, so it blows away the records
that I just appended also. I end up with...
|
5 |
15.08.2006 17:44:33 |
|
|
After compacting the database I run code and get the error-MaxLocksPerFile registry
I was running an code to loop through 14,000 trans numbers and number each line 1,2,3, etc until it sees a new trans number. Everything was working just fine until I compacted the database. Now I'm getting this error and my code stops running.
I still have several Mdb files that I haven't compacted and code still works. But does anyone know how I can fix this. I've expanded the registry to 2000...
|
1 |
15.08.2006 17:13:04 |
|
|
Run a module without form ?
Hi
I'd like to have an Access ap that has no GUI and just does its work (which
is using TransferDatabase) when started. I can't seem to find a way of
kicking off my code, which is in a module, without having a form first. Is
that the only way to do it, or am I missing the boat ?
Thanks for help
Balex...
|
5 |
15.08.2006 15:59:02 |
|
|
Query Formula
I have created a query based on a form and 2 of the fields have several
choices, for example; one field is price level (3) choices and the other is
material (7) choices. I need to be able to create a formula to give me a
material cost based on the material AND the price level chosen on the form..
Any suggestions? I have used Access in the past, but this has mne stumped....
|
2 |
15.08.2006 15:44:03 |
|
|
Convert jpg to bmp
I have seen Stephen Lebans' conversion tool for converting jpg to emf but
cannot figure how to take that to converting to bmp in order to efficiently
place pictures in the Access database I have built. There could be 3,000 or
more pictures when I have finished with it so manually opening and doing
saveas is out of the question.
Thanks for any help.
--
Best wishes,
Jim...
|
5 |
15.08.2006 14:35:01 |
|
|
Access 2K3, Terminal Server, and Oracle BE - Anyone able to help?
Hi all,
I have been working on this application for some time now (part time as of
late), and I seem to be getting no-where. I have read tons of posts
regarding linking vs. pass through, DNS-less connections, re-linking via code,
etc..., but I am still having issues with getting my head around it all.
What I really think I need is a mentor, but I'm not sure where to find one.
Anyways, I...
|
3 |
15.08.2006 14:11:16 |
|
|
Using ADO
Hi
I want to convert my code to ADO, whenever I want to open recordset, i
notice that i must write the following
Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strConn As String
strConn = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & CurrentProject.Connection
Set rst = New ADODB.Recordset
With rst
is there any way I can reduce it or?
Thanks ...
|
3 |
15.08.2006 11:21:42 |
|
|
ODBC connection error
HI,
I am completely stumped by this problem so any ideas would be appreciated.
I have an application that creates an Access DB for each day and stores data
in a table in the DB. I also have a number of front end Excel workbooks where
users can import and look at data for a particular day and if they want to
look at the data at a greater granularity they can press a button that
execute...
|
3 |
15.08.2006 07:56:01 |
|
|
Compacting on Size
Is it possible to compact a database from an open form based on the size of
that database?
I would like to be able to check the size of the database each time the main
form is opened. If that size is greater than 1.7 gig, I'd like the db to
automatically compact.
Possible? I am using Access 2003....
|
4 |
15.08.2006 04:37:57 |
|
|
How to Update a macro's properties thru VBA code?
Hi is it possible to update the properties of a macro step? Eg if i
have a TransferText
command in a macro with a property Table Name how do I update thru
code? I have many macros and i don't want to manually configure them
all. It this possible..?
eg. this is how har i've gone ...using DAO
CurrentDb().Containers("Scripts").Documents(0).Properties("??????").????
how do i get to the macr...
|
2 |
15.08.2006 04:15:05 |
|
|
Updating Combo box if Table is in SQL Backend
I don't know if this is the correct forum to ask this Q.
Win 2000, Access 2003 SQL Server 2000
I want to update the Vendor tbl with a new entry if it is not already present
in the table. I can get it to work fine if the tbl is local in Access (see
code below) but it does not update the tbl if I move it onto the SQL back end.
What VBA coding differences are there with the SQL route other t...
|
5 |
15.08.2006 01:33:04 |
|
|
Programmatically Interact with Sharepoint
I know I'm completely lost and probably in the wrong list, but I need to find
out where I can learn how to interact with SharePoint programmatically using
VBA.
I have an MS Access application which creates documents (e.g., Word merges,
snapshot files) and saves these documents to network directory shares/folders
today.
We're using SharePoint now and I need to programmatically write t...
|
1 |
14.08.2006 21:51:01 |
|
|
IIF and ISERROR Synatx problems in ACCESS
Hi I have a formula that I am trying to remove any potential #Errors in
Access. I have looked at other postings online but can not find the
correct syntax to make my formula work.
I am basically trying to do:
IIF(ISERROR(([numerator1]+[numerator2]+[numerator3])/([deniminator1]+[deniminator2])),"
",
(([numerator1]+[numerator2]+[numerator3])/([deniminator1]+[deniminator2])))
I am havin...
|
7 |
14.08.2006 20:40:02 |
|
|
Followhyperlink
Good day,
I have a customer information form. In this form I have a field called
website. I would like to have it so on Dbl Click it opens explorer and goes
to the website.
Any help would be appreciated.
THanks in advance....
|
12 |
14.08.2006 20:39:22 |
|
|
Webpage Submit
I currently have an access database that requires that submits come from a
website.
My question is from a high level regarding the best way to approach creating
the webpages and connecting to the database. I currently have frontpage and
have also noticed that access has a method of creating web pages. Also, I'm
not sure if an ODBC connection is recommended.
Any suggestions on how to ...
|
6 |
14.08.2006 20:02:52 |
|
|
Export To Excel
Hi,
How do I check if Excel is open before I run my code? I have code that
transfer data from Access to Excel. I use Excel.Application object as I have
to do complex manipulation of the data. If the excel application is already
open and modified than I get Error 91.
I would also like to export my data without having to close the open excel
application but I can't figure out how to...
|
3 |
14.08.2006 18:01:02 |
|
|
Number of Controls on Form Limit
Is there a max number of controls that can be on one form. Can this be
changed to a higher number.
--
Message posted via http://www.accessmonster.com
...
|
3 |
14.08.2006 17:55:02 |