I've created a form with the record source as a query. The form is set up as a continous form. I have the following code attached to a comand button, located...
4697
Neil Squires
greaterdesig...
Mar 3, 2003 3:33 pm
This will only work for the current record. On a form, you can only deal with one record at a time. If you want to do something with a full recordset, do it ...
4698
Lemonademn@...
Mar 3, 2003 6:12 pm
I am trying to use VBA codes to refresh a number of linked tables Anyone able to help??...
4699
Mckay, Jim
jmckays
Mar 4, 2003 3:10 am
http://www.mvps.org/access/tables/tbl0009.htm FYI the entire site is something good to check out... ... From: Lemonademn@... [mailto:Lemonademn@...] ...
4700
James Robinson
accdb
Mar 4, 2003 3:30 pm
Hi Chris, Try running an update query and then requery the record source for the form to view the update. ... ...
4701
Dave Elsey
d_elsey
Mar 14, 2003 10:58 am
Does anyone know why a "Stop" statement stuck in a piece of VBA code won't halt execution? I've replaced my Stops with a "intJunk = 1 / 0" statement, thinking...
4702
Neil Squires
greaterdesig...
Mar 14, 2003 2:38 pm
In your database properties menu, set it to break on all errors. From Access, type <Alt><F11> Tools-->Options-->General-->Error Trapping-->Break on all Errors....
4703
jmw95823
Mar 18, 2003 8:29 pm
I have a Contract table (ContractNumber, ContractName, ContractAmount, EndDate, ...) linked to an Invoice table (ContractNumber, BillingPeriod, BilledAmount,...
4704
Dinger188
Mar 28, 2003 3:56 am
I am looking for help with designing queries and reports for monthly and yearly reports. I recently developed a Incident reporting database for a local fire...
4705
James Robinson
accdb
Mar 28, 2003 9:23 pm
Dan, Add your date field to the query grid. Place the below line in the date field criteria section of the query grid. Between [Enter the Beginning Date] And...
4706
pagedcol
Apr 1, 2003 3:38 pm
Hi all, I would like to know how to use the MSDE instead of the jet engine to create access dbs. I have installed the MSDE but now I don't know how to design...
4707
Declan Gorman
declan_gorman
Apr 10, 2003 11:00 am
Hello All, I have a sub form that sits on a tab on a main form that whenever all of the data is entered I want it to jump to a new record using ...
4708
Mathew Sherman
msherman@...
Apr 10, 2003 8:47 pm
I got this code right out of a book and can't get it to work... basically I'm trying to put intelligent back-fwd buttons on a form but I want to disable the...
4709
Mckay, Jim
jmckays
Apr 11, 2003 5:15 pm
you need to pass an object reference not an access pseudo reference... which you can only properly do in a code event, not by setting the property on a...
4710
Mathew Sherman
msherman@...
Apr 11, 2003 7:26 pm
Ahhh, yes of course! I knew it was something like that. Thanks a lot Jim! Matt. ... From: Mckay, Jim [mailto:jrmckay@...] Sent: Friday, April 11,...
4711
Mathew Sherman
msherman@...
Apr 11, 2003 9:09 pm
Ohhh, I spoke too soon. When I tried this I still got a type mismatch error. When I hit the ... to create the sub it made one called Private Sub...
4712
Mckay, Jim
jmckays
Apr 15, 2003 3:42 am
What it originally made is correct. It automatically putting the () however is not... if its a function that doesnt return anything it shouldnt be doing that...
4713
Mathew Sherman
msherman@...
Apr 15, 2003 1:01 pm
No, the function does not need to return anything. I changed the call to add the "call" and the same thing happens. Here's the code from the form's module: ...
4714
pagedcol
Apr 29, 2003 8:39 pm
I am using Access 2K and I am a beginner when it comes to VB. Even if a form does not have focus can the On Key Press and On Mouse Move event still work? ...
4715
pagedcol
Apr 29, 2003 9:39 pm
I am using Access 2K and I am a beginner when it comes to VB. Even if a form does not have focus can the On Key Press and On Mouse Move event still work? ...
4716
Greg Kane
integrity@...
May 1, 2003 2:48 pm
I've got a AccessXP database with 30,000 names and address, unfortunately the data in in ALL CAPS and I need it in Title Case. In the past I've exported to...
4717
Mckay, Jim
jmckays
May 1, 2003 6:29 pm
Create a module, and paste the following function into it: Public Function CaseConvert( _ strIn As String, _ intMode As Integer) _ As String ' Comments :...
4718
Banerjee, Amit
amit.banerjee@...
May 1, 2003 7:28 pm
Hope this helps: In Access 97 you have to do it using a Function in a Module: Function Proper(X) ' Capitalize first letter of every word in a field. ' Use in...
4719
Greg Kane
integrity@...
May 2, 2003 2:56 pm
Thanks. I did a bit of web searching, and it turns out the VB function StrConv([myString],3) does this too. Greg Kane Denver...
4720
jtequia2000
May 2, 2003 5:35 pm
I'm having a problem setting up user accounts for a database that resides on my network. When I open the database from my workstation, it prompts for user and...
4721
traderbays
May 2, 2003 10:45 pm
Is there a way to take data that is put into my access database and use it on specific fields in an Excel form?(I can not find a strait answer)On how to do it....
4722
Dinger188
May 5, 2003 5:00 am
I have set up Security, via the wizard, on a database I created in Access 2000 with several users on it. The database is not a network, it's used on a stand...
4723
Mathew Sherman
msherman@...
May 7, 2003 9:47 pm
I have three tables in a relationship where the Projects Table is linked to the Jobs Table and the Jobs Table is then linked to the Invoices Table. I have...
4724
Vadim Kotryaga
vadim@...
May 13, 2003 5:52 am
Hi ! ... You must give Conditions in natural: tblProjects!ProjectID=12345.. Try this =DCount("[jobID]","tblJob","tblProjects!ProjectID=" & str([ProjectID]) ) ...
4725
Mathew Sherman
msherman@...
May 14, 2003 5:00 pm
Okay, this is a weird problem I'm having now... I created a link on a form which is supposed to open the details form and show the related record... nothing...
