Access VBA - Loop through table fields -> update Listbox
Thu, 27 Nov 2008 00:06:06 -0800
Hi there,
I have an Access 2003 database. In 2 of my forms i have a listbox which I
want to update/populate using VBA code.
Basically, i want to lookup the current record in a table and loop through
the fields. Whenever a field = TRUE, i want to add the relevant field name to
the List box
this is an e ...
|
Insert into - the rows of a table back into a table Parent Child
Wed, 26 Nov 2008 18:22:00 -0800
Hi,
I have a form with a subform in a parent child realtion.
Such that each record/row of the subform has the forms identifying ID.
I would like to be able to take the information in the subforms table (each
row) and be able to paste it into another new open form.
The original form has information whi ...
|
Select multiple records in the datasheet part of split form.
Wed, 26 Nov 2008 17:25:01 -0800
Does anyone know if it's possible to work with a multiple-record selection in
the datasheet part of a split form in the same way you can using a datasheet
or continuous form? I have the need to update several records at once and
I'd like to use SelHeight and SelTop to identify the records to update. I'd
l ...
|
Getting Closer - Sort of
Wed, 26 Nov 2008 13:46:05 -0800
I have a button set up - when I click the button it runs a Query. However
the Query has a hard coded value. So I have a text box and I can figure out
which event to use for the text box. But I need to understand how to read
the data in the text box (a 4-digit text string) into a variable and then how
to p ...
|
IIF(...
Wed, 26 Nov 2008 12:29:01 -0800
Hi guys,
I placed this Fuction =IIf([tfrom]>[tTo],"Time to must be higher that Time
from") in the validation rule for tTo, both are Time fields, but for some
reason is not working.
May someone give me a hand with this.
Thanks
...
|
What am I doing wrong here?
Wed, 26 Nov 2008 11:36:05 -0800
OK - I coded a subroutine from the book that looks like this:
Option Compare Database
Option Explicit
Sub BeepWarning()
Dim xBeeps As Integer
Dim nBeeps As Integer
nBeeps = 5
For xBeeps = 1 To nBeeps
Beep
Next xBeeps
End Sub
Then I selected the event to run and got this:
Private Sub btnBeep_Click ...
|
Report: Show Fields Only if Populated
Wed, 26 Nov 2008 10:44:06 -0500
I am trying to figure out how to do this. I have 10 fields. When I run a
report maybe only 3 fields at a given time will be populated with data.
For example: Report 1 has Fields A, C, F populated so I want my report to
show:
Lable: Deferrals Match Roth
Data: ...
|
|
|
Run-Time Error 75
Wed, 26 Nov 2008 13:50:31 GMT
I have create a database that works perfectly on Access 2000 and now that I
have a new computer with Vista when I open my DB to view my report in Print
Preview I get the Run-Time Error 75 I have included the code I am using and
where it highlights the error with the **: Is there a way to fix the problem?
Any sug ...
|
Find and Delete existing records
Wed, 26 Nov 2008 04:24:00 -0800
Hi all
I have some code which creates dates in a related table, snippet below:
NoOfDays = Forms![frm Itinerary]![Itinerary].Form![ReviewDays] - 1
StartDate = Forms![frm Itinerary]![Itinerary].Form![ReviewDate]
ItinID = Forms![frm Itinerary]![Itinerary].Form![ItineraryID]
dtmDate = StartDate
For n = ...
|
Running Several SQL Update Queries
Wed, 26 Nov 2008 10:45:30 GMT
Hi Guys,
Currently having issues trying to get the following to work:
Private Sub Label11_Click()
DoCmd.Echo False
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE Stores INNER JOIN Actions ON Stores.[Store No] = Actions.
[Store Number] SET Actions.[Date Works Required] = (Forms![Rebalance Update
Popup]