Run-time error '3075':
Hi all,
I'm using Access 2000 SR1
Could you please help me with this code. I'm trying to run SQL query from VBA:
VBA code:
strSQL = "SELECT tblUzorak.IDVrsta, | | 3 | 47 | 11/11/2009 7:02:01 AM |
Commondialog control filter for *.MDB and *.accdb files
I am using a common dialog control that filters for *.mdb. I need to modify
it to filter for both mdb and accdb extensions.
| | 1 | 49 | 11/11/2009 5:47:36 AM |
Can I use Access VBA code to create a macro for Excel and copy it into Exce l Mod
Hi All,
Is it possible to use Access VBA to create an Excel macro and copy it into an
Excel module.
I can modify a lot of things in Excel using Access but have been unable to do
th | | 3 | 39 | 11/11/2009 5:22:09 AM |
Function to count unique records?
I know there must be a way to do this, but I'm not finding a function to use
in my code.... anyone know one?
| | 2 | 58 | 11/11/2009 5:14:58 AM |
Excel won't go away
I have tried several variations of the following function, but can't seem to
get excel to quit at the end if I have all the excel formating in place. It
seems to lose it's connection to e | | 1 | 41 | 11/11/2009 5:13:34 AM |
Installing DLL
Hi, I need to get some help on the following issue:
Is it possible to install any DLL on my pc and then make reference to it in
order to call its functions from my access code?
If so, | | 1 | 55 | 11/11/2009 5:01:02 AM |
path of related tables in VBA
Hello, I'm writing in English but I'm Italian: forgive my language errors ...
I'm burning my brain. I'm trying to write some rows of code in a form of the
front-end database, to get the pa | | 2 | 52 | 11/11/2009 4:18:18 AM |
Database and WANs
I know a standard access db should not be used over a WAN.
That said, is there a way. Can one be setup using adodb or some other
method that instead of keeping a constant link would | | 2 | 44 | 11/11/2009 4:14:37 AM |
Programmatically set table field order
I need to programatically set the order of fields in a table that will later
be exported. I do not know where to start.
Hope you can help.
| | 1 | 54 | 11/11/2009 3:27:28 AM |
Importing csv
I am wanting to automate importing daily CSVs file into my database and was
first trying to do this manually (Import).
The issue I am having is the fact that not all of the columns in | | 3 | 46 | 11/11/2009 3:25:33 AM |
Finding and displaying images on a report?
Hello,
I need to display some images on a report. The images are stored on another
PC - mapped to the Z:\ drive. The images are all named with the number
corresponding to the [ | | 4 | 34 | 11/11/2009 3:20:18 AM |
One front End - Multiple Backends
Good day all...
I currently have a front-end that resides on each pc, linked to a back-end on
the server...no issues. I want to take the back-end and break it into
multiple back- | | 22 | 50 | 11/11/2009 1:05:34 AM |
How Not To Have To Go To Control+G > Tools > Reference > DAO > Etc.
Everytime I want to update my 50 or so users' Access, I have to go in
and do a DAO fix:
Control+G > Tools > Reference > Click off DAO 2.5 and go back
in a click | | 0 | 43 | 11/10/2009 9:37:01 PM |
Access DB slower on one computer only
Hello!
I have an Access DB that runs nicely on every computer except for one that
will hog for 20 minutes where it should take only 1 or 2 minutes.
This computer has access | | 3 | 54 | 11/10/2009 7:14:05 PM |
Updating a table from a form and subform
I started this thread in FormsProgramming, but got no response.
Maybe somebody in VBA can help me out
Thanks.
Any help would be appreciated:
I'm trying to add li | | 1 | 47 | 11/10/2009 6:16:54 PM |
Eval(CONSTANT)?
Is there a way to use Eval (or something similar) for get the value of a
constant (without having to go through a function for it)
I have a table of reports, in which I store some Whe | | 3 | 40 | 11/10/2009 5:51:40 PM |
Function to convert data
Is there a function in access to convert a number like " 1234.56 " to a
string like " one thousand two hundred thirty four and 56/100 dollars "
--
Thank you, Jack | | 2 | 44 | 11/10/2009 5:35:26 PM |
loop thru records to create a union query
I put this in the formscoding group but didn't get a response so I am
trying it here. Thanks in advance for any help.
I basically have a parameter query in which a customerID is entere | | 7 | 38 | 11/10/2009 5:27:30 PM |
Function in an ORDER BY statement
Hi,
I have a query that calculates a person's common name through a BuildName
function. This is also the ORDER BY in the sql... I notice that the function
itself is called twic | | 5 | 47 | 11/10/2009 4:42:02 PM |
Problem with PRINT REPORT TO PDF
Hello,
MS ACCESS 2003 on XP PRO.
A while ago, I found out about lebans.com and the marvelous code there to
print a report to PDF. using VBA. I have found that code to be reliabl | | 7 | 36 | 11/10/2009 2:30:01 PM |
Differences accdb and accde
I have strange problemm
I have a form with record source tbltableA
I have a button to send email with form field
my flow is
' force save form
If | | 1 | 55 | 11/10/2009 12:10:59 PM |
Updating data in form to two tables
I have created a database with two different table the clerical is the main
database, the ps table my second table. I have created a form with the field
from the PS Table. The PS table has | | 8 | 40 | 11/10/2009 11:04:20 AM |
64 bit
Hi all
As there will be both 32 and 64 bit versions of Access 2010, do you think
Microsoft will provide a means of using Access database files from 64 bit VB
2010 programs? At present | | 17 | 52 | 11/10/2009 11:00:18 AM |
Repeat field value
Having trouble trying to post this - or get it to come up on a search after.
Hopefully this isn't the fourth time you've gotten this.
This should be super easy but I can't find it in | | 0 | 43 | 11/10/2009 3:19:01 AM |
I want to install Microsoft Picture It 2002 and Vista will not tak
I do not want the new Picture It programs because they are auto corrections
to a picture. I want Picture It v.2002 on my Vista computer. It will
download and I think great. But when I op | | 1 | 45 | 11/10/2009 2:15:07 AM |
Run Saved Import
Hi all,
Just looking for the correct code to Run a Saved Import, say the name is
"Import-ASpreadsheet", already saved in Access.
End result is to paste that | | 1 | 65 | 11/9/2009 10:19:30 PM |
Silverlight for development is unstable!
Silverlight for development is unstable!
I installed Silverlight tools according to the standard procedure.
I made one Silverlight application in Visual Studio 2008 and that worked.
| | 1 | 48 | 11/9/2009 9:37:02 PM |
Repeat Field Value
I tried to post this earlier today, but it's not showing up when I do a
search so I'm trying again.
This has to be super easy but I can't find it in the forum or help. I am
try | | 3 | 44 | 11/9/2009 9:34:03 PM |
Adding a sequence number
Why doesn't this work:
Me.Box = Nz(DMax("[box]", "TShipTemp", "[order]=" & Me.Order), 0) + 1
(this is in my before insert event of my sub form)
| | 2 | 43 | 11/9/2009 9:15:15 PM |
Calculate number of days in months given a multi-month time period
I have data for billing cycles that span multiple calendar months. Sometimes
the billing cycle is only one month (i.e., 10/17/09 - 11/16/09), sometimes
two or more months (ie., 10/17/2009 | | 5 | 35 | 11/9/2009 8:52:01 PM |
Repeat field value
Try # three to post this.
This should be super easy but I can't find it in here or in help.
I have a form that accepts info for screen printing orders. Fields include
item | | 3 | 45 | 11/9/2009 6:16:59 PM |
Filenames with spaces
What syntax is correct for use with the SHELL() function to open a filename
which contains spaces?
| | 2 | 45 | 11/9/2009 6:16:04 PM |
How to convert a number to a date...
Does anyone know how to convert a number (which is not really a number), such
as 10202003 and convert it to a date "10-20-2003"? In a query or in code
doesn't matter, I just don | | 3 | 42 | 11/9/2009 5:55:03 PM |
ADODB from Excel - Running a Query
I have the following code linked to a button on a worksheet in Excel. I am
trying to run two existing queries in my Access database. The first is a
"make table" query that crea | | 1 | 43 | 11/9/2009 5:49:05 PM |
Combining records Questions
I have data like this:
Record 1:
Doe, Jane Doe, 1 main street
Record 2:
Doe, John Doe, 1 Main Street
What I what to do is the following:
Doe, Jane Doe, John D | | 1 | 46 | 11/9/2009 5:10:49 PM |
VBA code indentations changing
Access 2007
As I move between 2 computers the existing VBA code indentations change from
5 spaces to 1 space, even though both have the same indentation setting (5)
in VBA options. It is | | 4 | 52 | 11/9/2009 4:53:57 PM |
set properties of a passed textbox name
Hi,
I'd like to pass the name of a textbox to a procedure, and then set that
textbox to be locked.
Reason: I want to set many textboxs' properties to locked (and later ot | | 3 | 43 | 11/9/2009 4:11:03 PM |
syntax to copy text string from another field to clipboard
Hello,
The following code gets me close, but not quite. When this runs, I get an
error that the field doesn't exist. It's reading the text in the field as if
it's a field name. | | 6 | 54 | 11/9/2009 3:24:01 PM |
creating new folders
Hi
i have the following code, which creates a folder for each record:-
Option Compare Database
Option Explicit
Function CreateGradingFolder()
Dim rs | | 2 | 43 | 11/9/2009 1:44:05 PM |
DLookup, how to format vba code
I am struggling with this. I have asked questions on other forums only to be
told I should do this or do that. But I am trying to learn how to do
something other than some ones typical us | | 7 | 42 | 11/9/2009 1:39:02 PM |
Check if a back end is (still) password protected
Hi.
What is the best way to check if a back end database is (still) password
protected?
The only way I can think of is:
Try to link a table without the password. Then | | 2 | 43 | 11/9/2009 1:16:01 PM |
Creating Folders
Hi
I have the following code that creates a folder for each record in the
database:
Option Compare Database
Option Explicit
Function CreateGradingFolder()
< | | 1 | 46 | 11/9/2009 1:15:02 PM |
How to use varibles in SQL query
I'm tring to upsize my access 2007 database to SQL. In access I created a
function to accept a varible, then I could use the function in the query.
SEE BELOW:
Public Functi | | 0 | 45 | 11/9/2009 11:25:01 AM |
Problem with pivot tables
Hi everybody,
I have created an application in MS Access 2003. This application is used
also on the desktops, where no MS Office is installed and therefore runs in
Runtime mode. Everythi | | 2 | 44 | 11/9/2009 11:00:01 AM |
Multiselect Listbox and AfterUpdate
I use a multiselect listbox to let a user select multiple items. The items
selected are determined n the AfterUpdate event. In most cases the user
either clicks on a single item (and Item | | 1 | 48 | 11/9/2009 8:58:01 AM |
Finding and displaying images on a report.
Hello,
I need to display some images on a report. The images are stored on another
PC - mapped to the Z:\ drive. The images are all named with the number
corresponding to the [ | | 1 | 46 | 11/9/2009 5:51:06 AM |
What does the semi-colon do in vba code?
I ran across this line of code, which uses the semicolon instead of the
ampersand concatenation character. The only difference I could tell is the
semicolon adds an extra space to the out | | 2 | 61 | 11/9/2009 4:54:01 AM |
Recordset problem
I am trying to open a recordset that is a query. The query is saved as
"qDepositSlip". The query has 6 fileds and 3 fileds where the criteria is
based on textboxes in a form. | | 2 | 53 | 11/9/2009 4:21:01 AM |
Finding and displaying images on a report...
Hello,
I need to display some images on a report. The images are stored on another
PC - mapped to the Z:\ drive. The images are all named with the number
corresponding to the [ | | 0 | 45 | 11/9/2009 1:09:01 AM |
Choosing between two different images and more...
Hello,
I need to display some images on a report. The images are stored on another
PC - mapped to the Z:\ drive. The images are all named with the number
corresponding to the [ | | 0 | 45 | 11/9/2009 1:08:01 AM |
Use a combo box to find an Employee
Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, | | 0 | 41 | 11/8/2009 11:59:01 PM |
From Excel - Access run saved import then open query design view
Need a routine from within Excel that will ...
- Open Access 2007.
- Run "SavedImportX".
- Open "QueryX" in design view.
Have made numerous attempts | | 1 | 55 | 11/8/2009 11:48:01 PM |
Repeat field value in next field
This has to be super easy, but I have searched the forum and Help and can't
find it. I want the value from a field in the previous record to be repeated
in the next field so that the user | | 4 | 41 | 11/8/2009 7:21:01 PM |
Erase data
I am inporting a txt-file into a temp table. ([MyTempTable])
I there modify it a little before I finally send it over to the "real"
table. ([MyRealTable])
Now, to be su | | 3 | 56 | 11/8/2009 1:42:01 PM |
Get full UserName and UserInitials from MsOffice
Hi,
I would like to get the [full user name] and [initials] as defined in
Microsoft Office. In Access 2007 you will find this under Access Options -
Popular - Personalize your c | | 4 | 37 | 11/8/2009 1:12:35 PM |
Problem validating Field Value
I am getting a message that "You cancelled the previous operation" each time
the following sub is called.
Access 2003
XP Pro (my workstation)
I just finished | | 11 | 42 | 11/8/2009 1:17:47 AM |
Sending Serial Emails through Access
I have a databe setup, with a form that allows a user to enter text for a
subject line and body of an e-mail, then use a query to generate a list of
e-mails to send to; it also allows for th | | 4 | 40 | 11/7/2009 10:34:52 PM |
Convert Access 95 to later versions
I have Access 95 application which I need to convert to Access 2007. What do
I need to do? Thanks a lot for all the help.
| | 1 | 44 | 11/7/2009 3:03:25 PM |
Parse space in Access field
I have a table with one field that contains 2 spaces at the front and I need
to remove the spaces and then put a 0 as the first character. For instance
the field would look like ( 3380576703 | | 6 | 46 | 11/7/2009 2:11:27 PM |
Secure Hyperlink Fails
I have a table that contains hyperlinks; for example:
https://www.myboeingfleet.com:443/boldweb/documents/SB/MD11/SB-MD11-103-001-01--.PDF
If I cut-n-paste this hyperlink into a | | 1 | 66 | 11/7/2009 12:30:01 PM |
Preventing Screen Repaint - what confilicts with Echo?
I inherited a rather long, badly written batch of code, and as I was making
some requested changes, I tried adding Application.Echo False (and True at
end) to hide the screen flashing duri | | 1 | 46 | 11/7/2009 11:53:44 AM |
Forms and reports disappeared from my access database
I have an access database for Asset Tracking It had forms and reports. I have
been using it for the past 5 years. I used it yesterday and to my
astonishment on opening it today I had no fo | | 1 | 43 | 11/7/2009 6:28:37 AM |
Pulling ALL records in subform into VBA drafted email
Hello,
I have a form that has a subform which can have multiple records entered.
What I am trying to do is to pull in data from the form AND subform into an
email drafted by VBA wi | | 1 | 52 | 11/7/2009 5:59:20 AM |
Scripting File Library Reference AutoComplete
Hello:
I regularly use the Scripting Host features by defining them as follows:
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextStream = | | 3 | 50 | 11/7/2009 2:41:26 AM |
Update Query
I am attempting to update records in a table based on an expression created
in the "update to" row of the update query. The expression concatenates three
text strings from three | | 2 | 55 | 11/7/2009 12:19:02 AM |
Pass Through Queries (Access 2002)
Hi. Does anyone have an example of executing a stored procedure in VBA as a
pass through query?
I'm trying to send the query directly to SQL Server 2005 and bypass the Jet
data | | 2 | 50 | 11/6/2009 7:58:39 PM |
Cascading Delete Warning
Hi,
I have a database with a relationship set with cascading deletes. I do
not like the standard warning that pops up when deleting a field in the main
table. Is there a way to c | | 3 | 43 | 11/6/2009 5:18:08 PM |
Union Query question
Hi All
I have a union query that doesnt quite do what I want it to. The
query is supposed to grab all records from the Trade-Skill table and
also display corresponding records from C | | 2 | 49 | 11/6/2009 3:44:48 PM |
And/Or Statement
Hi,
I'm a beginner and I'm having a problem with my "and" and "or" statements.
I understand why it's not working just not sure of the syntax to make it work
| | 3 | 41 | 11/6/2009 3:38:09 PM |
excel.exe process doesn't quit
I have an access 2003 DB and a module that runs excel via automation, it
works fine. Except that the excel.exe process doesn't end after the
xlapp.application.quit. I have to manually go int | | 2 | 105 | 11/6/2009 3:11:04 PM |
Access 2007 Toolbar Issue
We have set up a function as listed below to display a custom toolbar used to
export data from the report. The function is called from the open event of
each report:
Function CBSho | | 1 | 50 | 11/6/2009 5:47:53 AM |
Move to new record
I have what I think is a real simple question. I have a form with several
subforms on various tabs. What I want to do is have the form automatically
go to a new record when the user clicks | | 1 | 49 | 11/6/2009 5:43:02 AM |
string manipulation - extract various data
Hi All,
My latest task is to create a part usage tracking system and incorporate this
into our current system, the first part works ok now and the resultant string
is copied back into a pa | | 1 | 48 | 11/5/2009 9:26:05 PM |
Parse space in Access field
I have a table with one field that contains 2 spaces at the front and I need
to remove the spaces and then put a 0 as the first character. For instance
the field would look like ( 3380576703 | | 0 | 47 | 11/5/2009 7:04:04 PM |
Function or Sub?
Hello all
This is actually a continuation of a previous thread (subject "Transfer
text?") that I started on 12 Oct, but which has 'gone cold'. Essentially, I
need to expor | | 9 | 39 | 11/5/2009 6:41:24 PM |
Comparison of text field values wtih Decimal symbol gives error
Hi,
I have a text field with numeric values (values have dot(.) as decimal
symbol ex. 5.3). Unfortunately it must be text as sometimes includes text
values also.
Now for nu | | 2 | 49 | 11/5/2009 5:46:34 PM |
changing TextBox Caption
Hello.
I have a form ("MainForm") with a subform ("Main_SubForm"). The subForm used
as Source Object ("SF_SourceObj") has a Text Box that i want to chabge the | | 6 | 73 | 11/5/2009 4:54:01 PM |
Application Crashes
I have an application that fires from a form button. It can take a long time
to run a report. The app is all on one pc, no network. Depending on what
information is requested the report c | | 3 | 45 | 11/5/2009 3:31:42 PM |
how to attach variable to fllowing command
The code is
docmd.openreport "report1",,,"[field1]="'abc'"
orderby="[id]'
is working but i want like this
condtion="[field1]="'abc'"
or | | 1 | 57 | 11/5/2009 2:55:02 PM |
how to get table values into variable
The following codes are working perfectly
a=forms!forms1.field1
forms!forms1.field1=a
like this any code is there for getting values directly from table ?
i tried
a | | 3 | 46 | 11/5/2009 2:23:01 PM |
Error 2001, Access 2007, Subform Bookmark
I´ve problems to synchronize subforms with access 2007. Runnig the same old
code that worked with Acess 2003:
Dim int As Integer
Dim rst As Dao.Recordset
int=Me.[ID]
Set | | 1 | 49 | 11/5/2009 3:08:00 AM |
Slow VBA module in small Access DB
Hello, all -
I have an Access DB I am designing. I am still in development, so the
DB is empty - only has 6 records in it right now. Now, this DB is for
a trading firm and I have a ve | | 3 | 39 | 11/4/2009 10:14:01 PM |
Count no of rows appended
Hi,
I’m using vba to run an append query, but where 0 rows are appended, I need
to pop up a message box to inform the user. Is there a way of counting the
number of recor | | 4 | 50 | 11/4/2009 4:22:06 PM |
Calculating Time based on an 8 hour basis
I am using the DateDiff function to calculate time between two dates.
Expr1:
DateDiff("h",[ClericalMetric.OrderDateclerk],[ClericalMetric.ClerkCompleteDate])
I am gett | | 1 | 46 | 11/4/2009 4:03:01 PM |
Crystal Reports OCX
I am trrying to run a Crystal Repors from wth in Access VBA. I have the OCX
control on a form and I have this code in a command button.
CR.UserName = "*****"
CR.Password = & | | 0 | 63 | 11/4/2009 4:01:02 PM |
42 Hosting Web www.ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Host | | 0 | 97 | 11/4/2009 11:50:22 AM |
Custom Ribbon disappeared when DB split
I created a custom ribbon to load when database opened using USysribbons
table (by listing it in drop-dwon box in access option, this database.
Worked great. Then I split the database, and | | 1 | 46 | 11/4/2009 5:47:50 AM |
Recordset with SQL strings
I need some help on the best way to get some numbers totaled for a particular
date range. I want to total the [CapitalGains] field for whatever date range
is selected on the form, a [Start | | 1 | 64 | 11/4/2009 3:26:58 AM |
Columns in a form
I want to provide my users with the option to select multiple items from a
list by clicking the option button next to the item. I'm displaying the list
in a form set to Continuous Forms. T | | 1 | 45 | 11/4/2009 2:33:46 AM |
Import Excel check field names Please Help
I am importing an excel file where the field names do not match my table
field names. I have a matrix in access that lets me know what the match is.
I would like to create the import temp | | 2 | 56 | 11/3/2009 11:30:01 PM |
Use a string to define a field
I have the following function:
Public Function LastMonthDDD(dddMonth As Long, dddYear As Integer, wicket As
String) As Long
Dim dbs As DAO.Database
Dim rst As DAO.Reco | | 1 | 66 | 11/3/2009 9:24:27 PM |
Not Responding when VBA code is Run
I'm making a form for generating records to represent a matrix of
experimental results. So if I have three samples for which I need to test
melting point and boiling point we need 6 recor | | 2 | 54 | 11/3/2009 9:19:01 PM |
Disable keyboard
Hi
I have two controls on a form that I am using conditional formatting to show
the days of the week in certain colours. Becuase I am using conditional
formatting I understand | | 3 | 62 | 11/3/2009 8:36:22 PM |
FollowHyperlink works in Mozilla but not IE
I have created a form with a combobox, textboxes and a command button. When
a user selects from the combobox, the textboxes display the related data.
The user is then able to press the c | | 2 | 89 | 11/3/2009 8:17:01 PM |
Appending mutiple reports to PDF using VBA.
I have 2 separate reports in the same database that I want merged together in
a PDF file as opposed to creating 2 separate PDF documents and then coping
and pasting the pages in Adobe.
| | 4 | 49 | 11/3/2009 8:16:01 PM |
Error 3061
Hi All,
I know there are a number of posts out here regarding this error and I
have read a # of them but cannot seem to figure out why I am still
getting this message for my query | | 3 | 61 | 11/3/2009 3:38:55 PM |
Item not found in this collection error
A03 I have a bit of code that changes user password. Works fine until I use
a different workgroup. Even if I copy and paste the workgroup (that works)
to another folder and join the work | | 1 | 53 | 11/3/2009 2:52:02 PM |
application.hyperlink giving 490 error
Hello,
I have a form with a linked picture. I'm trying to make a double click event
to open the picture with Windows Picture and Fax Viewer. JPG's are associated
to open with th | | 6 | 87 | 11/3/2009 12:50:02 PM |
Using predefined signatures when emailing from Access
I often have to create, pdf and email a report from within Access. I use the
DoCmd.SendObject function from within VBA. Is there any way of adding the
usual company signature to the emai | | 1 | 63 | 11/3/2009 12:33:01 PM |
connecting to Sql Server Express 2008 64 bit
Howdy,
I've developed an application in Access 2007 that uses SQL Express 2008 (32
bit) as a back end.
The Access front end and SQL backend are both local on an XP SP3 system and
| | 1 | 48 | 11/3/2009 6:56:57 AM |