Error 6: Overflow
Fri, 26 Sep 2008 09:42:52 -0400
Hello,
In the following snippit I am getting a overflow message after the line
rst![GalPerMile] = TripRptEntry.Form![totGal] /
TripRptEntry.Form![totHubMiles]
rst.Edit
rst![totalmiles] = TripRptEntry.Form![totHubMiles]
rst![PCMiler] = TripRptEntry.Form![totPCMiler]
rst![TotalGal] = TripRptEntry.Form! ...
|
Reading Groupwise email into a list box
Fri, 26 Sep 2008 06:06:01 -0700
How would I go about reading email from GroupWise and listing them in a
ListBox in Microsoft Access?
Is this possible? ...
|
Problem with Refresh of Linked Tables Module
Wed, 24 Sep 2008 08:50:12 -0700 (PDT)
I am having problems trying to automate the refresh of linked tables.
I have two tables linked to Excel spreadsheets. Since these
spreadsheets are exported from different files in the same program,
they need to be refreshed just in case the user doesn't name the
exported Excel files the same and/or doesn't puts ...
|
DateTimeSignatureStamp()
Tue, 23 Sep 2008 14:02:01 -0700
Hi all,
I'm new to Access and Visual Basic. I'm a single user, using Access on my
home network. My database design is not FrontEnd/backEnd (and doesn't need
to be).
I've migrated all my data from Paradox to Access. I've built the tables,
queries, forms and reports and I'm ready to write my first code ...
|
InsertRecordFromNetworkedPC()
Tue, 23 Sep 2008 14:00:11 -0700
Hi all,
I'm new to Access and Visual Basic. I'm a single user, using Access on my
home network. My database design is not FrontEnd/backEnd (and doesn't need
to be).
I've migrated all my data from Paradox to Access. I've built the tables,
queries, forms and reports and I'm ready to write my first code ...
|
ToggleDesignViewMode()
Tue, 23 Sep 2008 13:57:03 -0700
Hi all,
I'm new to Access and Visual Basic. I'm a single user, using Access on my
home network. My database design is not FrontEnd/backEnd (and doesn't need
to be).
I've migrated all my data from Paradox to Access. I've built the tables,
queries, forms and reports and I'm ready to write my first code ...
|
error 70
Tue, 23 Sep 2008 09:00:20 -0700
Have developed code that works fine in all but one macro. For some reason I
get permission denied 70 in this macro. I have been informed that maybe
another file has the file in use. Is there a way to shut down use of a file
when completeing run of macro. This is on one machine. Only one user at a
time. If th ...
|
|
|
rocco sardella
Mon, 22 Sep 2008 20:22:47 +0200
...
|
Running a Function Once On Startup
Mon, 22 Sep 2008 13:22:28 -0400
Hello -
Could someone tell me if this is possible...
I have created an update for my front end. As part of the new deployment, I
need to create a new system DSN on the end user's machine. I have a macro
on a form that will create the DSN if the user doesn't have it, but I'd like
to have it created auto ...
|
Shell not working
Sat, 20 Sep 2008 20:57:01 -0700
I have a Shell command in a VB Function, but everytime it is called, I get an
"error #5", "Invalid procedure call or argument".
I have tried:
Shell Filename$,1
RetVal = Shell(Filename$, 1)
Call Shell(FileName$, 1)
FileName$ is read from a form field when a button is pressed, and then a
Macro is called ...
|