Search results

I have data that looks like this: Acct Status Date 1 A 1/1/2001 1 I 1/2/2002 1 A 2/3/2002 2 A 4/1/2002 2 I 4/5/2002 3 A 1/1/2002 I need a query that will return the current status, meaning the status with the most...

You're not wrong...That works. BUT - I need to allow them to add new records because I have a button that will take a current record and copy it then paste it as a new record. Marking Allow Additions no prevents that. I just don't want them going to the end and adding one manually...

How can I tell when my user is at the last record for a bound form so they don't move to the Add Record blank record that is associated with the >* button?

I do step thru it 1 record at a time, but I need to pass individual records to other functions depending on their contents.

I have a passthru query to an oracle table that is supposed to return the sum of a field with a format of Number(11,2). It holds currency values, but when I get the return, it is rounded ot the nearest dollar. My SQL is: SELECT sum(charge_cr_amt) as TotalUsage FROM...

I know it's not unix. I concatenated the fields into a pipe-seperated string: field1|field2|field3 using strRecord = rst![Field1] & "|" & rst![Field2] & "|" & rst![Field3] I use the pipe as the seperator as I know that my data will never have a pipe in it and can reliably find fields that way.

I've never used ByRef variables... I opted to concatenate all the data from the record to a string with each field seperated by a pipe, |, and pass the string to the function.

I have some code that opens a recordset and I want to perform tasks based on the data in the current record. For example, if the field [CrCls] = A, I want to pass the entire record to the function named CClassA. How can I pass the current record to that function?

Perhaps I should have specified... This is a recordset from a Pass-thru to Oracle. I don't believe I can do that with this, can I? In addition, I only want to write the current record... [This message has been edited by rockies1 (edited 03-25-2002).]

Does anyone know how to parse a record from recordset so I can write it to a file? I want to be able to write out all of the record, but I'd like this to be flexible enough to use it for ANY recordset, and not have to code the field names. Thanks.

I have a Hex value (will be like "FEFF4CD8") I need to convert to Decimal, but I do not know how... Anyone have any pointers? Thanks!

I haven't had any luck with the code either. Because this will be a real-time e-mail, I can't change the default account. The users will normally be sending under their own name and only occasionally under this other name...

I have a user that needs to send e-mails via VBA in Access. They don't want the e-mail to appear to come from them, however. They have another e-mail box (Outlook98 on Excahnge) that they can put in the FROM box, and it then comes from that mailbox. How can I do the same via Access VBA...

Because I'm not doing it manually... I'm doing it from a VB program...

How, though, can I do this via code?

It fails on MyPosition = InStr(rst, SearchCharacter) becasue you are passing the InStr function a recordset (rst) when it wants a String. Try: MyPosition = InStr(rst![Billing_name], SearchCharacter) Also, this will give you an endless loop unless you rst.MoveNext after MyPosition =...

InStr requires a starting position. Use: pos = InStr(1,SID, "B", vbBinaryCompare) The 1 tells it to begin at the first character.

I have a table that looks like this: Item Parent 1 0 2 0 3 0 4 3 5 3 6 5 7 3 8 0 I want to be able to do the following: Delete a record and any records that would be under it. For example, if I delete Item 3, I need to delete items 4, 5, & 7 because their Parent is 3. In addition, Item 6...