Search Result

matt753 · May 13 '10, 11:24 PM

I have a subform that displays all of the invoices for the day selected. There is a "Print all" button (code below) that should print all the records in the recordset. I cant figure out why it does not work, but it appears to be only printing one record.

Does anyone have any ideas?

Code:

Dim rs As Recordset
    
    Set rs = frmsubAdminEdit.Form.Recordset
    
    rs.MoveFirst

...

leach613 · May 4 '10, 04:40 PM

First of all, I'm use Access 2003 but most of the people that will be using this database with be using Access 2002. I'm not sure if that will make much of a difference but anyways here is my question. Oh and I'm making an Accounts Receivable Database.

My main question is, can you populate a multi column comboBox by using a recordset?

I would like to choose a CustID in one comboBox and use afterupdate event to create...

kbbauman · Mar 25 '10, 05:49 PM

I have a database in access that I am trying to pull in and add 1 hour to a specific column [datetime field]. here is what i have so far...

Data1.RecordSou rce = "Select * from [table] where[column]+ #01:00:00 AM#"
Data1.Refresh

error says "date + date not allowed"

any ideas...?

thanks

nilanjangm · Mar 21 '10, 02:39 AM

I have a subform in the main form. I have a recordset as well (Access 2007).

I want to display the records in the recordset in the subform. So I wrote this.

Code:

Set subfrmResourceProposedInProject.Form.Recordset = rst

(The recordset is fetching value correctly, I have checked that) However, this throws run-time error ()

I had another way which worked. The code was like this.

Code:

strQueryName = "SELECT

...

ppletkov · Dec 11 '09, 04:28 PM

Hi -
I apologize if this is a simple question in advance :-) (hopefully it is so its quickly resolved!)

i'm trying to figure out why i keep getting an error (Compile Error : expected function or variable) for my .find method. I have checked the format of this statement and it appears correct...?

Code:

Dim ItemNumberWLO As String
Dim ItemNumberWLN As String

While Not WLO.EOF

    If WLO.Fields.Item(1).Value

...

atherstone · Aug 27 '09, 03:05 PM

Hi

Using Access VBA I am trying to store the resulting value of an SQL statement in a string variable (strLastAccount RefUsed) and an unsure of how to do this. Also I am unsure if my SQL statement is correct. I am using a string variable as a criterea in the WHERE part of the statement. strFirstThreeCh aracters is the first 3 alpha characters of a new customers name.

This is my incomplete and probably incorrect code,...

mbilalk · Aug 18 '09, 02:57 PM

Hello,

Well here goes, I am using Microsoft Access to design a user interface for SQL Server database, I am currntly using the project method. I have manged to link it up and get my form to show the record, but when I go to click on next record it is not showing the next record. Where you have the next buttons it shows how many records there are, in this instance there is 706, but always seems to get stuck on the first record, this...

raddrummer · Apr 16 '09, 07:02 PM

Hi gang,

I'm stumped on something that I've been at for a few days and so am seeking help.

I'm sending emails to managers to let them know that a performace review is due and attach a custom form for the employee referenced. I have the query working and have created the recordset. The emails are generating correctly from the recordset but I can't get the code to send the active record info over to populate a report...

dbrother · Mar 20 '09, 12:51 PM

Hello All,

I've been plugging away at testing some VBA SQL that executes when a user clicks a button from a 'custom query' form. The user has lots of options as to what parameters should be included in the query, so there might be a better way to handle the syntax here. My main concern right now is just possible getting a fresh set of eyes on the VBA to see what I'm missing. I'm using the form's textbox field txtKitNum (strKit)...

Chinde · Feb 24 '09, 02:24 PM

Hello again

Simple one, I hope probably just a yes or no.

I've got a single main form with a continuous subform which has more or less the same info in (the idea being that the main form is for input and the subform is like an embeded dynamic report on a departments spending for a given period).

what I would like to know is, is it possible to pass the ID from the subform back up to the main form, where...

trixxnixon · Dec 23 '08, 09:19 PM

i have a form bound to a table, with a primary key(autonumber) "recordno"
on this form, i have a dlookup that looks up a specific "recordno".

how can i get this form to open up the record corresponding to the value that the dlookup outputs.

Search Result

How to print all records in recordset

How to populate a combobox with an updatable recordset?

add one hour to column in sql via vb6

Displaying Recordset values in a Subform

Why am I getting a compile error when i try to use the .find method (ADO, Recordset)?

Store single value from an SQL MAX Statement in a string variable

Unbound form, how to get to next record ?

how do I filter by the current record in the recordset (when no Form is involved)

VBA SQL - Missing right parenthesis error

set the record source for a main form from a sub form

open a record,