|
Code not working correctly
I have the following code running from a command button, and it ignores the
section after the "&" sign in the strTableName statement, so it just gives me
a Table called tblBackupEnhancedCodes without the date. I can't figure out
what I am doing wrong. I want to run this periodically and create a backup
of a table but add the current date to the end of it.
Dim strTableName As String, s...
|
5 |
12/31/2008 4:36:01 PM |
|
|
Save a File from a Text Box
I have a Text Box on a Form that contains the full filepath and filename of
the users choice. How can programically I use the filepath & filename, from
the Text Box, to save the indicated file to a shared drive (Z:\) or shared
point (HTTP://Intranet)?
Thank you for any help.
Stephen...
|
4 |
12/31/2008 4:29:01 PM |
|
|
Revert to std menus/toolbars during runtime
Hi all, thanks in advance for any pointers.
I was curious if anyone knows of a way to programmatically restore Access
default menus and toolbars (same as holding 'shift' on startup).
I'm working on a project that will have about 5 users on different
computers, and have the startup options set so noone can get to the
code/tables all that easily (luckily, none of the users are powerusers...
|
1 |
12/31/2008 4:19:02 PM |
|
|
New problem for Access????
I not sure if this is the site for this problem. If you know a better site
please suggest it. Thank you
I have an Access 2003 program ( ISSORDERENTRY.MDB ).
Last week it worked fine. This week it has a problem. ????
The Problem:
Access will not handle .DBF files any more!
The ISSORDERENTRY.MDB gets it's price list via a DBF(4) file.
When the program tries to open the file it does o...
|
9 |
12/31/2008 2:21:01 PM |
|
|
define field name
I want to cycle round fieds in a data set F1, F2, F3 ... etc
How do I say
Do While iField <= nField
condition = rstImport!["F" & ifield]
Thanks...
|
3 |
12/31/2008 11:19:01 AM |
|
|
trying to copy a photo from one db to another
Hi I know this isn't the forum for coding but I'm at a standstill. How do I
copy a photo from one database and put it in another. I've been reading about
getchunks but I'm not sure that's what I need to do. I'm using appendchunk to
store it in the second database and that seems to be working fine. It's just
how do I get the photo out of the first database. Here is my convoluted code,
any...
|
2 |
12/31/2008 10:02:25 AM |
|
|
Pivot form calculated total
Hi,
I have a master table with employee information with emp ID as primary Key.
Other informations are name, tenure in organisation, designation etc.
I have prepared a Pivot form using the Wizard. I was trying to get the count
of employee with more that 6 months as tenure in the organisation using
Calculated field option in the menu.
Please help me with the corrrect syntax.
Thank...
|
1 |
12/31/2008 9:41:00 AM |
|
|
Convert Access to ????
Hi,
I have several Access programs. Is it possible to convert these programs to
some other platform so that the user would not need Access, Run-time or any
other software?
Thanks,
--
Phil...
|
4 |
12/31/2008 7:28:53 AM |
|
|
Change field format programmatically
Hi,
I have a table of items - where the item number display format is different
for based on item type.
e.g item type vertical item number ver-123 a b cc dd
item type piping itme number ver-4567890 a dd
Is ther a way I can alter the format so that when the record is dispayed it
display's the item number in the appropriate way?
Thanks
wAyne
...
|
7 |
12/31/2008 6:47:01 AM |
|
|
Tweeking API Code
Hello again,
I am using the Open/Save Dialog Box code found here;
http://www.mvps.org/access/api/api0001.htm
It works great! I have it inputting the full path&filename into a text box
just like I want.
What I am now trying to figure out is how to get just the file name, using 1
instance of the code, and input the file name into a separate text box.
I thought I could split it but ...
|
3 |
12/31/2008 4:11:02 AM |
|
|
Standard Toolbar is missing
Somehow, the standard toolbar is missing in my Access2003. I cannot see
File, Tools, Insert, Edit, etc, and when I manage to get into the customize
toolbars, there is no help there. Without being able to get into "tools" and
its "options" I am lost. How do I get this back?
...
|
6 |
12/31/2008 3:49:26 AM |
|
|
File Download
I have a database table that contains a list of file (by user) that users
need to download from the server to their notebook (connected through a
wireless network). I wish to automate the process so that when the user click
a button in the access application, the file can be downloaded. How can I do
this using Access Form and VBA.
Thanks.
--
Anthony...
|
3 |
12/31/2008 3:10:01 AM |
|
|
>> currentDb access.application
Hi is there a way to reference the access.application object of the current
database?
I have more than one version on my machine. Even though I am running an
application in Access12 using set acApp=CreateObject("Access.Application12")
returns 11 for acApp.version
Many thanks,
Jonathan...
|
8 |
12/31/2008 2:41:51 AM |
|
|
How to avoid sql login dialog box to run access query
Hi,
I have an Access application that has a sql server backend. I had to migrate
the application to a local machine. Now when I am running a access query I am
prompted with sql server login dialog box. This was not the case in the
previous installation. I would like to know how to get this dialog box from
not appearing while running this access query. I would appreciate any help
for res...
|
2 |
12/31/2008 12:08:13 AM |
|
|
How to reuse the Access 2007 ribbon buttons
Is it possible to reuse the Access 2007 ribbon buttons in a new ribbon?
I know I can create a USysRibbons table to save some new ribbons. I know how
to define groups and buttons with XML. I know how to create VBA subroutines
to handle user clicks on these new ribbons. However:
1) Everything was easier if I can simply reuse some existing buttons and
groups, i.e., like in the Access 2003 com...
|
4 |
12/30/2008 10:08:46 PM |
|
|
Find ranges or series of integers
I have an integer field named "section". I need a routine that will query
that [section] in a manner like the way Microsoft Word accepts page numbers
for printing. I envision having a search box on a form and entering either
single values (like "18"), multiple values separated by commas (like
"18,23,25") or ranges of values (like "15-18"). Does anyone have any VB code
like this?...
|
7 |
12/30/2008 9:49:03 PM |
|
|
Access/SharePoint Question
Thanks in advance for your reponse.
I read in the Access Bible 2007 that access could use sharepoint over the
web. does this mean that access can use a sharepoint list over the web like
it uses sql server over a lan?
thanks
...
|
2 |
12/30/2008 6:31:01 PM |
|
|
How to disable On Error Resume Next?
I use "On Error Goto" all the time, but Is it possible, once you use the "On
Error Resume Next" to undo this command completely so it just stops on each
error like if you never declared an "On Error" type statement?...
|
3 |
12/30/2008 6:17:01 PM |
|
|
OpenForm action cancelled error using Vista
I have an 2003 access database that works fine on Windows XP, but errors out
on the docmd.openform line of code (OpenForm action was cancelled) after
upgrading to Vista. Strangely enough, this is only a problem for one form, so
far. All the other forms that have identical code work fine. Basically, I
have the user select a record from a subform and then click on a command
button
(which...
|
14 |
12/30/2008 5:57:01 PM |
|
|
Query prompt to change field retrieved
I'm working with a table with a field for each month of the year. (can't be
changed) I need to query data for last month and I would like to be able to
prompt for a field. Does anyone have some code that would allow me to do
this?
...
|
4 |
12/30/2008 5:33:44 PM |
|
|
Disable message prompt
Does anyone know how to disable the message that prompts whenever I try to
send email using the command button? The one that says that the program is
trying to send email on your behalf...
Please help.
Thanks,...
|
2 |
12/30/2008 4:54:27 PM |
|
|
OpenRecordset SQL using wrong SQL statement
I have an issue where I am using 3 different SQL statements strSQL, strSQL1
and strSQLUp in a Do Loop:
strSQL = "Select OpCode " & _
"FROM R2ROpCodes " & _
"WHERE R2RPerfID=" & Me.R2RPerfID & ";"
Set rec1 = CurrentDb().OpenRecordset(strSQL)
Debug.Print rec1.RecordCount
rec1.MoveFirst
Do Un...
|
7 |
12/30/2008 3:46:00 PM |
|
|
Fastest method to combine 3 large lists into 1 multidimentional ar
Lets say I have 2 text files with 2 rows of data each. The first file
contains the "Occupation", the 2nd file contains the "Salary" and the 3rd
file contains the "Hire Date". Each file contains a "Name column" which
would be the "key" of sorts for each entry.
File 1 contains 15,000 entries
File 2 contains 15,000 entries
File 3 contains 15,000 entries
What is the fastest way, throug...
|
5 |
12/30/2008 2:55:01 PM |
|
|
Need Function to merge list box values
Hi,
I am creating a database for my process and we get multiple seal numbers for
each transactions. I need to list out all the seal numbers in one row while
preparing a report.
Can any one help me to create a function which will take the values from a
list box and displays all the records in one single text box.
...
|
3 |
12/30/2008 1:41:01 PM |
|
|
series 1,2,3,4,5,4,3,2,1,2,3,4,5,4,3,2,1
I am looking for code which can generate following series.
1
2
3
4
5
4
3
2
1
2
3
4
5
4
3
2
1
Pl help.
H S Shastri...
|
6 |
12/30/2008 11:28:52 AM |